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

How to connect to a MsSQL 2008 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...

How to connect to a MsSQL 2012 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...

Connection String for MsSQL 2008 database

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

How to connect to a MsSQL 2014 database using SQL Server Management Studio

Remote Database is not allowed in our Shared Servers.  For getting Remote Access for Management...