1

I want to upload my DNN site in customer's host, they use SQL Server 2005 and they use named instance, how can I use named space in connection string ?!

<add key="SiteSqlServer" 
     value="Data Source=79.175.164.226,2005; Initial Catalog=jdmedu; User ID=; Password=;" />

DNN shows database connection error.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sahar
  • 11
  • 1
  • The connection string is correct, assuming the actual one has the correct userid and password. The named instance is not relevant since the port number is specified instead. Post the actual error. If it is login failed error, the SQL Server error log will contain additional information not returned to the client. – Dan Guzman Sep 27 '15 at 11:52

1 Answers1

0

Can you check that you can construct ODBC Connections to the DB (outside of your application).

I Suspected that, the problem is in the Configuration of the DB Instance and it can be solved from the SQL Server Configuration Manager.

Also, can you check http://www.connectionstrings.com/sqlconnection/connect-via-an-ip-address/

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

OSAMA ORABI
  • 441
  • 1
  • 4
  • 14