Steps to connect MSSQL 2008 database

Please use any one of the following connection string for connecting to MS SQL Server 2008 database:-


Connection to a SQL Server instance 
------------------------------------
<add key="ConnectionString" value="Data Source=.\MSSQLSERVER2008;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 OR SERVER IP ADDRESS],1435;Network Library=DBMSSOCN;Initial Catalog=database_name;User ID=db_user_name;Password=db_password;Persist Security Info=True;" />

  • 8 Users Found This Useful
Was this answer helpful?

Related Articles

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

How to change the databases user name and password

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

Steps to take backup & restore MS SQL database in PLESK 12.X Control Panel?

To Backup and Restore MSSQL Databases in Plesk 12.X, please follow the following these simple...

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

Powered by WHMCompleteSolution