469,625 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Does DB-Restore on a different machine omit user/login information ?

Dear group,

I am a DB-Administrator for a Company that creates and maintains a
software solution based on SQL-Server and Crystal-Reports.

The Crystal-Reports part uses the following method to present data.
First a specific user (database authentification) is created with a
fixed password. Then Crystal Reports uses this
user/password-information to login to the database and present or print
the data.

I recently received a database from a customer of ours and i restored
it on my machine. It worked perfectly except that the Crystal Reports
part did not function at all (showing only blank reports).

After dropping the specific user and creating the fixed password the
thing worked.

So my question: does restoring a SQL-Server database on a different
machine alter or eliminate login and user information ?

Any reply will be highly appreciated.

Greetings from Vienna

Uli

Jul 23 '05 #1
2 1324
Yes - logins and passwords are at the server level and are stored in
the master database, so copying a user database may 'orphan' users.
Even if you have a login with the same name and password on your own
server, then SID will be different, so it won't map correctly to a
database user. See sp_change_users_login in Books Online, and this KB
article:

http://support.microsoft.com/default...b;en-us;314546

Simon

Jul 23 '05 #2

Simon Hayes schrieb:
Yes - logins and passwords are at the server level and are stored in
the master database, so copying a user database may 'orphan' users.
Even if you have a login with the same name and password on your own
server, then SID will be different, so it won't map correctly to a
database user. See sp_change_users_login in Books Online, and this KB
article:

http://support.microsoft.com/default...b;en-us;314546

Simon


THANK YOU VERY VERY MUCH

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by hendershot | last post: by
15 posts views Thread by Sabine Oebbecke | last post: by
8 posts views Thread by Mike Nolan | last post: by
4 posts views Thread by Mike | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.