Connection String for MsSQL 2008 database



You can use the following connection sting for connecting to MS SQL Server 2008 database

Connection to a SQL Server instance
------------------------------------
<add key="ConnectionString" value="Data Source=.\MSSQLSERVER;Initial Catalog=database_name;User ID=db_user_name;Password=db_password;Persist Security Info=True;" />

 

Connect to SQL server via TCP/IP Protocol
------------------------------------------
<add key="ConnectionString" value="Data Source=localhost,1435;Network Library=DBMSSOCN;Initial Catalog=database_name;User ID=db_user_name;Password=db_password;Persist Security Info=True;" />

 

Was this answer helpful?

 Print this Article

Also Read

Connection String for MsSQL 2012 database

You can use the following connection sting for connecting to MS SQL Server 2012 database...

How to View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Odin Plesk Panel

To View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Plesk, Please follow the...

How to connect to a MsSQL 2012 database using SQL Server Management Studio

Open the program SQL Server Management Studio Express and you will be prompted with a Connect to...

Connection String for MsSQL 2014 database

You can use the following connection sting for connecting to MS SQL Server 2014 database...

How to connect to a MsSQL 2014 database using SQL Server Management Studio

Open the program SQL Server Management Studio Express and you will be prompted with a Connect to...