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.