NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: de la Rosa on July 09, 2016, 08:20:08 AM

Title: Windows Authenticated MSSQL connection
Post by: de la Rosa on July 09, 2016, 08:20:08 AM

Hi,

My Customer runs the Nettalk application in a dedicated Application server while the DB is on a dedicated MSSQL server machine, the problem is the user logged on the Application server running the Nettalk app does not necessarily have login rights to the Mssql DB. I was trying to read something about impersonating a user in Mssql however I'm not really sure how to implement it on the Nettalk application or whether it is really an option to resolve the issue.

Vic

Title: Re: Windows Authenticated MSSQL connection
Post by: peterH on July 09, 2016, 11:26:55 AM

Normally, a user should have access to the database through the app but not otherwise. That is taken care of by using an appropriate connection string ("glo:owner").

But I'm not sure I fully understand your question. Something not working or ...?

Peter

Title: Re: Windows Authenticated MSSQL connection
Post by: kevin plummer on July 10, 2016, 11:02:27 PM

The user would need a SQL user account (or a generic one for the web app) as windows authenticated user won't necessarily work.