Additional SQL Server features and topics not covered by specific categories
Upgrading SQL 2019 to 2025 - Fulltext index issue
When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade. It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder,…
SQL Server | Other
Power BI Desktop "Cannot establish connection" - msmdsrv.exe listening but connection timeout
Hello, I'm experiencing a persistent issue with Power BI Desktop failing to start. The error message is: "Cannot establish connection. Please verify that the server is running." Environment OS: Windows 11 Pro (10.0.26200) Hardware: Intel…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Migration feature on SSMS 22
Hi Expert, I'm running first time Migrate SQL Server feature on SSMS 22 for Database Assessment with 10TB size, this report as below: "Status": "Error", "**AssessmentRecommendations": [],** "Name":…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
The error was while running the store procedure runs xp_cmdshell to run a batch file
The stored procedure SP_CreateClientDatabase internally uses xp_cmdshell to execute a batch file located at: F:\ECLOUD_DB_Script\CreateDB.bat However, the execution is currently failing with the below error:An error occurred during the execution of…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL “untrusted domain” error over VPN for one device only (Windows Auth)
I’m looking for some advice on an issue affecting a single user/device when connecting to SQL Server over VPN. The user receives the following error when launching an application that connects to SQL Server using Windows Authentication: “Login failed.…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Reinstallation doubt regarding Microsoft Visual C++ 2017 distributable package error
can we resolve this SQL Server 2019 install warning - Microsoft Visual C++ 2017 distributable package error, by re-installing the Microsoft Visual C++ 2017 distributable package, if the current windows version already got end of support?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
maxdop of a query will fallback to serial or not.
if a query has maxdop 2 : in this case can microsoft decided in this situation to not to use parallelism and use all cores/or execute a query serially, as if parllelism is switched off
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
An error occurred during the execution of DDL with variables while migrating the database using CDC.
We are performing a database migration for a SQL Server upgrade. After enabling CDC in SQL Server 2016, an error occurred in the SQL query for rebuilding an index with a variable, called by the database maintenance batch. Must declare the scalar…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL vs NoSQL Databases: Key Differences and Use Cases
What is the difference between SQL and NoSQL databases, and when would you choose each?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
# SQL Server 2022 Availability Group works in Workgroup but fails in Active Directory environment Hello everyone, I am currently learning SQL Server administration and I am doing a practical lab as part of my internship. I would appreciate some guidance
Hello everyone, This is my first time posting on this forum, so please excuse me if I miss any forum conventions or provide too much or too little information. I am currently learning SQL Server administration and I am doing a practical lab as part of my…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Create Crystal report error in Programs files folder .
I have a Crystal report which is having a data source from MS SQL server. I am always getting this error when we want to show the report: Unknown Query Engine Error Error in File C:\Users\ADMINI~1\AppData\Local\Temp\Test.rpt: Unknown Query Engine…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Disaster recovery license for SQL 2022 WSFC cluster
Hi all, I'm new to SQL, so I'd like to ask you a question about SQL licensing for a DR site. I have a WSFC for SQL Server 2022 in production with its own license. My question is: for a possible SQL cluster in the Disaster recovery site, is it possible to…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Error "[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied"
Hi, We are getting an error "[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied" for few users on accessing ERP application and most of the users are able to access application without any issue. We have enabled…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
We need to retrieve a SQL 2019 key
We purchased SQL 2019 Standard in 2022 from First Technology Group in South Africa (DG7GMGF0FKX90003). We have recently lost our server after a violent storm resulting in a power surge and now need to re-install SQL 2019 on a new server. We contacted…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Distribution Cleanup Job Failing Silently in SQL Server 2019 Transactional Replication Causing Distribution DB Growth to 1.5 TB
Hello All, We are facing an issue with SQL Server Transactional Replication where the Distribution Cleanup job has been failing silently, and the distribution database has grown to approximately 1.5 TB, causing severe disk space issues. Environment SQL…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Express ODBC Connection
Hi, I am trying to connect UPS WorldShip to a SQL server to pull shipping data. It keeps telling me the connection has failed, this is a replacement server, the old server still connects. I turned off the firewall on the server for testing, I…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Mssql Log Shipping Requirement
I want to know about Mssql Log Shipping requirement to make it and the setup in details
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How to activate SQL 2025 license on SQL2022
Hello i bought "SQL Server 2025 Standart sürümü Kalıcı 1 Sunucu Lisansı ve CAL 10".Before i bought this license, i talked with two microsoft sale representative. They confirm that i can use this SQL 2025 license on SQL 2022. But when i try to…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Can't connect to SQL Server to complete Learning Labs
DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories