SQL Server 2000 - Connection could be not be established

[JamesNewZealand]

When trying to connect to my SQL Server I'm getting the following error:

******************************************

A connection could not be established to (local).

Reason: Logon failed for user.

Please vertify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.

******************************************

SQL Server is definately running, but I'm unable to connect.

I've tried changing the ODBC settings but I can't get past the "MIcrosoft SQL Server DNS Configuration" window. I choose "With Windows NT authentication using the network lognin ID" and click "Conect to SQL Server to obtain default setting for the additional congiruation options" and click "Next" but I get stopped by the following error:

connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user machine1\Administrator'

Does anyone have any ideas on what I need to do to fix this? If it helps, this all seems to have started occuring since I changed the Administrator password

 

[DavidT_macktool]

Please post your connection string:

Sql server rights have not been granted to the user/password combination ==> read this:

http://support.microsoft.com/?kbid=889646&FR=1

 

[prav_roy]

as David says u need to post ur connection string,
also make sure u have rights to access sql server, and try to connect it through sql server authentication mode if you succeed in that then you can try out Windows Authentication,