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

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