MSSQL 2005 Connection Problem
I have done everything to allow remote connections to the database but still to no avail!
- All CentOS services start with [OK]
- Allowed both .exe's through firewall. (inbound and outbound)
- Enabled remote connections for user root.
- Enabled tcp/ip protocol.
- Port is correct and set to 1433.
- Running as administrator
- SQL and Windows authentication enabled.
I can login with the account using SQL Server Management Studio Express using SQL Authentication.
I have also executed the command to create an account successfully in the database.
I have tried to connect to the game but I cannot connect.
Last but not least I have also tried Cabal-Tools which just gives me the following error.
Quote:
SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
Re: MSSQL 2005 Connection Problem
Check youre MSSQL Configuration tools -> Surface Area Configuration -> Surface Area Configuration for service and connection -> check if MSSQL is start or stop if stop then try to start it ... and then try to run youre server
Click me
Re: MSSQL 2005 Connection Problem
Quote:
Originally Posted by
TanGzkie
Check youre MSSQL Configuration tools -> Surface Area Configuration -> Surface Area Configuration for service and connection -> check if MSSQL is start or stop if stop then try to start it ... and then try to run youre server
Click me
I already told you I have done that in the first post (TCP/IP Protocol). I have been searching google for 2 days, that is how I got those other fixes. I came here as a last resort so please don't direct me back to google.
Thanks for taking the time to post though.
Re: MSSQL 2005 Connection Problem
Please also provide your cabal logs.
Re: MSSQL 2005 Connection Problem
Quote:
Originally Posted by
TanGzkie
Check youre MSSQL Configuration tools -> Surface Area Configuration -> Surface Area Configuration for service and connection -> check if MSSQL is start or stop if stop then try to start it ... and then try to run youre server
Click me
its clear that he can connect on SQL,no problem on SQL service. the problem is, he cannot connect on game.
@Xero: check your odbc.ini in server side. check the IP, port and DSN in every database. also check your internal on client, make it sure you are using centos IP not SQL :) and please provide a logs.
Re: MSSQL 2005 Connection Problem
I personally checked this one via Teamviewer, it was configured properly.
But that didn't convince the MSSQL service to listen to that port. A fresh MSSQL 2008 R2 installation solved the problem.
I suspect evil gypsy magic behind this.
Re: MSSQL 2005 Connection Problem
Quote:
Originally Posted by
Alphakilo23
I personally checked this one via Teamviewer, it was configured properly.
But that didn't convince the MSSQL service to listen to that port. A fresh 2008 MSSQL R2 installation solved the problem.
I suspect evil gypsy magic behind this.
Thank you so much for taking your time to help me, I really appreciate it!
+rep
Quality Member!
**REQUEST THREAD CLOSE**