SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,769 questions
0 answers
I can't start the MSSQLSERVER on new esxi host
I am a student currently studying virtualization and SQL installation for one of my projects apkbeb. After obtaining approval from my instrcutor, I attempted to transfer a virtual machine (VM) to my personal laptop. However, upon doing so, I encountered…
![](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(70.4, 81%, 16%)' 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)
0 answers
Ununable to install sql server (setup.exe) Exit code (Decimal): -2147467259 Error description: The service did not respond to the start or control request in a timely fashion.
I'm trying to download SQL express through the installation process it gives me an error Oops... Unable to install sql server (setup.exe) Exit code (Decimal) -2147467259E Error description: The service did not respond to the start or control request in…
asked 2024-04-30T15:39:20.9433333+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, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
moris shehady
0
Reputation points
commented 2024-05-07T11:19:39.56+00:00
moris shehady
0
Reputation points
0 answers
SQL Connectivity Issue From Cloud app to on-prem server
hi, I have deployed a .net core MVC app in azure app service as a webapp. I have to connect to a on-prem sql server to retrieve data. I have setup Azure relay/hybrid connection for the same. Also I have installed hybrid connection manager in on-prem…
asked 2024-05-07T10:38:07.05+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(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
145
Reputation points
edited the question 2024-05-07T10:38:28.5966667+00:00
Santhi Dhanuskodi
145
Reputation points
4 answers
One of the answers was accepted by the question author.
Is there a 64 bit SSMS?
I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…
asked 2021-09-29T11:48:06.173+00:00
子明 李
21
Reputation points
commented 2024-05-07T10:37:11.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(208, 11%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vladimir Bazanov
0
Reputation points
0 answers
The target principal name is incorrect
Hi Team, I've got the error "The target principal name is incorrect. Cannot generate SSPI context" when I tried to connect to SQL Server from other server. I've checked sql logs and I found info SPN was registered . I've run Kerberos…
asked 2024-05-06T13:06:14.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(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marcin Woszczyna
0
Reputation points
commented 2024-05-07T09:39:12.2266667+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
1 answer
How to add Farm Account Shell Admin access to content databases?
Objective To grant SharePoint Farm account Shell Admin to all the content databases. Error Highlighted in white are "Add-SPShellAdmin <FarmAccount>", "WSS_Content_Database". Question How to give Farm account Shell…
asked 2024-05-07T01:18:10.12+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(246.4, 26%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
ChingSong Lim
60
Reputation points
answered 2024-05-07T09:25:42.2266667+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, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
41,941
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
Power BI Reporting Server on Standard DB Engine
Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…
![](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(265.6, 25%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
2 answers
The transaction log for database is full due to 'REPLICATION'
Hi! I have a SQL 2019 database that is a member of 3 node always on availability group. It is also the subscriber being populated from a DB2 database. The log keeps filling up and I am unable to shrink or backup.. I get the message: The transaction log…
asked 2022-04-25T08:33:47.077+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, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZO%3C/text%3E%3C/svg%3E)
zoe Ohara
286
Reputation points
commented 2024-05-07T09:12:45.76+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(48, 74%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi Sethi
0
Reputation points
0 answers
Key store providers cannot be set more than once(Always Encrypted with JDBC and Java 8)
We are trying to use SQL Always Encrypted feature in our Java Web Application. Java 8 is the JRE and uses mssql-jdbc-9.2.1.jre8.jar as the jdbc driver. Azure-Key-vault as the column master key store provider Our application uses below code to…
asked 2021-11-09T04:53:17.773+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(236.8, 3%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Subin Sankaran
1
Reputation point
commented 2024-05-07T09:07:01.79+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(32, 44%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Manjunatha Bhimanna (Aspiresys Consultant)
0
Reputation points
1 answer
I can see latest jar of MSSQL jdbc version 12.6.1.jre11 has Vulnerabilities in one of the dependent in built library
In our java application, we are using MSSQL jdbc and to remediate Vulnerabilities, we have upgraded our jar to latest version 12.6.1, but even it shows SCA Vulnerability in one of the inbuilt dependent as shown in below…
asked 2024-05-06T14:41:54.67+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, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Peruka, Himaja
0
Reputation points
commented 2024-05-07T08:55:49.45+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Integration service on dedicated SQL instance
Based on an assessment I did on a client's server, I have to move all the integration services to a dedicated machine. We decided to separate ETL and data on two machines. My question is: having a dedicated instance, how do I manage the memory CAP on…
asked 2024-05-06T09:26:30.6333333+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(268.8, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alen Cappelletti
911
Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti
911
Reputation points
1 answer
Error description: The system cannot find the path specified while installing SQL server management studio
I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …
asked 2024-05-06T16:23:40.68+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(41.6, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nikita Gaur
0
Reputation points
answered 2024-05-07T06:55:27.21+00:00
LucyChen-MSFT
1,120
Reputation points Microsoft Vendor
1 answer
Scripting out 'Create Merge Replication' does not include 'processing_order'
We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures. When we want to setup or refresh a test environment, we will script out the…
asked 2024-05-03T03:20:20.6466667+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(60.8, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGY%3C/text%3E%3C/svg%3E)
Greg Youdale
5
Reputation points
commented 2024-05-07T06:16:19.72+00:00
Greg Youdale
5
Reputation points
4 answers
One of the answers was accepted by the question author.
How to install sql server on windows 11 using UTM on mac,
Hello everyone Please help me. I am stuck here for 2 days. I am trying to install sqlserver 2022 on windows 11 using UTM on mac m1. I am getting this error.
asked 2023-01-25T16:38:55.61+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(195.2, 89%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Malik Allahyar Nawabi
20
Reputation points
commented 2024-05-07T02:53:33.55+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(220.8, 99%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Merna
0
Reputation points
0 answers
SetDatabaseConnection WMIMethodException Error
I'm using a slightly modified version of the script found here: https://blog.aelterman.com/2018/01/03/complete-automated-configuration-of-sql-server-2017-reporting-services/. The modification is that I'm pointing to (local)\SQLExpress on line 41 as the…
asked 2024-05-06T19:26:46.2033333+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(96, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Horton
0
Reputation points
edited the question 2024-05-07T02:31:33.8733333+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
2 answers
Text delimiter file
Hi, I have two tables: one for headers with 9 fields and another for lines with 6 fields. Both header and lines are highlited in yellow. I need to combine both the headers and lines using a UNION operation to display the result below. From the line…
asked 2024-05-06T14:48:13.48+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(182.40000000000003, 69%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vicki
46
Reputation points
answered 2024-05-07T02:18:28.6533333+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
1 answer
Performance Monitoring tools used for 4 hrs
Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs
asked 2024-05-01T22:28:33+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(51.2, 55.00000000000001%, 14%)' 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)
Avyayah
1,231
Reputation points
commented 2024-05-07T01:08:43.2566667+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
2 answers
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
asked 2024-04-29T21:26:46.1566667+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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Linda
1
Reputation point
commented 2024-05-07T01:05:43.68+00:00
ZoeHui-MSFT
33,211
Reputation points
4 answers
One of the answers was accepted by the question author.
SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server
Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…
asked 2021-05-03T11:51:51.583+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(80, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lynn Carelse
21
Reputation points
answered 2024-05-06T23:54:14.06+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(294.40000000000003, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Santiago Guerrero Toro
0
Reputation points
2 answers
Named Pipes Provider: Could not open a connection to SQL Server
Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja
asked 2024-05-02T05:30:16.5+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, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Raja Raju
0
Reputation points
commented 2024-05-06T20:43:46.97+00:00
Erland Sommarskog
101.4K
Reputation points MVP