'Duplicate connection name' error from SQL Server

Question

I've created a SQL Server database to keep track of transactions that will be handled by an application (Windows service) which connects to DB with a Login user.

When I'm trying to connect to the DB, the server replies with

Duplicate connection name

I've tried to connect to the database using SQL Server Management Studio and it works, but from the app it doesn't.

Does anyone know any solution for this?

The connection string is: EXEC SQL CONNECT TO :gHostConnect USER $integrated; — C. Damoc
– C. Damoc, Commented May 12, 2017 at 12:28

C. Damoc · Accepted Answer · 2017-05-12 12:48:56Z

1

The problem was caused by the fact that the user must be mapped to database role membership as db_owner. By setting the role, the connection problem was fixed.

image: set database role membership to db_owner in SQL Server Management Studio

answered May 12, 2017 at 12:48

C. Damoc

5264 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

'Duplicate connection name' error from SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related