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

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

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