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,764
questions
0
votes
0
answers
37
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 ...
- 229
1
vote
0
answers
14
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,458
-1
votes
0
answers
10
views
Mssql 2012 replication recovery after slave offline
We have a single database replicated to a secondary server, and I need to bring down the secondary server to extend it's C: drive (non-data drive). Do we need to tear down replication entirely, or ...
- 165
-1
votes
1
answer
26
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
56
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
111
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
250
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
104
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 ...
- 575
0
votes
3
answers
163
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 ...
- 109
0
votes
2
answers
88
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
1
answer
1k
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
782
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-...
- 221
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
38
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
35
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
56
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
281
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 ...
- 1
0
votes
1
answer
376
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?
...
1
vote
1
answer
79
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 ...
- 145
0
votes
3
answers
584
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 ...
- 201
0
votes
1
answer
38
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
45
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 ...
- 147
0
votes
0
answers
11
views
Can I manually move MSSQL database files to a clone of the same system?
I have a botched disk clone operation at hand. Apparently, the machine can't start dues to BCD error.
As I have backup of the full system, I was wondering could I restore the image of the system anew ...
- 362
8
votes
2
answers
1k
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 ...
0
votes
1
answer
156
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
431
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
41
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
249
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
176
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.
- 149
0
votes
1
answer
250
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
341
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 ...
- 734
0
votes
0
answers
127
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
50
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 ...
- 334
0
votes
0
answers
39
views
What will happen if I start more than 10 RDS native backups at once?
I want to create a SQL Agent job in an RDS MSSQL instance to back up all user databases whose names match a pattern. I have written this code:
declare @TimeStamp nvarchar(10) = convert(nvarchar(10), ...
- 305
0
votes
0
answers
41
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 ...
- 113
1
vote
2
answers
139
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
2k
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 <...
- 55
3
votes
2
answers
9k
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 ...
- 51
0
votes
0
answers
373
views
MSSQL: Service is unavailable
I'm whipping up a demo of Zabbix in our environment and have some trouble monitoring a SQL server.
The error: 'MSSQL: Service is unavailable' > 'The TCP port of the MS SQL Server service is ...
- 55
0
votes
1
answer
157
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
128
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
0
votes
0
answers
81
views
Recomendation sample size for statistics sql server?
There are any recommendation for sample size for query "update statistics table"? Is default table sample size always ok? How to detect the cases when the default sample size does not work ...
0
votes
0
answers
30
views
SQL Server - Peer to Peer Transactional Replication not available on Linux, why? Any alternatives?
As written on the following page: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-replication?view=sql-server-ver16, Peer-to-Peer replication is not available on Linux, anyone knows why?
...
1
vote
0
answers
141
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 ...
- 891
0
votes
2
answers
1k
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
0
answers
12
views
Restrict WFCS Cluster Shared Resource to certain nodes
I have 2 CSV resources on a single WFCS cluster that spans to both Primary and DR data centers. The CSV is getting shared with all the nodes in the cluster. Ideally, I want the Primary CSV should be ...
- 113
0
votes
1
answer
228
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
477
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 ...
- 182
0
votes
0
answers
762
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 ...
- 209
0
votes
0
answers
26
views
Need advice on SQL Server architecture/approach for higher-ed classroom usage with large number of DB creators
I'm a sysadmin at a university. One of our College of Business programs is changing their curriculum. They are going to be teaching a database course this coming fall that potentially has 120 students....
- 236