Click here to Skip to main content
15,886,919 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
GoDaddy changed the way the connection is made to MS SQL database only a few days ago. They are no help to me to get connected with my ASP.NET site. Here is the old connection string.
<add name="DbConnStr" connectionstring="Data Source=184.168.194.70; Database=DB98067;User ID=DB98067;Password=*******;" providername="System.Data.SqlClient">
And here is the information they provide for connecting to the database:

"You can use these database connection details, for example, when you are asked to specify ones during installation of a web app."
Host
P3NWPLSK12SQL-v15.shr.prod.phx3.secureserver.net:1433
Database name
DB98067
User name
DB98067
Password
******

But I don't know how to modify my connection string with this new information. I tried to replace the IP address with the host name with no success. Can someone guide me to useful information to change the connection string?
I searched without success.

What I have tried:

I tried to insert the host name for the IP address without success.
Posted
Updated 18-Jan-24 9:36am
v2
Comments
[no name] 18-Jan-24 17:29pm    
https://kili.io/2022/11/26/how-to-find-your-godaddy-database-connection-string/
BobbyStrain 18-Jan-24 18:52pm    
Thanks. But they just changed it 2 days ago.
BobbyStrain 18-Jan-24 19:40pm    
GoDaddy support fixed it with a second call. I included the port in the server name which they corrected. I'm sure there are lots of unhappy clients that got no notice of the change. Years ago they deleted my database and I had to reconstruct it. I keep an old backup now.

1 solution

Answered only to remove from Unanswered queue: solved by Godaddy support.
 
Share this answer
 
Comments
BobbyStrain 19-Jan-24 15:32pm    
I intended to accept your solution. Did I?
OriginalGriff 20-Jan-24 1:28am    
Yes. :D

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900