How to connect database by using username and password in .net c#

Question

I'm new to .net c#, hope this question is not sound silly. How can I connect to the database in web.config by using the username and password??

Example:

Following is the connection strings that I used to connect to the database. How could I write/set so that I can set the username (username = test) and password (password = abc123) for this connection strings and so that it will allows me to access to the database?

  <connectionStrings>
    <add name="aConnectionString" connectionString="Data Source=AAA-LLLL-SQL-00;Initial Catalog=Database_Name;Connect Timeout=1;Integrated Security=True;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Out of curiosity, why do you want to do this? Windows authentication is far more secure -- since not having to put passwords in easily readable config files is a Good Thing. — Kirk Woll
– Kirk Woll, Commented Sep 14, 2011 at 23:16
see connectionstrings.com/sql-server-2008 - this should be obvious — BrokenGlass
– BrokenGlass, Commented Sep 14, 2011 at 23:19

Jon · Accepted Answer · 2011-09-14 23:18:47Z

1

Try something like this.

<connectionStrings>
     <add name="aConnectionString" connectionString="Data
 Source=AAA-LLLL-SQL-00;Initial Catalog=Database_Name;User Id=myUsername;Password=myPassword"
 providerName="System.Data.SqlClient"/>   
</connectionStrings>

edited Sep 14, 2011 at 23:18

answered Sep 14, 2011 at 23:16

Jon

9794 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TomTom Over a year ago

More general: Check connectionstrings.com for most used database connection string variants. Beats most documentation.

tsells · Accepted Answer · 2011-09-14 23:21:10Z

1

Use this to pull your connection string from the web.config.

http://msdn.microsoft.com/en-us/library/ms178411.aspx

Then you will use the .net Sql Provider to create a connection.

using(SqlConnection con = new SqlConnection(connectionstring))
{

   con.Open();
   // Perform operations here

}

answered Sep 14, 2011 at 23:21

tsells

2,7811 gold badge19 silver badges20 bronze badges

Comments

Brian · Accepted Answer · 2011-09-14 23:23:13Z

1

Are you trying from IIS? Then you need to grant your App Pools account access to SQL Server.

CREATE LOGIN [IIS APPPOOL\ASP.NET v4.0] FROM WINDOWS WITH DEFAULT_DATABASE=[AAA-LLLL-SQL-00], DEFAULT_LANGUAGE=[us_english]
GO

answered Sep 14, 2011 at 23:23

Brian

1,8931 gold badge23 silver badges38 bronze badges

1 Comment

tsells Over a year ago

While this is one of the ways Microsoft says you can do it I myself have always believed this to be a hack. I really think they missed the boat on using Windows Auth with IIS and SQL Server.

jon3laze · Accepted Answer · 2011-09-14 23:19:34Z

0

Reference for ADO and ADO.NET connection strings http://www.sqlstrings.com/

answered Sep 14, 2011 at 23:19

jon3laze

3,2066 gold badges42 silver badges69 bronze badges

Comments

DotNetUser · Accepted Answer · 2011-09-14 23:28:44Z

0

    <connectionStrings>
       <add name="aConnectionString" connectionString="Server={ip};Database= {databasename}; User Id={username}; Password={password}"/>
</connectionStrings>

This should work replace {...} with your values.

answered Sep 14, 2011 at 23:28

DotNetUser

6,6221 gold badge27 silver badges27 bronze badges

Comments

sloth · Accepted Answer · 2012-08-02 11:34:01Z

0

<connectionStrings>
   <add name="aConnectionString" connectionString="Data Source=AAA-LLLL-SQL-00;Initial Catalog=Database_Name; User Id=your username; Password=pwd;" providerName="System.Data.SqlClient"/>
</connectionStrings>

edited Aug 2, 2012 at 11:34

sloth

101k21 gold badges182 silver badges224 bronze badges

answered Sep 14, 2011 at 23:19

ericb

3,4101 gold badge24 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to connect database by using username and password in .net c#

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related