Hi,
I have a asp.net website on my local machine it is running fine with connection string
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
on production server(shared hosting) i had to create my database( with a user name and a password) on server by running query it was created successfully with all the tables like on development machine, and i got error(on my login.aspx page) when tried to log in using login page then i used this connection string
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;database=Database1;Connection Timeout=30;User id=databaseuserid;Password=databaseuserpassword"
providerName="System.Data.SqlClient" />
</connectionStrings>
but i got same error(on login.aspx page) which i got earlier when i tried to log in to my website using its login.aspx page, error is given below
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
Plz can anyone tell me what CONNECTION STRING i should use so that i can run my website without this error.
Thanks