Troubleshooting : Sample Connection String for MSSQL ? Print

Sample String :

Please refer the below sample string

ASP Sample Connection String :
-----------------------------------

<%Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={SQL Server};Server=serverip;Database=databasename;UID=username;PWD=password;"%>

ASP.NEtSample Connection String
------------------------------

<connectionStrings>
<add name="sqlConStr" connectionString="Data Source=serverIP; Initial Catalog=databasename;User ID=databaseusername;Password=password;"
providerName="System.Data.SqlClient"></add>
</connectionStrings>

Using these sample connection string you can check your database connectivity to your site.