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 |
|
auser
Starting Member
2 Posts |
 Posted - 2010-09-06 : 06:25:13
|
| Hi,I've just restored a database from another machine onto mine.Now when I need to access the database I get: "Login failed for user 'xxx'"I checked that the user exists in the database and also checked that SQL Server 2008 is running on SQL Server and Windows Authentication mode.Any idea why I get this error?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-06 : 12:13:24
|
| you need to create a login for the user.for just a single user, it's probably easiest to drop the user from the newly restored database, then create a login and add then add it to users in the database. |
 |
|
|
|
|
|
Login failed for user 'xxx'.