0

My program connects to a MSSql database. If it connects via LAN it works fine, if it connects from outside I get the error message 0x80131904 Error when logging in the user 'ProgProj'. (translation might not be the same as on the english version. On the german version its like that)

I can exclude a port problem, because when the port was closed the message was that the server was not reachable. After opening the port it says it cannot login. But the login works on LAN with the very same Username and password.

What could be the cause of this problem? thanks!

EDIT-------------------------------------

It micht be that i have multiple databases running. When i connect via lan I set the servername and the name of the database. for example: sqlhost = DB01\DBNAME when i connect from outside tough, i do not specify what instance i want to connect to.. only the public IP address.. Because the ip addres followed by the \DBNAME does not work. how can i specify the server instance i want to connect to?

  • You have to specifically allow remote connections when you configure MSSQL. Have you done that? – Ramhound Jul 8 '15 at 11:57
  • if by allowing remote connections you mean "server properties -> connections -> allow remote connections to this server" then yes. if there is an additional setting then not. also in "default connection options" there is nothing checked. dont know if that is correct. Thanks! – sharkyenergy Jul 8 '15 at 12:02
  • updated the question with additional information that came to my mind right now.. – sharkyenergy Jul 8 '15 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.