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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-09-03 : 05:01:34
|
| Hi,I have restored the sql server express 2005 database (db1) from one machine into the sql server express 2008 on another machine.I can see, the user login user1 is also present in sql 2008.Now I think I should add this user under security folder in sql 2008 but when I do, it says the user already exists.And therefore, I am still unable to login to a sql query analyser window by something like:./sqlexpressusername: user1pwd: passwordWhat do I do to solve t his please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-03 : 05:40:55
|
| is your default db setting mapped to the restored db?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-09-03 : 11:33:37
|
| Not sure how to find this out. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-03 : 17:54:04
|
| Google for 'orphaned logins', that'll give you tonnes of info on this problem.--Gail ShawSQL Server MVP |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-09-04 : 03:26:10
|
| Thank you |
|
|
|
|
|
|
login