Problem wih DB connection

Page 2 of 2 1 2
11/06/2015 19:24 Truth1010#16
As snick says, still not entirely sure what you are asking. Thought you already managed to get the server on-line with a virtual machine, just do the same for the VPS, but with their IP.

Screen, or more detail will help us :)
11/08/2015 09:05 Piccoloale099#17
Sql config:
[Only registered and activated users can see links. Click Here To Register...]

session:
[Only registered and activated users can see links. Click Here To Register...]

dbagent:
[Only registered and activated users can see links. Click Here To Register...]

login:
[Only registered and activated users can see links. Click Here To Register...]

gamelog:
[Only registered and activated users can see links. Click Here To Register...]

userlog:
[Only registered and activated users can see links. Click Here To Register...]

game:
[Only registered and activated users can see links. Click Here To Register...]

gamewar:
[Only registered and activated users can see links. Click Here To Register...]
11/08/2015 09:26 Truth1010#18
What server files are you using? Some of your config files look completely different to mine, or any i've seen.

Also, you can uninstall the GameWar service from SPC. It's not working/needed
11/08/2015 09:32 Piccoloale099#19
Quote:
Originally Posted by Truth1010 View Post
What server files are you using? Some of your config files look completely different to mine, or any i've seen.

Also, you can uninstall the GameWar service from SPC. It's not working/needed
I'm using shaiya omega files (ep 4.5)
11/08/2015 18:35 SkuulCandy#20
Shaiya login created ? ^.^
11/08/2015 18:43 Piccoloale099#21
Quote:
Originally Posted by SkuulCandy View Post
Shaiya login created ? ^.^
Yes, created and configured but nothing
11/08/2015 20:00 Truth1010#22
Best to try run the server and post here each log file for us to see the results.
If they match the first you posted, then the server files aren't connecting to your DB properly.
11/08/2015 20:57 SnickQ#23
Change all IP adreses in sql to 127.0.0.1 and check SQL Server Service. You should have Local Service [Only registered and activated users can see links. Click Here To Register...]
11/09/2015 06:30 Piccoloale099#24
Quote:
Originally Posted by Truth1010 View Post
Best to try run the server and post here each log file for us to see the results.
If they match the first you posted, then the server files aren't connecting to your DB properly.
PS_DBAGENT__system

PS_GAME__system

PS_GAMELOG__system

PS_LOGIN__system

PS_SESSION__system

PS_USERLOG__system

Same logs

Quote:
Originally Posted by SnickQ View Post
Change all IP adreses in sql to 127.0.0.1 and check SQL Server Service. You should have Local Service [Only registered and activated users can see links. Click Here To Register...]
Changed all IP to 127.0.0.1, in sql server service i've selected local service but still nothing, same error
11/09/2015 09:04 Truth1010#25
Well, the logs show it's not connecting to your Database with user Shaiya and pass Shaiya123.

Check/confirm you have that account/credentials in your SQL (under security tab)
If all are set to 127.0.0.1 then it's a local connection only as well, so only the host pc will be able to connect (with a local ip game.exe)

From what i said before though, your config ini files are slightly different to what i've usually seen. You have extra lines of data there compared to mine. I used Omega's files, but that was years ago, however i don't remember the configs looking like that.
Add me on Skype sometime and i'll try see where/what your problem is, as you seem to have everything set as it should be to your eyes, probably just missing something small :)
11/13/2015 17:29 Piccoloale099#26
#UP i've still same problem, i've contacted my host for know if was a their problem but they confirmed me that it wasn't. Any other ideas?
11/13/2015 23:09 treica#27
His problem was that the SQL Server was installed with a named instance and the server IP was set to whatismyip.com, i have reinstalled it for him with the default instance, set the right server ip and it started.
12/04/2016 15:53 dkaswan#28
Quote:
Originally Posted by Truth1010 View Post
Oh i see now. In that case...

Check TCP port 1433. That needs to be open for remote access to SQL. TCP port 1434 may also be needed, that's for the SQL Browser.

And when connecting remotely, if you are set to have named instances, other than default. Then you must connect like
Code:
12.34.56.78\SQLINSTANCENAME
The logs you originally posted show that the server is failing to connect to the DB though, that's why the confusion. It looks like your asking 1 question, but showing problems linked to another :)
I also had same problem, I choose default instance setting while installing MSSQL Server 2008 Express Edition, but instance name was SQLEXPRESS instead of MSSQLSERVER. So I just updated all db ip (in ini files and Server Patch Config to "127.0.0.1\SQLEXPRESS"
12/05/2016 21:23 Piccoloale099#29
Quote:
Originally Posted by dkaswan View Post
I also had same problem, I choose default instance setting while installing MSSQL Server 2008 Express Edition, but instance name was SQLEXPRESS instead of MSSQLSERVER. So I just updated all db ip (in ini files and Server Patch Config to "127.0.0.1\SQLEXPRESS"
Solution already given about one year ago :) thanks for necroposting!
Please close this thread
Page 2 of 2 1 2