an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Move Database to Another Server - Permissions
Last Post 1/12/2010 9:23:06 PM By lukezy. 4 replies.
1/11/2010 10:15:03 AM
Applied
Posts: 93
Joined: 9/18/2009
Move Database to Another Server - Permissions
After moving a database to another server, what if any grants and permissions might need to be executed to allow the web site to perform DB operations as before?
 
1/11/2010 11:28:15 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Move Database to Another Server - Permissions
If you are just moving the database to a new server, you will need to make sure network service account has permission to access the new database. And then enable the service broker on the new database by running the following script.
 
alter database dotshoppingcart SET ENABLE_BROKER
ALTER AUTHORIZATION ON DATABASE::[dotshoppingcart] TO [sa];
DotShoppingCart Staff
1/11/2010 11:47:52 PM
Applied
Posts: 93
Joined: 9/18/2009
Re: Move Database to Another Server - Permissions
Thanks - I assigned EXEC permissions on all the stored procs. to get mine to work.
 
Does the 'alter authorization' command achieve the same effect?
 
1/12/2010 12:06:24 AM
Applied
Posts: 93
Joined: 9/18/2009
Re: Move Database to Another Server - Permissions
Licence Key - the server we have moved the database to is another internal server. However, entering Site Admin informs us that the Licence Key is invalid and won't accept the existing one. Do we need a new key, or can the existing one be made to work? (The new server is not a customer server).
 
1/12/2010 9:23:06 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Move Database to Another Server - Permissions
Did you move the web server as well? If so, you will need to ask us to reset your license key. Please check this.
DotShoppingCart Staff