April 2, 2009 at 12:21 am
Hi,
I got the following error message
Msg 916, Level 14, State 1, Line 1
The server principal "UserName" is not able to access the database "DBName" under the current security context.
Msg 15247, Level 16, State 1, Procedure sp_change_users_login, Line 46
User does not have permission to perform this action.
Shai
April 2, 2009 at 1:13 am
Whenever a database is restored, its as good as you are deleting and creating a new one. Until unless its specified, default db owner will be the user from which the db is restored.
April 3, 2009 at 11:15 pm
check what is your user's authentication, windows or sql server. below links may be helpful to you.
http://technet.microsoft.com/en-us/library/aa337562.aspx
http://msdn.microsoft.com/en-us/library/ms173463.aspx
"Don't limit your challenges, challenge your limits"
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply