What can it be?
-
A weird case.
All loginIDs with sa can access both SQL Enterprise manager and Query Analyzer.
All loginIDs wihout sa permission cannot access either SQL Server Enterprise manager or Query Analyzer.
The failed error message is:
ODBC: Msg 0, Level, 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 66 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Any input?
Great appreciation in advance.
-
Strange indeed... what version of SQL Server are you using? What version of the ODBC driver are you using? Also - do you have anything in the event log on the database server?
What do you mean by 'sa' permission? Do you mean: I get an exception when using an account other than 'sa'?
Thanks
Herve Roggero
hroggero@pynlogic.com
MCDBA, MCSE, MCSD
SQL Server Database Proxy/Firewall and Auditing -
Are you using mixed mode authetication, are the 'non-sa' accounts windows authenticated?
David
If it ain't broke, don't fix it...
-
Thank you all for your input.
The solution was found. Some people changed the master database. The errors were gone after restoring master database.
-
Did you thrash them soundly with a Cat6 cable? Be sure to use the ones with metal clips!
There's a reason why we back up the system databases! (if we're smart...)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
To the avoid giving non DBAs access to senstive database like master. Have them little privilege needed so that you don't land up in situation like this. Else you are the person who will be responsible for this.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply