All Questions
Tagged with connection-string azure
213
questions
50
votes
5
answers
16k
views
Azure connection string best practices
I have an application that I am just migrating to Azure. Currently I use web.config transformation to manage changing the database connecting string dev/staging/prod environments. How is it best to ...
- 36.6k
39
votes
4
answers
64k
views
How to get connection string out of Azure KeyVault?
A hypothetical web-site currently connects using:
public SqlConnection CreateConnection()
{
DbConnection connection = new SqlConnection();
connection.ConnectionString = GetConnectionString();
...
- 253k
33
votes
4
answers
29k
views
Setting the SQL connection string for ASP.NET Core web app in Azure
I have created a new ASP.NET Core web application in Visual Studio 2015. I've also set up an Azure web app to pull in the app from GitHub and run it. This works fine, but I'm having trouble connecting ...
- 13.9k
30
votes
15
answers
61k
views
azure blob storage "No valid combination of account information found"
I have an MVC4 project that I am running using Azure websites preview.
My problem is that I cant upload a blob into my blob storage container when I have deployed my website to azure, however the ...
- 585
30
votes
5
answers
18k
views
How do I set an ADO.NET Entity Framework connection string via the Windows Azure (Preview) Management Portal?
In the Windows Azure (Preview) Management Portal you can change the configuration options for web sites (see http://www.windowsazure.com/en-us/manage/services/web-sites/how-to-configure-websites/#...
- 1,936
30
votes
4
answers
19k
views
AzureWebJobsDashboard Configuration Error
I created a new Azure WebJob project in Visual Studio 2015 using .NET Framework 4.6.
In the app.config, I set three connection strings:
AzureWebJobsDashboard
AzureWebJobsStorage
...
- 29.2k
26
votes
1
answer
48k
views
How do you put environmental variables in web.config?
I am currently Following these tutorials, and I am wanting to call the clear text string from Azure's Application Settings for Web Apps. I am under the impression that environmental variables are used ...
- 1,293
18
votes
3
answers
10k
views
Set the application ConnectionString in the Service Configuration instead of web.config in Azure
I have an application currently in Azure and whenever we push it into the Staging segment, we cannot truly test since the connection string is pointing to the prod database.
Someone mentioned to me ...
- 183
15
votes
1
answer
9k
views
Output Azure SQL Database ConnectionString after template deployment
I have an ARM template that (among others) creates a database on an Azure SQL server (which is also created by the template).
I need to output the database ADO.NET connectionstring.
Becuase I wasn't ...
- 1,177
13
votes
5
answers
6k
views
Connection Strings are replaced when performing Azure Web Site staging Swap
(1) we have a web application running on Azure Web Site using Sql Server (Web Edition). The application includes two connection strings:
DefaultConnection - normal connection string, in the form of
...
- 709
13
votes
2
answers
32k
views
Where to look for UserId and Password for Azure SQL Server Connection
I have ASP.NET MVC app and I am trying to connect to Azure SQL database migrated on Azure.
I need to set my connection string in web.config and I have no idea where to look for the user id and ...
- 177
12
votes
11
answers
16k
views
The web publishing extension is not installed which is required to publish
I was tring to deploy an ASP.NET Web Application to a Windows Azure Web Site by following the tutorial through this link: https://www.windowsazure.com/en-us/develop/net/tutorials/get-started/
After ...
- 121
10
votes
2
answers
10k
views
Retrieve and use Windows Azure's connection strings?
I've configured connection strings in Azure management portal Configure->Connection Strings (linked resources):
What are these connection strings useful for?
I tried deleting the conn. strings from ...
- 104k
10
votes
2
answers
8k
views
Azure: Web.config Connection String' argument cannot be null or empty
When I try to publish an azure app I get this error.
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v14.0\Web\Microsoft.Web.Publishing.targets(4283,5): Error : The 'ibasis_Data_Transfer....
- 1,217
10
votes
3
answers
3k
views
Can't connect to SQL Azure from app, but can from SSMS
I have a SQL Azure instance set up and can connect to it with no issue from SQL Server Management Studio. However when my app tries to connect, this error occurs:
A network-related or instance-...
- 59.7k
9
votes
6
answers
25k
views
'MultipleActiveResultsSets' Keyword Not Supported
I am trying to read from an SQL Server database which is hosted on MS Azure, through an ASP.NET WebForms website created in Visual Studio 2013.
I've stored the Connection String in Web.Config, and ...
- 399
9
votes
1
answer
5k
views
SQL Azure EF Database First Connection String in Azure Management Portal
I have a site running n Azure, which uses EF Database First model.
If I embed the connection string in the web.config and deploy all is rosy.
<add name="MyEntities" connectionString="metadata=res:...
- 4,718
9
votes
1
answer
3k
views
What is the connection string to use Azure Storage Emulator with a Webjob?
I have a simple WebJob which I wish to test with the Azure Storage Emulator.
I currently have set the AzureJobsRuntime and AzureJobsData set to use development storage as follows:
<...
- 658
9
votes
2
answers
6k
views
Pre-login handshake woes with connecting directly to SQL Azure
We are currently experiencing a rather troublesome problem in our development environment with the following message...
A connection was successfully established with the server,
but then an error ...
- 1,868
7
votes
1
answer
24k
views
Connection string for Azure.Messaging.ServiceBus.ServiceBusClient
I'm trying to get started with Azure ServiceBus, but the Gods of Documentation are against me. I'm following this MS article, which says this code will allow me to send a message...
public class ...
- 1,593
7
votes
1
answer
4k
views
Settings keys to Azure Key Vault for sub-levels
For user secret management, I use user secrets for the development stage and I want to use Azure key vault for release and staging.
I have this configuration
"ConnectionStrings": {
"...
- 132
7
votes
2
answers
4k
views
Can i execute Azure webjobs without AzureWebJobsStorage connectionstring?
When i create new Azure webjob project i could see the connectionstring section in app.config section as below:
<connectionStrings>
<!-- The format of the connection string is "...
- 2,365
7
votes
3
answers
5k
views
Getting "StorageConnectionString" from ServiceRuntime: FAIL
I connect to a blob store programatically:
string connectionString = CloudConfigurationManager.GetSetting("StorageConnectionString");
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(...
- 3,353
6
votes
2
answers
2k
views
Is it possible to change the connection string during an Azure VIP Swap
I'm trying to setup Staging and Live environments in Azure (September toolkit) and I want a separate Staging and Live database - with different connection strings. Obviously I can do this with web....
- 12.4k
6
votes
1
answer
2k
views
Azure does not override application settings
In my Azure App Service I want to update application settings, but after publish from VS the keys doesn't override values from local Web.config
In Azure it looks like:
In the result my web.config on ...
- 917
6
votes
6
answers
7k
views
Entity Framework Code First Azure connection
I am using Entity Framework Code First 4.3 + Azure and having difficulties connecting to the database. The error I get is the following (on the first query):
Keyword not supported: 'server'.
I have ...
- 1,257
6
votes
1
answer
2k
views
web.config encryption for web sites
i already found information about how to encrypt the web.config with a custom provider and certificate for web roles in order to secure connection strings and other settings.
Is this also possible ...
- 61
6
votes
3
answers
2k
views
ASP.NET MVC 5 Azure Website fails to connect to SQL Azure DB on some views due to role based [Authorize] attribute
We have an ASP.NET MVC 5 website, which works fine when we run it locally with Visual Studio. When run locally the website is connected to two SQL Express databases (the AspNetUsers & our Content ...
- 169
6
votes
1
answer
2k
views
Connection string could not be found running azure function and entity framework
I've have an Asp.Net MVC app in one project and I moved my db context file used to connect to Entity Framework into it's own project, so that I can access EF from both my Asp.Net MVC app and my Azure ...
- 14.1k
5
votes
3
answers
7k
views
SQL Azure Database. Login with non-secure connection string
I have an SQL Azure database and have the auditing enabled on it. According to the portal , Auditing requires use of Security Enabled Connection Strings and consequently have set the Security Enabled ...
- 101
5
votes
1
answer
10k
views
Retrieve blob storage connection string using az cli or python sdk?
Is there a python function to retrieve a blob storage account connection string?
If so, how is this accomplished?
If not, is there a way to retrieve a SAS token using az cli or python?
Thank you
- 4,157
5
votes
3
answers
8k
views
Azure Function - The ConnectionString property has not been initialized
I developed a Azure Function in Visual Studio and it works when published in Azure (since a year ago).
Now I made a template from that Azure Function, in Visual Studio, and I changed some details, ...
- 341
5
votes
4
answers
5k
views
Azure: The context is being used in Code First mode with code that was generated from an EDMX
I have MVC app running fine in local. After updating to Azure, it started throwing the error:
The context is being used in Code First mode with code that was generated from an EDMX file for either ...
- 1,860
5
votes
2
answers
6k
views
Why am I getting "The magic number in GZip header is not correct." error using OWIN auth against Azure SQL
Nothing on Google or SO relates to this specific problem, so asking a new question. I created a brand new Asp.Net MVC Web Application with the standard user-security option. I also created an empty ...
- 93.2k
5
votes
2
answers
2k
views
Is there a way to use Slow Cheetah to transform app.config in Azure Worker Role?
I am trying to use Slow Cheetah to switch between a local db connection string and a SQL Azure connection string. This is in a Azure worker role that I am pushing to Azure with TeamCity. When I look ...
- 455
5
votes
2
answers
1k
views
ConnectionString configSource not found when deployed to Azure
I am securing my MVC5 project, by moving the connection strings out of web.config into an external file, and not checking this into source control, nor adding it to the project.
My web.config looks ...
- 462
5
votes
2
answers
11k
views
ArgumentException: Keyword not supported: 'server'
I have an Asp.net MVC5 application and have published it to Microsoft Azure. I first migrated my .mdf files toSql Azure Databases. The database connection string provided in the Azure Portal is not ...
- 1,103
5
votes
1
answer
6k
views
The connection string in the application's configuration file does not contain the required providerName attribute
I have a WorkerRole in Azure that's connecting to an MSSQL database (also in Azure, on its own virtual machine -- in other words not an Azure SQL database). The WorkerRole is using EntityFramework (...
user1379417
5
votes
1
answer
2k
views
Azure WebJob Storage Connection
I have these connection strings in my App.config for an Azure WebJob
<add name="AzureWebJobsDashboard" connectionString="UseDevelopmentStorage=true"/>
<add name="AzureWebJobsStorage" ...
- 6,594
5
votes
1
answer
3k
views
Azure connection string exception "network-related orinstance-specific error occurred"
When attempting to connect to SQL Azure with the following connection string
Server=tcp:SERVER.database.windows.net,1433;Database=DBNAME;User ID=USER@SERVER;Password=PASSWORD;Trusted_Connection=...
- 26.4k
4
votes
3
answers
4k
views
Can Azure Functions written in Node.js access Connection Strings?
The App Settings for an Azure Function App contain values for database connection strings that can be set in the portal. In C# they can be accessed using
ConfigurationManager.ConnectionStrings["...
- 4,861
4
votes
4
answers
23k
views
Configure my connection string in the Azure application setting and configure it in my web.config as an environment variable
I have a Web App in Azure and I configured the connectionStrgin in its application setting, but I do not know how I can set this configuration as an environment variable in the application web.config (...
4
votes
3
answers
3k
views
Azure: What are the Account Name and Access Key when using the Storage Emulator?
I'm following this guide:
http://blogs.msdn.com/b/brian_swan/archive/2010/07/08/accessing-windows-azure-blob-storage-from-php.aspx
but with the emulators, and not with an actual Azure account.
...
- 12.6k
4
votes
3
answers
2k
views
How do I hide my Storage and SQL connection strings using Azure Cloud Services?
I would like to move the Storage and SQL connection string from configuration files stored in the various projects of my solution to only be accessible in the Azure Portal.
Keeping connection strings ...
- 23.8k
4
votes
3
answers
7k
views
You can use CloudConfigurationManager.GetSetting for AppSettings, what is the equivalent approach for Connection Strings
Using CloudConfigurationManager, you can access AppSettings in your application or if running in the context of Azure the portal settings instead if the values exist there.
But I've not seen the way ...
- 12.7k
4
votes
4
answers
878
views
Managing connection strings Azure Cloud service deployment
I have an azure cloud service project which comprises of one worker role and one web role. I need to have both staging and live deployments but I need them to have different connection strings because ...
- 3,091
3
votes
1
answer
2k
views
What is the recommended place to store Azure Storage Connection strings
When creating a new WebJob project, the AzureWebJobsStorage connection string is added to App.config > configuration > connectionStrings
In contrast, the microsoft documentation for storage account ...
- 2,077
3
votes
2
answers
956
views
Can't connect to SQL Azure from EF, but can from SSMS
We have an Azure SQL server running which we use for our Azure Web App. The Web App can connect without a problem. We're trying to remotely update the database with the latest EF migrations via a C# ...
- 227
3
votes
1
answer
1k
views
SQL Azure connection keeps trying to open "master" despite connection string
I'm attempting to run the default "Welcome to ASP.NET MVC!" MVC3 application on Azure, using SQL Azure for the ASP.NET membership store, via ASP.NET Universal Providers. I have a SQL Azure database ...
- 878
3
votes
1
answer
1k
views
Can I use the System.Data.SqlClient provider to establish a connection with an Azure SQL Managed Instance? How about other SQL DBs?
Can I use a connection string with the System.Data.SqlClient provider to connect to an Azure SQL Managed Instance? Or just to a Microsoft SQL Server?
If so, should I still use the Windows ...
- 483