Skip to main content
J
jyotis73
Participating Frequently
September 2, 2015
Question

Login failed for user ''. when verifying datasource connection in Coldfusion Admin

  • September 2, 2015
  • 1 reply
  • 2908 views

All other datasource connections are verified OK except one connection to SQL Server and on verification it gives an error Login failed for user".

I'm using mixed mode authentication in SQL Server. Can 't seem to think what else to get rid of the error.

Please advise,

Thanks,

Jyoti.

This topic has been closed for replies.

1 reply

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
September 8, 2015

It seems the verification request is sending a blank string to the database management system. Edit the datasource settings, entering the correct user name.

J
jyotis73Author
Participating Frequently
September 8, 2015

Thanks for replying back BKBK.

That was also my first guess, and I tried doing that. But I can't submit my datasource credentials, since it gives me error to add something from ODBC DSN drop down list, and my ODBC DSN drop down is empty for some reason. How can I add entries for ODBC DSN drop down ? And also is it the same thing to add a SQL Server Connection instead of ODBC Socket, since SQL Server Connection came out Ok. But my lead wants me to add it is a ODBC Socket connection and not as a SQL Server Connection.

Thank you,

Jyoti

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
September 8, 2015

You can create an ODBC DSN in Windows as follows:

1) Open Control Panel;

2) Double-click on Data Sources (ODBC). That will open the ODBC Data Source Administrator;

3) Select the tab, System DSN.

4) Click on Add.

5) Follow the instructions to create a new DSN for SQL Server.

When you're done, restart ColdFusion. The new DSN will be available to the datasource page of the ColdFusion Administrator.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices