blocks|key|3099445|text|缺省情况下，sql+server+database+will+be+stored位于以下路径中|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3099446|<drive>:\Program+Files\Microsoft+SQL+Server\MSSQL.X\MSSQL\Data\|code-block|syntax|javascript|3099447|，其中<drive>是安装驱动器，X是实例号(对于数据库引擎的第一个实例，为MSSQl.1)。为了提供连接字符串，您应该知道您存储的sql+server数据库的服务器名称，后跟数据库服务器的实例。|style|CODE|3099448|通常，服务器名称类似于附加数据库的计算机的ip地址，默认实例为SqlExpress|BOLD|3099449|connection+string包含数据源名称(即服务器名称)、初始目录名称(即数据库名称)、用户id+(即数据库的登录用户id+)、密码(即数据库的登录密码)。|3099450|entityMap|0|LINK|mutability|MUTABLE|url|http://yousaiditnow.blogspot.in/2010/10/sql-server-2008-database-storage.html|1|http://www.connectionstrings.com/sql-server-2005^0|6|Y|0|0|0|3|7|0|V|A|0|J|1R|0|H|1|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|16|8|@$A|17|B|18|K|L]]|9|@]|C|$]]|$1|M|3|N|5|6|7|19|8|@$A|1A|B|1B|K|O]]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1C|8|@$A|1D|B|1E|K|O]]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|R|3|-4|5|6|7|1I|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]|Z|$5|U|V|W|C|$X|10]]]]

The <a href="http://yousaiditnow.blogspot.in/2010/10/sql-server-2008-database-storage.html" rel="nofollow">sql server database will be stored</a> by default in the following path

<pre><code>&lt;drive&gt;:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data\
</code></pre>

, where <code>&lt;drive&gt;</code> is the installation drive and X is the instance number (MSSQL.1 for the first instance of the Database Engine). Inorder to provide the connection string you should know what is the server name of the sql server database, where you have stored followed by instance of the database server. 

Generally the server name will be like the ip address of the machine where the database is attached and the default instance will be SqlExpress 

A <a href="http://www.connectionstrings.com/sql-server-2005" rel="nofollow">connection string</a> contains Data Source name i.e., server name, Initial catalog i.e., database name, user id i.e., login user id of the database, password i.e., login password of the database.

blocks|key|229495|text|在connectionstrings.com上，您可以找到每个DB提供程序的连接字符串。连接字符串是由某些属性/属性及其值构成的。对于SQL+server+2008，它看起来像这样(标准，这是您在这里需要的)：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|229496|Data+Source=myServerAddress;Initial+Catalog=myDataBase;User+Id=myUsername;Password=myPassword;|code-block|syntax|javascript|229497|在myServerAddress上，写入已安装实例的名称(对于SQL+Server+Express版本，默认名称为.\SQLEXPRESS+)。初始目录=您的数据库名称，连接后您将在左侧的SSMS中看到它。剩下的就不言而喻了。|style|CODE|229498|编辑|BOLD|229499|您需要省略windows身份验证的用户名和密码，并添加Integrated+Security=SSPI。|229500|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/^0|1|L|0|0|0|1|F|1L|C|0|0|2|0|R|O|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|14|8|@$A|15|B|16|K|L]|$A|17|B|18|K|L]]|9|@]|C|$]]|$1|M|3|N|5|6|7|19|8|@$A|1A|B|1B|K|O]]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1C|8|@$A|1D|B|1E|K|L]]|9|@]|C|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]]]

On <a href="http://www.connectionstrings.com" rel="noreferrer">connectionstrings.com</a> you can find the connection string for every DB provider. A connection string is built up with certain attributes/properties and their values. For SQL server 2008, it looks like this (standard, which is what you'll need here):

<pre><code>Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
</code></pre>

on <code>myServerAddress</code>, write the name of your installed instance (by default it's <code>.\SQLEXPRESS</code> for SQL Server Express edition). Initial catalog = your database name, you'll see it in SSMS on the left after connecting. The rest speaks for itself.

edit

You will need to omit username and password for windows authentication and add <code>Integrated Security=SSPI</code>.

blocks|key|229548|text|获取连接字符串的最简单方法是使用Visual+Studio中的“服务器资源管理器”窗口(菜单“视图”，“服务器资源管理器”)，然后从该窗口连接到服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|229549|然后，您可以在连接的服务器的属性中看到连接字符串(选择连接并按F4或Alt%2BEnter，或者在右击菜单上选择properties+)。|229550|高级连接字符串设置：创建连接时，您可以通过单击“高级...”修改任何高级连接字符串选项，如MARS、弹性、超时、池化配置等。按钮，点击“添加连接”对话框的底部。稍后，您可以通过右键单击数据连接并选择“修改连接...”来访问此对话框。可用的高级选项因服务器类型而异。|offset|length|style|BOLD|229551|如果使用SQL+Server+Management+Studio创建数据库，则将在服务器实例中创建数据库，因此，要部署应用程序，您必须备份数据库并将其部署到部署SQL+Server中。或者，您可以使用SQL+Server+Express+(+SQL+Server2012中的localDB)使用数据文件，该文件将很容易与您的应用程序一起分发。|229552|也就是说，如果它是一个ASP.NET应用程序，那么就有一个App_Datafolder。如果右键单击该元素，则可以添加新元素，该元素可以是SQL+Server数据库。此文件将位于该文件夹中，可与SQL+Express一起使用，并且易于部署。您需要在计算机上安装SQL+Express+/+localDB才能正常工作。|229553|entityMap^0|0|0|0|A|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

The easiest way to get the connection string is using the "Server Explorer" window in Visual Studio (menu View, Server Explorer) and connect to the server from that window.

Then you can see the connection string in the properties of the connected server (choose the connection and press F4 or Alt+Enter or choose Properties on the right click menu).

Advanced connection string settings: when creating the connection, you can modify any of the advanced connection string options, like MARS, resiliency, timeot, pooling configuration, etc. by clicking on the "Advanced..." button on the bottom of the "Add connection" dialog. You can access this dialog later by right clicking the Data Connection, and choosing "Modify connection...". The available advanced options vary by server type.

If you create the database using SQL Server Management Studio, the database will be created in a server instance, so that, to deploy your application you'll have to make a backup of the database and deploy it in the deployment SQL Server. Alternatively, you can use a data file using SQL Server Express (localDB in SQL Server 2012), that will be easily distributed with your app.

I.e. if it's an ASP.NET app, there's an App_Datafolder. If you right click it you can add a new element, which can be a SQL Server Database. This file will be on that folder, will work with SQL Express, and will be easy to deploy. You need SQL Express / localDB installed on your machine for this to work.

blocks|key|225958|text|检索连接字符串的一种非常简单的方法是创建一个文本文件，将扩展名从.txt更改为.udl。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225959|双击.udl文件将打开数据链接属性向导。|225960|配置并测试与数据库服务器的连接。|225961|关闭向导并使用您选择的文本编辑器打开.udl文件，只需复制连接字符串(不包括Provider=<driver>部件)即可在您的C#应用程序中使用它。|offset|length|style|CODE|225962|示例udl文件内容|BOLD|225963|[oledb]
;+Everything+after+this+line+is+an+OLE+DB+initstring
Provider=SQLNCLI11.1;Integrated+Security=SSPI;Persist+Security+Info=False;User+ID="";Initial+Catalog=YOURDATABASENAME;Data+Source=YOURSERVERNAME;Initial+File+Name="";Server+SPN=""|code-block|syntax|javascript|225964|你需要从中拷贝的东西|225965|Integrated+Security=SSPI;Initial+Catalog=YOURDATABASENAME;Data+Source=YOURSERVERNAME;|225966|如果您想指定用户名和密码，您可以从其他答案中采用。|225967|教程：https://teusje.wordpress.com/2012/02/21/how-to-test-an-sql-server-connection/|225968|entityMap|0|LINK|mutability|MUTABLE|url|https://teusje.wordpress.com/2012/02/21/how-to-test-an-sql-server-connection/^0|0|0|0|12|H|0|0|9|0|0|0|A|0|0|0|3|25|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1B|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1C|8|@$H|1D|I|1E|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1F|8|@$H|1G|I|1H|J|N]]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1I|8|@]|9|@]|A|$R|S]]|$1|T|3|U|5|6|7|1J|8|@$H|1K|I|1L|J|N]]|9|@]|A|$]]|$1|V|3|W|5|Q|7|1M|8|@]|9|@]|A|$R|S]]|$1|X|3|Y|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1O|8|@]|9|@$H|1P|I|1Q|1|1R]]|A|$]]|$1|11|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18]]]]

A very simple way to retrieve a connection string, is to create a text file, change the extension from .txt to .udl.

Double-clicking the .udl file will open the Data Link Properties wizard.

Configure and test the connection to your database server.

Close the wizard and open the .udl file with the text editor of your choice and simply copy the connection string (without the <code>Provider=&lt;driver&gt;</code>part) to use it in your C# application.

sample udl file content

<pre><code>[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=YOURDATABASENAME;Data Source=YOURSERVERNAME;Initial File Name="";Server SPN=""
</code></pre>

what you need to copy from it

<pre><code>Integrated Security=SSPI;Initial Catalog=YOURDATABASENAME;Data Source=YOURSERVERNAME;
</code></pre>

If you want to specify username and password you can adopt from other answers.

Tutorial: <a href="https://teusje.wordpress.com/2012/02/21/how-to-test-an-sql-server-connection/" rel="noreferrer">https://teusje.wordpress.com/2012/02/21/how-to-test-an-sql-server-connection/</a>

blocks|key|228802|text|将标签放在配置节点的web.config文件中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228803|+<connectionStrings>
<add+name="NameOFConnectionString"+connectionString="Data+Source=Server;Initial+Catalog=DatabaseName;User+ID=User;Password=Pwd"
++providerName="System.Data.SqlClient"+/>|code-block|syntax|javascript|228804|​|228805|然后你可以使用上面的connectionstring，例如|228806|SqlConnection+con+=+new+SqlConnection();
++++++++++++con.ConnectionString+=+ConfigurationManager.ConnectionStrings["NameOFConnectionString"].ToString();|228807|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

put below tag in web.config file in configuration node

<pre><code> &lt;connectionStrings&gt;
&lt;add name="NameOFConnectionString" connectionString="Data Source=Server;Initial Catalog=DatabaseName;User ID=User;Password=Pwd"
 providerName="System.Data.SqlClient" /&gt;
</code></pre>



then you can use above connectionstring, e.g.

<pre><code>SqlConnection con = new SqlConnection();
 con.ConnectionString = ConfigurationManager.ConnectionStrings["NameOFConnectionString"].ToString();
</code></pre>

blocks|key|225989|text|如果您在项目中创建了Connection+Manager，那么您可以简单地从那里提取连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225990|String+connection+=+this.dts.connections["<connection_manager_name>"];|code-block|syntax|javascript|225991|并在以下位置使用此连接：|225992|using+(var+conn+=+new+SqlConnection(connection))|225993|如果我错了，请纠正我。|225994|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If you created Connection Manager in your project then you can simply pull the connection string from there.

<pre><code>String connection = this.dts.connections["&lt;connection_manager_name&gt;"];
</code></pre>

And use this connection in:

<pre><code>using (var conn = new SqlConnection(connection))
</code></pre>

Please correct me if I am wrong.

blocks|key|3099697|text|SqlConnection+con+=+new+SqlConnection();
con.ConnectionString="Data+Source=DOTNET-PC\\SQLEXPRESS;Initial+Catalog=apptivator;Integrated+Security=True";|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3099698|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>SqlConnection con = new SqlConnection();
con.ConnectionString="Data Source=DOTNET-PC\\SQLEXPRESS;Initial Catalog=apptivator;Integrated Security=True";
</code></pre>

blocks|key|231174|text|如果使用工具Linqpad，则在从连接连接到目标数据库之后，可以获得要使用的连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|231175|右键单击数据库connection.|231176|Select+Properties|unordered-list-item|offset|length|style|CODE|231177|
|231178|Select+Advanced|231179|231180|Select+Copy+Full+Connection+String+to+Clipboard|231181|
，|231182|ordered-list-item|231183|231184|结果：Data+Source=.\jabberwocky;Integrated+Security=SSPI;Initial+Catalog=Rasa;app=LINQPad|231185|​|231186|📷|atomic|231187|231188|231189|删除依赖于驱动程序和其他项目的app=LinqPad，例如Server而不是源代码，您可能需要调整驱动程序以适应目标操作；但它为您提供了一个启动平台。|231190|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b2b6e0b3602f574e3f30037ee8c1deff.png|imageAlt^0|0|0|7|A|0|0|7|8|0|0|7|14|0|0|0|0|3|2B|0|0|0|1|0|0|0|0|F|B|T|6|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1I|8|@$G|1J|H|1K|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|1L|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1M|8|@$G|1N|H|1O|I|J]]|9|@]|A|$]]|$1|O|3|L|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|1Q|8|@$G|1R|H|1S|I|J]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1T|8|@]|9|@]|A|$]]|$1|T|3|-4|5|U|7|1U|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1W|8|@$G|1X|H|1Y|I|J]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|10|3|11|5|12|7|20|8|@]|9|@$G|21|H|22|1|23]]|A|$]]|$1|13|3|Z|5|6|7|24|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|26|8|@$G|27|H|28|I|J]|$G|29|H|2A|I|J]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]]|18|$19|$5|1A|1B|1C|A|$1D|1E|1F|-4]]]]

If one uses the tool Linqpad, after one connects to a target database from the connections one can get a connection string to use.

<ol>
<li>Right click on the database connection.</li>
<li>Select <code>Properties</code></li>
<li>Select <code>Advanced</code></li>
<li>Select <code>Copy Full Connection String to Clipboard</code></li>
</ol>

Result: <code>Data Source=.\jabberwocky;Integrated Security=SSPI;Initial Catalog=Rasa;app=LINQPad</code>

<a href="https://i.stack.imgur.com/eoJnI.png" rel="noreferrer"><img src="https://i.stack.imgur.com/eoJnI.png" alt="enter image description here"></a>

<hr>

Remove the <code>app=LinqPad</code> depending on the drivers and other items such as <code>Server</code> instead of source, you may need to adjust the driver to suit the target operation; but it gives one a launching pad.

blocks|key|3099743|text|如果已安装和设置MS+SQL+Server和Management+Studio，请转到Visual+Studio+(Visual+Studio而不是SQL+Server+Management+Studio)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3099744|3099745|+1]在Visual+Studio中，转到工具->连接到数据库。|blockquote|offset|length|style|BOLD|3099746|3099747|2]在服务器名称下选择您的数据库服务器名称(如果花费时间，让列表填充)。|3099748|3]在连接到数据库下，选择选择或输入数据库名称。|3099749|4]从下拉菜单中选择数据库。|3099750|5]选择数据库尝试测试连接后的。|3099751|6]如果测试连接成功，请单击确定。|3099752|7]在Visual+Studio中，转到视图->服务器资源管理器。|3099753|8]在服务器资源管理器窗口中，在数据连接下选择您的数据库。右键单击您的数据库->，然后单击属性。|3099754|9]在属性窗口中，您将看到连接字符串。|3099755|entityMap^0|0|0|1|2|L|A|0|0|0|2|0|0|2|D|A|0|0|2|0|0|F|0|0|2|0|0|2|K|C|0|0|2|T|I|0|0|2|3|2|D|5|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|14|8|@$F|15|G|16|H|I]|$F|17|G|18|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1A|8|@$F|1B|G|1C|H|I]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1D|8|@$F|1E|G|1F|H|I]|$F|1G|G|1H|H|I]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1I|8|@$F|1J|G|1K|H|I]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1L|8|@$F|1M|G|1N|H|I]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1O|8|@$F|1P|G|1Q|H|I]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1R|8|@$F|1S|G|1T|H|I]|$F|1U|G|1V|H|I]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1W|8|@$F|1X|G|1Y|H|I]|$F|1Z|G|20|H|I]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|21|8|@$F|22|G|23|H|I]|$F|24|G|25|H|I]|$F|26|G|27|H|I]]|9|@]|A|$]]|$1|10|3|-4|5|6|7|28|8|@]|9|@]|A|$]]]|11|$]]

