HELP: (Cant connect to Database) -(Open Port)-(Disconnected)

[prossian]

Please can any one help me? ill make it in 1 thread so i wont get spammy thread

Problem #1: How to open port? i did add port in firewall and router but still no open port like 44405

Problem #2: If i turn on SQL server network protocol "TCP/IP" my DataServer and JoinServer will get this error "cant connect to database" but if i turn on the SQL TCP/IP .. it can connect to database, but if i turn it off the problem is i cant use some tools.

Problem #3: from problem no 2, if i turn off TCP/IP i can open the Main.exe and get inside, but if i click the channel i get disconnected, what am i missing with this one?

Im using:
SQL 2012
Windows 10

thanks for the help, God Bless

 

[JamesDev]

heyy maybe your problem is not ports, you need to run the ODBC

You must be registered to see links

You must be registered to see links

Download link:

You must be registered to see links

Enjoy

 

[prossian]

heyy maybe your problem is not ports, you need to run the ODBC

You must be registered to see links

You must be registered to see links

Download link:

You must be registered to see links

Enjoy

thanks for the reply, already did the odbc, through registry also did it manually. ill try and use this files of yours.. ill be back for reply.

UPDATE: its the same odbc that i have.. still having the same issue

 

[JamesDev]

thanks for the reply, already did the odbc, through registry also did it manually. ill try and use this files of yours.. ill be back for reply.

UPDATE: its the same odbc that i have.. still having the same issue

Only two problems with odbc or maybe with sql check it.

 

[prossian]

Only two problems with odbc or maybe with sql check it.

okay i will re install everything, but if i turnoff the tcp/ip of sql there will be no problem on connect and join, but when i select channel inside game i will get disconnected problem.. is it really not the open port?

 

[KarLi]

seems like u cant open the port, maybe u must do it thru your router/modem

You must be registered to see links

and odbc

You must be registered to see links

 

[JamesDev]

seems like u cant open the port, maybe u must do it thru your router/modem

You must be registered to see links

and odbc

You must be registered to see links

yes you can learn from these video tutorial

okay i will re install everything, but if i turnoff the tcp/ip of sql there will be no problem on connect and join, but when i select channel inside game i will get disconnected problem.. is it really not the open port?

or,,,, upload a video here so I can see how you do it, so I can teach you where you went wrong

 

[zipper20032]

Also check both x64 ODBC and x32 ODBC. I've encountered this problem on Windows 10 only apparently. I didn't have any troubles on Win 7 tho. Just place them in both x64 and x32 ODBC. I don't think there's any conflict between them.