October 14, 2013 at 4:55 pm
Hi,
Not so new to ssrs but pretty new to setting up logins on sql server to make the report work. I have a report has a shared datasource which points to a relatively new server. I started out setting up with windows authentication, hoping an admin might have set me up correctly. I am an admin for our sql server instances in AD.
In this case my lack of credentials got me an error:
"Cannot create a connection to data source 'xxxxx' (rsErrorOpeningConnection)
Login failed for 'NT Authority\Anonymous LOGON"
I went back into the data source in the development environment and switch to sql authentication, using my sa account for the server. It works in the preview in BIDS.
What happened when I redeployed the data source is that is not overwritten on the server; I can tell this by going to server and clicking on the data source and looking at the xml; my new credentials are not there. I have no way of deleting the datasource so I'm sort of stuck.
Any help would be appreciate.
Thanks,
Fig000
October 15, 2013 at 4:14 am
How are you deploying your report? If you are deploying from BIDS, one of the options under project properties is to overwrite the datasource. You would want to change that property to true.
October 15, 2013 at 3:19 pm
if you right click on the project name and go to properties there's an option to "overwrite Datasource", that should let you fix the datasource.
Your other error sounds like it could be a kerberos problem. Have you set any SPNs?.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply