Reply to Re: newbie Simple Question about Users in SQL 2000

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация