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

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

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