XML to SQL connection string, Include User Id and Password

Posted on 2011-04-28
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>
Question by:sbdt8631
    LVL 9

    Accepted Solution

    <ConnectString>Data Source=ServerXXX;initial catalog=DBXXX;User Id=sa;Password=xyz</ConnectString>
    LVL 1

    Author Closing Comment

    Thanks radceasar.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now