2.3 files M2Server error >.< ( screeny )

[OoOoOo24]

Hey i set my server files up using the " guide for idiots" or whatever lol and came accross this error when loading my M2Server =/ any ideas?
I did doa search of the forums and nothing helped.




Thanks

 

[Killmaster]

Means your MSSQL isn't connecting to it. What does your DBServer say also?

 

[OoOoOo24]

TFrmDBSrv.starttimer
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected


=/ any changes i can make to MSSQL? as i downloaded the server files ready to use so there shouldnt accualy be a problem with them...... should there?

 

[Killmaster]

Its you lol.
You havent got the right password set in the files for it to connect to MSSQL.

Here is how to change the password without reinstalling.
Go onto Enterprise Manager. Open the security folder and then click on logins.
Double click on 'sa' then enter your new password in the password box. It should ask to confirm your new password again when you press ok.

 

[OoOoOo24]

did what you said & the problems still there =/

 

[Killmaster]

You have the set the password in the files right havent you lol?

 

[Weikster]

Make sure db name and sql pass is in your files.
M2Server/!Setup.txt
DBServer/dbrsc.txt

SQLUsername=sa
SQLPassword=your password
SQLDatabase=mir2 (your DB name)
SQLType=mssql

 

[PackardBell]

also did u install MSSQL Server in mixed mode and choosed your own password which u will use in the files Weikster told u to?

 

[OoOoOo24]

nevermind sorted it now, and yes i did all them things.
In the end i just re-installed SQL 2000 and restartd my computer and it worked
Thanks for your help all.

 

[Killmaster]

Glad its now working.