URGENT: ConnectionString for SQLServer db
- From: "Cirene" <test@xxxxxxxx>
- Date: Wed, 5 Dec 2007 18:33:33 -0500
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!
.
- Follow-Ups:
- Re: URGENT: ConnectionString for SQLServer db
- From: William \(Bill\) Vaughn
- Re: URGENT: ConnectionString for SQLServer db
- From: W.G. Ryan
- Re: URGENT: ConnectionString for SQLServer db
- Prev by Date: Re: Transactions and ASP.NET Membership
- Next by Date: Enumerate providers on System / Understanding providers and dataproviders
- Previous by thread: RE: Error while connecting remote SQL server
- Next by thread: Re: URGENT: ConnectionString for SQLServer db
- Index(es):
Relevant Pages
|