If you have installed and setup MS SQL Server and Management Studio, go to Visual Studio (Visual Studio not SQL Server Management Studio).
<blockquote>
1] In Visual Studio go to Tools -&gt; Connect to Database.
2] Under Server Name Select your Database Server Name (Let the list Populate if its taking time).
3] Under Connect to a Database, Select Select or enter a database name.
4] Select your Database from Dropdown.
5] After selecting Database try Test Connection.
6] If Test Connection Succeeds, Click Ok.
7] In Visual Studio go to View -&gt; Server Explorer.
8] In Server Explorer window, Under Data Connections Select your Database. Right Click your Database -&gt; Click Properties.
9] In Properties window you will see your Connection String.
</blockquote>

blocks|key|228849|text|我的朋友们，最简单的方法是打开visual+studio+2019上的服务器资源管理器选项卡(在我的例子中)，然后尝试创建到数据库的连接。在创建一个成功的连接后，只需右键单击它，然后转到propierties。在那里你会发现一个语法正确的字符串连接字段！...This对我来说很有效，因为在hand....just找不出正确的语法来运行我的ef+scaffold之前，我就知道我的服务器的名称了……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228850|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Easiest way my friends, is to open the server explorer tab on visual studio 2019 (in my case), and then try to create the connection to the database. After creating a succesful connection just right click on it and go to propierties. There you will find a string connection field with the correct syntax!...This worked for me because I knew my server's name before hand....just couldn't figure out the correct syntax to run my ef scaffold...

