Maybe when you installed MS SQL 2K you specified the access to be Windows
Authentication only and not SQL Server and Windows?
You can change this in your Enterprise manager, right click the server,
properties, go to Security tab and change to SQL Server and Windows.
I had this problem once and that fixed it for me.
HTH,
Nick
:> -----Original Message-----
:> I GET THE ERROR WHEN I CONNECT TO SQL SERVER 2000
:>
:> Microsoft OLE DB Provider for SQL Server error '80004005'
:>
:> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
:> Server connection.
:>
:> here is the connection string
:>
:> strConn = "Provider=SQLOLEDB; Data Source=" & _
:> Request.ServerVariables("NETXPLOR-VOIP") & _
:> "; Initial Catalog=TfXpressDB; User ID=sa; Password="
:>
:> do i need to set some thing .
:> this connection string was working fine in sql server 7
:>
:> PLEASE HELP
:>
:> thaks
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
