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 |
|
Conjurer
Starting Member
30 Posts |
 Posted - 2006-05-11 : 14:52:03
|
I am trying to connect from Excel into a database maintained in SQL Server. This has worked on two users, but when I try to make the connection for another person (the other two are not using it at time) I can't get it to connect her. From what I can see it looks like she has all the same groups and rights in active directory as the other two users but it bombs with the message: quote:
Connection failed:SQLState: '28000'SQL Server Error: 18456[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'RAMSEY\mmuser'.
This happens even if I login as her from a machine where it works for the other two people. Any ideas on how to fix? |
|
|
DarkCloudInc
Starting Member
10 Posts |
Posted - 2006-05-11 : 14:54:55
|
| I believe I have had a similar issue. Does the table or link have a DSN? |
 |
|
|
Conjurer
Starting Member
30 Posts |
Posted - 2006-05-11 : 15:02:12
|
| Well I am not even sure what a DSN is! |
|
|
|
DarkCloudInc
Starting Member
10 Posts |
Posted - 2006-05-11 : 15:34:47
|
| DSN: Data Source Name.I am unsure if it is advisable to use the method I had used to resolve a similiar issue. I was using a linked table that contained a DSN and found that many users that were trying to simultaneously access the table that had DSN were limited. So I resolved it by simply removing the DSN. After that, the issue has never came up. |
|
|
|
|
|
|
Connection Failed