Posted by Mo on 06/16/07 22:41

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?

Thank you

• Next in forum: Multi access in SQL Server
• Prev in forum: Re: Parameter for Stored Procedure
• Thread view: Re: newbie Simple Question about Users in SQL 2000

[Reply to this message]