Connection String for MsSQL 2012 database



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

Connection to a SQL Server instance
------------------------------------
<add key="ConnectionString" value="Data Source=.\MSSQLSERVER2012;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,1437;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 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...

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...

Connection String for MsSQL 2008 database

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

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...