Can't log in to Data Source

[kathryn]

I have created a DSN in Control Panel on my PC (Win NT). The database is an SQL 7.0 db on a co-worker's PC. The drive on which the db sits is shared. I can test the ODBC connection in Control panel and it works perfectly.

In Cold Fusion, I can see the ODBC source, but verification fails when I try to verify it. I can see the database in the database list in Studio, but it asks for a log in and password if I try to look at the tables or to create a new query. I have tried using my Windows login and password, but no luck.

Details on Control Panel ODBC configuration:

System DSN
Name: LeadManSys
Server: ALMEIDA_A
Verify using Windows NT authentication

When I click the "Test Data Source" button at the end of the setup, I get the message "TESTS COMPLETED SUCCESSFULLY!"

In CF Administrator, these are the settings:

Data Source Name: LeadManSys
Server: ALMEIDA_A
Use Trusted Connection is NOT checked, currently, but I have tried to verify with it checked and it still doesn't work.

Login Info Database: LeadManSys


Does anyone have any ideas? When I try to verify, I get the following:
***********************************
The connection to the data source failed. Check the following to resolve this problem:
Are the data source settings configured properly?
Did you provide valid security information in the data source settings ?

For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Windows NT Services Control Panel to change the account the ColdFusion Server service is using.
*************************************

Any help, ideas, war stories, resources or references would be greatly appreciated.

 

[kathryn]

As a followup to the above, I have gone in to Control Panel...Services, and set the CF Server to not use the system account, but to use my domain account.

Still no luck. When I verify the data source in Administrator, it fails.

I found a help article which said that if the data source verification fails, that you can use CFQUERY to get more info. How would I do that?

Any help greatly appreciated.

 

[DarkMan]

Maybe it means if you run a CFQUERY, the error message you get from the failed attempt will give more info that may point to the problem?

I've had trouble similar to this when the default database for a User had been deleted. Check the your Username in SQL Server for your default database. (You may want to try making the LeadManSys database the default for this user...)

Another idea: On the Server line, try inputting the ip address of the SQL Server instead of the server name.

The above are just ideas. Hopefully either they'll work or point you closer to the problem. Sorry I couldn't be more helpful....

DM

 

[programmher]

Kathryn,

I had the same problem. It was resolved when I re-installed CF. During setup, all the options were not selected (examples, etc). Once I selected all the options, it installed the cfsnippet, a test MSAccess database, etc. This resolved my issue. Hope this helped (in case you haven't already resolved this issue).