How to keep user account when import/export in SQL Server 7 
Author Message
 How to keep user account when import/export in SQL Server 7

Read in Books Online about sp_change_users_login.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

Quote:

> I was moving database to another machine. I tried export, but lost all
> user accounts, only dbo left. Then I trid backup/restore, it's even
> worse. The user accounts didn't show up, and I couldn't add account with
> original name and grant permission, it kept saying the user  already
> exists.
> Any idea to deal with it?

> Thanx, Yiwei



Mon, 25 Nov 2002 03:00:00 GMT
 How to keep user account when import/export in SQL Server 7

Look at sp_change_users_login within Books Online

Keith


Quote:
> I was moving database to another machine. I tried export, but lost all
> user accounts, only dbo left. Then I trid backup/restore, it's even
> worse. The user accounts didn't show up, and I couldn't add account with
> original name and grant permission, it kept saying the user  already
> exists.
> Any idea to deal with it?

> Thanx, Yiwei



Mon, 25 Nov 2002 03:00:00 GMT
 How to keep user account when import/export in SQL Server 7
I was moving database to another machine. I tried export, but lost all
user accounts, only dbo left. Then I trid backup/restore, it's even
worse. The user accounts didn't show up, and I couldn't add account with
original name and grant permission, it kept saying the user  already
exists.
Any idea to deal with it?

Thanx, Yiwei



Mon, 25 Nov 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Import a user account from export file?

2. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

3. how can I import and export DTS package and SQL Server Agent between SQL Server Groups

4. Import / Export Question from MS SQL Server 2000 to MySQL Server

5. SQL User Accounts - Single or Multiple Accounts?

6. import from pastel accounting to sql server

7. Problem connectiing SQL server ODBC driver from user account

8. SQL Server User Account

9. Proxy SQL Server Agent Account for Non SA Users

10. Error trying to run jobs using domain user account for SQL Server AGent service

11. User can not access OLAP Cube after change the SQL Server Account

12. SQL Server Running under a User Account


 
Powered by phpBB® Forum Software