Steps to connect MSSQL 2012 database

Please use anyone of the following connection string 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 [OR REPLACE_WITH_YOUR_DOMAIN_NAME],1437;Network Library=DBMSSOCN;Initial Catalog=database_name;User ID=db_user_name;Password=db_password;Persist Security Info=True;" />


  • 24 Users Found This Useful
Was this answer helpful?

Related Articles

Steps to connect MSSQL 2008 database

Please use any one of the following connection string for connecting to MS SQL...

How to manage website Files in the Plesk Control Panel

In Plesk Control panel the "File Manager" is used to upload, remove and organize all your website...

Steps to View Database via PhpMyAdmin / ASP.Net Enterprise Manager in Plesk

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

How to change the databases user name and password

Plesk panel version 12.0.18Steps for change the Databases username and password  1. Login...

How to change default index page in Parallels Plesk Panel 11.5

Follow the below steps to change the default index page in Parallels Plesk Panel 11.5 for...

Powered by WHMCompleteSolution