I'm new to MS SQL, so this may be a dumb error, but anyway, I can't figure it out. I'd like to connect to an SQL server on the internet, I've a valid username and password, but it can't find the server.
So, I've tried the following connectionstring: ConnectionString="server=127.0.X.X; uid=XXXXXX; pwd=XXXXXXXXXXXX; database=master", but it won't even get to check the uid/pwd. I've the following error message: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ".
I've tried using the TCP/IP but it says the same (can't find target computer, or something similar).
What is wrong with it?
I could use any help. so please, if you know, what the problem could be, post it!
Thank you very much!