Does windows support virtio_vsocket as host?
Does windows and hyper-v support virtio_tansport( virtio_vsocket) as host? if support, what are the advantages of hyperv_transport(hyperv_socket) over virtio_tansport(virtio_vsocket)? what is the reason why we are developing a new vsocket…
how to set order by ND columns
Hello This is my sql code DECLARE @cols NVARCHAR(MAX)='' DECLARE @query NVARCHAR(MAX)='' DECLARE @COLS_SUM NVARCHAR(MAX)='' DECLARE @COLS_TOT NVARCHAR(MAX)='' --Preparing columns for Pivot SELECT @cols = @cols + isnull(QUOTENAME(ND),0) +…
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
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…
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…
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…
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…
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
How do I transfer an on-premises license from one corporate user to another?
I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?
tại sao khi kết nối với máy chủ SQL 2022 Azure lại không có Restore Database
Khi tôi cài đặt Azure Data Studio kết nối với SQL bản 2022 và muốn restore advanturework 2022 để thực hành thì không có mục Restore dữ liệu khi nhấn chuột phải vào Database mà chỉ có mục Filter và Refesh. Làm thế nào để sửa lỗi này?
SSDT DEployment fails with "The Element or Annotation class SqlIndex does not contain the Property class Online"
Trying to deploy our DBs SSDT, both in an Azure Pipeline and on our team's Docker, fails with the following error: Assembly Initialization method <MyAssembly>.ComponentTestBase.AssemblyInit threw exception.…
How do I upgrade SQL server from 2016 to 2019
The current version is showing as SQL server 13.0.5893.48 after I thought I had upgraded it to 2019.
SQL Server Integration Services Projects 2022 exe for VS2022 is not detecting VS2022 and hence unable to install it
When i install SQL Server Integration Services Projects 2022, it does not detect my installed VS 2022. Hence, unable to select any VS and install. I tried from different machines.. in some machines its getting detected, but disabled, doesn't allow me to…
Security update for SQL Server 2022 CU12 - patch update failed
Security update for SQL Server 2022 CU12 Patch installation failed. Product: SQL Server 2022 Database Engine Shared - Update 'Hotfix 4120 for SQL Server Database Services Core Shared (64-bit) (KB5036343)' could not be installed. Error code 1603. Action…
How to find midpoint of a polyline
How would you calculate the x,y of the midpoint of a polyline with MS SQL Server? I can get start point and end point by using shape.STStartPoint().ToString() and shape.STEndPoint().ToString() An arbitrary point using…
MSSQL - Add Connection Errors
MSSQL Extension Version: v1.19.1 VSCode Version: 1.70.2 (Universal) OS Version: macOS 14.4.1 (23E224) After downloading SQL Server v1.19.1, I ran into the same initial error messages as this issue:…
How Can I set the right value according to comparison conditition
Hello, i have 2 tables , the first one is a referential of the quality services and the second is a historical tables as bellow the DDL : drop table if exists #oderstatus_quality create table #oderstatus_quality ( id int identity primary key, label…
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
Unable to start Microsoft SQL Server Migration Assistant for Access
I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…
Please wait for the user profile service problem
As, i am using sql server 2019 in windows server 2019, while login it got stuck in Please wait for the user profile service and please wait for the profsvc. As i cannot connet my server to internet due to security protocols. This problem happen each day…