[CD3.55] cant connect to database

[ervinzed]

i get an error msg on 3.55 server



i tried changing password or deleting CD.ini, firewall is disabled and OBDC gives the same error (Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.) when changing/placing a password for the dbs individually

this is the result from Kaori Mir 3 Setup Checker


---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 0 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
---------- Game Database (Direct) ----------
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
---------- Hero Database (Direct) ----------
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
---------- SQL Checking Done ----------


what should i look at to solve this?

 

[Ardbeg]

Try changing the connection setting from Windows Authentication mode to SQL Server Authentication mode.

 

[ervinzed]

same error, i even reinstalled sql



another error if i choose to continue anyway

 

[Ardbeg]

Have you tried this after rebooting your machine or with it still running ?
Sometimes windows updates can affect some SQL services and sometimes using another program to access the database can also affect them.
If you look in your Task Manager for various SQL services, notice any that aren't running and restart them. SQL Server browser is one that sometimes gets stopped.
Close MS SQL 2xxx down and restart the machine, see if that does the trick or, failing that, check for the stopped services.

 

[ervinzed]

still doesn't connect..


any other suggestions?

 

[Odisea]

it may be that you have not configured OBCD correctly with SQL.


Why you strip error when opening the CD is that I can not connect to that table.


Tip: Look back at the OBCD have if the address of the SQL or her behalf are misplaced.

 

[Serane]

Check crueldragon.ini and check the ip you added in also the name and password between cdini and sql

must be:
ID= sa
Password= your password

 

[ervinzed]

i tried all sorts of things and it still cant connect

i checked Microsoft help pages for mssql 2000 and tried everythingon multiple virtual machines, still the same error

 

[Patan]

to your secound error, i had ALWAYS the same problem after deleating the local server oder uninstalling enterprise manager(sql)
never got local server running again after it but dunno why :/