Help|Problam In SessionServer

03/26/2012 12:22 RonShin#1
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

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

anyone know what the problam here?
03/26/2012 14:55 Ultimo ☼#2
check this:

Quote:
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.
03/26/2012 22:28 RonShin#3
i did all thet and still the same problam

anyone??
03/28/2012 18:19 BlackLixt#4
try to restore the database that is what i recomend maybe get a new sesion server file or folder
03/30/2012 02:06 conquer93#5
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...