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

268votes
14answers

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
146votes
7answers

"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website

I am experiencing error when connecting MY DB which is in VM Role(I have SQL VM Role) from Azure Website. Both VM Role and Azure Website are in West zone. I am facing following issue: > SqlException (0x80131904): A connection was successfully established with the server, but then an error [...] read more
azure-web-roles
azure-vm-role
93votes
15answers

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
54votes
14answers

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
54votes
7answers

How to add LocalDB to Visual Studio 2015 Community's SQL Server Object Explorer?

PROBLEM I don't understand how to make LocalDB show up in the SQL Server Object Explorer. On some VMs, it shows up automatically, on some other VMs, it doesn't. Still, after googling for hours, I don't get it. CURRENT SITUATION 1. I have a clean VM 2. I installed Visual [...] read more
sql-server
visual-studio-2015
localdb
43votes
9answers

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
sql-server-2008
asp.net-webpages
31votes
8answers

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
.net
database
networking
21votes
6answers

EF Code First - Timeout expired. The timeout period elapsed prior to completion

Apology for this strangely worded question. I don't know what the actual problem is but hopefully someone can give me some insights. I am getting the following error when trying to run migrations: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not [...] read more
c#
sql-server
entity-framework
ef-migrations
8votes
4answers

Sql Exception With .net 4 & EF

