an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > SQL Server Authentication on Multiple Servers
Last Post 6/20/2008 10:45:16 AM By lukezy. 1 replies.
6/18/2008 5:08:32 PM
lanewman
Posts: 17
Joined: 6/14/2008
Location:Ft Lauderdale, FL, US
SQL Server Authentication on Multiple Servers
Hello, I'm trying to install the software in a multi-server environment.
Web Server: no SQL Database server installed
Database Server Sql Server 2005 Express
In addition, I need to pass a SQL Server Login to the dB. The user I'm running the command prompt from doesn't have access to the dB.
Any suggestions on how to proceed? I can't figure out how to get to installer to use a sql server login.
Thanks
6/20/2008 10:45:16 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Server Authentication on Multiple Servers

In InstDSC\Program.cs change line 98 from

                string args = string.Format("-E -S {0} -d \"{1}\" -i \"" + Utils.GetInstallPath() + "\\CreateDemoStore.sql\" -b", server, dbname);
to
                string args = string.Format("-U <your username> –P <your password> -S {0} -d \"{1}\" -i \"" + Utils.GetInstallPath() + "\\CreateDemoStore.sql\" -b", server, dbname);

Alternatively you could create DB on your local box and restore it to your production server.

DotShoppingCart Staff