C
Cirene
I developed my ASP.NET 2.0 web app using SQL Express. Now I'm moving it to
production.
On my web server I attached the SQL Express mdf database to a new SQL Server
database. The (example) SQL Server settings are:
DB Name: rnz_mydb
Server IP: sql123.MyHost.com
Login ID: rnz_admin
Db Type: MSSQL 2005
The current web.config connection string is this:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\zASPNETDB.MDF;Integrated
Security=True;Initial Catalog=ASPNETDB"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\zASPNETDB.MDF;Integrated
Security=True;Initial Catalog=ASPNETDB"
providerName="System.Data.SqlClient" />
</connectionStrings>
What should the connection string be now (to point to the new SQL SERVER
db)?
Thanks!
production.
On my web server I attached the SQL Express mdf database to a new SQL Server
database. The (example) SQL Server settings are:
DB Name: rnz_mydb
Server IP: sql123.MyHost.com
Login ID: rnz_admin
Db Type: MSSQL 2005
The current web.config connection string is this:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\zASPNETDB.MDF;Integrated
Security=True;Initial Catalog=ASPNETDB"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\zASPNETDB.MDF;Integrated
Security=True;Initial Catalog=ASPNETDB"
providerName="System.Data.SqlClient" />
</connectionStrings>
What should the connection string be now (to point to the new SQL SERVER
db)?
Thanks!