[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

connection string asp.net,sqlserver

Hi Expert,

I have installed Sqlserver 2008 R2 Express edition in other system. i am developing an application using asp.net. 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.

<connectionStrings>
    <add name="YourConnectionString" connectionString=" data source=HELPDESK13\TBI;Integrated Security=SSPI;Initial Catalog=TbiKanbanSystem; User ID=tapan;Password=Pass@123" providerName="System.Data.SqlClient"/>
  </connectionStrings>
0
Tapan Pattanaik
Asked:
Tapan Pattanaik
4 Solutions
 
kswathiCommented:
The "User ID=tapan;Password=Pass@123"  in the connection string is  the userid to connect to your database "TbiKanbanSystem" .
0
 
Tapan PattanaikSenior EngineerAuthor Commented:
i want to know this " User ID "is which ID ?
0
 
Rajkumar GsSoftware EngineerCommented:
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.

Raj
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rajkumar GsSoftware EngineerCommented:
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)

Raj
0
 
gopaltaydeCommented:
These are the sql server's user id and password.
0
 
Kelvin McDanielSr. Developer/ConsultantCommented:
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.
0
 
Tapan PattanaikSenior EngineerAuthor Commented:
Most corrrect one is 'azarc3' answer, i.e last anser.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now