0

I cannot connect to my SQL Server 2012 Express instance using addresses 127.0.0.1, local and localhost.

I added ports and test the databases on ODBC. I can also login over SQL Server management with all users but when I am trying to login over IP I get this error:

Login failed for user 'ipinfo'. Reason: Failed to open the explicitly specified database 'ipinfo'. [CLIENT: 127.0.0.1]

I have no connection strings but 'all i know is i am using mixed mode and all my users have the priviliges and access to the all databases.' i can 'login' with the same 'username' and 'passwd' using each 'users' and 'passwd' through the é Microsoft SQL Server Management 2012 Express ' but the real problem is when i lunch my 'Charserver.exe'

'which is a game server exe i use in my game servers, it is failing to connect to the required DBs. '

All ports and remote connection settings are done.

' My game server and the DBs are all on the same machine. '

Community
  • 1
  • 1
Ken Lin LIEN
  • 1
  • 1
  • Please show the code you used to try to open the database. – John Saunders Dec 24 '14 at 21:39
  • Is it primary instance? If not, you need append your instance name after `localhost`. – zhongxiao37 Dec 25 '14 at 06:19
  • @JohnSaunders **i'm trying to connect my DB with my exe. it's a game server "charserver.exe" and here is the config strings .exe file is reading:** ` ` – Ken Lin LIEN Dec 25 '14 at 11:00
  • That's not the code you used to open the database. Please include the connection strings, _and the code_ in your question. You can edit your question. Click the "edit" link. I hope you realize that you need _code_ to open the database. The connection strings are not enough by themselves. – John Saunders Dec 25 '14 at 15:47

1 Answers1

1

Open SQL server configuration manager and under your SQL Server Network Configuration for each protocol you find enable the TCP/IP Protocol and restart your services. It should work.

Marco Spijkerman
  • 31
  • 5