What is the Data Source syntax SQL Client Connection String to Azure?

Question

I am attempting to configure the connection string in web.confg for an ASP.NET app to connect to Azure DB. I am new to this but am familiar with sql configuration strings to SQL Server. How do I configure the login and data source in the connection string I am building. I haven't ever dealt with the cloud like this. If my db name is DB1 how do I set the Azure path for the data source portion of the connection string. NOTE: I know where to configure it in web.config and know to create a connection object.

Thanks.

Jared Moore · Accepted Answer · 2015-02-28 00:51:09Z

1

In the Azure portal, you can navigate to your database's dashboard and click 'Show connection strings' on the right side. See the first screenshot on the below tutorial:

http://azure.microsoft.com/en-us/documentation/articles/sql-database-dotnet-how-to-use/

To answer your original question, "Data Source" means the same as "Server", it is just your server name, i.e. blah.database.windows.net. All of the connection string keywords (including their synonyms) are documented here: https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%28v=vs.110%29.aspx

answered Feb 28, 2015 at 0:51

Jared Moore

3,80528 silver badges32 bronze badges

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

2 Comments

J.S.Orris Over a year ago

Where were you in July? ;)

Jared Moore Over a year ago

Haha, sorry I missed your question for so long :)

Collectives™ on Stack Overflow

What is the Data Source syntax SQL Client Connection String to Azure?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related