Questions tagged [sql-server]
Questions related to Microsoft SQL Server 2019 and 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,821
questions
0
votes
1
answer
47
views
Uneven CPU usage on VM with MS SQL Server
Greetings and salutations,
I would like to ask you for help with a curious situation what definitely caught my attention. We bought new hypervisor servers with two AMD EPYC 9174F processors (16 cores, ...
0
votes
0
answers
30
views
MSSQL Restore command taking over the terminal for 10 minutes
I run MSSQL as a statefulset on Kubernetes (I use the official docker image)
I wrote a startup script that should restore $n backups on $n databases.
my problem is: first database gets restored ...
0
votes
0
answers
30
views
Azure VM not receiving data from Externally Hosted SQL Server
I have an Azure VM that hosts a PHP web application and a MySQL server.
One of the processes required is to retrieve data from a third-party instance of MS SQL Server. To facilitate this, I have ...
0
votes
0
answers
48
views
What is the default Azure SQL connection pool size?
Our SQL client hit this exception:
Microsoft.Data.SqlClient.SqlException: Resource ID : 1. The request limit for the database is 200 and has been reached. See 'https://docs.microsoft.com/azure/azure-...
0
votes
1
answer
103
views
After updating PHP version from 8.2.6 to 8.2.20, I get error about an invalid attribute on a PDO object
I needed to update the PHP version from 8.2.6 to 8.2.20 for the security update.
I am using IIS 10. The only thing I did was to replace the php directory at C:/php with the new version of php.
I also ...
0
votes
0
answers
93
views
Significant slowness due to server when starting an ASP.NET MVC application
I have two dedicated servers with a hosting provider for shared hosting of websites using IIS (SQL Server + IIS, applications in ASP.NET MVC). Both servers have the same hardware configuration and are ...
0
votes
2
answers
105
views
Connect our SQL Server to a remote SQL Server
I would like to have my SQL Server connect (read-only) to a SQL Server at one of our vendors, pull data from it and populate a table on my SQL Server every 15 minutes. Is this possible? I have web-...
0
votes
1
answer
103
views
AWS Windows Server 2022 with SQL Server, license for Reporting Services?
My client's SQL Server Reporting Services (SSRS) stopped working on their AWS instance of Windows Server 2022 with SQL Server. The SQL Server included with this instance is the Standard edition, which ...
1
vote
1
answer
57
views
Can I view SQL Server encryption certificate remotely [duplicate]
The SQL Server connection encryption certificate expired on Friday. I don't have console access to the SQL Server. I sent instructions to a sysadmin on how to install the new cert through SQL Server ...
1
vote
1
answer
66
views
Can I use Kerberos to connect from Linux to other domain?
I'm trying to connect from a Linux machine to SQL Server with a domain user.
I've found some solutions for doing it from Windows on another domain. For example this one
When the Linux is in the domain ...
0
votes
1
answer
19
views
Is there a way to change the location of a trigger for a specific table in ssms?
By default when we create a trigger is located under the associated table in a foler called Triggers , I need to change this location? Is it Possible ?
0
votes
0
answers
78
views
Open Ports for SQL Server 2022 Installation
When installing SQL Server 2022, I get a warning message saying "make sure the appropriate ports are open."
I read the Microsoft documentation then created a PowerShell script to open the ...
0
votes
0
answers
88
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 ...
0
votes
0
answers
74
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 ...
0
votes
1
answer
107
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 ...