Switching from SQL Server/CAL based licensing to core based licensing model for all SQL servers
We are using Server+CAL licensing model for all SQL servers in our organization. Due to the limitation of number of cores supported by CAL based license, we are planning to switch to core based license. Upon checking with client, he informed, "Under…
can not start sql server2012.the request failed or ther service did not respond in a timely fashion.
This error will be reported after starting sql server 2012, check the log,Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
query taking long time to match
Hi Team, how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it query attachedcheck.txt
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
Regarding Compliance of SQL Developer
SQL Developer right now can be consider as free if not used as production environment. But there still something missing information, consider i read the EULA for how SQLDev work. (…
SSRS Report Viewer windows forms - The request failed with an empty response
Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…
Virtual Machine Windows Server 2019 Licensing / SQL Server Licensing
Greetings, I am trying to build a new infrastructure with 3 VMs for Application Server, SQL Server and a Test-Dev Server. In many discussions with different providers I did not get the answers that I really need. These 3 VMs must be licensed with Windows…
Licensing SQL server at a host level (2016 -2019)
Hello We have a 10 host on premise VMWare cluster, mostly running Windows VMs. We are looking to license all our SQL virtual machines (versions 2016 through to 2019) using the core based model and would like to license at the physical host level. My…
Exception problem
Hi, I've got issue due to this line below. reader = cmd.ExecuteReader(); Can it be owing to no record returned?
Execution Plan Parallel Deadlock Issue Persisting in SQL Server 2022
Hi Msft team! I hope this message finds you well. I am writing to report a persistent issue with execution plan parallel deadlocks that still exists in SQL Server 2022. Despite updates and patches, this bug appears to remain unresolved, and I have been…
SQL Server restrictions for support system centre
I am trying to confirm if I can run a SQL Server cluster (AG) to support System Centre. I understand the database must be Standard Edition and dedicated to System Centre. That's clear. What's not clear is can I run a cluster or must it be s single…
An error occurred while extracting the result into a variable of type (DBTYPE_I4) error
I have a simple sql statement which outputs a few columns, whch one of them is a column with an int datatype, but I get the following error when I execute the package, I tried to change the datatype in the flat file but it doesn't seem to work: [Execute…
SSMS 20 can't show conflict viewer
Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…
Are there enhancements in SQL SERVER 2019 transactional replication working as compared to SQL SERVER 2008 R2 transactional replication. Also, of all HA/DR solutions available in SQL SERVER 2019 which allows minimum data loss in case of disaster.
Are there enhancements in SQL SERVER 2019 transactional replication working as compared to SQL SERVER 2008 R2 transactional replication. Also, of all HA/DR solutions available in SQL SERVER 2019; which allows for minimum data loss in case of disaster.…
framework realated question
what is frame in framework for .net applicatons like .net framework 3.5 and what it indicates for frames
Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64
Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…
How to install SQL Server but got an error message
I'm trying to install SQL server but I am getting an error message that SQL server cannot be found and I should try install again, may I get help with the error?
Deploying the tabular cube failed with a timerunot error
Hello everyone, I'm encountering an issue while deploying the cube. It's failing, as shown in the image below. Can anyone help me with this?