we are using .net 4 MVC2 with EF & Sql Server 2005. For some requests, and it happens rarely, and only when we are doing search which is implemented with classes mapped to stored procedures performing full text search, we get the exception: [SqlException (0x80131904): Timeout expired. The timeout period [...] read more
.net
entity-framework-4
8votes
3answers

Renaming Identity tables with EF6 Migrations Failing

I'm trying to rename my Identity 2.0 tables via the Migrations tool in EF6/Package Manager. However, it's blowing up a part of the way through. I'm simply calling the following piece of code after the "ApplicationDBContext Create" in IdentityModels.cs: protected override void OnModelCreating(DbModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<IdentityUser>().ToTable("Users"); modelBuilder.Entity<IdentityRole>().ToTable("Roles"); modelBuilder.Entity<IdentityUserRole>().ToTable("UserRoles"); modelBuilder.Entity<IdentityUserLogin>().ToTable("UserLogins"); [...] read more
sql-server
asp.net-mvc
entity-framework
entity-framework-6
7votes
2answers

Azure: Login failed for user

What I have done: * I added Resource group in Azure. * Added Web Service with previous resource group. * Added SQL Server Database with previous resource group. * Retrieved generated connection string from this database and provided here username and password. * Added this connection string to App Settings [...] read more
.net
sql-server
database
azure
6votes
3answers

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
6votes
3answers

SQL timeouts after moving to azure

After deploying my application to Azure I am experiencing sql timeout issues with a few db intensive reports. I have tried changing the sql timeout in the connection string but without any effect.. I have also tried upgrading the database from S2 to P1, which then is performing well enough [...] read more
c#
azure
azure-sql-database
6votes
1answer

[Win32Exception (0x80004005): The system cannot find the file specified]

I'm working on a joke web application. I work with C#, Entity Framework, MVC and I do code-first. Now when i try to read out something in my DB, the error I put in the title shows up. And I have no idea what to look for. I looked up [...] read more
c#
sql-server
asp.net-mvc
code-first
entity-framework-6
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
1answer

Entity Framework throws exception on updates only - Invalid object name 'dbo.BirdBrain.service'

I've created an EF Core model from an existing database and all operations on entities work EXCEPT for updates; on updates EF Core is using an incorrect database name. eg. When I perform an update I get a SqlException: Invalid object name 'BirdBrain.dbo.services'.. BirdBrainContext is the name of my DbContext, [...] read more
c#
sql
sql-server
entity-framework
ef-core-2.2
5votes
7answers

Azure Web App Error, No such host is known

When Running the web App locally there is no issue to connect to the DB, after deploying the Web App to Azure the DB(Also Azure) connection attempt throws the following error: [Win32Exception (0x80004005): No such host is known] [SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection [...] read more
asp.net
azure
azure-sql-database
azure-web-sites
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
2answers

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Possible Connection String Issue?

I'm attempting to deploy my first MVC application and I keep running into issues revolving around connecting to my sql server database. My current problem is that when I try to publish the site, I'm greeted with: SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. What I'm not sure [...] read more
iis
asp.net-mvc-4
ef-code-first
sql-server-2012
web-deployment
4votes
2answers

How to get rid of deadlock in a SQL Server 2005 and C# application?

I have a code in C# for windows service which is mainly responsible to update records in a table in my database, but I get always a lot of errors in my log, all errors are about deadlock of resource, This is the error: > System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID [...] read more
c#
sql-server
sql-server-2005
deadlock
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
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

Specified network name no longer available when connecting to SQL Server in .NET

I reinstalled my main work pc, but didn't reinstall visual studio after 5 months. Now i did and started my old project, and now it doesn't run. I get a timeout error when connecting to SQL Server, so i increased the timeout in the connectionstring and now i get the [...] read more
c#
sql-server
visual-studio-2015
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

.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
1answer

.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
3votes
1answer

Entity Framework Core with managed identity to Azure SQL gives Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

We've enabled managed identity to connect to our Identity Server database on Azure using this tutorial but get the following error after a while (~7 hours). System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, [...] read more
sql-server
azure
asp.net-core
entity-framework-core
identityserver4
3votes
1answer

EF Core database update specify base version

In my projects I have two EF core migrations files in the Migrations folder which I have created based on the initial release and after an update. The initial migration ("Initial") contains many CreateTable statements, whereas the second migration ("Cleanup") only contains a few DropColumn statements in their Up methods. [...] read more
c#
entity-framework-core
ef-migrations
3votes
3answers

Error when connecting to SQL Server in docker container

I have an ASP.NET Core WebAPI running inside a Windows Docker container. I'm having trouble connecting to an on premises SQL instance from inside the app. This is the error message: > (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not [...] read more
c#
docker
asp.net-core
.net-core
docker-windows
2votes
1answer

Package fails because System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 's'

My package was perfectly fine for couple of days and today whenever I tried to run it, it transferred few columns from the first file in the folder and failed. The error that I'm getting is: > System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 's'. Unclosed quotation mark after the character string [...] read more
c#
sql
sql-server
csv
ssis
2votes
0answers

SQL timeout on one page of aspx site

I've just gone live with an web application using aspx pages, C# behind. All sitting on SQL Server. All data delivered with stored procedures. Almost all the procedures are dynamic SQL, with the sql statement being built in the procedure itself based on parameters passed in. There are three virtually [...] read more
c#
asp.net
sql-server
2votes
1answer

Incorrect syntax near @indexName. Dapper

This seems like a strange behaviour, but the following code is throwing an error: public async Task RebuildIndex(string tableName, string indexName) { await _dbConnection.ExecuteAsync($@" alter index @indexName on @tableName rebuild;", new { indexName = indexName, tableName = tableName }); } Error message: System.Data.SqlClient.SqlException (0x80131904): Неправильный синтаксис около конструкции "@indexName". at [...] read more
c#
sql-server
dapper
1vote
1answer

Dynamic CRM 2011 Import Organization from different locale fails on SQLException

UPDATE : Issue solved, see answer below. I'm struggling with a Dynamic 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 [...] read more
microsoft-dynamics-crm
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
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
0answers

Solved-Maybe? How to return list of DTO with nested lists of related DTO

Without using Automapper, I'm trying to map a list of DTO's into each element of a list of DTO's. Specfically in this example, I want the API to return a list of parents where each parent contains it's list of children and list of pets. I have an EF Core [...] read more
c#
asp.net-core
linq-to-sql
entity-framework-core
dto
1vote
1answer

Insert data into a SQL Server database using vb.net

I create a SQL Server database and I want to add some data in a particular table of that database. I use some textbox to input the data and an add button to complete. But when I tap the button the whole process was stopped and indicate an error in [...] read more
sql
sql-server
vb.net
inventory-management
1vote
0answers

How to fix duplicate foreign key when adding navigation property to existing relationship?

I have a very simply identity object: Public Class UserRole Inherits IdentityUserRole(Of Integer) End Class By default this generated the following migration: CreateTable( "dbo.UserRoles", Function(c) New With { .UserId = c.Int(nullable := False), .RoleId = c.Int(nullable := False) }) _ .PrimaryKey(Function(t) New With { t.UserId, t.RoleId }) _ .ForeignKey("dbo.Users", Function(t) [...] read more
vb.net
entity-framework
asp.net-mvc-5
ef-migrations
navigation-properties
1vote
0answers

GroupBy generating wrong OrderBy query

I have the following query: var trains = queryableTrains.Select(t => new TrainDto { Id = t.Id, Prefix = t.Prefix, Color = t.Color, PlannedMovements = t.TrainMovementPlans .Where(p => trackCircuitIds.Contains(p.TrackCircuitId) && p.TimeStamp >= start && p.TimeStamp <= end) .Select(p => new TrainMovementDto { SgfId = null, Prefix = t.Prefix, BlockSectionId = p.TrackCircuit.TrackCircuitGroupId [...] read more
asp.net-core
.net-core
entity-framework-core
ef-core-2.2
1vote
2answers

ASP.NET MVC 5 Data is NULL Due To Network Related Instance

I am getting the value from text field but can not find the reason of not getting saved in the variable. var user = new ApplicationUser() { UserName = model.Email ,Email = model.Email}; user is null despite Email contains the value. I have found it through debugging. { Line 81: [...] read more
asp.net-mvc
1vote
1answer

"How to fix" SqlException: Invalid object name 'Orders'. databatase location?

I followed the instructions in this video https://docs.microsoft.com/en-us/visualstudio/get-started/csharp/tutorial-aspnet-core-ef-step-03?view=vs-2019 to try to add a products database. and after some (inital bugginess I first crashed and the website asked me to apply migrations and i hit apply) an then it eventually worked. The instructions tell you to create a new models folder [...] read more
c#
asp.net
sql-server
1vote
1answer

Error removing the IUser in EpiServer - SqlException: Execution Timeout

I have used, CommunitySystem.CurrentContext.DefaultSecurity.RemoveUser(IUser user); To remove user. However, this was working fine. But suddenly it has given an error. And it keeps happening forever. The exception throws from the RemoveUser(IUser user). The exception details are here as below, System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to [...] read more
episerver
1vote
1answer

Invalid column name Entity Framework Core

I have following entity class: public partial class ProjectUser { public int Id { get; set; } public int ProjectId { get; set; } public int UserId { get; set; } public virtual Project Project { get; set; } public virtual Users User { get; set; } } When I [...] read more
c#
entity-framework-core
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
0answers

SQL server named instance connection

On several occasions I have observed a intermittent connection failure to SQL server (2012) resulting in the following stacktrace 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 correct [...] read more
sql-server
sql-server-2012
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

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

Cannot Connect From Amazon aws t2.micro windows 2012 instance to Amazon RDS SQL Express 2014

I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance. 1. I cannot connect through UDL file, and also not through my asp.net mvc web application. Windows EC2 Instnace ID: i-0fe6390a77605e7f2 Availaibility Zone: us-east-2c RDS SQL Server Instnace ID: tandt-201901-2 RDS SQL Server Zone: [...] read more
windows-server-2012-r2
amazon-ec2
amazon-rds
sql-server-2014
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

Getting error: SqlException (0x80131904):Subquery returned more than 1 value - why?

Error when running my query : > System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression This is my code: UPDATE Trade SET Reference = (SELECT DISTINCT [...] read more
sql
sql-server
0votes
0answers

SQL Server timeout period elapses during pre-login handshake on remote connections

I'm having an odd issue where I get a timeout with the DB if there's no activity for about 30 mins. Then, after a second or so it starts working again. Here's the error in my .NET code: > System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed while attempting [...] read more
.net
sql-server
0votes
2answers

Getting an sql connection string error when scaffolding in EF core?

For background info, I'm running .NET core on Arch Linux VScode and I also have SQL Server running on Arch Linux. When I connect to the server via sqlcmd or through the VScode SQL extension, everything works fine. Only when scaffolding am I getting errors, so my connection string is [...] read more
c#
sql-server
entity-framework
sqlconnection
scaffolding
0votes
0answers

Server to AWS RDS - No connection could be made because the target machine actively refused it

I'm moving a website from a dedicated server to AWS. First I want to transfer the database (sql server express). I've setup an AWS RDS Sql Express database - and can connect to it from my PC. However when I update the database connection string on my current server - [...] read more
.net
sql-server
amazon-web-services
amazon-ec2
iis-8
0votes
0answers

ASP.NET Exception Error From SQL Server Windows Authentication Login

I have read and tried all the suggestions from [ System.Data.SqlClient.SqlException: Login failed for user But none of those suggestions work. Thank you very much if you know why my setup have this error. From SQL Server Studio Management, I am able to login with no error to SQL Server [...] read more
c#
sql
windows-7
0votes
1answer

Entity Framework throws error: Invalid object name

I'm getting the following error with this sample I received, it looks correct by the manuals and docs I found. There are a lot of books I found here and all looks have the same pattern of code that looks like this one I received from a friend last week. [...] read more
c#
sql-server
entity-framework
0votes
0answers

membership.createuser method times out

I have a asp.net application hosted on an external server. I use .Net membership provider to create users for my website. It was working fine till last week and it throws time out elapsed exception now when membership.createuser() method is called.No code change was done on this. Any help as [...] read more
asp.net
0votes
1answer

.NET Core Invalid Object Name 'ApplicationUsers' When logging in

This is my login function: LoginViewModel lvm = new LoginViewModel { UserName = Input.UserName, Password = Input.Password, RememberMe = Input.RememberMe }; var valid = accountsData.Authenticate(lvm); if (valid != null) { var avm = applicationUsersData.GetByUsername(Input.UserName); var user = applicationUsersData.Get(avm.Id); var roles = userRolesData.GetUserRoles(user.Id); claims.Add(new Claim(ManagementStudio.ClassLibrary.Globals.CookieGlobals.UserName, user.UserName)); claims.Add(new Claim(ManagementStudio.ClassLibrary.Globals.CookieGlobals.Email, user.Email)); claims.Add(new Claim(ManagementStudio.ClassLibrary.Globals.CookieGlobals.PhoneNumber, [...] read more
c#
asp.net
.net
asp.net-mvc
asp.net-core
0votes
1answer

Only able to connect to a SQLServer Database using Integrated Security

I am trying to connect to a database with a Process account, but I am only able to connect using IntegratedSecurity. If I try to set it manually the application throws an error due to not being able to login with the user. I tried to run this code on [...] read more
c#
sql
sql-server
0votes
1answer

Connection problem when changing password

I have a software which displays some tables from our SQL database. Now I want to add a tool, where I can change the password for my "testdummy" user. I tried to open a connection again but it didn't help. If you need some additional code or informations, just write [...] read more
c#
0votes
3answers

Sometimes getting "A network-related or instance-specific error occurred while establishing a connection to SQL Server."

Every now and then I am getting > A network-related or instance-specific error occurred while establishing a connection to SQL Server. and in the details it says > SQL Server Express database file auto-creation error This error appears randomly. Sometimes when I go to another page it loads fine and [...] read more
asp.net
sql-server
asp.net-mvc-5
0votes
0answers

Why does my local SQL Express have to allow remote connections to use a local MDF?

When I set up my VB.net program to read from a local MDF database file (SQL), it tells me that I need remote connections. Details follow: I have a Visual Studio vb.net application. It needs a database, so I downloaded SQL Express and ran a script to add my database. [...] read more
sql-server
vb.net
connection-string
0votes
1answer

EF Core generates statement with invalid table name

I'm trying to get some values with Include and ThenInclude but EF Core generates a statement with an invalid tablename. This is my DataContext: public class BaseContext : BaseDbContext { protected BaseWebsiteContext(DbContextOptions dbContextOptions) : base(dbContextOptions) { } public DbSet<Image> Images { get; set; } public DbSet<Tag> Tags { get; set; [...] read more
c#
entity-framework-core
sqlexception
0votes
1answer

Entity Framework Core 2.1 System.Data.SqlClient.SqlException (0x80131904): Type Flag is not a defined system type

After upgrading to EntityFramework 2.1.11, I am facing the following issue. System.Data.SqlClient.SqlException (0x80131904): Type Flag is not a defined system type. I am getting this Error for Linq to SQL internal translation. There are two columns in database table which are of tinyint datatype which have corresponding C# datatype as [...] read more
entity-framework-core-2.1
entity-framework-core-migrations
0votes
2answers

Entity Framework migration error

I added a new table to my existing SQL Server database. I am using its generated id as the key. I ran dotnet ef migration add NewTable, which ran without errors. I reviewed the migration file and this is what was added for my new table: migrationBuilder.CreateTable( name: "InboxNotifications", columns: [...] read more
c#
asp.net
sql-server
entity-framework
0votes
1answer

Entity Framework insert conflicts with another foreign key

I am having difficulty inserting data with its related entities. public class Status : Entity, IAggregateRoot { //other properties public readonly List<Video> _videos; public readonly List<Photo> _photos; } -- public class Log : Entity, IAggregateRoot { //other properties public readonly List<Video> _videos; public readonly List<Photo> _photos; public readonly List<Sound> _audios; [...] read more
sql
.net
entity-framework
entity-framework-core
asp.net-core-2.0
0votes
1answer

The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction

I am getting the following error message randomly, whenever I am trying to execute the below stored procedure through the .net core application. Error Message: > System.Data.SqlClient.SqlException (0x80131904): The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction. Stored Procedure: ALTER [...] read more
azure
asp.net-core
stored-procedures
azure-sql-database
0votes
0answers

"DELETE statement conflicted with the REFERENCE constraint EF core" after SaveChanges()

I am using Entity Framework Core with .net core 2.2 and am encountering a strange intermittent issue. In my case I have these three tables with entities (simplified): Data Model: public class Case : BaseEntity { public int CaseId { get; set; } public Guid ClientId { get; set; } [...] read more
c#
asp.net-core
entity-framework-core
0votes
0answers

.Net Core Application connects to SQL server with wrong credentials

I am building a .Net Core (2.2, started as 2.1) application and I have been using a locally hosted database but as I continue I wanted to move to a database hosted on the server it will be located on in the future. The problem is I am not able [...] read more
c#
sql-server
.net-core
asp.net-core-2.2
0votes
1answer

Problem publishing ASP.NET application with a SQL Server database

I've created an ASP.NET website which runs perfectly from Visual Studio. It connects to a SQL Server .mdf database file in the App_Data folder. I published the project using FTP. The live website cannot however connect to the database, as it is LocalDB, and my host uses a SQL Server [...] read more
asp.net
sql-server
model-view-controller
0votes
1answer

Procedure or Function expects parameter which was not supplied even though it is supplied

Hello i cannot wrap my head around why i get the error saying that this SP expects @id which was not given when it is quite clearly given. this is how the code looks public Task<bool> InsertMessage(Message msg) { return CallDatabase(async (connection) => { var affectedows = await connection.ExecuteAsync( "messages_insert", [...] read more
stored-procedures
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

EFCore generating Column that is not valid

When i try to access the employees table for the Northwind database i get an invalid column name error, this column does not exist in the database and i am not sure how it is created or how to prevent it. i tried not to map the generated name but [...] read more
c#
.net-core
entity-framework-core
0votes
1answer

MySQL: Login Failed for User

I have tried to connect to my SQL database being hosted on Plesk with InterServer using C# ASP.NET MVC. Despite numerous efforts, it never seems to want to connect. What am I doing wrong? I've tried changing the connection string numerous times. Plesk and InterServer support ask me to deploy [...] read more
mysql
asp.net-mvc
database-connection
connection-string
plesk
0votes
0answers

Error while connecting to asp.net MSSQL database on godaddy server

I bought a windows "ultimate shared hosting" from godaddy. I've uploaded all the files that are required, the site works. When I created a database on myLittleAdmin and got the connection string from it. I put that connection string to my web.config file which is hosted on godaddy, but gives [...] read more
c#
asp.net
sql-server
shared-hosting
0votes
1answer

C# connected to SQL not returning a value

I connected to SQL Server with C#. Now, I have to do 3 options. One is to execute a procedure, which works perfectly, the second one is to retrieve some data, which is also done and the last option is to select a specific country, which is chosen by the [...] read more
c#
sql-server
connection
0votes
0answers

System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong

I am trying to modify a SQL Server table using Entity Framework model and I get this error: > Either the parameter @objname is ambiguous or the claimed @objtype (OBJECT) is wrong How can I solve this issue? I used below commands to do that. Add-Migration "comments", Update-Database PM> Update-Database [...] read more
c#
sql-server
entity-framework
0votes
0answers

Error while opening a winform : The target principal name is incorrect. Cannot generate SSPI context

I installed a Windows app on machine B. It's trying to connect to a SQL Server database on machine A using a static IP. (All SQL Server related configurations are done to make a remote connection) I cannot really figure out where to look for a problem. Please look at [...] read more
sql
sql-server
winforms
sql-server-2008
0votes
0answers

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired with Error Number:-2

I have a C# .NET 4.7.2 application that connects to SQL Server 2014. One of the stored procedures called from the application runs into following error: xyzStoredProcedure: Exception encountered. System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. [...] read more
c#
.net
sql-server
sqlclient
0votes
1answer

Connect to local SQL Server from .NET Core app running in docker

I have .NET Core console app running in docker and I want to connect to local MSSQL database (not dockerized!), but I'm unable to do so. Connecting to DB on remote server by IP works fine, but using connection string like Data Source=DESKTOP-9DRU731;Initial Catalog=DB;User id=user;password=password; gives me an error System.Data.SqlClient.SqlException [...] read more
docker
.net-core
docker-compose
dockerfile
0votes
1answer

Error while opening search result types in SharePoint 2013

I have a Search Service application and i want to customize how my search results look. I have a customized display template as well. But when i open my Search Result types i get an error saying Something went wrong.And also none of the managed properties can be seen. I [...] read more
sharepoint-2013
0votes
0answers

How to connect GCP App Engine to GCP Compute Engine SQL Server?

I'm setting up a new App Engine on my new GCP project but I can't seem to connect the NetCore app to a SQL instance on a Compute Engine. When I run the app from Azure or on my local pc with the same connection string it connects and everything [...] read more
sql-server
asp.net-core
error-handling
google-cloud-platform
timeout
0votes
0answers

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server

I'm connecting to a local version of the SQL database. I've created both entities and want to connect to them but when I try I've gotten a "Server Error in '/' Application," error. So far I've research the error and cannot tie down where to even begin looking. Line 23: [...] read more
model-view-controller
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
0answers

Using Custom Entities with OpenIddict

I'm trying to extend the entities used by OpenIddict based on the example provided here: https://github.com/openiddict/openiddict-core/issues/360#issuecomment-280268525 This includes creating entity classes extending those given by OpenIddict: public class CustomApplication : OpenIddictApplication<Guid, CustomAuthorization, CustomToken> { public string ImpersonateUser { get; set; } } public class CustomAuthorization : OpenIddictAuthorization<Guid, CustomApplication, CustomToken> { [...] read more
asp.net-core
entity-framework-core
openiddict
0votes
1answer

How to access SQL Server named instance remotely from web service using SQL Server authentication

I know this problem has been widely discussed, but after almost two days of research, I could not find a working solution yet. I have a SQL Server that hosts four instances of Versions 2012, 2014, 2016 and 2017, of which 2012 is the default instance. Everything works fine, as [...] read more
c#
sql-server
0votes
1answer

Failed executing DbCommand. .NET CORE

During creating my first page I noticed that I could not run .Net from cmd. I do not know what exactly is a problem. I am sending you a command lines. I checked some website's solutions. None from this solutions helped me. C:\Users\prywatny\Desktop\ProjektodZera\BigProject\BigProject>dotnet ef database update Done. C:\Users\prywatny\Desktop\ProjektodZera\BigProject\BigProject>dotnet run Używanie [...] read more
c#
sql
asp.net
entity-framework
0votes
2answers

How to fix System.Data.SqlClient.SqlException: 'Incorrect syntax near ''.'

im creating a website using asp.net in front end along with c#. I have two tables and im trying to update the columns of one table using the below query. however im getting the below error. Can anyone please help me resolving it. string sql = "UPDATE CurrentStudent SET CurrentStudent.DateOfJoining [...] read more
c#
asp.net
0votes
1answer

How do I allow a machine to connect to local SQL file

I'm currently working on an EPOS system for a friends shop, I'm currently getting him too test the features, making sure design etc is fine. I've set up the SQL Service Based Database, but the problem seems too be he is getting the error > System.Data.SqlClient.SqlException (0x80131904): A network-related or [...] read more
c#
sql-server
windows
visual-studio
0votes
0answers

MS-SQL communication in dotnet core under linux throwing errors

Im running on the default port 1433. when I execute a simple query against the DB all works well. but when I try to run a stored procedure .. like this: DataTable result = null; SqlCommand command = new SqlCommand(); command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = procedureNameWithDbVersionPrefix; command.CommandTimeout = m_nTimeout; foreach [...] read more
linux
.net-core
sqlclient
0votes
1answer

Database connection (Cannot open database "VRM" requested by the login.)

I'm getting Error when running my website on host. Unable to open database connection for the following application(s) .... Received exception. Message: Cannot open database "VRM" requested by the login. The login failed. Login failed for user Login failed for user 'IIS APPPOOL\DefaultAppPool'. Login failed for user 'IIS APPPOOL\DefaultAppPool'. Description: [...] read more
.net
sql-server
networking
0votes
4answers

Can't reach docker-hosted SQL server from web app docker on same host

On the same virutal machine (remote, ubuntu), I have * An SQL Server running in a Docker * An .NET Core 2.2 (IdentityServer) application running in a docker * An instance of jwilder.nginx-proxy serving as a reverse-proxy for every web application on the machine * A multitude of other .NET [...] read more
sql-server
docker
asp.net-core
0votes
0answers

Unable to access Azure DB from Azure VM if TransactionScope is used

I have .net 4.6.1 desktop application that migrates DB from 'old' version to the 'current' version. It works perfectly fine when I test it locally. But I need to deploy the DB on Azure SQL Server and then migrate the DB. I wanted to do that from Azure VM but [...] read more
c#
azure
azure-sql-database
azure-virtual-machine
0votes
0answers

DataService.GetConnectionString | System.Data.SqlClient.SqlException (0x80131904): MSDTC on server 'SERVER' is unavailable

I have written some insert queries those works fine when i try to use transactions i am getting the above exception. I tried to resolve using this link "MSDTC on server 'server is unavailable" but still not working. can some one help me out to reslove this. try { using [...] read more
c#
sqltransaction
0votes
1answer

EF Core There is already an object named 'AspNetRoles' in the database

I am receiving There is already an object named AspNetRoles in the database. error while attempting to use update-database command in NuGet console. Context: public class ApplicationDbContext : IdentityDbContext<IdentityUser> { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } public DbSet<Customer> Customers { get; set; } } Startup: public class Startup { [...] read more
c#
entity-framework
asp.net-core
entity-framework-core
asp.net-identity
0votes
1answer

Must declare the scalar variable "@PaperID"

<asp:SqlDataSource runat="server" ID="sdsFormViewPaper" ConnectionString="<%$ConnectionStrings:CPMS%>" OldValuesParameterFormatString="original_{0}" OnInserted="sdsFormViewPaper_Inserted" SelectCommand="SELECT * FROM Paper, Author WHERE Paper.AuthorID = Author.AuthorID ORDER BY PaperID;" InsertCommand="INSERT INTO Paper ( Active, FilenameOriginal, Filename, Title, Certification, NotesToReviewers, AnalysisOfAlgorithms, Applications, Architecture, ArtificialIntelligence, ComputerEngineering, Curriculum, DataStructures, Databases, DistanceLearning, DistributedSystems, EthicalSocietalIssues, FirstYearComputing, GenderIssues, GrantWriting, GraphicsImageProcessing, HumanComputerInteraction, LaboratoryEnvironments, Literacy, MathematicsInComputing, Multimedia, NetworkingDataCommunications, NonMajorCourses, [...] read more
sql
asp.net
sql-server
0votes
0answers

How to fix add-migration failing with transport-level error

When I try to add a string field to a domain object, and then I run add-migration, I get the following error: > PM> add-migration add-field-to-contact System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly [...] read more
c#
sql-server
entity-framework
0votes
0answers

System.Data.SqlClient.SqlException (0x80131904) - A Network relate...(Only on localhost)

I'm developing an application in ASP.NET Core 2.1, with Windows authentication for the first time. I've been working on my dev machine with a connection to a remote server hosting the SQL Server database for this application. Connection string is set in the appsettings.json file as follows: "DefaultConnection": "Server=V-APPSRV01;Database=devHub;Integrated Security=True;Trusted_Connection=True;MultipleActiveResultSets=true" [...] read more
c#
asp.net-core
sql-server-2012
iis-7.5
asp.net-core-2.1
0votes
0answers

TF246021: An error occurred while processing your request: SQL Server Error: 2627"

TFS returns exception during an API call when using: public TeamFoundationDataReader TrackMerges: > "TF246021: An error occurred while processing your request. Technical information (for administrator): SQL Server Error: 2627" Windows event log error: > Filing a WER application report for exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint []. Cannot [...] read more
sql
sql-server
tfs
0votes
3answers

Invalid SQL Server Connection String on Linux Entity Framework Core

I'm using Linux more specifically Xubuntu. I have installed SQL Server Express on my machine. I'm currently in the making of a web app and my connection does not seem working or I don't understand everything quite right? The output I get is : A network-related or instance-specific error occurred [...] read more
c#
linux
entity-framework
asp.net-core
entity-framework-core
0votes
0answers

My WEP API hosted in kubernetes pods are unable to communicate to external IP

I am not able to connect my on prem SQLSERVER database from the kubernetes pods.(Bare metal) logs: 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 SQL Server [...] read more
kubernetes
0votes
1answer

ExecuteNonQuery() from c# throwing exception - arithmetic overflow error converting numeric to data type numeric

I have a weird situation, I have a SP being called from my C# application through ADO.Net, the SP doesn't return any data. It is throwing the below exception, but when i execute the SP with the same parameters in SSMS it runs with out any issues. There is no [...] read more
c#
sql-server
ado.net
0votes
0answers

Entity Framework 6 Forces Distributed Transaction

I need to run custom sql script during the Entity Framework migration. Script: exec sp_executesql N'create view VIEW_TS_Shops as select * from openquery([TS-SQL], ''select * from Shops'')' Migration fails with error message: > System.Data.SqlClient.SqlException (0x80131904): The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "TS-SQL" [...] read more
sql-server
entity-framework
-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

Havingtrouble connecting to the database

System.Data.SqlClient.SqlException HResult=0x80131904 Message=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 SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not [...] read more
.net
sql-server
-1votes
2answers

The wait operation timed out Win32Exception (0x80004005): The wait operation timed out azure

Following error comes when retrieving large amount of data from sql azure. I have already implement the Transient Fault Handling but still getting this error 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 [...] read more
sql
azure-sql-database
azure-vpn
-1votes
1answer

Package Manager getting error Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

While i use update-database command in nuget package manager. getting "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." i check SQL Server configuration 2 check SSMS login Working properly For more details [...] read more
visual-studio-2017
nuget-package
package-managers
-1votes
0answers

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' in IIS

I've got my c# web app working on the local computer with IIS Express (Visual Studio), and have installed it on an IIS 2016 web server and I get this application error when I try to access the database: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' I am [...] read more
c#
sql-server
iis
-1votes
1answer

Executing stored procedure with input param in C#

I am having trouble executing a stored procedure supplying string value for a input param that is of type nvarchar(128). The param in question is 'username' . As per the proc definition is nvarchar(128) please look at screenshot#2. Below is my C# code where am setting the parameters if (StoredProcedureExists(auditStoredProc, [...] read more
c#
tsql
stored-procedures
-1votes
4answers

The column name 'phoneNumber' is specified more than once in the SET clause

I am creating for my student project, a coffee shop online. As it is a big file and, I am not sure which part anyone would need, here is a github link I have created a Registration form and I have created a order form. When I try to register, [...] read more
c#
asp.net-mvc
-2votes
0answers

Error while connecting page with SQL Server

I am trying to connect an ASP.NET page with a SQL Server database, but I get this error: > System.Data.SqlClient.SqlException HResult=0x80131904 Message=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 [...] read more
c#
asp.net
sql-server
-2votes
1answer

How to fix Incorrect syntax near the keyword "NOT" during Update-Database using Migration

I am new into software development. I am currently developing Asp.Net Core API. I have managed to do Add-migration successfully, the problem start when I need to Update-Database. The error is as follows System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'NOT'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException [...] read more
c#
asp.net
.net-core
asp.net-core-webapi
-2votes
1answer

How to debug a database error of "Incorrect syntax near the keyword X"?

I'm trying to count the number of user so that I can generate the unique id for new user. But the query which I have written shows some syntax error near User where User is my Table name. private int GenerateAutoId() { con.Open(); SqlCommand cmd = new SqlCommand("Select Count(*) from [...] read more
c#
sql-server
-3votes
1answer

System.Data.SqlClient.SqlException (0x80131904)) conversion data or time from character to string

I am trying to filter data between two dates; today 12:00 am to tonight at 12:00 pm. But I am getting this error: > System.Data.SqlClient.SqlException (0x80131904)) conversion data or time from character to string Code: DateTime today = DateTime.Today; string fileNameBase = today.ToString("dd-MMM-yyyy 12:00:00 AM"); ExportToExcel export = new ExportToExcel(); [...] read more
c#
sql-server

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