I am creating a report in SSRS and importing it into another application. When I try to run it in the other application I get the error that it cannot connect to Laser(My Database). I am an XML dummy but in all applications I have used I have to include a user name and password in the connection string to connect to a Microsoft Sql database. Below is the connection string I copied from the XML code from my SSRS report. What is the correct syntax to add the SA user and password?
<ConnectString>Data Source=YLSQL02;Initial Catalog=LASER</ConnectString>