4,605 questions
1
vote
0
answers
61
views
SQL Server connection authentication in Azure DevOps pipeline for .NET seeding data .sln
I have a .NET application that seeds data to an Azure SQL database after deployment via Azure DevOps pipelines.
I'm struggling with authentication when using a connection string in Azure DevOps ...
- 3,221
-1
votes
1
answer
79
views
Unable to connect to local database using local IIS instance
Firstly there's a similar question on Stack overflow, and I have tried suggestions from the responses, none of which have worked.
I have SQL Server and IIS running on my development machine and have ...
- 1,345
1
vote
0
answers
44
views
Where should I put my MongoDB connection string in Vue CLI project?
I am learning to build an MEVN project. I have a MongoDB connection string that looks like this "mongodb+srv://<username>:<password>@<clustername>.abcdefg.mongodb.net/?...
- 125
-1
votes
1
answer
59
views
SSIS: Connection may not be configured correctly or you may not have the right permissions on this connection
I have following problem:
I use a variable:
Server=DESKTOP-156DAO6\FILEWATCHERSER;Database=testDb;User ID=florian;Password=test123321;TrustServerCertificate=true;Trusted_Connection=False
for ...
0
votes
0
answers
102
views
Connection to SQL Server using Microsoft Entry MFA via sqlalchemy and ODBC in python always prompts for password
I am writing a python script that connects to Azure Serverless SQL and exports the rows for a given query. I am using sqlalchemy. I build the connection string
connection_string = 'DRIVER={ODBC ...
- 155
0
votes
1
answer
1k
views
Unable to connect to Azure AI Foundry AgentsClient
Getting following issue:
[DEBUG] .NET DNS resolution failed: nodename nor servname provided, or not known
[DEBUG] Inner Exception Type: Azure.RequestFailedException
when trying to connect to my Azure ...
- 1
0
votes
0
answers
42
views
Test whether a string contains a valid database connection string
I'm using System.Data.SqlClient.SqlConnectionStringBuilder to pull apart a connection string we save when loading data. In theory (although not yet in practice), the user could load the OM from one ...
- 9,322
0
votes
1
answer
79
views
SQL Open returns mysterious error: "System.Security.SecurityException: The operation completed successfully."
I have a C# program using this connection string:
Server={ServerName,Port##};Database={databasename};Trusted_Connection=True;Application Name=MyApp
I'm using System.Data.SqlClient v4.8.6 in a .NET 6....
- 6,277
0
votes
1
answer
227
views
psycopg_pool.ConnectionPool conninfo WARNING error connecting in 'pool-1': [Errno -2] Name or service not known
with ConnectionPool(
conninfo = app.config["POSTGRESQL_DATABASE_URI"],
max_size = app.config["DB_MAX_CONNECTIONS"],
kwargs = connection_kwargs,
) as pool:
With a ...
- 4,280
0
votes
0
answers
80
views
NetworkService identity for applicationpool but keep getting "login failed" in SQL Server for my machine
Just get a new Windows 11 PC replacing my old Windows 10 PC and trying to transfer an ASP.NET Core 6 website for the last 2 days.
I have done all the necessary steps, enabled IIS, copied the DB, the ...
- 1,073
0
votes
2
answers
143
views
Migrating from .NET Framework to .NET 9.0, How to access ConnectionStrings from a static class? (web.config vs appsettings.json)
I am in the process of migrating a large solution from .NET Framework 4.8 to .NET 9.0. I used .NET Upgrade Assistant to get started. I have a long way to go.
All of the projects in the solution have ...
- 29
1
vote
2
answers
58
views
builder.Configuration.GetConnectionString("DefaultConnection") Returns Null
I have an ASP.NET Core 6 Web API project. My controller will connect to a SQL Server database. When I run the app I can't get the connection string in Program.cs, it's returned as null.
Here's my ...
- 475
-1
votes
1
answer
298
views
Azure function app with SQL Trigger not working after deployment
I have an Azure Function app created locally using Python code, SQL Server change tracking that tracks any operation and triggers the SQL Server trigger for further process.
app = func.FunctionApp() ...
- 1
0
votes
0
answers
71
views
Cannot connect to remote MySQL server via connection string [duplicate]
I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+...
- 335
0
votes
1
answer
367
views
Azure function not working once deployed to access Azure Storage
I created an Azure function project in VS Code, using .NET 8 isolated. I followed the instructions here Develop Azure Functions by using Visual Studio Code and once I finished and deployed it, the ...
- 1,175