Open up C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG
2004-04-16 10:13:45.32 server SQL server listening on TCP, Shared
Memory, Named Pipes.
2004-04-16 10:13:45.32 server SQL server listening on
192.168.1.159:1433, 127.0.0.1:1433.
2004-04-16 10:13:45.32 server SQL Server is ready for client connections
It should have something like that. 1433 is the default port that SQL
server will listen on. The key thing to look for is the TCP and get the
IPs back.
1) If you don't have it listening check to make sure the ports are open.
2) Also make sure the SQL server is patched. An unpatched SQL server on a
Win2K3 box will not allow SQL server to listen in on TCP ports but will
allow shared Memory and Named Pipes - which means you can't create a JDBC
or ODBC connection but could connect via Enterprise Manager and Query Analyzer.
Won
At 13:56 4/15/2004 -0400, you wrote:
>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
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:160166>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=9550.8683.4>Fast
>Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>
>----------
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: Error adding CF Datasource Nathan C. Smith
- RE: Error adding CF Datasource Burns, John D
- RE: Error adding CF Datasource Burns, John D
- RE: Error adding CF Datasource Dave Watts
- RE: Error adding CF Datasource Dave Watts
- Re: Error adding CF Datasource Paul Hastings
- RE: Error adding CF Datasource Dave Watts
- RE: Error adding CF Datasource Dave Watts
- Re: Error adding CF Datasource Paul Hastings
- RE: Error adding CF Datasource Dave Watts
- Won Lee