Unable to start DataServer, SQL Server does not exist or access denied

[shin1234]

Hi I have experience in setting up MuOnline server, however I am having an issue in attempt to setup the following server.

https://forum.ragezone.com/f197/release-original-*********-muserver-97d-1123147/

Firstly, I am using Microsoft SQL Server 2016 with SP2 and I have successfully restored the DB for SQL 2005 and up.

Secondly, upon trying to startup my dataserver1 i am receiving this error - >

# SQLStateL08001, diagnosis:[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. #

Thirdly, in attempts to narrow down the issue, I have wrote a simple script on python to connect to my MuOnline.dbo.Test_Table, a table which I created on SQL Management Studio to test if I am able access my MS SQL Server on an external connection. And Yes it works, I am able to return my Test_Data1, Test_Data2

Fourthly, I am suspecting the issue lies in the OCDB that was given. Here's a script for the OCDB that was given in the above link for x64 bit OS

#

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnline]
"Driver"="c:\\WINNT\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnlineJoinDB]
"Driver"="c:\\WINNT\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\USELOG]
"Driver"="c:\\WINNT\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"USELOG"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"

#

Upon further checking, the folder for DefaultDSNDir \ODBC\DataSources does not exist in my C:\Program files\Common files

But I am not sure if it is right... Greatly appreciate if anyone could help

 

[KarLi]

do this

You must be registered to see links

and if still issues, insall sql server 2012 with management studio instead maybe ill sugges.t

 

[shin1234]

do this

You must be registered to see links

and if still issues, insall sql server 2012 with management studio instead maybe ill sugges.t

hi hi i have managed to solve it the issue lies with the ports in svc 2008 and up