Polybase - Enforce TCP/IP Protocol
Hello, We know Polybase service in SQL server by default makes use of shared memory protocol to connect SQL server (local). I would like to know if there is any way we can change or force the connections to make use of TCP / IP protocol. Any help would be appreciated.
Unable to installing the SQL server 2022 reporting services on the Windows 10 Pro and Windows 11Pro
I am writing to you because I am encountering an issue while attempting to install SQL Server 2022 Reporting Services on Windows 10 Pro and Windows 11 Pro machines. While I have been able to start the installation process, I am unable to run the SQL Server 2022 Reporting Services .exe file. I have included the error message log details below for your reference. Application: SQLServerReportingServices.exe Framework Version: v4.0.30319 Description: The process was terminated due to an internal error in the .NET Runtime at IP 6CD5D612 (6CA70000) with exit code 80131506. I would greatly appreciate any assistance you can provide in resolving this issue. Thank you for your time and attention to this matter.
SQL server compatible with macbook pro m3 max via Parallels VM?
I'm having problems in installing SQL server on my macbook pro m3 max via parallels virtual machine. But I have this downloaded together with the SQL server management studio on my macbook pro m1 via parallels virtual machine. I feel like I've wasted so much money buying the m3 max and I couldn't even install the SQL server and SQL server management studio. I hope someone can help me.SQL Server installation error on Windows 11 Pro system
Hi All, I'm facing the decimal error code while installing the SQL Server 2022(Developer edition) on my local system. I tried the few of the methods suggested which are - 1. removing all components of previously installed instance. 2. Running setup.exe file with admin access. 3. Turn off the firewall. Didn't get expected results. It would be very helpful if someone support me. Thanks in advance. ERROR - exit code decimal 2068052377 Error Description: Invalid command line argument. Consult windows installer SDK for detailed command line help. Regards, ManuSQL Server 2022: AlwaysOn AG databases can not sync after applying CU6 or higher
The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn Availability Groups are enabled on two (primary + secondary) replicas and use WSFC. Several availability groups are created and a database in each of them. AGs are configured with Sync Commit and Automatic failover mode, also they use dedicated separate VLAN for data sync. The issue we noticed is that after applying CU6 or higher ones , in case of we restart any of two replica hosts, on the secondary replica not all databases switch back to Synchronized state, part of them remain in Not Synchronizing state . Any ideas what could be the reason of that behavior change? Had someone similar issue ?I have Visual Studio 2022 and SQL Server 2022 (same versions) on 2 machines. DB file only works on 1
Hi I have a database file that I am able to connect to SQL Server 2022 using Visual Studio 2022 on computer_1, but when I move that file to computer_2 (also with the same versions of SQL Server 2022 and Visual Studio 2022) I get the error in the first image, "the file is not compatible with Current instance of SQL Server". If I upgrade the file on the computer_2, it can be attached, BUT when I move the file back to the original machine, I get the error in the second image, "the file cannot be opened because it is version 904".... Both computers have the most recent versions of SQL Server 2022 and Visual Studio 2022. Both computers have previous versions of SQL Server. It is as if the second computer is not using the same server as the first. The file was originally created in Visual Studio 2010, but again, works fine with SQL Server 2022 on computer_1. Does anyone know how I can clarify this situation and force the two machines to use the same versions of SQL Server (if that is the problem)? Note: I have confirmed the versions of SQL Server 2022 and Visual Studio 2022. They are the same. Thanks!
