How do I connect to a SQL Server database on my ISP?

  • I've got a web application for my side business. I've added a SQL Server 2019 database to it. Now, I'm trying to connect to it using SSMS 20.2 and also Visual Studio Code. I've been following the instructions they have here which seems straight forward to me. The error I'm getting from Visual Studio Code (the last attempt I tried) is this:

    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: 25 - Connection string is not valid)

    Perhaps I've got the IP wrong, I am not sure. I hunted around for the IP for my website, and used what I found.

    Up to now I have always used a SQL Server database either in my employer's domain or one I had on my personal PC. This is my first attempt at trying to use a SQL Server database on an ISP. I appreciate what help you can give me. Thank you.

    Rod

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply