November 5, 2002 at 8:41 am
I have a database(Produnction db), which
I created a bak file from and then restored over the development database. In my production database I have a user called MUser who has all of the permission assign to him trough role that was created in the database. The problem once I restored the production db over the development db,
I begin to have web problems getting an error
link communication is broken. Once I droppend the user and recreated him over and assigned the roles back to the new created user the web site begin to function correctly. Does anybody have an idea why it's happenning????
November 5, 2002 at 8:50 am
I'm assuming your problem is related to your development database. When you copied the database to the development box you also copied the database users. The database users where linked to production logins, so when you moved the database the user Muser was no longer associated with an server login on the development box. Basically it became an orphan user.
You needed to reconnect the orphan user to a develop login. This can be done using the "sp_change_users_login" procedure. Read up in BOL to determine how to use the sp to reconnect database users to server logins.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 5, 2002 at 10:26 am
If you cannot figure it out, pls post the exact errors.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply