Problem with database connect

03/02/2013 22:25 DarkHost#1

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

03/03/2013 04:06 st.jimmy998#2

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

03/03/2013 07:16 DarkHost#3

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

03/03/2013 09:55 Sh1nra#4

Check all .ini Files in:

PSM_Client/Bin/Config
PSM_Server/Config

Try to encrypt password new

03/03/2013 11:30 DarkHost#5

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