- Joined
- Dec 13, 2004
- Messages
- 119
- Reaction score
- 4
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
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