[INFO]MSSQL: The Easy Way

[jM2.me]

Just some info, credits to everyone but not me.

I will assume that you have installed MSSQL 2008 and restored databases.
Then you tried to setup ODBC and failed. If it's true then simply do following.

Open each server.ini and change

ODBC = "SQL Native Client"

to following

ODBC = "SQL Server"

Now change "SERVER" values to either IP Address of your MSSQL Server or local address. Like following:

SERVER = "(local)"

or

SERVER = "127.0.0.1"

or

SERVER = "192.168.0.10"

or

SERVER = "10.0.0.15"

or

SERVER = "[COMPUTERNAME]\[MSSQLINSTANCENAME]"

like following

SERVER = "jM2-PC\MSSQLSERVER"

Note: the name of your mssql instance might be different.

After that you can delete all ODBC Configuration and start server.

Note: It is recommended to turn on TCP/IP protocol for the MSSQL Instance that you will be using. (should be turned on by default)

 

[laukinfai001]

These are things which do not understand basic?? Do not understand do not rack server

 

[WireShark]

nice that's was so easy =)

 

[esteniomaldade]

Thanks!

 

[al3css]

abd for this error you know something??



------------------------------------------------------------------------------
-- Logging Start (09/04/11 14:07:47)
------------------------------------------------------------------------------
14:07:47 - "D:\RaiderZ Server Files\RaiderZ Server Files\AppServer\AppServer.exe" 14:08:02 - Start application without service mode
14:08:02 - application_commandline : "D:\RaiderZ Server Files\RaiderZ Server Files\AppServer\AppServer.exe"
14:08:03 - Server Socket Opened. (Port = 7502)
[e] 14:08:03 - Init GameDB fail.
14:08:03 - Can't Connect To DBMS
[e] 14:08:03 - Failed! InitDB
[e] 14:08:03 - Server Init Failed: 1: DB에 연결할 수 없음
14:08:03 - Server Closed




my db name is CALIDUS\SQLEXPRESS not (local)