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

x

XML to SQL connection string, Include User Id and Password

Medium Priority
549 Views
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">
      <rd:DataSourceID>5b6220e7-ee13-4f3d-a597-c9c20dfc9e76</rd:DataSourceID>
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=YLSQL02;Initial Catalog=LASER</ConnectString>
      </ConnectionProperties>
    </DataSource>
Comment
Watch Question

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

Author

Commented:
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.

OR

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.