SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 questions
1 answer
Unable to process the existing user settings and will overwrite the file with user settings from this session.
I have local install of sql server 2022, with Analysis server & MSRS features enabled, when I launch the management studio, I get the error message below, any suggestions on how to suppress the message ? Thanks Jay Unable to process the existing…
asked 2024-07-30T16:36:54.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 65%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay Tabatabai
20
Reputation points
commented 2024-09-19T03:46:10.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 25%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nick Christie
1
Reputation point
2 answers
Is my Resource Governor set up correctly?
Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…
asked 2024-09-18T18:01:13.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
chrisrdba
386
Reputation points
answered 2024-09-19T03:27:11.2633333+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
2 answers
PivotTable in Excel
Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…
asked 2021-05-03T21:26:19.957+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 30%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Samir abdelmalek
21
Reputation points
edited a comment 2024-09-19T02:30:33.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM0%3C/text%3E%3C/svg%3E)
MyName-0111
0
Reputation points
2 answers
How to make sql server backup files immutable
How to make sql server backup files immutable without using Azure Storage?
asked 2024-09-18T16:46:04.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dave Guo
0
Reputation points
answered 2024-09-19T02:01:03.6833333+00:00
LucyChenMSFT-4874
4,430
Reputation points
2 answers
Unable to connect SQL server to Power BI
Getting below error while connecting Sql to Power Bi We encountered an error while trying to connect. Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not…
asked 2024-09-18T11:26:34.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Sachin Yadav
0
Reputation points
answered 2024-09-19T01:26:24.8133333+00:00
LiHongMSFT-4306
26,791
Reputation points
0 answers
OLE DB provider "MSDASQL" for linked server Can't connect to MySQL server, connection issue
I have setup SQL Server 2014 linked server to connect to MySQL 8 instance and when I run a single openquery insert statement like below it works fine. However, when I run multiple insert statement to insert data to multiple tables like below openquery…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
818 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,957 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
741 questions
asked 2024-09-17T05:08:03.9866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
binrip
0
Reputation points
commented 2024-09-18T22:11:30.4466667+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee
1 answer
Azure SQL Database
Hello I have a question about something that is happening to me regarding access to SQL Databases When I give a group or a user, after creating the Login in the SQL Server, access to the databases that it contains within that same SQL Server, if I give…
asked 2024-09-18T18:06:43.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
160
Reputation points
commented 2024-09-18T21:01:11.85+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee
1 answer
The Test connection to the Linked Server failed.
Summary: We are using Windows 11 device "B" to connect to an instance "A" using SQL management Studio. It connects to "A" perfectly fine. Now, when we try to test connection with a Linked Server "C" created on…
asked 2024-01-23T16:36:00.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 32%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Singh, Mohanpreet
10
Reputation points
commented 2024-09-18T20:25:56.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Li, Hong (MOH)
0
Reputation points
2 answers
OAuth Authentication Fails for Azure SQL Server - Login Error for User
Description: I am trying to implement OAuth authentication for an Azure SQL Server database using the Go (go-mssqldb) driver. I have successfully retrieved the access token using the following credentials: Client ID Client Secret Tenant ID However,…
asked 2024-09-12T08:06:04.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 28.999999999999996%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rohini Prabhakar Gohate
0
Reputation points
commented 2024-09-18T19:36:26.48+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee
1 answer
What are best security best practices to connect AKS with SQL Server?
Hi, I have an AKS cluster on Azure and one of the pod is connecting to the SQL server, the SQL server is also being consumed by a function app. I dont want my SQL server to be exposed publicly, and I know private endpoint can be used between function app…
asked 2024-09-09T07:58:28.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 25%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENU%3C/text%3E%3C/svg%3E)
Najam ul Saqib
280
Reputation points
commented 2024-09-18T18:30:27.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
150
Reputation points Microsoft Vendor
0 answers
How to fix error Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host?
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host, I need to get data from microsoft project on line to moicrosoft SQL database
asked 2024-06-03T11:52:47.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 9%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mostafa Elframawy
0
Reputation points
commented 2024-09-18T14:57:04.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 1%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sai Kiran Bandi (LTIMINDTREE LIMITED)
0
Reputation points Microsoft Vendor
2 answers
Cannot open database requested by the login - "Error Number:4060,State:1,Class:11"
I have an ASP.NET app, and when I launch the app and try to list items from a table by accessing the corresponding route, I get this error: SqlException: Cannot open database "appointments" requested by the login. The login failed. Login failed…
asked 2024-09-13T18:52:54.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 88%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Juan Jose Herrera
0
Reputation points
commented 2024-09-18T10:05:57.8833333+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
2 answers
SQL Replication issues
Can anyone please suggest me, how to resolve below replication please <stats state="2" fetch="105" wait="7474" cmds="1842373" <stats state="2" fetch="105" wait="7474"…
asked 2024-09-17T21:48:25.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 83%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aella, Sreenivas
0
Reputation points
answered 2024-09-18T09:50:56.0333333+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
3 answers
One of the answers was accepted by the question author.
Windows 11 22h2 update breaking connections to legacy SQL Servers?
We've got a legacy SQL server (2008 R2 SP3) running in our environment right now (I know - plans are in place to migrate to 2019 and eventually SQL Azure, but these things move slowly) and everything was fine with it until I installed the Windows 11 22h2…
asked 2022-11-18T17:15:49.707+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Ryan Waddell
56
Reputation points
commented 2024-09-18T07:15:12.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 81%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Roy Whitehead
0
Reputation points
1 answer
Azure Blob Download Task error
Greetings!!! I am using the Azure Blob Download task to copy files from Azure Data Lake Storage Gen2 on to a local directory on-premise. But, when I do this I run into error. Error Message: [Azure Blob Download Task] Error: Download task has stopped with…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
3 answers
How to debug a trigger in ssms 20.2, sql 2019
How to debug a sql 2019 table tigger in ssms, i am nit seeing debug in ssms
asked 2024-09-03T18:09:39.9366667+00:00
Sushil Agarwal
406
Reputation points
edited the question 2024-09-18T04:18:08.78+00:00
Jack J Jun
24,491
Reputation points Microsoft Vendor
2 answers
Change compatibility
is there any impact on always on while change the compatibilkity level.
asked 2024-09-10T14:01:14.7366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Allen
0
Reputation points
commented 2024-09-18T02:47:34.9766667+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
1 answer
Mssql-tools18 not installing on debian 12
Hi, I am trying to install mssql-tools18 on a debian docker image. this is what my dockerfile looks like: FROM python:3.11.10 RUN curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg…
asked 2024-09-11T20:14:13.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 48%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gaurav Singh
0
Reputation points
commented 2024-09-18T02:41:57.83+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
2 answers
SQL Server Latch buffer wait type experienced by inserts occassionally
Hello We have got 12TB pure oltp database(SQL 2017), not doing any complex access patterns. Occasionally we notice the insert statement latency spikes to 2 to 3 sec and we could notice it experience IO wait (in Foglight) If we drill down further, it is…
asked 2024-09-12T11:22:31.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
commented 2024-09-18T02:40:59.84+00:00
CathyJi-MSFT
21,871
Reputation points Microsoft Vendor
2 answers
Detecting and closing opened ODBC connections
Hi, I'd like to know if it is possible to detect and close an opened ODBC connection: a my connection doesn't function more and I want to detect possible pending connections. Thanks
asked 2024-09-17T13:10:56.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pmscorca
987
Reputation points
answered 2024-09-18T02:35:22.8833333+00:00
LiHongMSFT-4306
26,791
Reputation points