Help|Problam In SessionServer

[RonShin]

hello
i have vps and is service pack is sp2 windows server 2003

and im using sql 2000

i changed the ip and the sql user and password in SessionServer

but i gat error like thes in the photo



anyone know what the problam here?

[Ultimo ☼]

check this:

14. Go To Security -> Login -> Right Click -> New Login
15. Put Name "account" -> Click Dot In SQL Server Authentication
16. Use "account" As Password -> Choose "master" As Default Database
17. Go To Tab Database Access -> Click On Database "account, billing, cash, character"
18. In Permit In Database Role Click On "db_owner" For Each Of The 4 Databases -> Click OK
*If You Get An Error "User "account" Already Existed" Then Go To "account, billing, cash, character" -> Users And Delete The User "account" That Should Be There. And Then Do Steps 14-18 Again
19. Go To Databases -> "account, billing, cash, character" -> Right Click -> Properties -> Permission Click All Of Them On User "account"
20. Open SQL Query Analyzer And Run Query In Q-1 And In Q-2

Obviously you can choose to use this Name and Password, or you can change them at your leisure. Just be sure that you are giving the right permissions.

[RonShin]

i did all thet and still the same problam

anyone??

[BlackLixt]

try to restore the database that is what i recomend maybe get a new sesion server file or folder

[conquer93]

check your sql acc properties
i think your acc does not have acces to your dekaron databases.

@ Sql go to Security tab and then go to Logins.
ther will be your account and right click it /Properties.
now go to database acces and give your account (db_owner) to \Account\billing\cash\character\ this might fix your problem...