Reputation: 1049

Sql connection-string for localhost server

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();

Upvotes: 81

Answers (13)

Aftab Ahmed

Reputation: 915

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

Upvotes: 20

Aung Kyaw Nyunt

Reputation: 41

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

Upvotes: 4

Jari Turkia

Reputation: 1373

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/

Upvotes: 8

Vishav Premlall

Reputation: 495

<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.

Upvotes: 10

Robert Green MBA

Reputation: 1886

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;" />

Upvotes: 118

Mahmoud

Reputation: 49

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

Upvotes: 4

Akil M Belim

Reputation: 125

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";

Upvotes: 10

Ajay

Reputation: 6590

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

Upvotes: 9

priyana_.net

Reputation: 94

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

Upvotes: 3

Amarnath Balasubramanian

Reputation: 9460

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

Upvotes: 0

Waqar Ahmed

Reputation: 5068

use this connection string :

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

rename person with your database name

Upvotes: 5

Vignesh Kumar A

Reputation: 28413

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" ;

Upvotes: 2

Nagaraj S

Reputation: 13484

Choose a database name in Initial Catalog

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

Upvotes: 25

Sql connection-string for localhost server

Answers (13)

Related Questions