August 9, 2002 at 9:43 am
We are basically trying to backup the database on one server and restore it on another server. While trying to restore, SQL Server, terminates the restore process with the error message 'Server user xxxx is not a valid user in database xxxx'. Please note that we have the user in both the SQL Servers (source and target) and user names too are the same. The command we used to restore the file on the new server is given below
RESTORE DATABASE 'C:\ITMDOCS\TEST.BAK' FROM
WITH FILE =1,
MOVE 'TIMN99' TO 'C:\TEST45.MDF',
MOVE 'TIMN99_log' TO 'C:\TEST45_log.ldf'
The user on both the SQL Servers have 'DiskAdmin' and 'Dbcreator' roles assigned to them. For security reasons, we cannot assign 'sysadmin' fixed server role to the user on both the Servers.
Please help us if there is a way to solve this.
Thanks
Suresh
August 9, 2002 at 10:03 am
Typically happens with sql logins. They will have one id on the original server, a different id or not exist on the new server. Set up your logins first, then after you restore run sp_change_users_login to match up user to login.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply