Windows error 0x80131904, -2146232060

There is already an object named in the database

Update-Database failed from Package Manager Console. I've used Entity Framework 6.x and code-first approach. Error is "There is already an object named 'AboutUs' in the database." How can I solve this problem? internal sealed class Configuration : DbMigrationsConfiguration<Jahan.Blog.Web.Mvc.Models.JahanBlogDbContext> { public Configuration() { AutomaticMigrationsEnabled = true; AutomaticMigrationDataLossAllowed = false; } protected [...] read more

Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am trying to deploy my website on windows server 2003. Am i missing something or what is wrong from the following error message, how can I correct it? Thank I am having the error message: > A connection was successfully established with the server, but then an error occurred [...] read more

Win32Exception (0x80004005): The wait operation timed out

I'm running an ASP.NET Web Pages page that upon initial load pulls a list of items from a SQL server. This query runs in a second or so and loads the page within 2 seconds. The return is about a 1000 records, give or take. I'm pulling Hostnames from a [...] read more

The network path was not found

I'm running my code and getting this error. But what does it mean? > The network path was not found Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the [...] read more

Entity Framework Scaffold-DbContext Login failed for user

I am trying to build an API using Visual Studio 2017 and .NET Core 2 with Entity Framework Core. I am following the directions from This Link. I am on the section titled: Reverse engineer your model The command they give to run is as follows: Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=Blogging;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir [...] read more

remote procedure call (RPC) protocol stream is incorrect

I use entityframework 5.0. I have so many test. If I run a test alone it passes, if I run this with the others eachother in the same time, it does not pass. There is no contact between the tests. Everytime one same query was sent. It would not be [...] read more

Error connecting to MS SQL from one server but not the other

We got a MS SQL server and two web site servers. I'm in the process of moving all the sites from one of the web site servers to the new one. My asp.net sites are not able to connect to the external ms sql server after I've moved them to [...] read more

SQL Server 2008 R2 Express + Wildcard SSL Certificate

Wildcard certificates (for example, *.example.com) simply did not work in SQL Server 2008 or lower. But Encrypting Connections to SQL Server on MSDN states, plain as day, that > SQL Server 2008 R2 supports wildcards certificates. Excellent. So I set up SQL Server 2008 R2 Express on a machine, and [...] read more

Invalid object name 'dbo.UserRoles'

I am getting this error: [SqlException (0x80131904): Invalid object name 'dbo.UserRoles'.], but I can't catch where error is. I can retrieve other data from other tables, but not this. conditions are: connection string in web.config: <add name="myStoreConnection" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename='|DataDirectory|\myStore.mdf';Integrated Security=True" providerName="System.Data.SqlClient" /> context: public class AdminMyStoreConnection : DbContext { public [...] read more

Entity Framework Core: cycles or multiple cascade paths

Database in my project includes table with cycle link: [https://i.stack.imgur.com/crYxc.png] Here's the entity class with fluent configuration: public class ReportFolder { public Guid Id { get; set; } public string Name { get; set; } public Guid? ParentFolderId { get; set; } public virtual ReportFolder ParentFolder { get; set; } [...] read more

How do I disable TLS 1.0 without breaking my IIS/ASP.NET websites?

We are running Windows Server 2008 R2. TLS 1.0 has been non-PCI compliant for some time now, and disabling it via the windows registry is easy. In the past, though, disabling TLS 1.0 has caused 2 problems for us: 1. It's impossible to connect to the server via Remote Desktop. [...] read more

Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud

Background For years I hosted all of my server functionality, including IIS, Apache, MySql, and MSSQL on a single server instance, yikes! As my client base grew this led to persistent SQL Timeouts when the server got busy. Over the past year I've reorganized this into three servers, one Windows [...] read more

SQL Server 2012 Connection Timeout Expired

I am running MS-SQL Server on Windows Server 2012. From time to time I get this Exception: > Server Exception : System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and [...] read more

IIS SQL connection fails under heavy load; reset IIS fixes temporarily

Server 1: SQL Server 2008 Standard Edition Server 2: Windows 2008 Server R2, IIS 7.0 A web-site on Server 2 requires data in SQL Server on Server 1. Everything works fine for a while (weeks sometimes). Then, under heavy load, Server 2 reports it cannot connect SQL Server on Server [...] read more

Cannot connect to sql server by IP Address but using the hostname works

After upgrading to the newest version of windows (windows 10 build 10586) I am no longer able to connect to a remote sql server by ip address. Here is the error I see: > [SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake [...] read more

How to fix: 'After MS SQL Server restart alipne .net core 2.2.5 container which use it has one CLOSE_WAIT tcp connection - CPU of dotnet rise'

I have problem with App that is hosted on official asp-dotnet-core-alipne container and SQL Server on other server. After restart server on which we have SQL, containers gets high CPU and some internal thread hangs. Helps only restart of container. We investigated that there are some tcp connection in state [...] read more

How can I specify a location to create database files for an Entity Framework Core application?

I have an application using Entity Framework Core to create an SQL Server database and its tables by applying migrations. I need to be able to specify the directory location where the database files will be created. What I want to be able to do is either: 1. Have my [...] read more

Can't connect to SQL Server Docker Container through Web API .NET Core

I am trying to connect to a Docker image SQL Server database through another containerized application (microservice) built with .NET Core 3.1 but I get the following error thrown by Docker: fail: Microsoft.EntityFrameworkCore.Database.Connection[20004] An error occurred using the connection to database 'ProductDb' on server 'localhost,1433'. fail: Microsoft.EntityFrameworkCore.Query[10100] An exception occurred [...] read more

Generating non-nullable rowversion on SQL Server with EF Core 3.1

We are trying to generate a non-nullable rowversion column on SQL Server with EF Core 3.1 using Fluent API: public class Person { public int Id { get; set; } public byte[] Timestamp { get; set; } } public class PersonEntityConfiguration : IEntityTypeConfiguration<Person> { public void Configure(EntityTypeBuilder<Person> builder) { builder.HasKey(p [...] read more

EF core Scaffold-DbContext doesn't work : Execution Timeout Expired

I'm trying to scaffold Models from an existing database. Scaffold-DbContext "connectionString" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models But I got this error: > Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. * All required packages are installed (tried another connection [...] read more

EF Core Group By is working on sqlite but not SQL Server

In case I have the following EF Core statement var totalCallsOnHealthRelatedIssue = await _context.CallReasons .Where(cr => cr.Call.IsDeleted != true && (cr.Call.CallStartDateTime >= filterStartDate && cr.Call.CallStartDateTime <= filterEndDate) && cr.Reason.ReasonTypeId == 2) .GroupBy(cr => cr.CallId) .CountAsync(); // Reason: Any type of health issue is counted ReasonType: Health Issue == 2 It [...] read more

Scaffold-DbContext "Login Failed" "Error Number:4060,State:1,Class:11"

My ASP.NET MVC core application should connect to an existing MSSQL LocalDB file via Entity Framework. Database-first development requires reverse-engineering the existing database. Following the instructions in the official documentation, I am running the following command in the NuGet Package Manager Console: Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models However I am [...] read more

EF core errors to add entities when running within a cycle

I have been dealing with some EF core issues that I cannot identify the source and although I can get around them it's resulting in inefficient code in my opinion. Let me explain, I am calling the below procedure within a cycle after a POST form submission: if (form.Inventory != [...] read more

AZURE_KEY_VAULT provider in SSRS

I've recently set up Always Encryption on an on-prem SQL Server db with the column master key in Azure Key Vault. If I SELECT from the table in SSMS with 'Column Encryption Setting=Enabled' I can read the column in plain text so _I'm pretty confident* the encryption is functioning as [...] read more

Dynamics CRM 2011 Import Organization from different locale fails on SQLException

I'm struggling with a Dynamics CRM 2011 , when trying to import an existing organization - coming from a customer's Window Domain, not ours. THE SETUP Two servers. * One windows server 2008 r2 x64 Standard (locale fr-FR) for the Front-end, WebApp and all * One Windows server 2008 r2 [...] read more

How to find missing permission in MS SQL server

Problem description:I am trying to use SQLDependency on a table of a commercial product (TAC Reservation Assistant). The DB is a large Microsoft SQL 2016 database on which we don't have db_owner rights (only TAC does). I am now trying - together with support staff of TAC - to grant [...] read more

Exception when upgrading organization from crm 4 to 2011- invalid column names

In development and QA environments we've upgraded dozens of organizations from dynamics v.4 to v. 2011 without a hitch. Naturally, when we try to upgrade our first prod organization, we run into a previously unseen error during the import process. It seems like the new schema for the 'Organization' table [...] read more

Team Foundation Server (TFS) 2017 Failing to create backup

So we've had backups running for a few years now, and in the last few days it started backing up extra times. I went to reconfigure the backups to verify the settings and got an error saying it can't backup the dummy database. [Info @12:03:50.669] +-+-+-+-+-| Running Confirming Permissions: Confirming [...] read more

Azure VPN cannot connect to sql server

We have setup our VPN connection in Azure to our on-premises database, the connect is working with no problems. I have written a MVC app that tries to connect to our on-premise database in SQL Server and am getting the following error: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred [...] read more

Install SQL Server 2017 on Windows 10 Azure VM

I have one Azure Windows 10 VM set up as a workstation which has among other things: * Visual Studio 2017 * Python 2.7 * NodeJS * SQL Server 2017 When a coworker created a new Windows 10 VM and went to install SQL Server, he got an error. I [...] read more

Windows 2012 R2 Azure VM Cannot Connect To Local SQL Server

I created an Azure virtual machine running Windows Server 2012 R2 that I am using as a web server to host a couple different web sites. This is my first time ever doing something like this and I am struggling to get it to work. I installed IIS 8.5 and [...] read more

SQL Connection Problems between two servers

I have two Windows Server 2012 R2 servers HOST1 and HOST2. HOST1 has a web application that talks to a SQL Server 2014 instance on HOST2. When pulling larger amounts of data, notably during scheduled integrations, HOST1 encounters errors that cause processes to fail. There problem is always one of [...] read more

C#/SQL Server: Login failed when connecting from remote machine

I've got an SQL Server 2008 Express set up on one machine and am trying to connect with my C# app to the server from another machine (both Win 7). The server machine has a user account for me in the system. The SQL Server is configured to use Windows [...] read more

what instance name in connection string for Dynamic management Views

I want to run the following query :: SELECT S.* FROM sys.dm_exec_requests S JOIN sys.dm_exec_sessions R ON r.session_id = s.blocking_session_id It works when i run it in SQL Server Console. But I haven't been able to do the same thru code. I am using the following connection string: "Data Source=localhost\\sqlexpress;Initial [...] read more

Powershell Remoting always logs in as anonymous

I need some help in automating deploying some applications on my domain. The deployment process follows this basic flow in a Powers Shell script: 1. Stop services 2. Copy out applications 3. Log into at least 1 remote server and run "\Services\Shipping\ShippingService.exe /deploy" 4. Start services. I'd like to cut [...] read more

ASP.NET Core MVC webapp error after Azure deployment

I wrote an app in ASP.NET Core MVC with CRUD to deploy to Azure, using code first. I followed this tutorial: https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-dotnet-sqldatabase The tutorial is slightly out of date, but I am confident that I followed it properly. I also attempted to literally follow the tutorial with the sample app, [...] read more

Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

I have a problem I am using lazy loading and virtual, but when using this it generates the following error > Violation of PRIMARY KEY constraint Cannot insert duplicate key in object How can I solve it? These are my classes: public class Producto { [Key] public Guid ProductoId { [...] read more

Problem catching SqlException 547 with DeleteConfirmed class in ASP.NET Core MVC Controller

I have standard MVC Controller on simple database table (Products) with corresponding Model and all Views (Index, Detail, Edit and Delete). All functionalities works without problem if record doesn't have foreign key constraint. I've modified DeleteConfirmed class in my Controller so I can catch SqlException that happens when someone tries [...] read more

ASP.NET Core Web 3.1 - IIS Express can fetch data from localdb but local IIS can not

I have a very weird problem as stated above. The code running is exactly the same, the only difference is the Debug profile used. I'm using Microsoft Visual Studio Community 2019 Version 16.6.3. When using the IIS profile the code says I have no Media in my database. enter image [...] read more

System.Web.HttpException: 'Unable to connect to SQL Server database using User.IsInRole("string")

I have this code: if (User.IsInRole("CanManageUsers")) { return RedirectToAction("Index", "Account"); } Which throws the following error: > System.Web.HttpException: 'Unable to connect to SQL Server database' Now I can not figure out why because prior to that I'm successfully connecting to the same database and I fail to understand why in [...] read more

Entity Framework Core - Error when trying to Add Migration after creating Model from existing database

I have .NET Core Project with Entity Framework Core. I created a model from an existing database using the following command Scaffold-DbContext "Server=.\SQLEXPRESS;Database=DBName;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models The Model was generated and I tried to add migration but the migration that is generated is actually trying to create anew the already [...] read more

Linq query with too many includes exception

I am using EF6 and I have a query that selects only one entity from the database but with including all of the related entities. I am selecting only one using FirstOrDefault() method but sometimes this exception appears > System.Data.SqlClient.SqlException (0x80131904): Distributed transaction completed. Either enlist this session in a [...] read more

System.Data.SqlClient.SqlException after CREATE/ALTER/PRINT

I'm coming from 2 other questions, and am trying to understand why this exception happens. Entity Framework seed -> SqlException: Resetting the connection results in a different state than the initial login. The login fails.results-in-a-dif What does "Resetting the connection" mean? System.Data.SqlClient.SqlException (0x80131904) This code reproduces the exception. string dbName [...] read more

Creating SQL Server in Amazon, cannot connect to it using Azure Data Studio

I've created a SQL Server in AWS, here is the screenshot. enter image description here [https://i.stack.imgur.com/3wJm3.png] Then, I've pasted the endpoint, and try to connect using Azure Data Studio. enter image description here [https://i.stack.imgur.com/3dMXq.png] However; I couldn't connect to SQL Server I created through AWS. Here is the error message: [...] read more

Database deadlock on simultaneous API requests that insert to 2 tables

So i have endpoint in my api that accepts file with data. For each file i extract data and save it to Products table and at the same time i save filename and date added to diffrent SavedFiles table. Each product has fileId so that we know which file does [...] read more

Fixed Cannot open database requested by the login. The login failed

I try to execute this web application but it gave me this error messages when I try to register a user account in the web application: > System.Data.SqlClient.SqlException occurred HResult=0x80131904 Message=Cannot open database "rentalsystem" requested by the login. The login failed. Login failed for user 'MicrosoftAccount\corene100@outlook.com'. Source=.Net SqlClient Data Provider [...] read more

Entity Framework is combining my table name and the Id name

This is an odd issue. My Entity Framework Core project is combining the table and the Id into one column like this: MonsterListMonsterId Here is the error: Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'MonsterListMonsterId' This is the controller that generates the error: var treasuresByMonster = await _context.MonsterTreasures.Where(q => q.MonsterId == id).ToListAsync(); [...] read more

Azure SQL Single Database DTU Timeout Expired Error

I am using Azure SQL Single database DTU purchase model. The average load seems to be under 10%. From time to time I am receiving an error, now it's happening almost each day. I am using EF Core 3.1 for database access. The database is accessed from an API built [...] read more

Moving my first Blazor solution to Azure - Build still pointing to local DB

I just loaded my first Blazor solution to Azure. Using Visual Studio, I developed on my local laptop with two databases. One for security, another for data. I have successfully deployed everything to the free Azure service created, and my local build reads data from the online Azure databases. But [...] read more

Connect to db server from an app server: (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I have two servers: AppServer with IP 192.168.1.2 and DBServer with IP 192.168.1.3 On DBServer I have the database EMSMVC in the DBSERVER\SQLEXPRESS instance. The database is working. On the AppServer in web.config I have: <add name="DefaultConnection" connectionString="Data Source=;Initial Catalog=EMSMVC;Integrated Security=True;Server=192.168.1.3;user id=DBSERVER\admin;password=admin" providerName="System.Data.SqlClient" /> <add name="EMSMVCEntities" connectionString="metadata=res://*/Models.EMSModel.csdl|res://*/Models.EMSModel.ssdl|res://*/Models.EMSModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=DBSERVER\SQLEXPRESS;initial [...] read more

UWP cannot connect to local SQL Server

I'm creating a simple UWP application working together with my local DB server I set up with SQL Server Management Studio. I can successfully set up a connection in the server explorer and run queries in the DB: SERVER EXPLORER [https://i.stack.imgur.com/rViri.png] However when I run the application I get an [...] read more

BizTalk.Operations TerminateInstance SQL Error

I'm getting the following when trying terminate an instance calling TerminateInstance on Operations object: System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier. at Microsoft.BizTalk.Database.DatabaseAccessor.ExecuteReader(Int32 procIndex, Object[] procParams) at Microsoft.BizTalk.Operations.OperationsMessageBoxAccessor.ops_OperateOnInstances(Int32 snOperation, Int32 fMultiMessagebox, Guid uidInstanceID, String nvcApplication, Int32 snApplicationOperator, String nvcHost, Int32 snHostOperator, Int32 nServiceClass, Int32 snServiceClassOperator, [...] read more

ASP.NET [Win32Exception (0x80004005): Access is denied] Error

When I test it in Visuall Studio by pressing F5 and it's working fine and I can able to login the webpage and sql query process working nicely. Also note that my SQL server is active over internet which can be accessed using IP address. But when I publish my [...] read more

.Net Core Docker Image cannot access database when running in docker

I have a dotnet core application that tries to access to the database, when I run it in visual studio it works fine (probably because of my domain authentication) but when I try to build docker image and run it with docker run -it --rm -p 8080:80 --name console console [...] read more

Unable to connect to sql database using System.Data.SqlClient 4.4.3 and hostname but ip works

I have tried running this in a asp.net core 3.1 app inside a docker container based on mcr.microsoft.com/dotnet/core/sdk:3.1-bionic (Ubuntu 18.04). also tried with mcr.microsoft.com/dotnet/core/sdk:3.1-buster. I'm trying to connect to a database with the following code: using var connection = new SqlConnection(connectionString); connection.Open(); If i use an ip adress it works [...] read more

.NET Core console application with EF Core is not working when run from using dotnet run command, throwing authentication failed exception

I wrote a simple .NET Core console application to explore EF Core using the code first approach and I followed the below steps (windows machine). 1. Create a new .NET Core console application dotnet new console -o CodeFirstDemo 2. cd into the CodeFirstDemo directory cd CodeFirstDemo 3. run the application, [...] read more

Sql Exception 0x80131904 cannot log in

My program connects to a MSSql database. If it connects via LAN it works fine, if it connects from outside I get the error message 0x80131904 Error when logging in the user 'ProgProj'. (translation might not be the same as on the english version. On the german version its like [...] read more

SQL Login fails for app but not for SSMS

I wrote a simple test application in C# (4.5) which does nothing more than connect to a database and display a message. (Basically just to test the deployment and DB connection.) On my local workstation everything works fine. I installed SQL Express 2012, connect as the current user (integrated security), [...] read more

Active Directory SQL Server Random Handshake Timeouts

We've installed active directory on a new server and joined our database server and web servers to this new domain. However, randomly, we'll get the following error. What would be the cause of the handshake timeout error we're sometimes seeing? The fact that it's not ALWAYS happening to me means [...] read more

An error occurred using the connection to database 'myDb' on server 'tcp:xx.xxx.xxx.xx'. SQLServer - Google Cloud

I'm having a problem deploying my app. The error, below, says that there is an error connecting to the database. Here is my connection string: "Server=tcp:'sql server public IP';Database=MyDB;User Id=sqlserver;Password=passwd" The strange thing is that, when I connect through my local computer, adding a firewall rule, everything is ok, but [...] read more

Network Exception thrown after session timeout

My site will run fine and I can go through the entire site, but after my session times out, when I make another request to a page I get this exception: Server Error in '/' Application. The system cannot find the file specified Description: An un-handled exception occurred during the [...] read more

Unable to connect to a new installation of sql server

I just installed SQL Server on my Windows Server 2012 R2 box. The installation went well but my apps can't connect to it. If I use the public DNS name for the server in the connection string, the stack trace looks like this: > [Win32Exception (0x80004005): Access is denied] [SqlException [...] read more

Getting Error while calling a UDF function with function name having special character ampersand in NAGIOS

While calling a UDF function in NAGIOS with function name containing ampersand '&', It returns an error > System.Data.SqlClient.SqlException (0x80131904): The multi-part identifier "dbo.udf_tarrif_t&TT" could not be bound read more

How to get my VM on Azure to allow in My SQL Connection?

I have a Virtual Machine that is running my web api. I have then created a SQL Database through Azure(this db is not on the VM) and I put that connection string in my application. I get this when I try to run it. What do I need to do [...] read more

Intermittent DB connection failure

Recently I started to see intermittent errors in log files of my web application. Raising from different places of the application the error is always about failed connection to DB which is located on another server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The [...] read more

Delete TFS Project Collection - SqlException

I'm trying to delete a team project collection in TFS 2010. Unfortunately after struggling with some old instances (some that don't even have databases anymore) I get an error even when attempting to delete a brand new instance. I go through the detatch process and get an error during the [...] read more

How can I troubleshoot an application connecting to SQL Server

I'm trying to get ASP.net StoreFront to Connect to SQL Server Express 2005, on Windows Server 2008. I followed This Microsoft Support article without success. Below is the error. [SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or [...] read more

Hosting Website Issue

I have a web project which I want to post in to our company`s hosting server: IIS Vs.6.0. The name of the server which is running our whole websites is: testing.test.com and domain is testing.com I am added as a User in it as myname@testing.com. Now in the IIS Manager [...] read more

HTTP Error 500.30 - ANCM In-Process Start Failure - An error occured during migration

I have read this thread, however unfortunately couldn't find the solution to my problem. I have an ASP.Net Core project (that's called Rent) and it works without any problem on my local machine. However, once I publish the project to the IIS (still in development mode) I get the below [...] read more

EFCore Scaffold-DbContext SqlClient.SqlException (0x80131904): Invalid column name

I am using entity framework core to connect to my existing SQL DB that is used by other applications as well and therefor want to use the scaffolding to create my models from said DB. I have used it time and time again to create my models from the existing [...] read more

EF Code First: Unable to connect to local SQL server DB

I have created EF using codeFirst approach. In the connection string the tutor used SQL Server Express but as I have SQL Server 2019 localDB. I wrote as below <connectionStrings> <add name="DefaultConnection" connectionString="data source=(localdb)//mssqllocaldb;Initial Catalog=PlutoCodeFirst;integrated security=SSPI" providerName="System.Data.SqlClient"/> I am getting exception when I try to run command update-database Exception: Specify [...] read more

Dockerizing .NET Core Web Api

I'm trying to dockerize .NET Core 2.x web api application for the first time. Here are my files: DOCKERFILE FROM mcr.microsoft.com/dotnet/core/sdk:2.1 AS build-env WORKDIR /app COPY *.csproj ./ RUN dotnet restore COPY . ./ RUN dotnet publish -c Release -o out RUN dotnet ef database update FROM mcr.microsoft.com/dotnet/core/aspnet:2.1 WORKDIR /app [...] read more

EF Core: A connection was successfully established with the server, but then an error occurred during the login process happening spontaneously

I have issues with our SQL Server express install on the staging environment. The following exception happens in spontaneous intervals and it requires the .NET Core app to be restarted to fix the issue. Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during [...] read more

Visual studio form app access is denied 5

I am trying to make a SQL form app that works offline with visual studio (c# and SQL). the build worked perfectly on my computer but not on my friend's, he already got SQL 2019 express installed another friend got it working perfectly but not this friend he keeps on [...] read more

Asp.NET Core & EF Core with an existing identity database

I have an existing database. It uses the asp .net identity I built in .NET 4.x. Everything in it works fine. I have run a scaffold dbcontext. I have imported a few of my files into this asp .net core project and ef core. When I attempt to login to [...] read more

C# StackTrace method names do not align with source code

I have a case where a stack trace contains a method name that does not align with the method in the source code. The source calls .FirstOrDefault() and a DbUpdateException gets thrown (a timeout) with a stack trace that shows .SingleOrDefault() instead. This is not a case of the source [...] read more

What does "Resetting the connection" mean? System.Data.SqlClient.SqlException (0x80131904)

I know this is a bit vague, but I'm not being able to pinpoint the issue. When I run the a bit of code against a local database it runs fine. When I use a remote database I get an error. It occurs midway of the program execution. The DBup [...] read more

connect Unity and MSSQL

public void Test() { Debug.Log("Connecting to database..."); string connectionstring = @"Data Source = 127.0.0.1; user id = sa; password = test; Initial Catalog = test;"; SqlConnection conn = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "insert into Test(이름 ,아이디 , 비밀번호) values(@이름, @아이디 ,@비밀번호)"; cmd.Parameters.AddWithValue("@이름", [...] read more

provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host

In short, I wrote a console app that just calls a stored procedure in a SQL Server database. Then setup a Windows Task Scheduler event to call the console app's .exe file every 5 minutes. Most of the time it works, however about 10 times a day or so we [...] read more

Error 'Could not open a connection to SQL Server' while upgrading database with codefluent pivot runner

We use the pivot runner to update our databases. Since a year we regularly receive error message below. The database server is available, and is hardly used by other processes. After restarting, the same message usually reappears several times, but not always with the same action. As soon as we [...] read more

Passing pColumns with space as params in ExecuteSqlRaw

I am trying to execute a stored procedure using ExecuteSqlRaw. Normal params are getting executed properly, but when I tried to execute a stored procedure with the mandatory parameter like below List<SqlParameter> Params = new List<SqlParameter> { new SqlParameter("ContactEMail", "test@gmail.in"), new SqlParameter("Name", "test" ), new SqlParameter("Password", "test"), }; SqlParameter[] parameters1 [...] read more

Connecting a database Visual Studio

Im trying to make a simple login page using mysql and visual studio. my code is as follows private void Login_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=USER;Initial Catalog=admin;Integrated Security=True"); // making connection SqlDataAdapter sda = new SqlDataAdapter("SELECT COUNT(*) FROM Login WHERE Username='" +this.Username.Text + "' AND [...] read more

Connection SQL Server 2012 via Windows service

I created a windows service for monitoring to send data (OS info, proc, ram etc) to my SQL Server database and it works fine on my computer. I already installed the service in another machine that has SQL Server and it can connect to mydatabase successfully but when the service [...] read more

Connections issue while interactiing with SQL from Azure Function

We are talking to Azure SQL Db using Azure Function. We use latest version of Azure functions which is 3.1 along with .net core 3 and EF core. Recently we saw below error message in our logging Microsoft.Data.SqlClient.SqlException (0x80131904): Resource ID : 1. The request limit for the elastic pool [...] read more

asp.net sqldatasource parameter not supplied

I am creating a very simple CRUD (CREATE, READ, UPDATE, DELETE) test program in asp.net framework 4 which needs to have a table id as a uniqueidentifier and primary key. I have decided to let SQLServer create the unique identifier. I need to get the delete stored procedure to work. [...] read more

how can I validate if there are no errors when executing SaveChangesAsync?

I am testing a scenario where I am trying to save a duplicate element and it shows me the following error since the element must be unique (the name and fields of my table are in Spanish, for the example of my code, I preferred to put it in English): [...] read more

NLog writes to all targets from my machine but fails writing to Database target on application server

Quick summary before getting into the nitty gritty > (NLog version 4.7.2) ASP.NET Core 2.2 web application correctly logs to file & database targets from local machine. As soon as it's deployed to staging application server, file logging continues but database logging doesn't work and gives no errors in internal [...] read more

Issue connecting to SQL Server with new ASP.NET Core application

I've deployed a new .NET Core app to a production web server, and I'm having trouble connecting to a SQL Server database on another server. The web server currently has applications running on ASP.NET web forms and connecting to the database successfully. The application is developed in ASP.NET Core 2.1. [...] read more

Azure SQL Database: [SqlException (0x80131904): Could not find stored procedure

I get the error: > Azure SQL Database: [SqlException (0x80131904): Could not find stored procedure when I deploy my ASP.NET MVC application to azure. My database is an Azure SQL database. The code runs fine in my development environment. The procedure belongs to a custom schema. Below is how I [...] read more

String or binary data would be truncated. The statement has been terminated.[SqlException (0x80131904): String or binary data would be truncated

I have already searched for answer saying the inserted value could be long or mismatch of datatype, due to that this type of error could come but this web app works fine on my local system but when I use it after publishing it to the web, this error shows [...] read more

can't update database in asp.net core

I've created a table named USERGOLD using add migration and update-database and it works fine the table is created in sql server,but now i'm creating another table named FoodMenu I've created model and dbset ... i used add=migration and the table is created in migration but when i put update-database [...] read more

While creating SharePoint group using Rest api, getting Microsoft.SharePoint.SPException with Error code: -2146232060

Actual Error: body : "{"error":{"code":"-2146232060, Microsoft.SharePoint.SPException","message":{"lang":"en-US","value":"Exception from HRESULT: 0x80131904"}}}" statusCode : 500 statusText : "Internal Server Error". Scenario:Actually In SharePoint online, By Rest API, My SharePoint Hosted app will create new list item and following that, create two groups, group 1 created successfully, while creating group 2 getting this above [...] read more

Identity server 4 - error The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors

V4.0.2 We're receiving spontaneous peaks of errors, that are only shown in application insights, such as: Microsoft.Data.SqlClient.SqlException (0x80131904): The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors. For the following query: SELECT [p].[Key], [p].[ClientId], [p].[ConsumedTime], [p].[CreationTime], [p].[Data], [p].[Description], [p].[Expiration], [p].[SessionId], [p].[SubjectId], [p].[Type] FROM [...] read more

Accessing Azure SQL from Web App with EF Core, Docker and System Assigned Identity

I'm trying to access a serverless azure SQL database from an Azure Web Application running a docker container under Linux. The container is a .Net Core 3.1 web application using the latest EF Core. The web app has been configured to use a system assigned identity. For the SQL user, [...] read more

When using MiniProfilter to wrap DbConnection, receive error Procedure or function 'X' expects parameter '@Y', which was not supplied

I am adding MiniProfiler to our existing custom ORM which is based on ADO.Net. This link indicates that I just need to wrap the DbConnection with a new instance of ProfiledDbConnection but when I do that all or most of the queries performed through this connection fail with the message [...] read more

Login Failed Error when connecting to SQL Server

I am unable to connect to one of the database on our work server. Able to connect to one db but not the other (both hosted on the same server). Connecting through C# .Net Framework Application. Here is the setup. * Server name: MYSQLSERVER * Database 1: mydb1 * Database [...] read more

Having trouble working with UserManager<IdentityUser>

Am trying to create login/registration functionality, I am using user manager but am having trouble figuring it out when my code hits the section where user manager is used I get this error Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AspNetUsers'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean [...] read more

SQL Server Connection Failed with Linux Mint + SQL Server 2008 R2 using AzureDataStudio

I am trying to connect to my SQL Server 2008 R2 with SP4 database, however, I got this error and I have tried some solutions that I found here, but none works for me. PS. I do not know exactly how to understand this error > Microsoft.Data.SqlClient.SqlException (0x80131904): A connection [...] read more

How to fix " A network-related or instance-specific error occurred while establishing a connection to SQL Server" error in ASP.NET

I published my site on plesk, in login form when I enter username and password I get error. I should say that my login form is based on asp.net configuration and roles and users are set there. > System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection [...] read more

SQL Server 2016 unique identifier and foreign keys

I have a simple db table that stores actions taken by the user. CREATE TABLE [admin].[AuditRecords] ( [Id] [bigint] IDENTITY(1,1) NOT NULL, [TypeName] [varchar](200) NOT NULL, [IssuedBy] [uniqueidentifier] NOT NULL, [IssuedOn] [datetimeoffset](0) NOT NULL, [Details] [varchar](max) NOT NULL, CONSTRAINT [PK_AuditRecords] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE [...] read more

EF Core Update-Database failing when creating Foreign key

When I run Update-Database I get the following error: fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Failed executing DbCommand (938ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] ALTER TABLE [port_portal] ADD CONSTRAINT [FK_port_portal_port_portal_page_default] FOREIGN KEY ([default_page_id], [organization_id]) REFERENCES [port_portal_page] ([page_id], [organization_id]) ON DELETE NO ACTION; Failed executing DbCommand (938ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] ALTER TABLE [port_portal] ADD CONSTRAINT [FK_port_portal_port_portal_page_default] FOREIGN [...] read more

Network issue while starting Docker container for dotnet core console application

I have created a simple console application in .NET Core with EF Core executing a SQL Server stored procedure from the server that's accessible only through a VPN connection. I was able to run the application on its own, but the container always exists throwing network error when I start [...] read more

Cascading Referential Integrity Constraints for many to many relationships in EF Core

I'm using EF Core 3.1.5 with Asp.Net Core 3.1. When I'm trying to Add-Migration I get next error: > Microsoft.Data.SqlClient.SqlException (0x80131904): Introducing FOREIGN KEY constraint 'FK_PhotoDevice_Device_DeviceId' on table 'PhotoDevice' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN [...] read more

Azure Function timer trigger failed runs execution of stored procedure

I want to execute stored procedure on my azure function timer trigger. The function deployed successfully. But, when the function runs, I get this error stack trace messages Microsoft.Azure.WebJobs.Host.FunctionInvocationException: ... System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw: ... Inner exception System.ComponentModel.Win32Exception handled at System.Data.SqlClient.SqlConnection.OnError: ... Here is the code, [FunctionName("DimensionFactTableUpdate")] public static async Task Run([TimerTrigger("%CronJobSchedule%")]TimerInfo myTimer, [...] read more

Connection to SQL server fails after evry update of IIS hosted .net core app

We've deployed a .net core 3.1 app to IIS server. The app connects to a SQL server on another VM. After the initial deployment the app had no problems connecting to a database. However, every time we update the app database connections fail with the following exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Connection [...] read more

Entity Framework 3.1 One-To-Many Insert data

I have Offer and OfferLocation. One offer can have many offer location. While saving offer I also want to save offer locations into offer location table, but I get an error saying: > "Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.\r\n ---> Microsoft.Data.SqlClient.SqlException (0x80131904): [...] read more

How to use CASCADE DELETE for removing all tenant data

I want to remove all the entities related to a tenant from the a multi-tenant database when one tenant is removed. I'm working with EF Core and Microsoft SQL Server, although I guess this topic is not limited to those technologies. In this answer, it is said that: > this [...] read more

Asp.net core in docker Unhandled exception. SqlException (0x80131904): .., but then an error occurred during the pre-login handshake

I'm getting the error "Unhandled exception. Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - Unknown error 203)" when I start asp.net core application container using docker-compose in CI/CD flow from gitlab (self-hosted) runner [...] read more

docker mssql container and web api

I followed the steps in this tutorial: https://docs.microsoft.com/en-us/sql/linux/tutorial-restore-backup-in-sql-server-container?view=sql-server-ver15 to create a container with my personal database backup. This part is working correctly and I am able to connect to the database through SSMS using these credentials: * Server Name: localhost,1433 OR 172.0.0.1,1433 (these both work) * Username: sa * Password: [...] read more

Azure SQL Does not allow login for Created Clients

I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure: * add client ip addresses to firewall * create login on the master database * create users * add appropriate roles that at least encompass db_accessadmin Despite this, [...] read more

An error occurred using the connection to database 'myDb' on server 'tcp:xx.xxx.xxx.xx'. SQL Server - Google Cloud

I'm having a problem deploying my app. The error, below, says that there is an error connecting to the database. Here is my connection string: "Server=tcp:'sql server public IP';Database=MyDB;User Id=sqlserver;Password=passwd" The strange thing is that, when I connect through my local computer, adding a firewall rule, everything is ok, but [...] read more

Unable to authenticate MFA for Azure Conditional Access

I am currently setting up an Azure portal using a free account which I am currently on a Premium 2 trial for Active Directory. Originally I was able to access the database using the credentials of a user called JP01. This user is part of a Database Admin group which [...] read more

Execute a job in SQL Server Agent : login from an untrusted domain

I have an issue with the execution of an SSIS Package within the SQL Server Agent. Context : * I deployed a package into the Integrated Services Catalog : http://i.stack.imgur.com/m9Y9c.png I have not difficult to execute this package manually. Problem : * When I try to execute this package within [...] read more

asp.net core 3.0 docker image failing to create

I am using asp.net core 3.0 with sql server, trying to create microservice using docker. However when I tried to run docker-compose I am getting > "An error occurred while migrating or seeding the database." error. I have entity-framework 3.1 migrations in code, when the new database container spins-up I [...] read more

How to configure SQL Server docker before docker run in vs19

I have pulled the docker for SQL Server and run it using this command. docker run -e 'ACCEPT_EULA=Y' -e "SA_PASSWORD=12345678Aa" -e "MSSQL_PID=Express" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest-ubuntu When I try to run my project in Visual Studio via IIS Express,it's running correctly. enter image description here [https://i.stack.imgur.com/7eOEL.png] But I try to [...] read more

Cannot delete Product record after upgrading from Dynamics 365 CRM 8.1 to Dynamics 365 CRM 9

I have tried the following steps in CRM 9: 1. Disabled all the plugins related to Product Entity 2. Created a new Product without any Parent or Child product. 3. Tried deleting the product. This step throws an error. The error I received was: enter image description here [https://i.stack.imgur.com/VDDmP.png] > [...] read more

The network path was not found in windows 7

when I'm running http://localhost/ in my local PC getting this error. But what does it mean? The network path was not found Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated [...] read more

Cannot access ADLS from Synapse Analytics

I have; 1. A master key. 2. A database scoped credential. 3. An external data source. 4. File format. 5. A user created managed identity for Azure SQL Server. 6. RBAC contributor permission for that managed identity on my ADLS storage account. When I execute the code to create an [...] read more

How to properly update multiple records in asp.net core 3.1?

I have an API (PUT) request like the following: {{APIBaseUrl}}/accounts/mappingType The request body looks like the following: [ { "CompanyId" : "AA", "AccountIndex": 134, "Value": "TTTTTTT" }, { "CompanyId" : "A", "AccountIndex": 5148, "Value": "TTTTTTT" }, { "CompanyId" : "B", "AccountIndex": 5146, "Value": "TTTTTTT" } ] The mappingType in the [...] read more

Cannot scaffold DbContext using my local (Azure Ad) credentials

we're using Azure AD to authenticate user and service principals for access to our Azure Sql database. This works fine in my Azure Functions project when running locally via func start or when deployed to Azure, using MSI. Since we're not using the code first approach, there have been some [...] read more

.NET and SQL Server container with EF Core and K8s

My goal is to deploy a blazor web application using ASP.NET as the frontend and a SQL Server (on Linux) as the backend. The problem is utilizing the EF Core code because of my embedded connection string: var connectionString = "Server=localhost,1433;Database=HelmDevDb;uid=sa;pwd=27u6DG;MultipleActiveResultSets=true;"; The problem is that within the Blazor application it [...] read more

EPiServer: The wait operation timed out

Versions used: EPiServer 10 (with latest package updates) Visual Studio 2017 15.0.0-RTW+26228.4 Also occurs with VS 2015 Preface: EPiServer is a CMS which allows content types and page types to be defined in code. When those are updated, a task will update respective items in database. When I add or [...] read more