CODEWITHSUNDEEP
visual-studio-2010sql-server-2005database-connectionconnection-string
Crysis Hhtht
Crysis Hhtht

Reputation: 131

SQL Server database connection

I have an ASP.net web application and a database created on another computer. Now I want to run this on my computer.

I have installed SQL Server Express edition and SQL Server Management Studio on my computer and I copied database file to my SQL directory and attached it successfully through SQL Server Management Studio. Applications current connection string looks like this.

<add name="ASPNETDB" 
     connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" 
     providerName="System.Data.SqlClient" />

What do I have to change in this to make it work? FYI I have already copied database to SQL Server Management Studio default installation directory and attached it through SQL Server Management Studio express. Also I connect to SQL Server Management Studio using this server name.

localhost\SQLExpress

Upvotes: 1

Views: 268

Answers (1)

marc_s
marc_s

Reputation: 754258

If you've attached the database to your SQL Server Express instance, then you should be able to use this connection string from now on:

<add name="ASPNETDB" 
     connectionString="Server=.\SQLEXPRESS;Database=ASPNETDB;Integrated Security=True" 
     providerName="System.Data.SqlClient" />

With this, you basically tell your application

  • what server (instance) to connect to (.\SQLEXPRESS)
  • what database to use on the server (ASPNETDB - or whatever name you gave it)
  • to use integrated security (e.g. use your Windows credentials) to log on to SQL Server

That's all you need - SQL Server will handle all the details of dealing with data and transaction log files and all those nitty gritty jobs for you.

Upvotes: 1

Related Questions