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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-03-06 : 05:21:18
|
| This is the connectionstring I use to get to sql server 2000Data Source=GBLOND0\MSQL_COMDEV_DEV1;Initial Catalog=testDB;Persist Security Info=True;User Id=Webspeople;Password=something;Now on another server I installed sql server 2005.Restored a backup of sql server 2000 databse into sql server 2005.So now I have sql server 2005 with the database that I was using in sql 2000. The question is to do with login.In sql 2000, connecting to sql query analyser using the above credentails, works fine. But not in sql 2005The error is:Login failed for user webspeople. The user is not associated with a trusted sql server connection.Any guidance to solve this issue please?Thanks |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-03-06 : 07:17:20
|
| I suspect that your SQL2K server is using Mixed Mode authentication (SQL and Windows) and your SQL2K5 Server is using Windows authentication only. The connect string you posted looks like a SQL Authentication Connection String.Of course it might also be that you haven't created the users Login in SQL2K5 . . . Although the user exists in the restored database, there is no login (with Matching SIDS) created.Just a couple of thoughts-- RegardsTony The DBA |
 |
|
|
|
|
|
sql 2005 login