Web.config connection string not working on site

Question

0.00/5 (No votes)

See more:

i have a SQL database for my little site
this connection string was working on site but host had some changes and it does not working anymore

C#

<add name="connectionStringName" 
connectionString="Initial Catalog=siteIp;
Database=databaseName; 
User ID=userName; 
Password=password;" 
providerName="System.Data.SqlClient" />

i tried to fix it and use this connection string in visual studio and every thing is ok
but this not working on website!
i changed web.config on site and refresh the site but not working!

C#

<add name="connectionStringName" 
connectionString="Data Source=siteIp; 
Initial Catalog=databaseName; 
User ID=userName; 
Password=password;" 
providerName="System.Data.SqlClient" />

i am wondering why this work on visual studio but not working in site?

What I have tried:

i can login to my database by SQL Server Managment Studio
Server Name:siteIp
Login:userName
Password:password

Posted 10-Sep-20 14:40pm

4L4K1

Updated 12-Sep-20 10:03am

v2

Add a Solution

2 solutions

Solution 1

Check that the actual server is visible from the client computer, and that there are no firewalls in place that might block SQL Server: Configure Windows Firewall - SQL Server | Microsoft Docs[^]
It's pretty obvious, but check the server he is connecting to does have the DB installed under SQL - if you are Attaching a DB for example then that will only work to Express editions of SQL Server, not Production.
Then check what the actual server he is using has configured in terms of users and passwords: unless he is using the same server as you it's likely that the users are not set up.
Also look at any error messages generated by the connection process - they can often tell you what area the problem is.

Posted 10-Sep-20 20:10pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

4L4K1 · Accepted Answer · 2020-09-12T10:04:00

Solution 2

I published whole site and uploaded it again and everything is ok
i do not know why editing connection string in web.config file not working

Posted 12-Sep-20 10:04am

4L4K1

Updated 12-Sep-20 10:05am

v2