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.
4,804
questions
3
votes
1
answer
2k
views
Let's Encrypt certificate on SQL Server 2019 - "The target principal name is incorrect"
Summary
I'm having trouble getting a certificate issued by Let's Encrypt R3 to work on SQL Server 2019. When using the certificate for SSL but not trusting the server certificate explicitly (In SSMS, ...
- 31
1
vote
1
answer
124
views
Index rebuild of system-versioned table
Curious, if a table is system-versioned and an index needs to be reorganized/rebuilt, how will its history table affect this operation. Does the history table have to get checked/scanned during an ...
- 121
1
vote
1
answer
839
views
What is the difference between Mandatory and Strict modes in SQL Server 2022 encryption
It is possible to configure SQL Server encryption mode as Strict, rather than Mandatory.
Unlike other versions of SQL Server and ODBC drivers where you could only specify whether you want the ...
- 251
1
vote
0
answers
66
views
Unable to restore an MSSql Database from an Azure Storage backup
We have a simple sql script to restore an MSSql DB from an Azure storage blob. We backup our PROD DB to Azure Storage.
Trying to run this script (which we swear used to work a while ago).. now errors:
...
- 6,608
-1
votes
1
answer
163
views
Are the results from Microsoft SSRS in real-time from SQL Server?
From my understanding MS SSRS is a data warehouse product. Its data is only as new as the last refresh. However, 3rd party support insists that SSRS results are in real-time.
If I am using a SQL ...
- 193
2
votes
0
answers
63
views
Emptied SQL Server Database broke the Cube
We have a SQL Server hosting our Analysis Services and accessing data from the ERP system by a ETL process. It was some duplicates in the data and therefore the SQL Server database was emptied. After ...
- 71
-1
votes
1
answer
905
views
How to get an IP address for MS SQL Cluster network configuration?
I just started a new internship and have been tasked to set up a SQL failover cluster. They gave me 3 virtual machines to use and when I started I knew nothing. I've been doing a lot of research the ...
1
vote
1
answer
2k
views
Can no longer connect to server (an error occurred during the pre-login handshake)
Apologies if this isn't the place to ask this, or if it isn't enough information to go off of. I'm pretty new at this and don't know what or where else to ask.
Since two nights ago, nobody can connect ...
- 11
0
votes
0
answers
996
views
Ingesting SQL Server Logs into Azure Sentinel
I have been following the guide below and have set up the auditing from the two SQL server boxes. I don't understand how to do the Sentinel part as our Sentinel doesn't have the options shown in the ...
- 615
0
votes
3
answers
658
views
Before-snapshot script hook for Windows guest on Proxmox?
I have a Proxmox server setup with a Windows 10 guest that will be running MSSQL Express. The Windows guest has QEMU guest agent installed and working. For backups, I have a separate server running ...
- 121
0
votes
2
answers
667
views
Solution for Web app hang or stack due to high traffic
I have a web app deployed in IIS on Windows Server 2016. It uses a SQL Server 2016 database. Currently, it has heavy traffic. When it reaches its limit (don't know what the limit is) web app stack, ...
- 9
0
votes
2
answers
6k
views
Installing sql server drivers for php on ubuntu
Background
I have an ubuntu server running laravel that needs to connect to a different server of ours running mssql.
Linux server:
Ubuntu 20.04
php 8.1
I created a laravel test query to help me ...
- 103
1
vote
1
answer
5k
views
Can't find NT SERVICE\MSSQLSERVER to give it Read privs on a cert
I've got SQL Server 2016 happily running under the default account NT SERVICE\MSSQLSERVER. Now, though, I need to give that pseudo-account read priv on a newly installed SSL Certificate.
The pseudo-...
- 223
0
votes
3
answers
2k
views
"Unknown token received from SQL Server" errors since recent Windows Updates
I posted a question to Stack Overflow about this error when it started occurring for our older Delphi 7 applications on Windows 10.
It is now happening on Windows Server 2012 R2 systems that had these ...
- 101
0
votes
1
answer
169
views
SQL Server - Windows Active Directory users
I am actually using SQL server for my application. If I work with one user (Install and Update app with WIX installer) everything works good, but if I try to change me windows user account to the ...
0
votes
3
answers
365
views
Is there a benefit to running my File Sharing server on the physical server and my SQL server on a virtual machine?
I've never heard of anyone running one server on the original instance of Windows Server on the physical machine, and then running a second server on a Virtual Machine, so I can't find any info on ...
0
votes
1
answer
269
views
Alter Database recovery model & Shrink log, DB dynamically
I normally do on daily basis these operations in GUI
Alter database to simple recovery model
shrink log file
shrink database file
Alter database to full recovery model
I can understand script but ...
-1
votes
1
answer
619
views
Trying to access sql server publicly on Ubuntu 22.04 in Docker
SOLUTION: Need to forward the port you set up when creating the image, mine was the default 1433, sending your IP address, the same you might SSH. See my answer for more info and links if you are ...
- 31
0
votes
1
answer
1k
views
how many nodes can we add to windows failover clustering
In Availability group, for windows server 2012 only 4 replicas supported
from windows server 2016 8 replicas supported
Just like that how many nodes can add into our windows failover clustering?
...
2
votes
1
answer
1k
views
How to tell what is accessing my Azure SQL Server?
I have a legacy Azure SQL Server that I want to decommission but we have a LOT of legacy systems that no one knows about.
I want to confirm what accesses this server and/or its databases.
It doesn't ...
- 165
0
votes
3
answers
3k
views
How to test Windows Service Account can login to SQL Server database?
How to test that a Windows AD service account has been granted access to read from a SQL Server database server via Windows Authentication ?
This would need be an isolated test independent of any ...
- 207
0
votes
1
answer
55
views
Connecting to SQL server on a virtual machine is more computationally expensive than a dedicated SQL instance?
I have two options:
I can connect my web app to a SQL server hosted on a virtual machine, or I can connect it to a dedicated SQL server instance. All will be hosted in the same zones in Azure / AWS e....
- 123
0
votes
1
answer
71
views
Sharing a SQL Server between two locations -- best solution? [duplicate]
We're looking at opening a second facility which will have its own internal network for workstations and file sharing, but will need to access our central database server. Existing capacity on our ...
- 146
8
votes
2
answers
2k
views
What are the pros and cons of using a separate SQL server?
I've been running a Debian server since 2018 and recently I've noticed that it's functions have been expanded to the point that it's become quite "monolithic".
This server runs an instance ...
- 111
0
votes
1
answer
419
views
Windows defender ransomware protection and SQL Server
Our small company has organized several levels of virus protection for Windows servers, but there are always fears that this is not enough.
Is it correct to configure Windows Defender Ransomware ...
- 101
0
votes
1
answer
2k
views
How to get name of BUILTIN\Users & BUILTIN\Power Users
Is there a universal way to get the principals BUILTIN\Users or BUILTIN\Power Users (specifically retrieve the name)
The obvious answer would be that I already have the names! However, they are called ...
- 121
0
votes
1
answer
113
views
Can't print or preview Crystal reports when an old server gets turned off
We have a piece of ERP software installed on a server 2012 machine, we'll call this Server 1. It hosts the ERP software and a number of other things.
We have an old, semi-retired server that I will ...
- 9
1
vote
0
answers
739
views
AWS: Unable to drop MSSQL RDS database
We have an RDS MSSQL instance, configured as Multi-AZ.
I created a test DB, "Moose" on RDS.
After 5-10 minutes, it shows "(Principal, Synchronized)" in SSMS
<= So far, so good.
...
- 270
-1
votes
1
answer
685
views
Azure Security Alert - Login from an unusual data center
Azure Security Center generates an alert for a SQL Database that someone authenticated from an "unusual datacenter". Provided IP is Microsoft owned. Hostname is nothing recognizable.
- 159
0
votes
1
answer
712
views
Azure sql server read only replica
we have a database which is a SQL server PaaS offering, I would like to create a read only replica database which has a dedicated server behind it. The reason behind this is that I do not want to use ...
- 101
0
votes
1
answer
810
views
Using variables from task in following loop task
I want to deploy some stored procedures across multiple MSSQL instances on multiple server.
In my playbook I have a task which gathers all the instances on a server which I use in the following tasks ...
- 854
0
votes
0
answers
350
views
SQL Always On Failover Cluster Issues
We have created an Always on SQL Failover Cluster. There are 4 servers in the cluster, 2 on one subnet and 2 on another.
FAILOVER CLUSTER (172.16.82.22 OR 172.16.92.22)
SQL AVAILABILITY GROUP
LISTENER ...
0
votes
0
answers
200
views
Verify/checksum of MS-SQL backup doesn't work (as I expected)
When doing MS-SQL backup of a database you can choose these two options in SSMS:
But if I afterward change a bit in the backup-file (.bak) and do a restore or Verify Backup Media the database is ...
- 383
0
votes
0
answers
51
views
Reinstalling server and SQL Server database
Due to some Windows issue, can't clean-up the WinSxS folder and the Disk Space process (cleanmgr.exe) makes the CPU going to 100% meaning that I am at 97% of disk usage, I am planning to reinstall the ...
- 123
1
vote
2
answers
243
views
MS SQL maintenance plan not running if server is off
I am maintaining an MS SQL 15.0 (2019) server, and part of that includes a nightly backup of the databases. I have a Maintenance Plan that is run by the SQL server agent just after midnight each ...
- 343
2
votes
2
answers
6k
views
SQLCMD command works but ODBC does not
I'm trying to connect to a MS SQL server from a Linux machine, but can't get ODBC to work.
The following command works and I get a shell:
sqlcmd -S tcp:<servername>,<dynamic port> -U <...
- 65
4
votes
2
answers
20k
views
"context deadline exceeded" error on pod in Kubernetes while pulling a public image of ms sql server
Following Les Jackson's tutorial on microservices, on local installation of Docker with Kubernetes enabled, I wanted to create a new pod in Kubernetes that would contain an image of ms sql server ...
- 71
0
votes
1
answer
531
views
How to setup an Azure Windows VM for multiple users to RDP to their unique MS Access file?
I have 2 Azure VMs. One will act as an application server. The application is an Access file. This Access file connects to a separate Microsoft SQL Server database on a different Azure VM which will ...
1
vote
2
answers
451
views
Connect Access 2016 to remote SQL Server - SQL Server Error 17
Good morning,
I am trying to connect to a SQL server from a remote machine, with ACCESS 2016, using the "External data" option. Both are on the same network.
It is important to note that I ...
- 125
1
vote
0
answers
299
views
SQL Server on Linux "Verify that the certificate file(s) are of a supported format."
I'm running SQL Server on Linux (CentOS 8)
Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64)
I'm trying to setup TLS certificates for incoming connections and followed these ...
- 933
0
votes
2
answers
3k
views
How to backup MSSQL to NAS storage with local credentials
I have Synology NAS with local credentials authentication. How can I create a backup from MSSQL to such share? My only option is to authenticate with username/password combo since the Synology UI does ...
- 103
0
votes
1
answer
515
views
SQL Server JDBC Drivers installation on JBoss EAP 7.3
are the commands below correct? if no what is the correct way to install the module properly
module add --name=com.mssql--resources=[PATH] --dependencies=javax.api,javax.transaction.api
/subsystem=...
- 11
1
vote
1
answer
2k
views
OpsMgr SDK Service Event ID 26219 - SCOM 2022
Every 5 minutes, the following log generates twice in the Operations Manager logs on the Management Server. It's definitely related to the reporting services. I uninstalled the reporting services ...
- 192
0
votes
0
answers
2k
views
Swap memory 95% on SQL server running on Windows Server
I had an interesting situation the other day where a customer's SQL server was at 95% swap memory utilisation. This occurred on a Windows server running SQL Server.
The customer has 64GB RAM, and the ...
- 239
1
vote
0
answers
1k
views
MS SQL Always-On Listener DNS entry lost in domain due to scavenging - should this be expected?
When running MS SQL with an Always-On group / listener, is it expected that the always-on listener DNS entry be kept active in the domain's DNS? When the listener was created, a DNS entry was added to ...
- 221
0
votes
1
answer
507
views
Can I use an UNC path on remote MSSQL server in a store procedure to access remote file?
I have a store procedure on a remote MSSQL server. It has bulk insert from a file.That file is on another server. The file is shared on Ubuntu via Samba.
Can that store procedure access my file? What ...
- 101
0
votes
0
answers
227
views
error 17054 severity 16 state 1 sql server 2014 enterprise edition
Our new database is just inaccessible.
I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL ...
- 1
1
vote
1
answer
388
views
Ansible task for updating/cleaning up dbatools failing
I keep the Installation of the dbatools.io PowerShell module updated on my MSSQL Servers with a simple Ansible playbook which includes the following task:
#################### UPDATE DBATOOLS #########...
- 854
0
votes
1
answer
182
views
MSSQL reportserver behind web application firewall
Good Morning everyone!
First, please just point me in direction, where can I look into documentation.
I should get a consultant, but as a DBA, I want to solve this issue by myself.
Issue:
Management ...
- 1
0
votes
0
answers
27
views
how to install a software with sql database in a domain with different windows clients on windows 2016 server
I have a domain (Windows 2016) and 4 clients (Windows) attached to it. Now I need a software which hase inbuilt mysql server. How do I install that software so that the software will be accessed from ...
- 101