Problem with database connect

DarkHost · 03/02/2013, 22:25

I have very stupid problem with DB connection.
I moved my game server to vps hosting and now I can't connect to database. I see that port 1433 is open, but in logs

Code:

2013-03-03 01:03:43 PS_USERLOG__system log start (UserLog)

2013-03-03 01:03:59 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=DarkHost1982, Pass=HeruVi12

I can use these login and password for SSMS and remote connections without problem. It's not my first instalation.
Thanks for any help.
OS - 2008Server

st.jimmy998 · 03/03/2013, 04:06

Maybe "linked server"?
did you create new user on sql logins?

DarkHost · 03/03/2013, 07:16

I see all "linked server" in the Server Objects -> Linked Servers. Of course I created a news user "DarkHost1982". I see him in the "Security" tab and I can connect to db from remote workstation.

Code:

SELECT srvname FROM master..sysservers
game
PS_DEFINEDB
PS_GAMEDB01
PS_NCASH
PS_USERDB
PS_USERDB01
WIN-65N21CUC4VB\SQLEXPRESS

and

Code:

SELECT name FROM master.dbo.syslogins
sa
##MS_SQLResourceSigningCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_PolicySigningCertificate##
##MS_SmoExtendedSigningCertificate##
##MS_PolicyEventProcessingLogin##
##MS_PolicyTsqlExecutionLogin##
##MS_AgentSigningCertificate##
NT AUTHORITY\system
NT SERVICE\MSSQL$SQLEXPRESS
BUILTIN\Users
BUILTIN\Administrators
DarkHost1982

Sh1nra · 03/03/2013, 09:55

Check all .ini Files in:

PSM_Client/Bin/Config
PSM_Server/Config

Try to encrypt password new

DarkHost · 03/03/2013, 11:30

I've tried it.
I created new user with a simple login and password. But it did not work. I'm shocked.