Windows error 0x80131904, -2146232060

Detailed Error Information

COR_E_SqlException[1]

Comment System.Data.SqlClient.SqlClientException

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode19 (0x013)
NameFACILITY_URT[2][3]
DescriptionThe source of the error code is .NET CLR.[2][3]
Error Code6404 (0x1904)

Questions

288votes
17answers

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavailable" errors before, but am now seeing a connection timeout error. I'm not familiar with this - [...] read more
c#
asp.net
sql-server-2008-r2
timeout
sqlcommand
105votes
21answers

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
database
entity-framework
ef-code-first
entity-framework-6
ef-migrations
58votes
17answers

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
sql
asp.net-mvc
windows-server-2003
sql-server-2005-express
24votes
10answers

"The system cannot find the file specified"

I saw many questions on SO with this error. But none were related to forms. I just hosted my application server after testing locally. I think it worked for a few mins but I'm not sure as I may have looked at the localhost tab for a moment. Then it [...] read more
asp.net
membership
19votes
6answers

Entity Framework 5 Multiple identity columns specified for table. Only one identity column per table is allowed

I am creating this model as part of my code first entity framework public class NewUserRegistration { [Key] public int NewUserRegistrationId { get; set; } } Using the Update-Database -Verbose -Force command in the Package Manger ConsoleI get this exception during the this bit of the update Applying automatic migration: [...] read more
c#-4.0
entity-framework-5
15votes
5answers

Adding 'GO' statements to Entity Framework migrations

So I have an application with a ton of migrations made by Entity framework. We want to get a script for all the migrations at once and using the -Script tag does work fine. However...it does not add GO statements in the SQL giving us problems like Alter view should [...] read more
sql
entity-framework
ef-migrations
10votes
4answers

SQL Server connection errors when moving .net app to new server

I have a number of .NET web apps on a Server 2008 machine that I'm trying to migrate to a Server 2019 machine, and some of them are giving me problems connecting to SQL Server 2016 instance on another server after moving them. The error I get is > System.Data.SqlClient.SqlException [...] read more
c#
asp.net
sql-server
asp.net-core
windows-server-2019
8votes
4answers

.NET Core can´t connect to SQL DB

I build a new .net Core Web API with connection to SQL DB. I have problems to connect the API with my Database I tried a local DB "DefaultConnection": "Server=(localdb)\\MSSQLLocalDB; Initial Catalog=ib; Integrated Security=SSPI", and a remote (see appsettings.json). Remote: Microsoft SQL Server Express (64-bit) 11.0.2100.60 System: Microsoft Windows NT [...] read more
c#
asp.net-core
7votes
2answers

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
c#
.net
wpf
entity-framework
tsql
5votes
1answer

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
iis
web-server
windows-server-2012
5votes
2answers

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
sql-server-2008
ssl-certificate
5votes
7answers

SQL Server Agent - SSIS Package - Error 0x80131904 - Timeout expired

There's been a string of random occurrences of the following error in the SQL Server Agent scheduled jobs lately that I have been unable to find a solution to. The error occurs infrequently, but usually once a week for a daily scheduled job, but in any number of different jobs [...] read more
sql-server
ssis
sql-server-2012
sql-server-agent
4votes
1answer

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
windows-server-2012
timeout
sql-server-2012
iis-8
.net-4.0
4votes
3answers

Can't connect to my own MDF file. Cannot open user default database. Login failed.Login failed for user... and other errors

SQLSEXPRESS service IS running!! I have I program I wrote some time ago and it works. It was written in MS Visual Studio with local MDF file. How is it possible to edit this file from Microsoft SQL Server Management Studio? I don't see this file in the list of [...] read more
sql-server
sharing
mdf
4votes
2answers

.NET Core API can't connect to database via docker-compose

I'm developing a .NET core web API with a MSSQL Server database. I tried to containerize this into a Docker container and use Docker Compose to spin up this service. But my API cannot connect to the database. The following error occurs: > Application startup exception: System.Data.SqlClient.SqlException (0x80131904): A network-related [...] read more
sql-server
docker
.net-core
docker-compose
containers
3votes
2answers

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
windows-server-2008-r2
iis-6
tls
pci-dss
3votes
0answers

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
networking
sql-server
windows-10
3votes
0answers

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
sql-server
windows-server-2012
3votes
1answer

How do I use Entity Framework Extensions BulkInsert and AllowDuplicateKeys

I am importing data from a CSV file into a SQL Server DB, the CSV may contain duplicate entries. My existing code uses SqlBulkCopy() and "IGNORE_DUP_KEY = ON", all is well with duplicates. I am switching to code first using EF Core with Zzz Projects Entity Framework Extensions. Primary keys [...] read more
c#
.net-core
entity-framework-core
3votes
1answer

The MARS TDS header contained errors - ASP.NET Core + EF Core 2.1.4 + Azure SQL Server

I have an ASP.NET Core app [Microsoft.AspNetCore.App 2.1.4] with EF Core 2.1.4 [DbContext pooling enabled] and data stored on an Azure SQL database. Occasinaly [once in 1-2 days] I get unrecoverable error stating System.Data.SqlClient.SqlException (0x80131904): The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained [...] read more
sql-server
asp.net-core
azure-sql-database
entity-framework-core
3votes
1answer

