[GUIDE] Setup a server without errors [1x GameServer]

Quote:

Originally Posted by killerbern how can create SRO_VT_ACCOUNT.bak or were i can... how can create SRO_VT_ACCOUNT.bak or were i can find it!??

Quote:

Originally Posted by Yfel Alright, I got my server running but when I run it using edx. it says my server is offline, can anyone tell me what settings I need in edx?? Also here are all the pics.. If anyone knows the solution, I would really appreciate it.

Quote:

Originally Posted by zikor1337 already answered on the first post ! of course it is offline . You have 2x "db connection failed" error that means your ini files are wrong !

Quote:

TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore failed for Server 'DOME-PC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Unable to open the physical file "C:\Database\SRO_MDF_files\SRO_VT_ACCOUNT_Data.MDF ". Operating system error 5: "5(Zugriff verweigert)". (Microsoft.SqlServer.Express.Smo)

Quote:

Originally Posted by zikor1337 of course . You have 2x "db connection failed" error .

Quote:

Originally Posted by _HouseMusicx3 u may know whats wrong at me ? when i try to restore database ...

Quote:

Originally Posted by zikor1337 send me your teamviewer. I'll take a look my self !

Quote:

Originally Posted by Yfel Alright, yeah ive noticed that like 5 minutes ago but everything is ok in database, ive done everything EXACTLY as in this post. Is there anything else that I need to edit in MSSQL besides Privileged IP,An account and the Region? Ive added everything in ODBC at User DSN. And ive edited everything in the Certification. Im 100% sure that my ini files are good.... Could you explain me what ive done wrong...

Quote:

Originally Posted by _HouseMusicx3 thanks for fixing it ;) @ 8,400 posts ;D

Quote:

Originally Posted by zikor1337 post me your srShard.ini and srGlobalService.ini

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=1234;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=1234;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=1234;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

Quote:

Originally Posted by Yfel srGlobalService.ini Code: [global] count=1 [entry0] operation_type=22 name=SRO_Vietnam_TestLocal query=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=1234;DATABASE=SRO_VT_ACCOUNT global_manager_node_id=697 srShard.ini Code: [global] count=1 [entry0] id=64 global_operation_id=20 operation_type=22 name=SroLand query=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=1234;DATABASE=SRO_VT_SHARD query_log=DRIVER={SQL Server};SERVER=MITCH\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=1234;DATABASE=Log_DB capacity=20 shard_manager_node_id=705 u1=240 u2=208 u3=17 u4=1 u5=0 u6=0 u7=0

Quote:

Originally Posted by zikor1337 Make me a picture of your databases .

Quote:

Originally Posted by Yfel You mean this? [Only registered and activated users can see links. Click Here To Register...] NVM, I think I see the problem. The DB should be Shard_Init... in srShard.ini. I'll test it right now..