an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > SQL Server installation on different server
SQL Server installation on different server
Last Post 6/14/2010 1:31:11 PM By lukezy. 10 replies.
2/2/2010 12:29:31 PM
landsharkdaddy
Posts: 16
Joined: 1/24/2010
SQL Server installation on different server
I want to install the dotShoppingCart on one server and have the database be on a different server with SQL Server installed. What I am looking for is exactly what paramaters I need to run the InstDSC with. I think I have a grasp on all the other parameters but I am not sure what I should be putting in the database data file path parameter if anything at all. Any help you can give me on this would be appreciated.
InstDSC.exe <database server name> <database name> <database data file path> 
<encryption key path> [<smtp email server>] [<system email address>]
2/2/2010 12:41:13 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server installation on different server
The database data file path is where you want to put the database file on the database server machine. It's the local path on the database server machine e.g d:\SQLData\ . Make sure the path exists.
DotShoppingCart Staff
2/3/2010 12:32:38 PM
landsharkdaddy
Posts: 16
Joined: 1/24/2010
Re: SQL Server installation on different server
OK so exactly what will the installation command line look like if I do the following:
 
Database Server Name = databaseserver.host.com
DatabaseName = dotshoppingstore
DatabaseFilePath = ??
EncryptionKeyPath = ??
SMTP email server = mail.testing.com
System.EmailAddress = testing@test.com
 
My installtion command line string to me looks like this
 
InstDSC.exe databaseserver.host.com dotshoppingstore d:database\dotshoppingstore  d:\BowlopolisStoreEncryptionKey
 
I am thinking the databasefilepath should be like the d: drive on the database server? and the encryption key should be saved on the machine that is running the dotshoppingcart software. Please help me clear this up.
 
2/3/2010 12:45:20 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server installation on different server
You get the most right. You can run the following
 
InstDSC.exe databaseserver.host.com dotshoppingstore d:\database\dotshoppingstore  d:\BowlopolisStore\EncryptionKey mail.testing.com testing@test.com
 
d:\database\dotshoppingstore  is the path on the database server and make sure it exists before you run the command.
d:\BowlopolisStore\EncryptionKey  is the path on the web server where you install DotShoppingCart Software
DotShoppingCart Staff
2/3/2010 4:09:34 PM
landsharkdaddy
Posts: 16
Joined: 1/24/2010
Re: SQL Server installation on different server
That was perfect and exactly what I was looking for. It seems to work just fine now.
6/1/2010 7:43:15 AM
bansal_db
Posts: 181
Joined: 4/13/2009
Re: SQL Server installation on different server
I have a related question. Where would the orderpipe service installed?
 
On the web server or the database server?
 
-D
6/1/2010 10:14:52 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server installation on different server
You can install it to any server. Web server might be a better fit.
DotShoppingCart Staff
6/11/2010 6:49:51 AM
bansal_db
Posts: 181
Joined: 4/13/2009
Re: SQL Server installation on different server
Hey Luke,
 
I don't want to use the admin user for sql, so i created a new user and modified the web.config connection string and app.config connection string.
 
What rights should this new user have on the database?
 
Thanks
 
-D
6/11/2010 11:46:03 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server installation on different server
Why don't you use the default user Network service?
DotShoppingCart Staff
6/14/2010 1:24:43 PM
bansal_db
Posts: 181
Joined: 4/13/2009
Re: SQL Server installation on different server
The network service has the db_owner rights to the database. Currently my production site runs the same way.
 
I don't want to give db_owner rights to the user from the website for security reasons. That's why I created the new user and trying to limit the rights.
 
Do you what rights are required by the database user or it has to be db_owner?
 
Thanks
 
-D
6/14/2010 1:31:11 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server installation on different server
Why did you give dbo to network service? Network service has been granted all the necessary permissiones by CreateDB.sql. If you want to see more detail, please take a look at CreateDB.sql which you can find in the install folder.
DotShoppingCart Staff
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.