Knowledgebase
MS SQL - SAMPLE CONNECTION STRING (ASP.NET) Print this Article
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
Was this answer helpful?
Related Articles
MS Access
Does TechPlus support MS Access? MS Access is typically used in conjunction with Windows servers...
Does TechPlus support MS Access? MS Access is typically used in conjunction with Windows servers...
Accessing your MySQL database with Perl
The Perl module, DBI.pm is a convenient way to connect to the database from within Perl scripts....
The Perl module, DBI.pm is a convenient way to connect to the database from within Perl scripts....
Maximum number of databases per hosting account
We provide different number of databases in each hosting account. You can check detail on each...
We provide different number of databases in each hosting account. You can check detail on each...
Do you support for MySQL 5.x?
Yes. We support for MySQL 5.x.
Yes. We support for MySQL 5.x.
MS SQL Remote Management
We allow remote management/connections for our MS SQL database (Business and Mocha plans only)...
We allow remote management/connections for our MS SQL database (Business and Mocha plans only)...