asked on

Web Config / DB string on ASP.net

I have a common web config connection strings in asp.net / IIS / MS SQL Server Express DB.
When it is on localhost, everything is working. Both file web config & connectionstrings.config file are in the same directory level.

When it is on www.abc.com, the database does not read and have no error message.
Any idea how to fix it?

Web config

<connectionStrings configSource="connectionStrings.config" />

Open in new window

connectionStrings.config file name

<add 
       name="pwrsssdfsadfasdf_connectionstring"  
       connectionString="Data Source=WIN-GB8M3MMasdfasdf6T2M\SQLEXPRESS;Initial Catalog=dbdata;Integrated Security=True;User ID=sa;Password=asdfdsa000!"
       providerName="System.Data.SqlClient"
       />

Open in new window

Obadiah Christopher

What is this Data Source?

WIN-GB8M3MMasdfasdf6T2M\SQLEXPRESS

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jesus Rodriguez

Check first pcelba suggestion. After that ask yourself this question

- Did you are hosting the www.abc.com website in your machine or pointing to your machine??? ??

If your answer is yes then check the connection to your database (firewall open ports that allow connect throught sql ports) , if your answer is no and you're connected to a database that reside on www.abc.com host machine then you need to point your connection string to that database like www.abc.com\SQLEXPRESS. if is an sql express what you are using on that domain.