blocks|key|228852|text|打开SQL+Server+Management+Studio并运行以下查询。您将获得连接字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228853|select
++++'data+source='+%2B+@@servername+%2B
++++';initial+catalog='+%2B+db_name()+%2B
++++case+type_desc
++++++++when+'WINDOWS_LOGIN'+
++++++++++++then+';trusted_connection=true'
++++++++else
++++++++++++';user+id='+%2B+suser_name()+%2B+';password=<<YourPassword>>'
++++end
++++as+ConnectionString
from+sys.server_principals
where+name+=+suser_name()|code-block|syntax|javascript|228854|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|$]]

Open SQL Server Management Studio and run following query. You will get connection string:
<pre><code>select
 'data source=' + @@servername +
 ';initial catalog=' + db_name() +
 case type_desc
 when 'WINDOWS_LOGIN' 
 then ';trusted_connection=true'
 else
 ';user id=' + suser_name() + ';password=&lt;&lt;YourPassword&gt;&gt;'
 end
 as ConnectionString
from sys.server_principals
where name = suser_name()
</code></pre>

I have created a database with SQL Server Management Studio, I would like to now use it in my C# application. I need the connection string?

Where can I find the connection string, and where is my database stored?

Do I have to publish it or something like that, or is it in my documents somewhere?

<pre><code>using (var conn = new SqlConnection("your connection string to the database"))
</code></pre>

How do I obtain the connection string? Where can I find the connection string to copy paste into the above section?

How to I publish my database so that Visual Studio can pick it up? Then I can just pull the connection string of there?

How to get the connection String from a database

备份数据库

Visual Studio

身份验证

SQL Server

数据库

服务器

我已经使用SQL Server Management Studio创建了一个数据库，现在我想在我的C#应用程序中使用它。我需要连接字符串吗？我可以在哪里找到连接字符串，我的数据库存储在哪里？我是否必须发布它或类似的东西，或者它是否在我的文档中的某个地方？using (var conn = new SqlConnecti...

问如何从数据库获取连接字符串
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从数据库获取连接字符串EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从数据库获取连接字符串
EN