Hi @db042190 ,
What method do you use for authentication?
If we configure the data source to use Windows integrated security, we will not be able to use SQL Server authentication in the connection. Please just use the following connection string: Data Source=servername;Initial Catalog=databasename
If you want to use SQL Server authentication, please follow these steps:
- Set the connection string to be: Data Source=servername;Initial Catalog=databasename
- Check "Credentials stored securely in the report server", and type the UID and PWD in the username and password textbox.
Your error message looks like it forgot your password,if it is an embedded data source> right click on the data source and go to Properties> Credentials to view the data source.
Hope this helps.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What is your data source type? Could you share the connection string?
What method did you use for authentication?
microsoft sql server. Data Source=myservername;Initial Catalog=mydb