Posted by Erland Sommarskog on 06/17/07 08:53

Mo (le_mo_mo@yahoo.com) writes:
> Thank you very much for your great post. It was quite informative. as
> you mentioned I detached and copy the MDF file to the new machine and
> attached it. I have read the documents and I am still a bit confused.
> I have removed d_xxxxx from the users in the instance. Then I have
> added d_xxxx in the logins in master. Then I have changed the d_xxxx
> server roles to System Administrators and have assigned the database
> access with the roles public and db_owner for the database. Is this
> the wrong process? Currenlty under logins I have d_xxxxx as user and
> under users in the instace I have:
>
> Name Login Name DataBase Access
> --------- ------------------ -------------------------
> d_xxxx d_xxxx permit
>
>
> I still get login failed for user d_xxxx. Can this be just a case of
> bad password?

If the message is just "Login failed for user 'd_xxxxx'" this usually
indicates a problem with the password - or the login name itself. If
the problem was with the access to the database, the message is different.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]