SQL Server

How can I get the email used to buy a sqlserver license

I have a SQL Server 2017 license, but I can't find the email address it was purchased with. I don't think it's tied to a tenant, but it could be tied to another account, but I can't figure out which one. Isn't there a form where I can enter the license…

creating subscription for SCOM Audit Reports throws error

On the SSRS for SCOM ACS the Audit Reports, running SQL 2022 CU20 When I try to create a subscription I get the error “Subscription can't be created or edited because the credentials used to run the report are not stored, or if a linked report, the link…

Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated

  Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated    Impact:- Application is not working properly with below error. Error: TCP Provider, error: 0 - The specified network name is no…

I have A clustered SQL Server Instance that does not fail-over completely due to using SQL authenticating credentials on an appvolumes database for a VDI database.

Hello, I have A clustered SQL Server Instance that does not fail over completely due to using SQL authenticating credentials on an AppVolumes database for a VDI database. The account being used to access the database has the user mapping to the…

SQL Server Import and Export Wizard: Can not go back after error

Hi. After finishing an import using the SQL Import and Export Wizard, and if there's an error, I can't find a way to go back and fix it, even though the wizard indicates at the top that this should be possible: It's very annoying to have to start from…

SSRS 2019 Configuration Error – “The RPC server is not listening (0x800706B3)”

Hello Microsoft Support, We are having an issue while configuring SQL Server Reporting Services (SSRS) 2019. Environment: Windows Server 2019 SQL Server 2019 Standard Edition SSRS 2019 (standalone) Service Account: NetworkService Logged in as a…

SQL Server patching and information on Cumulative Updates and Security Updates(GDR and CU GDR)

Hello Support, I am a bit confused of what the patches mean and contain for SQL Server and will appreciate if you can clarify this for me: My question is for SQL Server 2019( but it is also applicable for SQL Server 2022 We have the RTM version…

how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

SQL Server 2022 Developer Edition is not installing in my Microsoft Surface Laptop 7th edition

Lost my SQL Server 2017 Product License. How can I get it back for reinstallation

We have purchased Microsoft SQL Server Standard Edition 2017. We have got all the Purchase details except License Key. As we need to reinstall the server for some technical issue we need that License Key. How can we get it back.

Can sqlserver perpetual and subscription lincense mixed?

We have purchased 4 core SQL Server perpetual lincense. But after new years, now we want to add more CPU to DB server. So, can we buy subscription lincense for new DB core? Or only can buy perpetual lincense？

AT TIME ZONE - GMT Standard Time - Windows [Bug]

Hi, On Windows, SQL Server "AT TIME ZONE" uses the Windows Registry to determine time zone conversion. However, daylight savings conversions in the "GMT Standard Time" time zone on Windows become inaccurate and problematic from years…

Preventing Database Deletion in SSMS

prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…

Sql Server 2014 connectivity issue after Windows patch update

Hello, We have currently Sql server 2014 SP1 and after our windows team apply the patch with GPO which caused connectivity issue within the application although I am able to connect via my local SSMS but when our application trying to connect it causing…

Missing Branding tab

I cannot see Branding tab in Site Settings menu, I am running the latest SSRS which is >16.018 and I am running SQL standard edition 2022

SPLIT_String is not recognized function name in SQL 2022

Good day, In SQL Server 2022 split_sting function shows with red underline like it doesn't exist. This statement SELECT v.value FROM #FirstResult CROSS APPLY SPLIT_STRING(Prov_Last_Name,'') AS v returns this error: Msg 208, Level 16, State 1,…

Implementing User-Defined Sort via Trigger

Hi, Running SQL Server 2008 R2. We have a requirement to implement an arbitrary sort for a table using a numeric sort column. DDL and DML below: CREATE TABLE [dbo].[Test] ( [TestID] [bigint] IDENTITY(1,1) NOT NULL, …

Experience with SQL2014 to SQL2022 where table column data has been encrypted.

Have a SQL2014 Express database (instance=COMP) where some columns in a table have been encrypted (using Master Key, Certificate, Symmetric etc). Have created a SQL2022 database (instance=COMP2022) and Restored into SQL2022 a backup of SQL2014. Queries…

SQL standard server licensing question

Greetings, We are looking to set up a cost effective VM with MSSQL for a project with 2 concurrent users. This is hosted in a research cloud so we are confused about what license can be used. The research cloud is not listed under microsoft's authorised…

How to signing EKM providers for MsSQL Servers on Linux

getting error Failed to get verify Authenticode signature on DLL while creating cryptographic provider on SQL server on Linux need solution