Problems with SQL 2005 and I do not know >.<!

[mamalola]

Here is more information:

-Importan information:

Operative System: Windows Server 2008 Standar
SQL version: SQL Server 2005 Express
Server files: Project 1.03h JPN Season4
Firewall: Outpost firewall Pro 7.5.1

-More info:

Already Restaured MuOnline database
Already created ODBC manually, using as server, the name of SQL (useretc/SQLEXPRESS) <-- this is an example

-Information of the problem:

When i start the Server StartUp: At begin The first dataserver drop this:

Error
GSDBSet ODBC Connect Fail

-Extra information:

I tried launch the GS only: And It doesnt read my user and pass of SQL; this says that i must configure SQLmanagerSystem.ini (I also tried change the ip 127.0.0.1 to the name of SQL (useretc/SQLEXPRESS); but i didnt work.

I hope you can help me! This is my first day with this SO and SQL, really need this, A a huge a merry Christmas.

Added information:

ExDB Shows: SQLSTATE:28000, diagnosis:[Microsoft]SQL Native Client][SQL Server]

JoinServer Shows: When i start to start it, it just crash.

DataServer1 and 2 Shows: GSDBSet ODBC Connect Fail

______________________________________________________________

Added:

When i create the ODBC manually, i should select SQL Native Client or SQL Server?

Second question, I create a ODBC called MuOnline, There is another ODBC that i should make?

[MentaL]

[EnErDjIIIII]

i had similiar problem. First delete your sql and when you register the sql make sure the SQL Instance Name is only "SQLEXPRESS" without useretc. This can be done during the installation of sql.This will prevent the gameserver from saying whatever it says :D.... oh and keep in sqlmanagersystem.ini - 127.0.0.1, no sql names.

About ODBC's ... after you do that thing with the sql you will start creating the odbc. If your OS is 64bits - go in c:/windows/syswow64/odbcbad32 and open and create odbc. Or the easiest way is to open the odbcx64 from database but before you do that , open odbcx64 with NotePad(Right Button and Edit :D). Now since you already open the odbcx64 wih notepad make sure to change "(local)" with your sql name instance -by looking at what you've written it will be probably "SQLEXPRESS".

1st Start with your sql ... the name instance has to be with 1 name only.. DO NOT USE TWO like useretc/SQLEXPRESS - gameserver will not start. This was my problem.