Skip to main content
S
SkyDocker
Participant
November 20, 2018
Question

Connecting users in SQL to a datasource in ColdFusion.

  • November 20, 2018
  • 1 reply
  • 264 views

I created a data source in ColdFusion to connect to a CFusion user in SSMS (SQL server management studio) but when I try to connect to the user through CF admin I keep getting a login failure, I have the user mapped to the database I want to connect to and the user is also a dbo, the password is the same and I have all of the right settings in the CF administrator I have TCP enabled I've tried reinstalling both ColdFusion and SQL server yet nothing is working, I don't know what I'm missing.

[Here is the list of all Adobe forums... https://forums.adobe.com/welcome]

[Comments is to ask about the operation of the Forum, not a specific program]

[Moved from the Comments forum to the specific Program forum... Mod]

    This topic has been closed for replies.

    1 reply

    WolfShade
    WolfShade
    Legend
    November 20, 2018

    Maybe I'm missing something, here.  But SSMS is just an interface to the actual SQL database server, so you should be connecting to the user account on SQL Server, not SSMS.

    Also, the database should be set up to use TCP/IP (default is Named Pipes, I believe) and make sure you're using the right port number (I think it's 1433 by default.. it's been ages.)

    HTH,

    ^ _ ^

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