News

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...
To connect to Azure SQL Database using the traditional username/password way, you can compose the connection string based on your programming language and library, then configure the connection string ...
To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name and endpoint (such as a DNS name or IP address). For this article, we're only ...
I am trying to run an Azure Durable Function on ACA using an Azure SQL server as storage. Connection authentication must be done via Active Directory. The Connection string created by Aspire is as ...
Please note that Integrated Security=false was set in the connection string used above, as the example uses SQL Server Authentication. If Windows Authentication is used, this must be adapted.
Next, we'll need to establish a connection to the SQL server. Below I'm defining a SQL connection string and passing that as an argument to the SqlConnection object.
I had been passing username/password strings directly into the ADO.NET connection string, however this means that if a user has a quote character in his password, it borks the ConnectionString and ...