Sql/M2server error

[DemDem]

Ok just started making a new server and got stuck on this:

Server Started...
-- SQL KeepAlive
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
-- --> Error Keeping Query Alive!
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
-- --> Error Keeping QueryCommand Alive!
H-QyChr=0 H-NwChr=0


That error from Database ^^^^^


[4/5/2007 6:19:16 PM] -- SQL KeepAlive
[4/5/2007 6:19:16 PM] -- --> Error Keeping Query Alive!
[4/5/2007 6:19:16 PM] -- --> Error Keeping QueryCommand Alive!

This from m2server. What do we do to sort this out please?

Also can get into the server but can't create character, I am going to hazard a guess that this is why?

/Ash

EDIT:

Also we can't find the "Table admin" ~.~

 

[Xx69xX]

heres screenie of our problem

 

[DemDem]

Anyone want to help lol?

 

[Xx69xX]

no 1 know ? lol .. ,

 

[jasper]

it looks like you have installed mssql incorrectly, or have the incorrect info in the ini's as to what the db is called, id and pass, perhaps. i think i had it 1st time round, and i hate to say this, but im sure i searched the interent for
"login failed for use sa.....!

but there are clever people here,, im sure someone may know the definitive answer


edit, just found this, might be useful

http://www.scriptlogic.com/support/kb/displayarticle.asp?UID=564

 

[Dookie]

Do you have a user "sa"?

 

[Xx69xX]

meaning?

the id as SA?

or the user after SQL server group?

 

[Skyline]

uve installed sql wrong.

Reinstall when u coem to the 1st password bit, use a windows logon ID and Pass.

next page use another password i nthe two boxes

 

[Xx69xX]

kk cheers geeza ty 4 help