Connection String for MsSQL 2012 database


Remote Database is strictly not allowed in Shared Hosting Servers.

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;" />

 



  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

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

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...

Connection String for MsSQL 2014 database

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...

Connection String for MsSQL 2016 database

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...

Connection String for MsSQL 2017 database

Remote Database is strictly not allowed in Shared Hosting Servers. You can use the following...