Questions tagged [sql-server]
Questions related to Microsoft SQL Server 2016 through 2022. Questions for older versions are off topic. If your question is version specific please tag it specifically for that version. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.
4,842 questions
-1 votes
0 answers
31 views
SQL Server won’t recover after system CPU spike
I have an ASP.NET application using SQL Server 2022 hosted in IIS on a VPS running Windows Server 2016. The problem is that the app sometimes stops responding to web requests, and the system log fills ...
- 99
6 votes
1 answer
682 views
sqlservr.exe writing to System Volume Information folder
Our Microsoft SQL Server sometimes has performance issues due to extensive I/O being triggered. We may have insufficient (in terms of performance) storage, but I noticed that during this behavior ...
- 163
2 votes
1 answer
152 views
How Does my WIndows Cluster Computer Object have permission to Create other AD Computers
I have a SQL Server Availability group which sits atop of a WSFC on a Windows Domain. There are two nodes in the cluster, both of which are SQL Server availability group replicas My SQL Server ...
- 145
0 votes
1 answer
166 views
MS SQL Server login failed
I installed MS SQL Server on a Google Compute VM using standard image. I can connect to the VM via RDP. I open Microsoft SQL Server Management Studio and can see the database instance running. When I ...
- 1
0 votes
1 answer
219 views
PHP-fpm (v 8.3) not using sqlsrv or pdo_sqlsrv on Ubuntu 24.04
My VM running Ubuntu 24.04 is giving an error that it cannot find the driver for SQLServer (aka MSSQL-Server aka sqlsrv). Sure enough, a page with phpinfo(); shows no sqlsrv or pdo_sqlsrv. Here were ...
1 vote
2 answers
231 views
Azure "Run Command Script" Invoke SQL on new SQL Server VM using "NT AUTHORITY\SYSTEM"
I deploy SQL Server 2022 Azure VM's on a regular basis. I want them to be pre-configured with a series of company standards (the details are not that important just know that this involves restoring ...
- 235
3 votes
1 answer
231 views
How to fix Powershell script when it says "mdf, ndf and ldf already exist"
I have a PowerShell script producing the error below: Set-DbatoolsInsecureConnection -SessionOnly Get-ChildItem "F:\WH_BEE\FULL\WH_BEE_FULL_$(Get-Date -Format "yyyyMMdd")_*.bak" | ...
- 131
0 votes
0 answers
81 views
How to mount(/bind) a host folder for the database files for a Docker-ized SQL Server Express instance?
I'm executing the following command line on MS Windows 11: docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Pass@word" -e "MSSQL_PID=Express" -p 1433:1433 --...
- 101
0 votes
1 answer
89 views
Power BI Report Server Database Login Password Change Issue
Facing an issue while attempting to change the database login password for Power BI Report Server. After updating the password in the database and in the Report Configuration Manager, the following ...
-1 votes
1 answer
109 views
Can SSMS 21 run on VMware Fusion running on Apple Silicon?
I was able to install it without errors, but then when I launch the app from taskbar or start menu, nothing happens. I can still launch the older version SSMS 20 in VMware fusion just fine. I've tried ...
- 36
0 votes
1 answer
114 views
How do I save credentials for a server with a backslash (\) in Windows Credential Manager?
I connect to an SQL Server instance with SQL Server Management Studio (SMSS) where the server name that includes a back slash to designate the instance, (eg: DevServer.Company\Frontend). I ...
- 135
1 vote
0 answers
299 views
Installing Windows-Internal-Database on a Windows Server 2025 with an SSD where driver defaults are a mixed 4K/8K sector size
My original problem was as follows: Environment Requirements: Windows server 2025. HP ProLiant DL360 Gen10 Server with SSD or NVme C drive. I have two SCSI SSD inserted in a 2.5" drive slot. ...
- 21
0 votes
2 answers
143 views
Powershell Invoke-Sqlcmd Issue - DB in Single User Mode but can't restore DB
I've been trying to figure out what's going on and I'm at a loss. Hoping someone can help! I have an Azure Pipeline that's using a self-hosted agent. The overall goal is to be able to restore SQL ...
- 11
0 votes
0 answers
106 views
How to find out the free space available in my mapped drive in Azure for my SQL Server backups?
I backup my SQL Server to an Azure location. The way I do this is by mapping the Azure location as a drive in SQL Server and then direct my backups to that location. When I run the following script I ...
0 votes
1 answer
211 views
After a database restore, SQL server 2022 instance refuses to accept commands from sqlcmd
Context I have a powershell script that performs some setup for an application in a test environment. Among other things, the script calls sqlcmd several times. A few days ago, I performed a restore ...
- 101