Some thing for help you? for MSSQL 2k5
1-In file config [db]. if you use localIP (local) / 127.0.0.1 or IanIP or wanIP and still error. Pls use ....\SQLEXPRESS (your MSSQL 'name)
2-In file config
2.1 AccountServer.cfg
dbserver =...\SQLEXPRESS
db =accountserver
userid =account
passwd =EZCpyYOZVofugqDFBZrLKw==
2.2 GameServer.cfg
db_ip = ...\SQLEXPRESS
db_usr =game
db_pass =EZCpyYOZVofugqDFBZrLKw==
2.3 GroupServer.cfg
IP = ...\SQLEXPRESS
DB = gamedb
Login = game
Password = EZCpyYOZVofugqDFBZrLKw==
2.4 same other.
3- when you attach or restore Database. Pls delete User [game,account] and schemas [game,account] under gamedb and accountserver only .Some time when you delete User [game,account] and schemas auto delete too. (for beginer skill only)
3.1 create new user (game and account) and password is Y87dc#$98 (it md5 for EZCpyYOZVofugqDFBZrLKw== ) under security --->Logins and now you focus on Logins right click --> NewLogins
3.1.1 Under General tab.
login name: game
and select SQL server Authentication: password is :Y87dc#$98
and select Enforce password policy only
and Default database: gamedb
3.1.2 Under Server Roles
select public and sysadmin
3.1.3 Under User Mapping
select gamedb only and below select all role.
3.1.4 Under Status
select Grant and Enabled
3.1.5 press Ok button.
3.2 Do the same for user is account and database is accountserver (3.1.1 --> 3.1.5)
4. check all files config form your server folder.
5. Run server.
1-AccountServer.exe
2-GroupServer.exe
3-GateServer.exe
4-GameServer.exe
-----------------
Sorry my bad english and sorry if it wrong.