sql server connect: Not associated with a trusted SQL Server connection. -- sql server connect

Not associated with a trusted SQL Server connection.

Jennifer Sanders
2/9/2004 11:58:45 AM

sql server connect:

My connection to a local machine running MSSQL Server has
failed. I'm trying to set up a datasource using ODBC
through the ColdFusion Administrator. I've successfully
set up a ODBC datasource DSN in the ODBC control panel
using windows NT authentication. But when I try to use
SQL server authentication through the CF Admin or through
the ODBC panel, I get the same error: 'Not associated with
a trusted SQL Server Connection'.

Are there workarounds for this?

Although a remote possibility, since I installed MSSQL a
while ago, I may have the password wrong. Is there a way
to check the password within the MSSQL program?

(I've also tried changing the port from port 1433 to port
80 and changing from the named server on my local network

RE: Not associated with a trusted SQL Server connection.

Jennifer Sanders
2/9/2004 3:29:28 PM

OK. At least now I'm getting a different error. It says:
Login failed for user 'Administrator'.

Just noticed that two services that might be pertinent are
stopped: MSSQLServerAdHelper and SQLExecutive. Are these
left over from SQLServer 6.5 or could they be causing the
error?

[quoted text, click to view]

RE: Not associated with a trusted SQL Server connection.

kevmc NO[at]SPAM online.microsoft.com
2/9/2004 10:02:53 PM

Check the server settings in Enterprise Manager under the security tab.
Set the server to allow both SQL Authentication and Windows Authentication.
Then stop & start MSSQLServer service.
Retest.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

RE: Not associated with a trusted SQL Server connection.

kevmc NO[at]SPAM online.microsoft.com
2/10/2004 8:31:29 PM

If you're getting login faild "Administrator" then you must not be in a
domain or logged on as a user in the domain.
If your machines are in a workgroup and you want to make a Trusted
Connection , then you need to have the same username & password on both
machines.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.