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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
26 views

sql server max memory change event viewer log

In the Windows Event Viewer application, I see a record that the maximum memory value of SQL Server is reduced by 99%. After this process, we could not access the database from anywhere. How can we ...
Kadir Çolak's user avatar
0 votes
0 answers
43 views

How to create a Service Principal Name (SPN) for an AWS RDS-managed SQL Server instance computer object in AD?

We are using AWS RDS for SQL Server, an AWS managed service. We joined our RDS to our self-managed AD: We found the Active Directory Service Principal Name (SPN) for the RDS-managed-service database ...
Federico Navarrete's user avatar
0 votes
1 answer
29 views

SQL Agent Failing Backup using Domain Account

Good Day, I am hoping you can help with a frustrating issue i have encountered. We have recently setup a domain joined SQL 2022 Cluster using HYPER-V failover. All is working well with the databases ...
Chayne's user avatar
  • 1
0 votes
1 answer
21 views

How do I create a new login on an Azure SQL Database?

I'm trying to install SonarQube on Azure, using an Azure SQL Database, which is a serverless database. Instructions I have found advise me to run these commands from the query editor: -- On master ...
ProfK's user avatar
  • 493
0 votes
1 answer
74 views

Insufficient disk space when restoring or resizing db on SQL Server 2019 dev ed

Strange problem: I'm trying to restore AdventureWorks2019 from the downloaded backup file and constantly receive the error SQL Error [3257] [S0001]: There is insufficient free space on disk volume 'C:...
Mat's user avatar
  • 13
0 votes
3 answers
159 views

How do I get something like the INFORMATION_SCHEMA.COLUMNS metadata view of the INFORMATION_SCHEMA.COLUMNS view itself?

All columns of the INFORMATION_SCHEMA.COLUMNS view are listed at Learn -> SQL -> SQL Server -> COLUMNS (Transact-SQL):: COLUMN_NAME is of data type nvarchar(128): But there is no more ...
questionto42's user avatar
-2 votes
0 answers
42 views

TSQL query to get metadata statistics like granularity, number of rows, indexes, keys, sort of a broadened INFORMATION_SCHEMA.STATISTICS for TSQL [migrated]

The MySQL INFORMATION_SCHEMA.STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. This value is always def. TABLE_SCHEMA The name ...
questionto42's user avatar
0 votes
0 answers
13 views

Deployment Automation, Script incompatibility SSMS and sqlcmd

I need your experienced advice on automation. I am proficient in Linux, and we are attempting to automate the deployment of Microsoft SQL databases using sqlcmd. The problem arises when using SQL ...
Yousuf's user avatar
  • 37
0 votes
1 answer
69 views

Why does a DPM protection group configured for Sync work for some databases in simple recovery model but not others?

Using System Center Data Protection Manager 10.22.197.0 to back up SQL Server 2022 CU 10 on Windows Server 2022. DPM agent is also 10.22.197.0 on these SQL servers. The SQL Server instance was ...
M Herbener's user avatar
-1 votes
2 answers
162 views

SQL is not showing up when trying to connect to it via odbc from a client computer after migrating database to a new server

I installed SQL 2012 on a new Server 2022 vm and restored a database on the new server from a SQL generated backup. The new SQLserver/instance is not showing up in the Odbc client on a windows client. ...
Mark's user avatar
  • 79
0 votes
2 answers
171 views

How to assign IP address for MS SQL AG Listener?

Sorry folks this is maybe a stupid question but I'm struggling. All manuals like this just say "Click to add to add a static IP address to a selected subnet..." and nothing more. I don't ...
Niksr's user avatar
  • 121
0 votes
1 answer
33 views

MS SQL Server Analysis Server Powershell administrator entitlement

I am trying to programmatically add an administrator to the MS SQL Server Analysis Server Server Administrators via PowerShell. I can't seem to find a cmdlet or a reasonable method to do this after ...
rismoney's user avatar
  • 113
1 vote
1 answer
87 views

Command line option to uncheck Azure Extension during SQL Server 2022 setup

