Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ckleong
Starting Member
17 Posts |
 Posted - 2009-06-25 : 06:17:24
|
| Hi, I am getting below error while listing the databases using EM. Server is running and it is on mix-mode. Please help, urgent.A connection could not establish to \\server\abcReason: Login failed for user 'aaa' ---> administrator right given (workgroup)Please verify sql server is running and check your SQL server registration properties and try again |
|
|
EMarkM
Starting Member
16 Posts |
Posted - 2009-07-10 : 09:25:34
|
| Hmmm: you say that SQL Server is up and running under mixed authenticaton mode, so the most likely explanations are the "aaa" has not been declared as a login on the server or that it hasn't been declared as a user on any of the databases.One other explanation could be that your connection protocols are not set up correctly: if the server is only listening on TCP/IP, for instance, and your Client Network Utility has only been set up for Named Pipes, then you might have a problem.What version of SQL Server are you running? |
 |
|
|
|
|
|
error when trying list the databases