Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Moving SQL Server

Author  Topic 

silas2
Yak Posting Veteran

65 Posts

Posted - 2007-02-20 : 12:26:50
I'm doing a remote deployemnt of an asp.net app using Sql Express from my local dev machine to the ISP.
Moving the database to the new machine is one thing, but how do you move the users?
Just adding the same username and pwds as logins is still going to throw you out of the db isn't it?
I've run the Database Publishing Wizard on the target machine, but the t-sql falls over whenever it encounters an unknown user.

Kristen
Test

22859 Posts

Posted - 2007-02-21 : 02:30:44
This may help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Move%20database,Moving%20to%20a%20new%20sql%20server,Fix%20Orphaned%20Users

Kristen
Go to Top of Page
   

- Advertisement -