NetTalk Central

Author Topic: Windows Authenticated MSSQL connection  (Read 3745 times)

de la Rosa

  • Full Member
  • ***
  • Posts: 128
    • View Profile
    • Email
Windows Authenticated MSSQL connection
« 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

peterH

  • Sr. Member
  • ****
  • Posts: 413
    • View Profile
Re: Windows Authenticated MSSQL connection
« Reply #1 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

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Windows Authenticated MSSQL connection
« Reply #2 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.