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,788
questions
0
votes
1
answer
47
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 (...
- 169
0
votes
0
answers
44
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 ...
- 1
0
votes
2
answers
186
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 ...
-1
votes
2
answers
60
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 ...
0
votes
1
answer
60
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 ...
- 5
0
votes
0
answers
21
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 ...
0
votes
0
answers
119
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 ...
- 101
0
votes
2
answers
169
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 ...
- 101
0
votes
0
answers
60
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. ...
- 121
0
votes
1
answer
45
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. ...
0
votes
0
answers
116
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 ...
- 63
0
votes
0
answers
39
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 ...
- 175
0
votes
1
answer
34
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 ...
- 207
0
votes
0
answers
587
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] ...
0
votes
1
answer
227
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 ...
- 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 ...
1
vote
0
answers
18
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? ...
- 11
1
vote
1
answer
50
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 ...
- 111
0
votes
0
answers
585
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 ...
- 249
0
votes
0
answers
78
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 ...
- 121
0
votes
1
answer
139
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 ...
- 101
0
votes
0
answers
37
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' ...
- 1
0
votes
0
answers
14
views
DataProtector backup session stucks in "Inactive/Waiting" status
DataProtector v. 11.01
Backup session stucks in "Inactive/Waiting" status. There are no requests detected on DB-server. On the other hand, other sessions (for another DB`s on the same DB-...
-1
votes
3
answers
182
views
how to design a sql query to have sub-columns in the result?
I tried several sql queries but it does not meet my expectations because in the result I cannot have sub-columns
i need to design a sql query for the following result (have sub-columns in the result):
...
0
votes
0
answers
117
views
What is the efficient way to copy large database from one server to another?
I have a SQL server's full database backup job that runs daily at night.
Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different ...
1
vote
1
answer
109
views
Failover Cluster Manager - Location of the stored clusters
I have about a dozen clusters that i monitor daily. I use the Failover Cluster Manager under MMC for a dashboard view of the clusters.
Two things i am looking for.
Where are the cluster names that ...
- 202
0
votes
0
answers
311
views
Error connecting to windows cluster
We currently have 6 MSSQL (SQL2016 Enterprise) servers running on Windows server 2016. We are running windows failover cluster and always on availability.
Last weekend we had an issue with the ...
2
votes
1
answer
93
views
SQL Server 2019, SQL Server Agent service doesn't auto-load - error 776, token supplied to function is invalid
I noticed after a recent update to Windows 2019, our lone server running Active Directory, that several related SQL Server services were no longer starting.
After researching each of those errors, I ...
0
votes
1
answer
173
views
How to change SQL Server sa password as part of ec2 userdata
I'm provisioning some development EC2 instances running Windows Server, with SQL Server installed. I use a custom Amazon Machine Image with the configuration we need, but as part of the provisioning ...
- 185
0
votes
0
answers
1k
views
Getting an error in SQL Server 2019: The certificate chain was issued by an authority that is not trusted
I've enabled "Encrypt connection"
I've enabled "Trust server certificate"
I've added the TrustServerCertificate=true to my connection string
I've confirmed the service is running - ...
1
vote
1
answer
729
views
How to setup Windows Remote Desktop Connection Broker HA with SQL Server Express?
I am preparing an environment in which Remote Desktop Connection Broker for which HA is to be based on SQL server (windows server standard 2022)
In my case, the SQL server is MS SQL Server Express ...
-1
votes
1
answer
42
views
Backup MSSQL database via disk (no SSMS no command line)
Our Windows server is having issues but before running disk repair, I want to take a backup. At the moment I'm using SystemRescure (the Linux utility) and I have successfully saved files.
The only ...
- 99
3
votes
1
answer
1k
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
67
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
323
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 ...
- 249
1
vote
0
answers
45
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,578
-1
votes
1
answer
91
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
62
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
571
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
1k
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
683
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 ...
- 605
0
votes
3
answers
532
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
420
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
5k
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
3k
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
95
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
201
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
211
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
525
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