DBServer Problem

[noisound]

DBServer Problem:

"TFrmDBSrv.starttimer"

M2Server Problem:


Loaded client version information and server table...
Loading StdItem.DB...
[06/03/2009 18:55:31] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user



all it says on the screen, its been a while since ive looked at any files, and i have no idea what the problem is,

dbsrc notepad:


[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=(local)
SQLPort=3306
SQLDatabase=mirserver
SQLUsername=*****
SQLPassword=*****
[Setup]
ServerName=Diamond
ServerAddr=127.0.0.1
ServerPor=6000
MapFile=C:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=127.0.0.1
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=127.0.0.1
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=C:\mirserver\DBServer\FDB\
IdDir=C:\mirserver\DBServer\FDB\
HumDir=C:\mirserver\DBServer\FDB\
FeeDir=C:\mirserver\DBServer\FDB\
BackupDir=C:\mirserver\DBServer\Backup\
ConnectDir=C:\mirserver\DBServer\Connection\
LogDir=C:\mirserver\DBServer\Log\
[Backup]
AutoBackup=1
BackupTime=18000000



and yes all the ip's in the other notepads are correct


any help please?


all the others work fine.

 

[Ri0N]

Your SQL username has to be SA. did you set up SQL using mixed authentication mode or w/e its called?

If you didnt uninstall SQL and reinstall it cos you need to use default sql account. When you set up SQL choose 'mixed authentication mode' make the username 'sa' and any pass you want.

Please feel free to correct me if im wrong.

 

[T0MMY]

Don't like the look of the mirserver as sql database, try put it as lom2.

 

[noisound]

didnt set SQL as sa


ty all figured problem just gota sort it now


thanks