Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 18:02

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Can't connect to account DB cannot occupy db session : select *

Discussion on Can't connect to account DB cannot occupy db session : select * within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2007
Posts: 77
Received Thanks: 5
Can't connect to account DB cannot occupy db session : select *

Hello everyone I always get the following error
in the global manager

Can't connect to account DB
cannot occupy db session: select * from SK_SilkChange_BY_Web
cannot occupy db session: update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64



if anyone can help me out over teamviwer wold be nice

Checkt this srGlobalService and the other datas 1000X
blackrider1234 is offline  
Old 07/04/2020, 13:57   #2

 
XxGhostSpiriTxX's Avatar
 
elite*gold: 53
Join Date: Jul 2012
Posts: 542
Received Thanks: 191
check the certificate settings
XxGhostSpiriTxX is offline  
Old 07/04/2020, 14:00   #3
 
elite*gold: 0
Join Date: Mar 2007
Posts: 77
Received Thanks: 5
Quote:
Originally Posted by esteve458 View Post
check the certificate settings
Yeas did this 100x now... At moment I take a brake and check again but I'd don't found any mistake
blackrider1234 is offline  
Old 07/04/2020, 15:56   #4

 
CloudStrife^'s Avatar
 
elite*gold: 192
Join Date: Apr 2020
Posts: 47
Received Thanks: 22
1) Check IP address on ini Certification
2) Check SQL Server, enable TCP/IP and set specific port
3) Check firewall settings
CloudStrife^ is offline  
Old 07/05/2020, 08:07   #5
 
elite*gold: 57
Join Date: Apr 2020
Posts: 73
Received Thanks: 18
Cert > ini>SrGlobalService
check sql pw and id and host name
also DB connect located at C
Nario7 is offline  
Old 07/05/2020, 09:54   #6
 
elite*gold: 0
Join Date: May 2020
Posts: 130
Received Thanks: 51
Sometimes, some files come without "SERVER=".
For example:

query=DRIVER={SQL Server};SQLNAME\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=id ;PWD=password;DATABASE=SRO_VT_SHARD


The correct format is :

query=DRIVER={SQL Server};SERVER=SQLNAME\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=id;PWD=pas sword;DATABASE=SRO_VT_SHARD
Emerald Garden SRO is offline  
Thanks
2 Users
Old 07/05/2020, 11:26   #7
 
elite*gold: 0
Join Date: Feb 2016
Posts: 309
Received Thanks: 39
Bla bla bla,

dm me and i will fix it for you.
Krypton93 is offline  
Old 07/05/2020, 11:52   #8
 
elite*gold: 0
Join Date: May 2020
Posts: 130
Received Thanks: 51
Quote:
Originally Posted by KingMaeX View Post
Bla bla bla,

dm me and i will fix it for you.
I have fixed it for him today. The problem was the missing "SERVER="
Emerald Garden SRO is offline  
Reply


Similar Threads Similar Threads
[Selling] Honorbuddy - Account & Key (Lifetime Session) Unlimitierte Session
06/01/2016 - World of Warcraft Trading - 0 Replies
Honorbuddy - Account & Key (Lifetime Session) Unlimitierte Session | eBay
cannot occupy db session : select * from SK_SilkChange_BY_Web
02/18/2014 - SRO Private Server - 6 Replies
Hello, whenever I start the globalmanager it gives me that error. Screenshot by Lightshot
cannot find quest index for subquest_42 Assertion failed: (!"cannot find quest index"
02/06/2012 - Metin2 Private Server - 0 Replies
cannot find quest index for subquest_42 Assertion failed: (!"cannot find quest index"), function LoadStateScript, file questnpc.cpp, line 99. Root Server How FIxt
cannot find quest index for mb Assertion failed: (!"cannot find quest index"),
02/06/2012 - Metin2 Private Server - 0 Replies
cannot find quest index for mb Assertion failed: (!"cannot find quest index"), function LoadStateScript, file questnpc.cpp, line 99. :mad: How fix



All times are GMT +1. The time now is 18:02.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.