MS SQL - SAMPLE CONNECTION STRING (ASP.NET)

This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP.NET:

<connectionStrings>

<add name="connStr" providerName="System.Data.SqlClient" connectionString="Data Source=YYYY;Initial Catalog=XXXX;User ID=XXXXX;Password=XXXXX;" />

</connectionStrings>

Data Source = YYYY - You need to use the server address listed in "Database server" field when you were creating your database in Plesk.

For security reasons, we have changed specific settings with XXXX

NOTE: You MUST include the full database name, which consit of the user prefix and the name that you have given, for example XXX_DB
webhosting company

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Changing permission in website Panel

1. Log in to WebSitePanel. 2. Click the File Manager to browse through the folders and files...

MS SQL Remote Management

We allow remote management/connections for our MS SQL database for applications such as SQL...

How to connect to MS SQL remotely?

The remote MS SQL is activated by default. You need to create database, and database user and...

MS SQL Reporting Services

We do include support for MS SQL Reporting Services.   For more information please check the...

Restoring MS SQL Database from a backup

If the database already exists and you only need to restore its content:   Go to Domains >...