connection to sql server 2000

[mickywall]

i am trying to connect to a database on my machine. I am running windows 2000 advanced server.

below is the connection string
DSN1 ="DRIVER={SQL Server};SERVER=MICKTS;UID=sa;PWD=;"
DSN1 = DSN1 & "DATABASE=MICdb"
Set conn = Server.CreateObject("ADODB.Connection&quot
conn.Open DSN1


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
/development/search.asp, line 44

has anyone any ideas?

 

[redgate]

Hi

I would guess you have your SQL Server setup for windows Authentication only.

Try - right the click the Server in the SQL Enterprise manager and select properties. Click the security tab.

Change the authentication to SQL Server and Windows and not just Windows only.

Hope it helps.