ADO/MSSQL and Connect-Permission problem
- From: "Bernd Maierhofer \(dato\)" <bernd.maierhofer@xxxxxxx>
- Date: Fri, 28 Mar 2008 11:30:47 +0100
This is weird, but I hope someone has an explanation:
Delphi 2006 going against an MSSQL2000 database using ADO-Components.
There is a user DBACCESS in MSSQL, which has the necessary rights for
connect and select.
The app connects to the DB using this user. Security in MSSQL Server is set
to mixed.
The users of the app login to the microsoft network using their accounts.
Everything worked fine until one day:
Some users including the domain admin(!) no longer were able to connect to
the database. They got "sql server does not exist or wrong login".
For some users everything still worked fine.
So:
Logging in with user A, starting the app, the app tries to connect with
DBACCESS --> connection error
Logging in with user B, starting the app, the app tries to connect with
DBACCESS --> connection successful
Interesting too:
Logging in with user A, launching Query analyzer and connectiong with user
DBACCESS succeeds too.
The only thing, that was changed, was that the machine hosting the mssql
server was virtualized.
Any idea what´s going on?
TIA
Bernd
.
- Prev by Date: Re: List availalbe SQL Servers?
- Next by Date: Running stored proc on very large database
- Previous by thread: about dbgrideh's checkBox
- Next by thread: Running stored proc on very large database
- Index(es):
Relevant Pages
|
