M2Server and SQL error

[Neptune]

wen i load up my M2Server.exe i get this msg

Loaded client version information and server table...
Loading StdItem.DB...
[23/04/2008 01:51:49] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'

any ideas?? i looked thru SQL to see what it says my username was and tryed changing it and no look

 

[1PKRyan]

Have You Setup Sql Right Mate.

 

[Neptune]

i can do everythin like add items mobs etc thru the DB i can make my self "admin" well im guessing i can, can view guilds etc that were on it (cool) and view the 1 player that was made "sting"

p.s there TD's files

 

[jewjewbee]

did you change sql password in dbserver/dbrsc.ini, and m2server/setup.ini
to your password>?

SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=*******

 

[Neptune]

ill have a look over it now and see what happens

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=(local)
SQLPort=3306
SQLDatabase=lom2
SQLUsername=sa
SQLPassword=lom2

i have that in the res and SQL data as you see, but were it says "(local)" is that correct, as people keep saying about "localhost" would this make a difference??

 

[koni]

the problem is the login details in sql, its looking at the txt that you have posted to log into the sql database, when you set up sql in mixed mode you would of entered a password and the created a database, the details in the setup.txt (m2server folder) and the dbsrc config file need to have the same database name and password or you will get a login odbc error in the m2server

 

[Neptune]

i just looked over both of those files and both r the same, i will install SQL again later on an retry

 

[Neptune]

im still getting the error message any ideasas or help is gr8

 

[WasteMan]

im still getting the error message any ideasas or help is gr8

Follow the guide lol... When you install SQLServer 2000 look for Mixed Authentication - then localhost and enter a password when your given the option - your username will always be sa and the password is what you choose it to be. Unless you do that - your always going to get an error in SQL 2000. Goodluck.

/Gelexx.

 

[Elvin]

I know you dont have to but go to control panel select administrative tools
then select ODBC data sources and when that opens up select system dsn and enter the details in there , see if that helps.

you can also try this
DBSRC.ini
[SQL]
SQLType=mssql
SQLHost=(local)
SQLDatabase=lom2
SQLUsername=sa
SQLPassword=Your password

!setup.txt for one database
[SQL]
UseSQL=TRUE
SQLHost=(local) you can also try localhost with no brackets or 127.0.0.1
SQLUsername=sa
SQLPassword=Your Password
SQLDatabase=Single DB name
SQLType=mssql
SQLPort=3306
SQLCharDatabase=Same as first db name for a single DB sql

!setup.txt for twin databases
[SQL]
UseSQL=TRUE
SQLHost=(local) you can also try localhost with no brackets or 127.0.0.1
SQLUsername=sa
SQLPassword=Your Password
SQLDatabase=lom2 or single database name
SQLType=mssql
SQLPort=3306
SQLCharDatabase=CharDB or two database name

 

[Neptune]

omg im such a noob, all is fine now,

ill explain wot i did so if any 1 else gets a error like this we have more info on it.

well basicly wen i get the server files, the dir for some of them was C:/Mirserver... and that was it wen i loaded on SQL, but i had my folder with a small "m" so i changed the folder name to the "M" and then it knocked everythin off in my SQL as it was looking for "mirserver" and not "Mirserver"

dont ask me wot made me check that with SQL i was just thinking about it and then it clicked wot i had done -_-