blocks|key|2763788|text|使用默认实例(即MSSQLSERVER，使用DOT+(.))|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2763789|<add+name="CONNECTION_STRING_NAME"+connectionString="Data+Source=.;Initial+Catalog=DATABASE_NAME;Integrated+Security=True;"+/>|code-block|syntax|javascript|2763790|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code>&lt;add name="CONNECTION_STRING_NAME" connectionString="Data Source=.;Initial Catalog=DATABASE_NAME;Integrated Security=True;" /&gt;
</code></pre>

blocks|key|2763635|text|在初始目录中选择数据库名称|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2763636|Data+Source=HARIHARAN-PC\SQLEXPRESS;Initial+Catalog=your+database+name;Integrated+Security=True"+;|code-block|syntax|javascript|2763637|see+more|offset|length|2763638|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/sql-server-2008/^0|0|0|0|8|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Choose a database name in Initial Catalog

<pre><code>Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=your database name;Integrated Security=True" ;
</code></pre>

<a href="http://www.connectionstrings.com/sql-server-2008/" rel="noreferrer">see more</a>

blocks|key|2976592|text|您有内部连接还是外部连接。如果您使用了内部连接，请尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2976593|"Data+Source=.\SQLEXPRESS;AttachDbFilename="Your+PAth+.mdf";Integrated+Security=True;User+Instance=True";|code-block|syntax|javascript|2976594|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code>"Data Source=.\SQLEXPRESS;AttachDbFilename="Your PAth .mdf";Integrated Security=True;User Instance=True";
</code></pre>

blocks|key|2763696|text|尝试此连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2763697|Data+Source=HARIHARAN-PC\\SQLEXPRESS;Initial+Catalog=yourDataBaseName;Integrated+Security=True|code-block|syntax|javascript|2763698|有关更多详细信息http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%2528v=vs.110%2529.aspx，请参阅此链接|offset|length|2763699|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%2528v=vs.110%2529.aspx^0|0|0|8|33|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Try this connection string.

<pre><code>Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=yourDataBaseName;Integrated Security=True
</code></pre>

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

blocks|key|167234|text|<add+name="connstr"+connectionString="Data+Source=localhost;Initial+Catalog=DBName;User+Id=username;Password=password"+providerName="System.Data.SqlClient"/>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|167235|上述方法也适用。它忽略在连接字符串中传入的用户名和密码。我从环境数据库切换到本地数据库，即使连接字符串中的用户不存在于此上下文中，它也工作得很好。|unstyled|167236|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

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.

blocks|key|165153|text|您也可以使用点(.)对于本地密钥，即；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|165154|Data+Source=.\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True|code-block|syntax|javascript|165155|如果您有默认的服务器实例，即MSSQLSERVER，那么只需为数据源使用点。|offset|length|style|BOLD|165156|Data+Source=.;Initial+Catalog=master;Integrated+Security=True|165157|entityMap^0|0|0|E|B|V|3|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

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

<pre><code>Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True
</code></pre>

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

<pre><code>Data Source=.;Initial Catalog=master;Integrated Security=True
</code></pre>

blocks|key|168857|text|使用此连接字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|168858|Server=HARIHARAN-PC\SQLEXPRESS;Intial+Catalog=persons;Integrated+Security=True;|code-block|syntax|javascript|168859|使用您的数据库名称重命名person|168860|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

use this connection string :

<pre><code>Server=HARIHARAN-PC\SQLEXPRESS;Intial Catalog=persons;Integrated Security=True;
</code></pre>

rename person with your database name

blocks|key|165148|text|在.Net配置中，我将使用如下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|165149|"Data+Source=(localdb)\\MSSQLLocalDB;Initial+Catalog=..."|code-block|syntax|javascript|165150|此信息来自https://www.connectionstrings.com/sql-server-2016/|offset|length|165151|entityMap|0|LINK|mutability|MUTABLE|url|https://www.connectionstrings.com/sql-server-2016/^0|0|0|5|1E|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

In .Net configuration I would use something like:

<pre><code>"Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=..."
</code></pre>

This information is from <a href="https://www.connectionstrings.com/sql-server-2016/" rel="nofollow noreferrer">https://www.connectionstrings.com/sql-server-2016/</a>

blocks|key|167249|text|public+string+strConnectionstring+=+"Data+Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=%7CDataDirectory%7C\\DataBaseName.mdf";|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|167250|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>public string strConnectionstring = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\DataBaseName.mdf";
</code></pre>

blocks|key|2763765|text|string+str+=+"Data+Source=HARIHARAN-PC\\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True"+;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2763766|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>string str = "Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;
</code></pre>

blocks|key|166191|text|string+str+=+@"Data+Source=HARIHARAN-PC\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True"+;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|166192|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>string str = @"Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;
</code></pre>

blocks|key|168888|text|使用SQL+Express时，需要在连接字符串中指定\SQLExpress实例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|168889|string+str+=+"Data+Source=HARIHARAN-PC\\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True"+;|code-block|syntax|javascript|168890|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code>string str = "Data Source=HARIHARAN-PC\\SQLEXPRESS;Initial Catalog=master;Integrated Security=True" ;
</code></pre>

blocks|key|2763761|text|Data+Source=HARIHARAN-PC\SQLEXPRESS;+Initial+Catalog=Your_DataBase_name;+Integrated+Security=true/false;+User+ID=your_Username;Password=your_Password;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2763762|To+know+more+about+connection+string+Click+here+|unstyled|offset|length|2763763|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/sql-server-2012/^0|0|0|1C|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

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

<a href="http://www.connectionstrings.com/sql-server-2012/" rel="nofollow">To know more about connection string Click here </a>

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:

<blockquote>
 <blockquote>
 Data Source=HARIHARAN-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True
 </blockquote>
</blockquote>

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 :

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


 }
</code></pre>

This code errors out at con.Open();

Sql connection-string for localhost server

数据库

服务器

我是这个.NET的新手，请不要介意回答我的简单问题。我正在尝试编写一个windows应用程序，其中我使用本地主机SQLserver作为数据库。如果我的服务器名看起来像下面这样，我需要知道本地主机的确切连接字符串是什么：数据源=HARIHARAN-PC\SQLEXPRESS；Initial Catalog=master;Integrated Security=True我是否需要给出与连接字符串相同的

问Sql连接-本地主机服务器的字符串
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Sql连接-本地主机服务器的字符串EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Sql连接-本地主机服务器的字符串
EN