[Request] Need help Client error on start

[terra006]

Client problem finxed but...now i got another one -.-" after i'm online i got DC after 5-10 sec...what can be the problem?

i got this in GameServer :

DBConnect :

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=5.112.93.62;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=112233;"
DBConnA.Open strConnectA

%>

[turkplaya76]

can you connect to DBConnect thru your browser ?
it should show a blank page
"yourip/DBConnect.asp"

[terra006]

i get an white page when i do what you say ....... i use now hamachi it can be problem?

[youngvegas]

Solution :

YOyoyo broski

The issue is your DBconnect and your ODBC and your DB itself

go into ur DB ur ODBC and your DBconnect

MAKE SURE ALL THE NAMES ARE MATCHING you will say they are but they're not

i'll help u step by step here

1.Go into Database go into security > logins > your login make sure sever roles are all ticked ( i think its sever mapping or roles idk but i think its roles )make sure in general ur default db is SRO_VT_Account go into server mapping tick (SRO_VT_Account SRO_VT_SHARD SRO_VT_SHARDLOG and in the bottom box tick db_owner and public for each of the DBs)
in ur ODBC u know wat to do its common sense if not then go to it and recheck it

[terra006]

was a good one to check ODBC ^^ it was setted little wrong
but when i go in sql on login and try to make my SRO_VT_ACCOUNT how you said "db_owner and public" i got this error from sql...

Fixed Thx to Chernobyl <3