Highlighted

Connecting users in SQL to a datasource in ColdFusion.

New Here ,
Nov 20, 2018

Copy link to clipboard

Copied

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]

Views

133

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Connecting users in SQL to a datasource in ColdFusion.

New Here ,
Nov 20, 2018

Copy link to clipboard

Copied

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]

Views

134

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Nov 20, 2018 0
LEGEND ,
Nov 20, 2018

Copy link to clipboard

Copied

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,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 20, 2018 0