connection string,sqlserver

Posted on 2011-10-14
Last Modified: 2012-05-12
Hi Expert,

I have installed Sqlserver 2008 R2 Express edition in other system. i am developing an application using I want to access remote database(LAN) in other system. Can you explain me in connection string  User ID=tapan;Password=Pass@123"  is which password ? is it operating system loing id and  password  OR user's login id (sa) and password. Please explain me clearly.

    <add name="YourConnectionString" connectionString=" data source=HELPDESK13\TBI;Integrated Security=SSPI;Initial Catalog=TbiKanbanSystem; User ID=tapan;Password=Pass@123" providerName="System.Data.SqlClient"/>
Question by:Tapan Pattanaik
    LVL 6

    Assisted Solution

    The "User ID=tapan;Password=Pass@123"  in the connection string is  the userid to connect to your database "TbiKanbanSystem" .
    LVL 20

    Author Comment

    by:Tapan Pattanaik
    i want to know this " User ID "is which ID ?
    LVL 23

    Expert Comment

    by:Rajkumar Gs
    You can get that UserID from SQL Server database. That is the UserID someone set in Sqlserver database, which may have limited previlages for this application.

    LVL 23

    Assisted Solution

    by:Rajkumar Gs
    If you know the the password of admin UserID - sa of Sql Server, you can try that here instead. (If you are not able to access database using current credentials)

    LVL 7

    Assisted Solution

    These are the sql server's user id and password.
    LVL 11

    Accepted Solution

    As Gopaltayde stated, these are for a SQL server login. This only permits the application to connect to the server instance. That login still needs to be associated with a user who has permissions in the TBI database.
    LVL 20

    Author Closing Comment

    by:Tapan Pattanaik
    Most corrrect one is 'azarc3' answer, i.e last anser.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    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

    14 Experts available now in Live!

    Get 1:1 Help Now