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 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 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 Setting Folder or File permissions in Plesk 17.X

To set the folder or file permission in Plesk 17.X, please follow the following steps :- 1. Log...

How to Change the ASP.NET Framework Version

Please follow the below steps to change the ASP.NET Framework version, Log in to...

Powered by WHMCompleteSolution