We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


XML to SQL connection string, Include User Id and Password

Medium Priority
Last Modified: 2012-05-11
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?  

<DataSource Name="Laser_1">
        <ConnectString>Data Source=YLSQL02;Initial Catalog=LASER</ConnectString>
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)


Thanks radceasar.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.