creation I am specifying the user that I created for connections to SQL
and right now that user is set up as a System Admin in the SQL server.
John Burns
-----Original Message-----
From: Nathan C. Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 2:28 PM
To: CF-Talk
Subject: RE: Error adding CF Datasource
Is your service account for all the ColdFusion services set up as a
domain user with security access to the appropriate systems?
-----Original Message-----
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:57 PM
To: CF-Talk
Subject: Error adding CF Datasource
Ok, I just set up a new server with Windows 2k3 server. This is the
first go around I've had with working on W2k3. I installed MS SQL and
CFMX 6.1 on the server. I can connect to the SQL server fine through
enterprise manager and I set it up a windows user to use when connecting
to the sql databases. I went into the CF admin and set up a datasource.
When I submit the datasource, I get the following error:
Connection verification failed for data source: (mydatasource)
[]java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Login failed for user '(domain\cfuser)'. Reason: Not
associated with a trusted SQL Server connection.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer
JDBC Driver][SQLServer]Login failed for user '(domain\cfuser)'. Reason:
Not associated with a trusted SQL Server connection.
What I'm trying to figure out is whether this is a CF thing or a SQL
server thing or maybe some new default security lock-down in W2k3.
Please help! :-)
Thanks,
John Burns
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
