Connecting users in SQL to a datasource in ColdFusion.

[SkyDocker]

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]

[WolfShade]

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,

^ _ ^