EF Migrations - There is already an object named '' in the database

I am having trouble adding a new table to my database. these are the commands I entered when trying to add the new migration: Add-Migration AdminSett > Scaffolding migration 'AdminSett'. The Designer Code for this migration file includes a snapshot of your current Code First model. This snapshot is used [...] read more
c#
entity-framework
migration
ef-migrations
3votes
1answer

SQL Azure impersonation error when called from Azure Function App's Managed Service Identity

THE SCENARIO I have an Azure Functions App that will be triggered when a file is added to a blob storage. It will be triggered once per day. That app will call a stored proc in a SQL Azure Database, connecting using the Function App's Managed Service Identity. That stored [...] read more
azure-sql-database
azure-functions
3votes
4answers

EF Core Migration error: Database 'MyDatabaseName' already exists. Choose a different database name

I am running ASP.NET Core 2.1 with EF Core 2.1 application on Windows Server 2016 with SQL Server 2017 Web edition. At the end of public void Configure(IApplicationBuilder app, ... method in Startup.cs I call context.Database.Migrate();. This applies migrations. Everything works. Now I backup database in my development environment in [...] read more
entity-framework-core
entity-framework-core-migrations
entity-framework-core-2.1
2votes
0answers

How to fix System.Data.SqlClient.SqlException: Login failed for user

When I run it I get this: Error Screenshot I enabled Windows authentication in IIS, SQL Server, and also added the authentication method in web.config: <system.web> <authentication mode="Windows"/> </system.web> (I am literally out of ideas...) As you may see, the DataConnection is running: DataConnection Screenshot The connection string from web.config: [...] read more
c#
connection-string
sql-server-2017
2votes
1answer

How to debug composite entity with "Incorrect syntax near the keyword 'FROM'" exception?

I created a new composite entity based on two new entities. Those in turn are based on new views, which are based on new queries. The queries are based on a mix of standard tables and views and custom tables. Similar composite entities were created in the past and work. [...] read more
ssis
dynamics-365-operations
2votes
1answer

Dropping SQL Tables if they exist / Creating if they don't (Within C#)

I am trying to create a C# Method to DROP tables if they exist and to create if they do not. So far I have created a SQL query which is TRYING to delete the tables if they exist. However I am getting this error > System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax [...] read more
c#
sql
sql-server
2votes
2answers

Stored Procedures in EF Core 3.0

How to use stored procedures in EF Core 3.0 ? I have tried the following var user = await _context.Query<User>().FromSql("EXECUTE dbo.spGeneral_Authenticate").FirstOrDefaultAsync(); var user = await _context.Query<User>().FromSqlRaw("EXECUTE dbo.spGeneral_Authenticate").FirstOrDefaultAsync(); var user = await _context.Set<User>().FromSql("EXECUTE dbo.spGeneral_Authenticate").FirstOrDefaultAsync(); var user = await _context.Set<User>().FromSqlRaw("EXECUTE dbo.spGeneral_Authenticate").FirstOrDefaultAsync(); EF core translating the SQL in wrong way. I got the [...] read more
.net-core-3.0
ef-core-3.0
1vote
0answers

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
encryption
azure
visual-studio-2017
ssrs
1vote
1answer

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
microsoft-dynamics-crm
1vote
2answers

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
sql-server
1vote
0answers

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
microsoft-dynamics-crm
1vote
1answer

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
team-foundation-server
1vote
0answers

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
azure
azure-sql
azure-networking
1vote
1answer

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
sql-server
virtual-machines
azure
windows-10
1vote
0answers

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
windows-server-2012-r2
azure
iis-8.5
1vote
0answers

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
networking
windows-server-2012-r2
1vote
2answers

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
windows-7
sql-server-2008
windows
1vote
1answer

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
sql-server-2008
networking
remote-access
1vote
1answer

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
active-directory
powershell
1vote
2answers

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
c#
asp.net
1vote
3answers

How to wait for MSSQL in Docker Compose?

I have a service (an ASP.NET Core Web application) that depends on MSSQL. The services are orchestrated using Docker compose, and I want docker compose to first start the database and wait for it to be ready before running my service. For that, I am defining the docker-compose.yml as: version: [...] read more
c#
sql-server
docker
asp.net-core
docker-compose
1vote
2answers

dotnet core 3.1 web api development sql connection fail on server

fail: Microsoft.EntityFrameworkCore.Database.Connection[20004] An error occurred using the connection to database 'databaseName' on server 'domainName'. fail: Microsoft.EntityFrameworkCore.Query[10100] I have developed a web api with dotnet core 3.1 on macbook. I used Scaffold-DbContext "Connection String" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models to connect to the existing database on a server. On local everything works fine [...] read more
.net
asp.net-core
asp.net-core-webapi
asp.net-core-3.1
1vote
1answer

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
sql-server
amazon-rds
azure-data-studio
1vote
2answers

SQL Server connection Error Number:2,State:0,Class:20

When trying to connect to a local SQL server (MAMP) I'm getting this exception: > Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.dll System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is [...] read more
c#
sql-server
1vote
1answer

Create a subquery to filter on windowed function value

I'm trying to add ROW_NUMBER functionality to EF Core and filter by it. After adding custom function, it works fine in Select but doesn't work in Where, because of malformed SQL. Linq: var query = dbContext.OrderItems .Select(i => new { i.Name, RowNumber = EF.Functions.RowNumber(i.ProductId) }) .Where(i => i.RowNumber == 1); [...] read more
c#
entity-framework-core
ef-core-3.1
entity-framework-core-3.1
1vote
1answer

Why Can C# EXE Access SQL Server Datasource But DLL Is Blocked?

TL;DR WinForms in a C# DLL using DataBinding to a data source appear to be blocked from accessing the SQL Server database, yet raw SQL queries work. What am I doing wrong? -------------------------------------------------------------------------------- Detailed Problem Description We have a C# WinForms .Net Framework 4 application consisting of: - An EXE [...] read more
c#
sql-server
data-binding
1vote
1answer

Entity Framework Core Cascade Delete Error

Though it has been set to on-delete: "ReferentialAction.Restrict" on foreign key "FK_TeamMember_Teams_TeamId", it gives the following error when trying to delete a record from TeamMember table. Can you please help me with how I should get rid of this error? Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the [...] read more
asp.net
entity-framework
entity-framework-core
asp.net-core-webapi
webapi
1vote
1answer

SQL Server: A connection was successfully established with the server, but then an error occurred during the login process

Our application sometimes throws out this error: > System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ---> System.ComponentModel.Win32Exception (10054): An existing connection was [...] read more
sql
.net
sql-server
.net-core
1vote
1answer

Execution Timeout Expired in C# Web Application

I didnt mentioned Timeout in "command timeout", "Web.Config file" nor "SQL server". But whenever method runs, i will get below error. Please have a look and let know if your aware of this kind issues. Find detail error below. > System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior [...] read more
c#
sql
.net
1vote
1answer

Azure Hybrid Connection with Entity Framework Connection failure

I'm attempting to publish an ASP.net web app to the Azure cloud. I have to use a hybrid connection to talk with one of my SQL Servers. I believe I have it all set up correctly; however, my entity framework connection string does not appear to work. This is what [...] read more
asp.net-mvc
azure
entity-framework-6
azureportal
azure-hybrid-connections
1vote
2answers

.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
c#
docker
1vote
3answers

SQL statement used in C# program wont recognize database "System.Data.SqlClient.SqlException (0x80131904): Showing Invalid object name 'CDA'."

I am developing a basic C# application that will read folder names and insert them into a DB. However it keeps throwing > System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'CDA'. (CDA is name of my database) This is the code in question static void InsertSql(Guid folderGuid, string folderName) { try { [...] read more
c#
sql
sql-server
1vote
0answers

Connect to SQL server container with other docker container

I have a Docker container with SQL Server: sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Foo" \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04 I want to connect to this SQL Server from my application, using this connection string: "DefaultConnection": "Server=sql1,1433;Database=mydb;User Id=superuser;Password=Foo;TrustServerCertificate=True", My docker container which wants to connect is run [...] read more
c#
sql-server
docker
0votes
0answers

Azure Studio connection Error with MS SQL on Linux Mint 19.2

I have MS SQL 2017 running on Linux Mint 19.2. I used "sqlcmd" to verify that it's running, and the reported version is "Microsoft SQL Server 2017 (RTM-CU16) (KB4508218) - 14.0.3223.3 (X64)" However, when I tried connecting to the database server using Azure Studio version 1.10.0 (For Linux) it failed [...] read more
networking
linux-mint
sql-server
0votes
0answers

Failure obtaining db row lock: Execution Timeout Expired What this error describes

Quartz.Impl.AdoJobStore.LockException: Failure obtaining db row lock: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not [...] read more
database
sql-server
0votes
0answers

We've been using DCN as our best networking app and it crashed can it be fixed?

Server Error in '/' Application. Login failed for user 'DB_A3CF5B_dynamiccircle_admin'. 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 code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DB_A3CF5B_dynamiccircle_admin'. Source [...] read more
webserver
0votes
0answers

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
login
ms-sql
0votes
1answer

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
windows-server-2008
.net-framework
sql-server-express
0votes
2answers

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
active-directory
sql-server
0votes
0answers

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
sql-server
sql
0votes
1answer

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
sql-server
0votes
1answer

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
windows-server-2008-r2
sql-server
virtual-machines
azure
0votes
1answer

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
windows-server-2008-r2
sql-server
iis-7
iis-7.5
dotnet-framework
0votes
0answers

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
team-foundation-server
0votes
1answer

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
windows-server-2008
sql-server
sql-server-2005
0votes
2answers

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
hosting
iis-6
asp.net
web-hosting
windows
0votes
0answers

Access/Query SQLServer within Docker on Mac using c#/visual studio

I am new to development and C# - working on a MAC with Visual Studio Community - I installed Docker and installed MSSQL Linux within Docker. I created a database, added tables using Azure Data Studio. I can query the database from Azure. I want to connect to the SQL [...] read more
c#
sql-server
macos
docker
0votes
0answers

dbup for Azure sql datawarehouse?

Does Dbup support the azure datawarehouse DB? When i tried to run the c# console project, even for select statement, i am getting the below error, any advice appreciated? is there any alternative sql automation version like dbup, apart from dacpac. [error]Script block number: -1; Message: Enforced unique constraints are [...] read more
azure
azure-sql-data-warehouse
dbup
0votes
1answer

Trouble connecting to DB in .NET Core app while following tutorial

Ok, here's my issue. I'm following the tutorial here: https://docs.microsoft.com/en-us/aspnet/core/data/ef-rp/intro?view=aspnetcore-2.2&tabs=visual-studio And when I get to the section where you first test the app, I get a connection error for my database. I haven't touched the connection string (the tutorial doesn't say to). But the error I get is this (through [...] read more
.net-core
0votes
0answers

Installation 2SexyContent in Dnn Portal (dnnSoftware)

When I install 2sxc in DnnSoftware in recent versions I got the following error message. My provider has SQL Server switch to "czech_CI_AS" I can´t this change to US-language. Does anyone have advice? SqlDataProvider Info Created - SqlDataProvider\00.99.00.SqlDataProvider Info Executing 00.99.00.SqlDataProvider Info Start Sql execution: 00.99.00.SqlDataProvider file Failure SQL Execution [...] read more
install
2sxc
dnn9
0votes
0answers

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
sql-server
ssl
sqlexception
0votes
0answers

Timeout connecting SQL Server during the post-login phase

I'm getting this error: Microsoft.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 respond; Or it could have timed out while attempting to create multiple active connections. The duration spent [...] read more
sql-server
asp.net-core
0votes
2answers

Error on UWP trying to connect to SQL Server Express via EFCore

Team, this is driving me crazy. I always receive this error when I start the UWP application: > Microsoft.Data.SqlClient.SqlException: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that [...] read more
sql-server
uwp
entity-framework-core
database-connection
ef-core-3.0
0votes
0answers

ASP.NET machinekey settings causing error on Firefox but working on Internet Explorer

Previously we are experiencing frequent "Validation of viewstate MAC failed." error. Our app is deloyed on a web farm, and we found out that to fix this we should add machinekey settings on our web.config. After adding machinekey settings to our config, On Firefox, we are now experiencing an error [...] read more
asp.net
iis
machinekey
0votes
0answers

MS SQL Server with EF Core 'Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths' with Delete Behavior SetNull

I really thought I'd understood the EF Core delete behavior constraints concerning MS SQL Server, but obviously I don't :-( Introducing a foreign key with delete behavior "set null" leads to the following exception when updating the database: > ALTER TABLE [AppointmentParticipations] ADD CONSTRAINT [FK_AppointmentParticipations_SelectValueMappings_ResultId] FOREIGN KEY ([ResultId]) REFERENCES [SelectValueMappings] [...] read more
c#
sql-server
entity-framework-core
ef-core-3.1
0votes
0answers

LocalDB connection string to v14 SQL

I created a DB like this: C:\Users\user>sqllocaldb create demo LocalDB instance "demo" created with version 14.0.1000.169. C:\Users\user>sqllocaldb info demo Name: demo Version: 14.0.1000.169 Shared name: Owner: PC\user Auto-create: No State: Running Last start time: 13/03/2020 11:11:43 Instance pipe name: C:\Users\user> I Can connect to it with SQL Server 2017 Management [...] read more
sql-server
entity-framework
ssms
0votes
0answers

SqlDataReader Item property loses connection

I have this large SQL Server query (legacy) over several tables, that I read with a SqlDataReader. It usually has a limited number of rows to handle, but recently I had to use it over a larger number. After a number of iterations, the SqlDataReader object, on reading an Item() [...] read more
vb.net
visual-studio
database-connection
sqldatareader
0votes
0answers

Full Text Search on ValueObject in same Table generates incorrect query

I have an existing table using a valueobject placed into the same table. A full text index has been placed on the fields in the table from the valueobject, but when using EF.Function.Contains EF generates a query that fails with Sql Exception. ValueObject public class Address { [Required] [MaxLength(50)] public [...] read more
c#
entity-framework-core
0votes
1answer

.NET CORE 3 With Angular 9 loading extremely slowly

I've bought the book ASP.NET CORE 3 and Angular 9 third edition and am currently reading it and coding along. I do however have a problem, when I launch the app (pressing F5 from visual studio 2019) every request to the server is extremely slow (it can take 25 seconds [...] read more
angular
performance
asp.net-core
0votes
0answers

Windows Authentication: Login failed for user 'DOMAIN\MACHINE$'

I have seen many posts with the exact same error: > Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user ' DOMAIN\MACHINE$'. but the origin from this exception coud be quite different for each case, here is the explanation of mine: I am building an API using asp.net core 3.1, the idea is [...] read more
c#
asp.net-core
iis
sql-server-2008-r2
asp.net-core-webapi
0votes
0answers

The wait operation timed out in devexpress report

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 code. Exception Details: System.ComponentModel.Win32Exception: The wait operation timed out Source Error: Line 1399: dataTable.Clear(); Line 1400: } Line 1401: [...] read more
c#
sql-server
stored-procedures
dataset
devexpress
0votes
0answers

Need help deploying an ASP.NET WebApp that uses EF6 on an IIS server on another computer

I'm currently just a begginer with ASP.NET. I've implemented a Webapp that uses EF6 on a computer A. I now have to deploy it on an IIS server on another computer (Let's call it computer B). Whenever I try to access a web page for which it's controller need access [...] read more
c#
asp.net
.net
asp.net-mvc
entity-framework
0votes
1answer

I am not able to rectify this following error : System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'OAT'

protected void btnDeleteVenue_Click(object sender, EventArgs e) { try { con.Open(); string ddl = DropDownList1.SelectedItem.Value; string sq = "select venue_name from Venue"; cmd = new SqlCommand(sq, con); SqlDataReader r = cmd.ExecuteReader(); string dq = null; if (r.HasRows) { while (r.Read()) { if (ddl.Equals(r.GetValue(0).ToString())) { string dq = "DELETE from Venue WHERE [...] read more
c#
sql-server
visual-studio
0votes
0answers

Does docker compose does not start services in parallel

I guess docker-compose up can start multiple services in parallel (REF). I have an application that depends on multiple services (e.g., database). The application is implemented in ASP.NET Core, and uses Polly for resiliency; e.g., wait for database for a certain time intervals, if a given exception is thrown, re-try [...] read more
c#
docker
asp.net-core
docker-compose
0votes
0answers

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
azure-managed-identity
azure-synapse
0votes
0answers

SQL server Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired on azure

I am using external SQL Server to host our database and ASP.NET MVC Core application is hosted on Azure. Locally on Dev machine, the Web application works fine when a complex query executed but on Azure I get an exception Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired I am using the same [...] read more
c#
sql-server
azure
entity-framework-core
0votes
0answers

The target principal name is incorrect. Cannot generate SSPI context. in .Net MVC

I have deployed my application in AWS. When I run the application, it seems working but the problem is when I am trying to register or login. It throws error: > Server Error in '/' Application. The target principal name is incorrect. Cannot generate SSPI context. Description: An unhandled exception [...] read more
sql-server
asp.net-mvc
amazon-elastic-beanstalk
0votes
1answer

Connecting to remote sql server from dot net core from linux sometimes fails, then starts working randomly

I have a C# dotnet core 3.1 Asp.net MVC Application running on Ubuntu 18.04. It connects to a remote Sql Server running on Windows Server 2016 using Entity Framework. Most of the time, the connection and queries work fine. However, once in a while, especially if the connection application has [...] read more
sql-server
entity-framework
asp.net-core
asp.net-mvc-3
.net-core
0votes
1answer

Convert string to HierarchyId in Fluent API (EF Core) using "HasConversion()" or any other method?

I am using FileTables with EF Core Code First approach. I have used stored procedure to get the Path_Locator (PK) from FileTable (named as 'DocumentStore') in string and now attempting to insert the same in another table where I store information about that file. I have manually added the Foreign [...] read more
c#
sql-server
entity-framework-core
ef-code-first
filetable
0votes
0answers

SQL Server 2008 - Intermittent error 18456 with sa

I have an application that uses a group of SQL 2008 databases. For some reason, the main database intermittently throws a series of 18456 errors (Login failed - failed to open the explicitly specified database). This causes the application to wig out and often crash. In the SQL server logs, [...] read more
c#
sql-server
sql-server-2008
windows-7
0votes
1answer

Sql Server: timeout connection

I have a problem of this type on the code below, when I try to execute it I am shown the following error. How can I go about solving this? What is this due to? this series of code allows the implementation of the query within a c # program. [...] read more
c#
sql
sql-server
0votes
1answer

UmbracoCms ends up with error: This SqlTransaction has completed; it is no longer usable

I've installed UmbracoCms 8.5.3 (and tried some older versions as well) package on an Empty ASP.NET Web Application (.NET Framework 4.7.2) in VS 2019 v. 16.4.5. I can install it completely when default SQL CE is selected on installation process. But if I try to install it with SQL Server [...] read more
umbraco
umbraco7
umbraco8
0votes
0answers

SSIS Catalog DB Execution - Connection Timeout Expired Issue

Need some help on the SSIS packages execution. We have around 20 packages that are executed all the same time (7:00 PM). Microsoft (R) SQL Server Execute Package Utility Version 13.0.5598.27 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 6:19:12 PM Failed to execute IS server package because [...] read more
ssis
0votes
0answers

Pre-Login Handshake error when attempting to connect to SQL Server from .Net Core App in Linux

I'm trying to connect to a Sql Server database with a .Net Core server application running under Linux. According to the error, the connection is successful, but an error occurs during the "Pre-login handshake". This is not he result of a delay, I get the error immediately. Most of the [...] read more
sql
.net-core
handshake
0votes
1answer

Error "cannot find the file specified" when connecting to Azure SQL

I have developed an ASP.NET application which I deployed on Azure. I did connect my program to a database (and properly changed the Connection String). I followed this tutorial until the migration part, and yet I have the following error: The system cannot find the file specified Description: An unhandled [...] read more
c#
azure
deployment
0votes
0answers

DNN Error: DotNetNuke.Site ExportImport Installation failed while upgrade CMS from versions 9.1 to 9.3

I am getting this error message when upgrading site from 9.1 to 9.3.1. Can Does someone suggest how to get rid of this error? StartJob Starting Installation Info Starting Installation - SiteExportImport Info Starting Installation - Assembly Info Assembly already registered - bin\DotNetNuke.SiteExportImport.dll Info Creating backup of previous version - [...] read more
dotnetnuke
dotnetnuke-9
0votes
1answer

Having issue with DNN 6 upgrade network path

So we are upgrading site and came across interesting problem. We have a 6.01 version we are using upgrade path upgrades. Going to 6.4 then 7 to 8 to 9 etc etc. So far other version 7 sites upgrade fine, the version 6 sites as stated above fails. PLEASE NOTE: [...] read more
dotnetnuke
0votes
0answers

How skip some migrations in ef core?

I had some changes in my ef context and I added new Migraions dotnet ef migrations add changed98112601 then I run the below command dotnet ef database update I have the following output. It seems that want to apply Initial migrations. The Poems table is in database because it was [...] read more
c#
entity-framework
asp.net-core
entity-framework-core
ef-migrations
0votes
0answers

SqlException (0x80131904): Cannot open database "DBName" requested by the login

I have the following connection string in ASP.NET Core, but I get the following error: > Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBName" requested by the login. The login failed. Login failed for user 'admin-PC\admin'. In SQL log > Error: 18456, Severity: 14, State: 38. and Login failed for user 'admin-PC\admin'. [...] read more
sql-server
asp.net-core
0votes
1answer

MS DTC Cancelling Transaction with Entity Framework Core

I'm receiving a > System.Data.SqlClient.SqlException (0x80131904): The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction. error when using EF Core 2.1. The full stack trace is at the bottom of this message. Here's the basic process: 1. Read request message from Kafka 2. Write message to a [...] read more
c#
sql-server
entity-framework-core
0votes
1answer

My database won't update, something wrong with my connection string

I've been trying to figure this out for ages and I tried different methods but nothing seems to work. I have done a successful migration and now have a migrations file for my project. I am trying to update my database but it fails each time I try. For the [...] read more
c#
sql-server
asp.net-web-api
entity-framework-core
asp.net-core-webapi
0votes
2answers

One to one to many causes cycles or multiple cascade paths error

I'm using Entity Framework Core 3.1.0 together with SQL Server Express during development. I have a one to one relation and a one to many relation connected like this: Relation --> SupplierSettings --< Conditions So between Relation and SupplierSetting I have a one to one relation. Between SupplierSetting and Conditions [...] read more
c#
.net
sql-server
entity-framework-core
0votes
1answer

migrating to EF.core 3.1 from EF.core 2.2 breaks generated sql, adds 1 to some column names

Migrating from .net core 2.2 to 3.1 has broken several EF calls: The generated sql is introducing fields with "1" appended. Any reason? fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Failed executing DbCommand (257ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [d].[deployment_id], [d].[days_off], [d].[days_on], [d].[dt_end], [d].[dt_start], [d].[guard_id], [d].[guard_id1], [d].[last_modified], [d].[last_modified_by], [d].[site_id], [d].[site_id1], [g].[guard_id], [g].[address], [g].[bank], [g].[dob], [g].[dt_joined], [g].[dt_trained], [...] read more
c#
entity-framework
ef-core-3.1
0votes
1answer

Unable to connect to DATABASE while using command Update-Database

So, let me explain the problem a bit. I have installed MYSQL server and created a new connection and a databaseMYSQL SERVER And i can connect with no error:Connection no error Then i used the "Server Explorer" menu in visual studio to connect to the same database and grab the [...] read more
c#
mysql
.net-core
0votes
1answer

SharePoint 2010 Web Part Error - Exception from HRESULT: 0x80131904

A client of ours recently encountered a problem with a web part I wrote a while back. This web part is an advanced search which returns results based on information entered into a text box and the criteria selected from a drop down. This web part has been functional on [...] read more
c#
sharepoint
sharepoint-2010
0votes
1answer

Login page works in visual studio, not in IIS

This may seem like a duplicate question but the answers provided in the other posts did not help. I am making a C# ASP.NET website, currently it works fine when testing in the Visual Studio IDE. The site uses the default login controls that are created when you create a [...] read more
asp.net
sql-server
iis
visual-studio-2017
0votes
1answer

SQL and IIS error when publish an ASP .NET application to IIS

I have added a database to my application and then published it in IIS. I am getting an SQL error and IIS error when trying to browse to the site and have been trying to figure it out all day. I hope you can look and see if you can [...] read more
sql
iis
0votes
0answers

Error 6002: The table/view 'Customer' does not have a primary key defined. The key has been inferred and the definition was created as a read-onte

System.Data.SqlClient.SqlException HResult=0x80131904 Message=Unclosed quotation mark after the character string '1398/11/09'. Incorrect syntax near '1398/11/09'. Severity Code Description Project File Line Suppression State Suppression State Warning Error 6002: The table/view 'foroosh.dbo.Vw_Customer' does not have a primary key defined. The key has been inferred and the definition was created as a read-only [...] read more
sql-server
wpf
view
syntax
tableview
0votes
2answers

SQL Server Disconnect

Could you please help with such error? > CheckHMFireTime: System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired read more
sql-server
0votes
3answers

Getting error when trying to save data to database in console app

My app scans a folder for any changes made in it. Once it has detected a file being added it should the save that file or path in my database. But at the moment this is the error I am getting: File created: New Text Document - Copy (2).txt Unhandled [...] read more
c#
0votes
0answers

If exists, update is getting timeout from using ExecuteNonQueryAsync() in C# Azure Function from about 450k rows in SQL Server

I am getting a timeout error from using ExecuteNonQueryAsync() to do an update if something exists. The table that I am doing the update has about 450k rows so I wonder if this has something to do with it. Below is the query IF EXISTS (SELECT * FROM dbo.File_Tracker WHERE [...] read more
c#
sql-server
0votes
0answers

Docker recipe for .NET Core 3.1 and SQL Server

I have a Docker recipe to run a server for .NET Core 3.1 and SQL Server. The recipe is: Dockerfile FROM mcr.microsoft.com/dotnet/core/aspnet:3.1 as base WORKDIR /app EXPOSE 80 FROM mcr.microsoft.com/dotnet/core/sdk:3.1 AS build WORKDIR /src COPY ["ExampleProject.csproj", "./"] RUN dotnet restore "./ExampleProject" COPY . . RUN dotnet build "ExampleProject" -c Release [...] read more
sql-server
docker
.net-core
asp.net-core-3.0
0votes
2answers

SqlParameter "disappears" when assigned a value of null?

I stumbled across the following issue recently: Assigning a null to the Value property of an SqlParameter appears to cause the parameter to be omitted from the query rather than passing NULL. This results in a potentially misleading error message when the Stored Procedure has no default value for the [...] read more
.net
sql-server
default-value
sqlparameter
0votes
0answers

.NET Core valid IdentityUser Registration model returns NULL

I started developing a .NET Core 3.1 app and I'm stuck at the IdentityUser registration. The ApplicationUserModel model is valid (ModelState.Valid = true) but when I create a new variable the new variable is always null. It just doesn't make sense! Code below: [HttpPost] [AllowAnonymous] [Route("Registration")] public async Task<IActionResult> UserRegistration(ApplicationUserModel [...] read more
c#
.net-core
model
null
bind
0votes
0answers

ASP.NET MVC viewmodel SQL query syntax

I'm trying to convert basic models to model vİew and SQL queries. So what is wrong my queries or other files? // GET: Cars public ActionResult Index() { List<CarsTrxViewModel> model = db.Database.SqlQuery<CarsTrxViewModel>(SqlCars.CarsTrxByID()).ToList(); return View(model); // return View(db.Cars.ToList()); } View model: public class CarsTrxViewModel { public int CarID { get; set; [...] read more
c#
sql-server
asp.net-mvc
action
viewmodel
0votes
0answers

How to resolve SQL Exception 0x80131904?

I've connected a SQL Server to an ASP .Net Core app, but now, everytime I launch the app, or call "Update-Database", in Visual Studio, returns the error > Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Also, I'm trying to deploy the [...] read more
sql-server
visual-studio
asp.net-core
iis
.net-core
0votes
0answers

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

Can someone tell me why I'm not able to login to my web application in visual studio? I know that the web.config connection string is correct, because it is reading the rates table and showing correctly on my home page when I debug it in visual studio. I have already [...] read more
instance
generate
0votes
1answer

SqlDataException: Incorrect Syntax near '='

I am trying get the data from database but I am getting this error. I am sure I am missing some simple logic but I couldn't figure out what's wrong with the query as it is working fine directly on DB. SqlCommand retrievedgeids = new SqlCommand("Select edgeid from Edges where [...] read more
c#
sql-server
ado.net
0votes
1answer

SQL Server doesn't delete all database files, when the database is deleted?

I run SQL Server using Docker with image mcr.microsoft.com/mssql/server:latest. My problem is that, if I delete a database as follows: ALTER DATABASE [ZapDB] SET OFFLINE WITH ROLLBACK IMMEDIATE; DROP DATABASE [ZapDB]; then files remain in the SQL Server's filesystem, which prevents a new database with the same name to be [...] read more
sql-server
database
0votes
1answer

How do I migrate asp.net 2.2 identity tables to asp.net 3.1 schema?

I started a project with asp.net core 2.2. I developed the database using the "code first" approach. Later, I created a new solution with asp.net 3.1. I generated an initial migration from that existing database. Lastly, I added authentication and roles to the new asp.net 3.1 web app. Unfortunately, now [...] read more
asp.net-core
entity-framework-core
asp.net-identity-3
ef-core-3.0
0votes
1answer

Not Getting Back a Count from an Insert Executed by ExecuteNonQuery Against MS SQL Server from PowerShell script

The following code executes a BULK INSERT which succeeds, but it does not return the number of rows affected. When I do a 'SELECT count(*) ...' to confirm the count, millions of rows have been inserted. I suspect the overflow error is part of the problem. Why is the rows [...] read more
sql-server
powershell
error-handling
executenonquery
0votes
1answer

Why is Entity Framework Core attempting to insert records into one of the tables from many to many relationships and NOT the join table?

Given the following set up where there are many Teams and there are many LeagueSessions. Each Team belongs to zero or more LeagueSessions but only ever one LeagueSession is active. LeagueSessions have many teams, and the teams will be repeated. Many-to-many relationship is established between Teams and LeagueSessions with a [...] read more
c#
entity-framework-core
0votes
2answers

EF using code first with existing table

I am using MVC5 & EF6. I am doing code-first approach. I have some tables that require to be generated using migration (works) and some tables that I need to use from existing database - tables. in the DbContext class I have 'new table that is created in the DB [...] read more
asp.net-mvc
entity-framework
ef-code-first
entity-framework-6
ef-migrations
0votes
1answer

.net core api returns 500 when i make a post request from axios post

I have a .net core web api deployed on azure with mssql database which is also deployed on azure. I try to do a post request from postman and it's successful but when i try to do it inside my react app using axios i get 500 error which has [...] read more
sql-server
reactjs
asp.net-core
axios
asp.net-core-webapi
0votes
1answer

How to connect to an SQL Server on Parallels VM

I'm attempting to connect to a test Database on a Parallels VM on Mac using Azure Data Studio, but I'm getting the standard, generic connection error: > System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not [...] read more
sql-server
parallels
azure-data-studio
0votes
1answer

IIS, SQL Server & Umbraco

I wonder if anyone can help me out, we have a Umbraco installation running: * OS: Microsoft Windows Server 2016 Standard, v10.0.14393 Build 14393 * SQL Server: SQL Server 2016 Standard Edition, v13.0.1728.2 * Umbraco: v7.3.4 The server had a scheduled reboot this morning at 5 am, from then, we've [...] read more
sql-server
iis
umbraco
umbraco7
-1votes
1answer

Error in job agent when running a package in SSISDB catalog (SQL Server)

I created a simple package in visual studio. Then I deployed this package in SSISDB catalog which is on a different server. I am using Job agent to execute this package with a proxy account. But I am getting this error in Job Agent: "Excuted as user: *\test**. Microsoft (R) [...] read more
sql-server
ssis
-1votes
1answer

ASP Application on IIS crash

ASP application always hangs and didn't work on IIS during rush hours connections Also other scripts like PHP are working properly on IIS. The problem only with ASP. I'm receiving this error when i'm trying to open the ASP script. ================================================================ Server Error in '/' Application. Timeout expired. The timeout [...] read more
windows-server-2008
iis-7
asp.net
-1votes
0answers

Cannot Insert Null Error When Registering a new user Asp.Net

I followed the upvoted answer to this question, to change the Id type of AspNetUser table to int instead of string Change User Id type to int in ASP.NET Identity in VS2015 However, when I try to register a new user, it returns an error: > Cannot insert the value [...] read more
c#
asp.net
.net
asp.net-mvc
asp.net-identity
-1votes
0answers

EF core 3.1 Divide by zero error encountered with no division performed

I am trying to migrate a .net core 2.2 project to 3.1. So far I have encounter many issues, the first one was the classic Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException because I am manually assigning the Ids instead of auto-generating them with EF. So I corrected that with the fluent API (ValueGeneratedNever()) and annotations [...] read more
c#
sql-server
.net-core
ef-core-3.1
-1votes
1answer

Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','

I believe this may be a syntax error, but I cannot find it. This is the full error: > Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','. at Microsoft.Data.SqlClient.SqlCommand.<>c.b__164_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location where exception [...] read more
c#
sql-server
api
asp.net-core
stored-procedures
-1votes
1answer

Can't initialize local SQL Server database with EFCore commandline tools

I've been trying to follow several different tutorials with EFCore and .net core and I've been totally blocked at the point where I try and create a local database. I've used both the powershell tools and the commandline tools to try and create an initial migration (or do anything, really). [...] read more
c#
sql-server
entity-framework
.net-core
entity-framework-core
-2votes
1answer

Hangfire - .net core web api - IIS Implementation Error

I got an error hangfire implementation when I try to publish the web api on web server IIS. (WServer 2012) It was work on locally when I start on my computer host on IIS express. It was working well, I see my jobs on dashboard. I use the same connection [...] read more
c#
sql-server
asp.net-core-webapi
hangfire
hangfire-sql

Comments

Leave a comment

(plain text only)

Sources

  1. https://github.com/dotnet/coreclr/blob/v1.1.0/src/inc/corerror.xml
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx
  3. winerror.h from Windows SDK 10.0.14393.0

User contributions licensed under CC BY-SA 3.0