When installing SQL Server 2022 (16.x), is there a command line argument or configuration file option that can skip the Azure Extension for SQL Server step, or at least leave the Azure Extension for ...
Jim's user avatar
  • 651
0 votes
1 answer
151 views

SQL Server installation failing due to Software Restriction Policy - but no policy exists on server?

I am attempting to install SQL Server Express 2022 on Windows Server 2022. When I setup the Windows server, I added a Software Restriction Policy for preventing the installation of executables and msi ...
RazorKillBen's user avatar
0 votes
1 answer
45 views

MSSQL Background processes that won't go away

Even after rebooting, these processes persist. I need to disconnect all users from the DB to run some end-of-year processes, but these processes from sa won't go away, and I'm at wit's end trying to ...
LinuxGnut's user avatar
  • 217
0 votes
2 answers
446 views

SQL Server Services won't start and database engine can't be accessed

So my SQL server can't be connected to after the computer crashed while connecting to it over RDP. The MSSQLSERVER, UALSVC and MSSQL$SQLEXPRESS services are all set to automatic (the ualsvc is set to ...
tobymax's user avatar
0 votes
1 answer
35 views

SharePoint information hosted in SQL Server

So quick question, where in the SharePoint_Config DB would I expect to find the SharePoint server that is being used? SQL SharePoint Currently getting the "Could not connect to the configuration ...
Matt du Toit's user avatar
2 votes
0 answers
132 views

Repair-VirtualDisk remains in suspended

We erroneously added a P40 disk to our (marketplace) Azure Sql server / virtual machine. We tried removing it following the process described in following articales https://learn.microsoft.com/en-us/...
Reinard's user avatar
  • 223
0 votes
1 answer
89 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 (...
Felice Pollano's user avatar
0 votes
0 answers
201 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 ...
cladmin's user avatar
1 vote
2 answers
751 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 ...
user11665472's user avatar
-1 votes
2 answers
70 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 ...
Yousef Albakoush's user avatar
0 votes
1 answer
120 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 ...
Gbl's user avatar
  • 5
0 votes
1 answer
73 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 ...
Anuj Kadam's user avatar
0 votes
0 answers
392 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 ...
Clinemi's user avatar
  • 101
0 votes
2 answers
648 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 ...
Ben Rubin's user avatar
  • 101
0 votes
0 answers
181 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. ...
zu1b's user avatar
  • 121
0 votes
1 answer
65 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. ...
Jack Duece's user avatar
0 votes
0 answers
287 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 ...
user53815's user avatar
0 votes
0 answers
71 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 ...
TomS's user avatar
  • 185
0 votes
1 answer
130 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 ...
AndyD273's user avatar
  • 207
0 votes
0 answers
969 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] ...
Ainz Ooal Gown's user avatar
0 votes
2 answers
833 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 ...
JKith's user avatar
  • 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 ...
Philip Gierszal's user avatar
1 vote
0 answers
25 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? ...
Shahab Ali's user avatar
1 vote
1 answer
59 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 ...
Mighty's user avatar
  • 111
0 votes
1 answer
1k 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 ...
username's user avatar
  • 251
0 votes
0 answers
122 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 ...
Nick P's user avatar
  • 121
0 votes
1 answer
240 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 ...
James's user avatar
  • 101
0 votes
0 answers
45 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' ...
Laurens's user avatar
0 votes
0 answers
26 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-...
Alex Ilyin's user avatar
-1 votes
3 answers
344 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): ...
user11665472's user avatar
0 votes
0 answers
215 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 ...
Parkeralex's user avatar
1 vote
1 answer
258 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 ...
pithhelmet's user avatar
0 votes
0 answers
590 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 ...
bobbydinken's user avatar
2 votes
1 answer
140 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 ...
ZX Spectrum 48K's user avatar
0 votes
1 answer
344 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 ...
data princess's user avatar
0 votes
0 answers
2k 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 - ...
Shanebagel's user avatar
1 vote
2 answers
1k 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 ...
sprawdzone.it's user avatar
-1 votes
1 answer
62 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 ...
user1274113's user avatar

1
2 3 4 5
97