Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
24 views

SQL Server not accessible from some network segments [closed]

Our office computers connected to the local network run erp apps that connect to a SQL Server. The problem is that not all computers can use apps. Instead they get an error where they can't start the ...
tabbora's user avatar
-1 votes
0 answers
107 views

Repairing SQL Server installation fails

I am installing a local instance of SQL Server. During setup the database engine fails. What others steps can make sure the installation succeeds? What I've tried: Installing two times. Repairing ...
guradio's user avatar
  • 139
-1 votes
0 answers
7 views

SQL Server 2022 express download error [migrated]

I was trying to download SQL Server 2022 Express in windows 11. I got this error. which is Exit code(Decimal): -2061893606. Then i checked log and saw SystemConfigurationCheck report. img below. This ...
mehmed aras's user avatar
0 votes
0 answers
73 views

Backups failing for VM running SQL database for Windows Server 2019 RDS License Service

We have a Windows Server 2019 VM's failing backup using Unitrends. After investigation, we found it is not a Unitrends issue, but an issue in the Guest preventing checkpoints from being created ...
Matty Brown's user avatar
-1 votes
0 answers
39 views

SQL database backup fails due to failing storage

We have a SQL Server using storage with bad blocks that is about to fail. We are unable to move the data or the SQL server due to the hardware problem. A backup script runs on the SQL Server which ...
Whitefire's user avatar
0 votes
0 answers
26 views

Created New MSSQL Instance, Can't Execute Commands

I created a new MSSQL instance following the steps from this video. My purpose is to teach my students how to attack an MSSQL instance from a Linux machine, however I cannot execute a single command ...
sunflower's user avatar
0 votes
0 answers
10 views

SQL Server 2019 failure due to transaction log is full [migrated]

The transaction log in our SQL Server log grew to the maximum size of 2 TB, even though the disk is 10 TB. The server is now generating 9002 errors. We tried to add another log file, however it failed ...
sandeep's user avatar
0 votes
1 answer
56 views

Determine who applied a CU patch

Have a possible user that is implementing the CU incorrectly (under the wrong login) I am Looking for a way to determine what account was used to install a CU update. Any suggestions would be ...
pithhelmet's user avatar
0 votes
2 answers
69 views

Configure data source in JBoss 7.4 with Microsoft SQL DB

I'm creating a data source in jboss with MS SQL DB. The required driver is loaded under the modules. Testing the connection fails. Connectivity is fine between machines. Connection url - jdbc:...
Vamshi Krishna's user avatar
0 votes
1 answer
40 views

No way to hide other databases from an SSMS user in Sql Server

This is a very long running issue for me. I have tried all the solutions. All I want is for customers to be able to use SSMS to connect via a read-only connection to their database so they can see ...
Luke's user avatar
  • 101
0 votes
0 answers
111 views

Preprocessing failed for performance counters zabbix, MSSQL server

I've connected my MSSQL server to zabbix via ODBC. I'm receiving results for some items but for other items errors are returned: Preprocessing failed for: [{"object_name":"SQLServer:...
Han's user avatar
  • 1
1 vote
1 answer
49 views

sql server max memory change event viewer log

In the Windows Event Viewer application, I see a record that the maximum memory value of SQL Server is reduced by 99%. After this process, we could not access the database from anywhere. How can we ...
Kadir Çolak's user avatar
0 votes
0 answers
128 views

How to create a Service Principal Name (SPN) for an AWS RDS-managed SQL Server instance computer object in AD?

We are using AWS RDS for SQL Server, an AWS managed service. We joined our RDS to our self-managed AD: We found the Active Directory Service Principal Name (SPN) for the RDS-managed-service database ...
Federico Navarrete's user avatar
0 votes
1 answer
51 views

SQL Agent Failing Backup using Domain Account

Good Day, I am hoping you can help with a frustrating issue i have encountered. We have recently setup a domain joined SQL 2022 Cluster using HYPER-V failover. All is working well with the databases ...
Chayne's user avatar
  • 1
0 votes
1 answer
25 views

How do I create a new login on an Azure SQL Database?

I'm trying to install SonarQube on Azure, using an Azure SQL Database, which is a serverless database. Instructions I have found advise me to run these commands from the query editor: -- On master ...
ProfK's user avatar
  • 493
0 votes
1 answer
128 views

Insufficient disk space when restoring or resizing db on SQL Server 2019 dev ed

Strange problem: I'm trying to restore AdventureWorks2019 from the downloaded backup file and constantly receive the error SQL Error [3257] [S0001]: There is insufficient free space on disk volume 'C:...
Mat's user avatar
  • 13
0 votes
3 answers
260 views

How do I get something like the INFORMATION_SCHEMA.COLUMNS metadata view of the INFORMATION_SCHEMA.COLUMNS view itself?

All columns of the INFORMATION_SCHEMA.COLUMNS view are listed at Learn -> SQL -> SQL Server -> COLUMNS (Transact-SQL):: COLUMN_NAME is of data type nvarchar(128): But there is no more ...
questionto42's user avatar
0 votes
0 answers
20 views

Deployment Automation, Script incompatibility SSMS and sqlcmd

I need your experienced advice on automation. I am proficient in Linux, and we are attempting to automate the deployment of Microsoft SQL databases using sqlcmd. The problem arises when using SQL ...
Yousuf's user avatar
  • 35
0 votes
1 answer
94 views

Why does a DPM protection group configured for Sync work for some databases in simple recovery model but not others?

Using System Center Data Protection Manager 10.22.197.0 to back up SQL Server 2022 CU 10 on Windows Server 2022. DPM agent is also 10.22.197.0 on these SQL servers. The SQL Server instance was ...
M Herbener's user avatar
-1 votes
2 answers
253 views

SQL is not showing up when trying to connect to it via odbc from a client computer after migrating database to a new server

I installed SQL 2012 on a new Server 2022 vm and restored a database on the new server from a SQL generated backup. The new SQLserver/instance is not showing up in the Odbc client on a windows client. ...
Mark's user avatar
  • 79
0 votes
2 answers
283 views

How to assign IP address for MS SQL AG Listener?

Sorry folks this is maybe a stupid question but I'm struggling. All manuals like this just say "Click to add to add a static IP address to a selected subnet..." and nothing more. I don't ...
Niksr's user avatar
  • 121
0 votes
1 answer
39 views

MS SQL Server Analysis Server Powershell administrator entitlement

I am trying to programmatically add an administrator to the MS SQL Server Analysis Server Server Administrators via PowerShell. I can't seem to find a cmdlet or a reasonable method to do this after ...
rismoney's user avatar
  • 113
2 votes
1 answer
160 views

Command line option to uncheck Azure Extension during SQL Server 2022 setup

When installing SQL Server 2022 (16.x), is there a command line argument or configuration file option that can skip the Azure Extension for SQL Server step, or at least leave the Azure Extension for ...
Jim's user avatar
  • 671
0 votes
1 answer
289 views

SQL Server installation failing due to Software Restriction Policy - but no policy exists on server?

I am attempting to install SQL Server Express 2022 on Windows Server 2022. When I setup the Windows server, I added a Software Restriction Policy for preventing the installation of executables and msi ...
RazorKillBen's user avatar
0 votes
1 answer
72 views

MSSQL Background processes that won't go away

Even after rebooting, these processes persist. I need to disconnect all users from the DB to run some end-of-year processes, but these processes from sa won't go away, and I'm at wit's end trying to ...
LinuxGnut's user avatar
  • 217
0 votes
2 answers
765 views

SQL Server Services won't start and database engine can't be accessed

So my SQL server can't be connected to after the computer crashed while connecting to it over RDP. The MSSQLSERVER, UALSVC and MSSQL$SQLEXPRESS services are all set to automatic (the ualsvc is set to ...
tobymax's user avatar
0 votes
1 answer
36 views

SharePoint information hosted in SQL Server

So quick question, where in the SharePoint_Config DB would I expect to find the SharePoint server that is being used? SQL SharePoint Currently getting the "Could not connect to the configuration ...
Matt du Toit's user avatar
2 votes
0 answers
156 views

Repair-VirtualDisk remains in suspended

We erroneously added a P40 disk to our (marketplace) Azure Sql server / virtual machine. We tried removing it following the process described in following articales https://learn.microsoft.com/en-us/...
Reinard's user avatar
  • 223
0 votes
1 answer
112 views

MSSQL database slow when move database on other disk

MSSQL Developer Edition, with many database online for test purposes. To better handle disk space, I moved some databases to another disk. Moved databases perform slower than the original location (...
Felice Pollano's user avatar
0 votes
0 answers
265 views

Can not connect to mssql server on Ubuntu using AD user account

I have installed a mssql-server (15.0.4335.1-6) on Ubuntu 20.04.6 LTS, following Microsoft Documentation Mssql-server is up and running and I can connect using the sa account. What I want to do, is to ...
cladmin's user avatar
1 vote
2 answers
1k views

How to solve the intermittent failed execution of SSIS package in debug mode

I created an SSIS package with Oracle data source and SQL Server destination ok. In fact through an SQL query I want to export data from an oracle table to an SQL server table. At this level ...
user11665472's user avatar
-1 votes
2 answers
83 views

How to Return the SQL_DB log files (.ldf) to the default Application

I have tried to open a "log" file of SQL DB with Windows Notepad application. Unfortunately, I forgot to remove the tick from the checkbox of “Always use the selected program to open this ...
Yousef Albakoush's user avatar
0 votes
1 answer
133 views

How to tell sqlsrv extension (php8.1-fpm) to accept self signed certificate?

I am currently encountering a problem on a Moodle server which uses an external MS SQL DB for its authentication and enrollments. During connection, an error occurs related to a self-signed ...
Gbl's user avatar
  • 5
0 votes
1 answer
109 views

How to create a VPC endpoint to access SQL DB hosted inside EC2 instance?

I have a lambda in VPC-1 trying to access a SQL database which is hosted inside an EC2 instance in VPC-2. How should I establish a connection between Lambda(VPC-1) and SQL DB (VPC-2) using VPC ...
Anuj Kadam's user avatar
0 votes
0 answers
448 views

SSIS package cannot see network drive

I have an SSIS package that cannot see a network folder (with files) - when run directly from SSMS. (Windows Server 2019, SQL Server 2019, Visual Studio 2019, SSMS versions 17 & 18). I am using a ...
Clinemi's user avatar
  • 101
0 votes
2 answers
1k views

Server's Disk Queue Length is high, but Disk Bytes/sec is lower than it's capable of

I have an environment running SQL Server on a Windows VMWare platform using a SAN with SSDs set up in RAID 6, and using Veeam for server backups and LiteSpeed for SQL Server backups. I've had a ...
Ben Rubin's user avatar
  • 101
0 votes
1 answer
235 views

Problems with SQL2022 always on alert 1480 on failover

We have a three node sql2022 cluster that is using the always on functionality. I have a need to start a job to perform some maintenance task when an instance fails over from one node to another. ...
zu1b's user avatar
  • 121
0 votes
1 answer
77 views

Server running MS SQL getting login request from another server every minute

I have a Windows Server 2016 virtual machine running IIS 10 and MS SQL Server 2016. Every minute I'm getting a "Login failed for user" message in the event log. Sometimes 3 times per minute. ...
Jack Duece's user avatar
0 votes
0 answers
333 views

SQL Server "Cannot generate SSPI context" possible root cause from domain account/permission?

I see the official document about troubleshooting the windows SQL login problem, as shown here. I'm administrating an environment of Windows server 2019 + SQL server 2019 and all the hosts are within ...
user53815's user avatar
0 votes
0 answers
76 views

Add ODBC driver for Office 365 (local install) in Windows Server 2016

For some ETL operations using Microsoft's SSIS system, we need to read data from an XLSX file accessible from the database server (Windows Server 2016, Microsoft SQL Server 2017 on prem). When ...
TomS's user avatar
  • 185
0 votes
1 answer
164 views

Full Text Index stuck

We recently upgraded our SQL Server database server. We have a search on our website that uses a full text index to search. I am now trying to figure out why the full text index appears to be stuck. I ...
AndyD273's user avatar
  • 207
0 votes
0 answers
1k views

[Microsoft][ODBC Driver 17 for SQL Server] SSL Provider: [error:0A000102:SSL routines::unsupported protocol] in PHP Laravel on macOS using Brew

I'm encountering an issue while trying to connect to a SQL Server database using PHP Laravel on macOS with Brew. I'm receiving the following error message: [Microsoft][ODBC Driver 17 for SQL Server] ...
Ainz Ooal Gown's user avatar
0 votes
2 answers
1k views

System.EnterpriseServices Error when trying to connect Excel or PowerBI to a SQL Server

I just setup a new SQL server and am trying to connect Excel and PowerBI to it. I'm getting an error that says the following: Unable to connect Details: "An error happened while reading data from ...
JKith's user avatar
  • 1
0 votes
1 answer
55 views

Creating a low-cost and scalable star network infrastructure

I am tasked with creating the architecture for an integration application for 2 systems. I will be running a Ubuntu LTS instance, with an application that requires to connect to our clients MSSQL ...
Philip Gierszal's user avatar
1 vote
0 answers
28 views

Fortify Software Security Center Database (HA) Issue

We have deployed Fortify Software Security Center in an environment with configured MSSQL ssc_db. How would I configure the High Availability Database configuration in Fortify SSC if possible? ...
Shahab Ali's user avatar
1 vote
1 answer
62 views

SQL Server Management Studio 2019 save to CSV and then import it after test

I'm fairly new to SQL, and I'd like to do some quick testing. I'm about to update a field in 81 records in a table. After each test, I'd like to get back where I started. I've saved off my query ...
Mighty's user avatar
  • 111
0 votes
1 answer
1k views

Cannot start SQL Server 2022 on a system with TLS 1.3 only

From documentation it seems that SQL Server 2022 should support TLS 1.3: SQL Server 2022 (16.x) supports Transport Layer Security (TLS) 1.3 when TDS 8.0 is used. link However, when I try to start a ...
username's user avatar
  • 251
0 votes
0 answers
138 views

Cannot import bacpac from blob storage

I'm unable to import a data tier application (BACPAC) via SSMS from Azure storage on my PC. It works with the same account on multiple other PCs, the only difference is that that runs an older version ...
Nick P's user avatar
  • 121
0 votes
1 answer
269 views

Unable to install SQL Server 2019 because of the missing ODBC driver

I am unable to install Microsoft SQL Server 2019 Developer Edition because of a missing ODBC driver 2017 (screenshot attached) I already installed various version of the ODBC driver, already ran ...
James's user avatar
  • 101
0 votes
0 answers
50 views

Ghost Login failed for MSSQL Server

A bit in the background, I have two servers one is for the web application, and the other is a database server containing MSSQL. I keep getting the message 'Login failed for user 'NT AUTHORITY\SYSTEM' ...
Laurens's user avatar

1
2 3 4 5
97