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 |
|
somecallmejosh
Starting Member
3 Posts |
 Posted - 2007-04-23 : 09:42:22
|
| Hello,This is my first post to this forum. I see many issues related to error 18456 within the forum, but my situation seems a bit unique. I'm running SQL 2K, with Access 2K3 as a front end. I just created two new tables in SQL, and linked them to the front end. So far so good... For some reason, the only account that can access the objects associated with the new tables is mine (an account with admin rights) - we're talking Windows authorization. All other objects are accessible by all members of our organization, with the exception of these new tables? Here is the error message they receive:Connection FailedSQL State: '28000'SQL Server Error: 18456[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for userAny ideas? I've checked the permissions in SQL and everything seems to be hunky dory...??? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 10:29:15
|
| The message says user can't login to sql server. Did you double check sql login for the account? |
 |
|
|
somecallmejosh
Starting Member
3 Posts |
Posted - 2007-04-23 : 11:01:18
|
| Yes, all users can log in to the DB. I'm just baffled as to why they cannot access objects associated with the new tables. |
|
|
|
somecallmejosh
Starting Member
3 Posts |
Posted - 2007-04-23 : 13:07:04
|
Thanks for your help. I switched from SQL to NT Authorization and everything seems to be hunky dory again.  |
|
|
|
|
|
|
Connection Failed