Sql connection-string for localhost server

Question

I am newbie in this .NET and please don't mind in answering my simple question. I am trying to write a windows application, where in I am using a localhost SQLserver for database.

I need to know what is the exact connection string for my localhost, if my server name looks like as below:

Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True

should i need to give this same as connection string, or is something wrong in this syntax.

whn i try to open my connection. I am seeing error in opening connection.

How the format of connection string should be? any one please guide me.

I tried like this :

 private void button1_Click(object sender, EventArgs e)
    {
        string str = "Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ; 
        SqlConnection con = new SqlConnection(str);
        SqlCommand cmd = new SqlCommand();
        SqlDataReader r;

        cmd.CommandText = "SELECT * from Table1";
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;

        con.Open();

        r = cmd.ExecuteReader();

        con.Close();


    }

This code errors out at con.Open();

Which type of "authentication mode" you are using ?? Is it "Windows Authentication mode" or "SQL Server mode (Mixed mode)" ?? You should use user id and password in your connection string. — Krishnraj Rana
– Krishnraj Rana, Commented Dec 27, 2013 at 7:14

Robert Green MBA · Accepted Answer · 2016-08-29 22:58:33Z

119

Using the default instance (i.e., MSSQLSERVER, use the DOT (.))

<add name="CONNECTION_STRING_NAME" connectionString="Data Source=.;Initial Catalog=DATABASE_NAME;Integrated Security=True;" />

answered Aug 29, 2016 at 22:58

Robert Green MBA

1,8963 gold badges31 silver badges57 bronze badges

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

Comments

Nagaraj S · Accepted Answer · 2013-12-27 07:06:50Z

25

Choose a database name in Initial Catalog

Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=your database name;Integrated Security=True" ;

edited Dec 27, 2013 at 7:06

answered Dec 27, 2013 at 7:00

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

1 Comment

Shaiju T Over a year ago

this post worked for me to connect to local using localhost\SQLEXPRESS

Aftab Ahmed · Accepted Answer · 2020-01-02 02:23:34Z

21

You can also use Dot(.) for local key i.e;

Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True

If you have the default server instance i.e. MSSQLSERVER, then just use dot for Data Source.

Data Source=.;Initial Catalog=master;Integrated Security=True

answered Jan 2, 2020 at 2:23

Aftab Ahmed

93512 silver badges17 bronze badges

Comments

Vishav Premlall · Accepted Answer · 2018-07-25 09:51:14Z

10

<add name="connstr" connectionString="Data Source=localhost;Initial Catalog=DBName;User Id=username;Password=password" providerName="System.Data.SqlClient"/>

The above also works. It ignores the username and password passed in in the connection string. I switched from an environment db to a local one, and it works fine even though my user in the connection string does not exist in this context.

answered Jul 25, 2018 at 9:51

Vishav Premlall

4956 silver badges23 bronze badges

Comments

Ajay · Accepted Answer · 2013-12-27 11:38:22Z

9

Try this connection string.

Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=yourDataBaseName;Integrated Security=True

See this link for more details http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%28v=vs.110%29.aspx

edited Dec 27, 2013 at 11:38

answered Dec 27, 2013 at 7:04

Ajay

6,59818 gold badges83 silver badges135 bronze badges

Comments

Yick Leung · Accepted Answer · 2013-12-30 05:49:50Z

9

Do You have Internal Connection or External Connection. If you did Internal Connection then try this:

"Data Source=.\SQLEXPRESS;AttachDbFilename="Your PAth .mdf";Integrated Security=True;User Instance=True";

edited Dec 30, 2013 at 5:49

Yick Leung

1,0781 gold badge9 silver badges16 bronze badges

answered Dec 27, 2013 at 7:05

Akil M Belim

11510 bronze badges

Comments

Jari Turkia · Accepted Answer · 2018-10-16 14:38:01Z

8

In .Net configuration I would use something like:

"Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=..."

This information is from https://www.connectionstrings.com/sql-server-2016/

answered Oct 16, 2018 at 14:38

Jari Turkia

1,4231 gold badge27 silver badges43 bronze badges

1 Comment

Jari Turkia Over a year ago

Also see difference between SQL Express and SQL Server Developer Edition: stackoverflow.com/a/61659580/1548275

Ram Singh · Accepted Answer · 2013-12-27 07:09:18Z

5

use this connection string :

Server=HARIHARAN-PC\SQLEXPRESS;Intial Catalog=persons;Integrated Security=True;

rename person with your database name

edited Dec 27, 2013 at 7:09

Ram Singh

6,97235 gold badges107 silver badges172 bronze badges

answered Dec 27, 2013 at 7:00

Waqar Ahmed

5,0883 gold badges28 silver badges46 bronze badges

1 Comment

Waqar Ahmed Over a year ago

we can use Database= persons as well .I do use it

Mahmoud · Accepted Answer · 2014-09-11 06:02:49Z

4

string str = @"Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;

answered Sep 11, 2014 at 6:02

Mahmoud

491 bronze badge

Comments

StealthRT · Accepted Answer · 2019-06-10 20:17:50Z

4

public string strConnectionstring = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\DataBaseName.mdf";

edited Jun 10, 2019 at 20:17

StealthRT

10.6k41 gold badges195 silver badges371 bronze badges

answered Apr 8, 2019 at 4:00

Aung Kyaw Nyunt

411 bronze badge

Comments

priyana_.net · Accepted Answer · 2013-12-27 07:43:21Z

3

string str = "Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;

answered Dec 27, 2013 at 7:43

priyana_.net

945 bronze badges

Comments

Vignesh Kumar A · Accepted Answer · 2013-12-27 07:08:05Z

2

When using SQL Express, you need to specify \SQLExpress instance in your connection string:

string str = "Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;

answered Dec 27, 2013 at 7:08

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Comments

Amarnath Balasubramanian · Accepted Answer · 2013-12-27 07:09:40Z

0

Data Source=HARIHARAN-PC\SQLEXPRESS; Initial Catalog=Your_DataBase_name; Integrated Security=true/false; User ID=your_Username;Password=your_Password;

To know more about connection string Click here

answered Dec 27, 2013 at 7:09

Amarnath Balasubramanian

9,5028 gold badges37 silver badges62 bronze badges

Collectives™ on Stack Overflow

Sql connection-string for localhost server

13 Answers 13

Comments

1 Comment

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

13 Answers 13

Comments

1 Comment

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related