Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

XML to SQL connection string, Include User Id and Password

Posted on 2011-04-28
2
Medium Priority
?
529 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>
0
Comment
Question by:sbdt8631
2 Comments
 
LVL 9

Accepted Solution

by:
radcaesar earned 2000 total points
ID: 35485849
<ConnectString>Data Source=ServerXXX;initial catalog=DBXXX;User Id=sa;Password=xyz</ConnectString>
0
 
LVL 1

Author Closing Comment

by:sbdt8631
ID: 35485880
Thanks radceasar.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Integration Management Part 2
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

577 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