February 29, 2016 at 6:33 am
Hello,
I've build a server-side report using VS 2008. The version of SQL Server is 2008R2.
The report, including the same login credentials I'm trying to use in Report Manager, work with no problem when I 'preview' it from within VS 2008. I can also login to SQL Server Management Studio with the same credentials. The application, designed in VS 2014, also uses the same login credentials with no issues.
The error only occurs with Report Manager when I try to configure the datasource properties of the report. I've attached an image in case I'm not being clear.
My questions are: what is causing the error and how do I resolve it? And why does it say 'Connection successfully created' lower down if the password is wrong. Or is the password wrong for one resource and correct for another?
Thanks in advance for any help.
March 1, 2016 at 12:51 pm
There could be a few things going on here, but one thing that I see in your image is that you do not have "User Windows Credentials" checked. Without that checked it will attempt to use SQL Security to connect the user name and password directly to the SQL Server, database, and tables/views you are trying to access.
With it checked, it will pass your Active Directory account to SQL Server.
It is best practice to setup a "Report user" for the environment in AD and give that user read access or read/execute perms if your using a Store Proc in SQL.
March 2, 2016 at 2:03 am
Jaselnewpar (3/1/2016)
There could be a few things going on here, but one thing that I see in your image is that you do not have "User Windows Credentials" checked. Without that checked it will attempt to use SQL Security to connect the user name and password directly to the SQL Server, database, and tables/views you are trying to access.With it checked, it will pass your Active Directory account to SQL Server.
It is best practice to setup a "Report user" for the environment in AD and give that user read access or read/execute perms if your using a Store Proc in SQL.
Thanks for the suggestion. I'll give it a try!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply