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 |
|
david_r6@yahoo.com
Starting Member
3 Posts |
 Posted - 2009-01-07 : 19:04:04
|
| I just restored a sql database from an old server that was falling apart. Everything went well it seemed, no errors of anykind during the load or the restore. When the client tries to login now from his pc in a domain to the new server 2008 standard workgroup with SQL 2005 using a front end called Sybase he gets this error msg: sqlstate=28000 microsoft sql native clent login failure for user ". The user is not associated with a trusted sql server connection.sql 2005 is setup to use local machine authentication which seemed logical since it is in a stand alone workgroup and not part of the larger domain. The user can see the server from the local XP machine he uses, mapped drives just fine....any thoughts would be highly apprciated as I am out of ideas and tired of banging around on the server tyring to find the answer.ThanksDavid |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2009-01-07 : 20:58:07
|
| check your Sql port number. try this. telnet <IPaddress> <port number>Is he trying windows authentication or SQL authentication?hey |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-07 : 21:22:34
|
| have you moved logins which resides in master db from old server to new server?[url]http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx[/url] |
|
|
|
david_r6@yahoo.com
Starting Member
3 Posts |
Posted - 2009-01-08 : 10:20:19
|
| It is setup to use windows authentication. When I did the restore the logins came over with it.Thanks for the helpDavid |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-08 : 10:45:54
|
| You have to map database users with Login to match SID.Use sp_change_users_login 'update_one','Login','Login' to resolve it. |
|
|
|
david_r6@yahoo.com
Starting Member
3 Posts |
Posted - 2009-01-08 : 11:55:05
|
| I think part of the issue might be that it came out of (backed up from) Windows 2003 full domain with Active Directory, and now it has been restored to Windows 2008 as a workgroup over the top of a standard SQL 2005 load. I selected to use the windows login option since the users are no longer existing on the server in the form it was in when backed up...I will be heading over there today to try to repair the logins.Thanks for all the help David |
|
|
|
|
|
|
login failure after restoring to new server