Using Toad Data Point 18.104.22.1688, we are currently unable to connect to SQL Server 2005 (9.0.3042 and 9.0.4053) databases using Windows authentication with limited (‘read only’) privileges. We are receiving SQL Server Database Error - ‘The user does not have permission to perform this action’. We have no problem accessing these databases with SQL Server Management Studio 2008 R2 or Toad Data Point versions prior to 3.4.
I’m current researching the privileges we do have to these databases and I’m thinking the new connection parameter option with the hard coded ‘Application Name = Toad Data Point’ may be causing the problem.
Does anyone have a workaround for this issue?
Thanks in advance …