SQL Server Database Engine

How Do I Connect to SQL Server?

How do I connect to a SQL server using my home computer? I ultimately just want to connect SQL to several CSV files that are on my desktop. Please let me know if you need additional information.

Table Name: Order1 OrderId: Order's id OrderItemId: Item ids of the purchase orders. QuantityOrdered: Number of items Ordered for an order. ItemPrice: Order total value PromotionDiscount: Discount of an Order. batch_id: Batch id of the order. (Note: Us

Click on "Console" at the top right corner. Agree to the terms of service and click Continue. Search for "bigquery" on the search bar at the top. Click on "Create Project" Give the project a name you like. Click on…

Need hands on help with SQL server availability

I need on hands help diagnosing SQL server availability

Why do no nodes appear in summary

I thought it would have at least one node, but it didn't. Did I misunderstand its concept

Msg 15871, '@@FETCH_STATUS' is not supported.

I am running a query and have @@Fetch_Status while loop, but the query stops at the while loop and gives the error: Msg 15871, Level 16, State 6, Line 43 '@@FETCH_STATUS' is not supported. Not sure what the problem could be. Please assist.

SQL server collation issue while doing replication

Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)

Ever since the last patching window, we have some scheduled jobs on SQL production that are intermittently failing, producing the error "Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)" The jobs run fine if they are not…

Availability Group is not connecting through Listener

I have set up 2 SQL VMs on Azure with VPN we connect to those VMs and it is a single subnet , No Public IP is used. but the listener is only accessible from Node1 when Node1's Availability group is primary and the listener is not accessible from Node1…

I cannot uninstall SQL Server 2022

I have the same issue when uninstall SQL Server 2022 Express Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052294 Start time: 2025-03-13 08:39:16 End time: …

In MS Access what is the maximum "length" of the field in a table with data type "long text"?

Hi, i cannot see the size of the field and i have difficulties entering data with length higher than 2500 as varchar (table from sql server). I increased the field size to 3000 but it is not working I connected to that table again thanks for any…

SQL Server 2019/.2022 Express Launchpad service failed to start

I installed SQL Server 2019 Express on Windows 11 Pro 24H2 (with 250 GB HD, and 8 GB RAM) with ML services. It is a standalone machine and it is not a Domain Controller. The installation went fine. However I am unable to test R, Python, Java because the…

Issue access SQL - Error: Netlogon has failed an additional 1583 authentication requests in the last 30 minutes.

Any idea on how to fix this? " Netlogon has failed an additional 1583 authentication requests in the last 30 minutes. The requests timed out before they could be sent to domain controller (DC) in domain example.com. Please see…

SQL Express installation fails. Getting Exit code (Decimal): -2068052294 the setup failed

I am using a brand new laptop that I just bought a few months ago. It is a Windows laptop 7. I tried to download SLQ Express a few times. The first few times I tried, I thought the program failed because of the firewall, but after I turned it off, the…

Why is Azure SQL DB used space larger than physical server storage used space?

We have an Azure SQL Server database and a physical server with a SQL Server database. The databases have the same structure, and we store similar data on both (different servers for different clients), and we've been using the physical server for longer…

Creating LinkedServer between On-Prem SQL to Azure SQL MI

Hi, is it possible to use security option (Be made using the login's current security context )with lnikedserver from on-prem SQL to MI ? Our MI is enabled for windows auth and we are successfully connect MI in SSMS using windows auth from on-prem…

I cannot install the SQL Server 2022 Developer Edition

I cannot install the SQL Server 2022 Developer Edition (x64) on windows 11 i tried alot of things even setup a new windows i get this error code 0x84B40002 and it says The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair,…

Could not connect azure sql db from ssms

I am getting error Microsoft.Data.SqlClient.SqlException (0x80131904): 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…

I cannot install the SQL Server 2022 Developer Edition

I cannot install the SQL Server 2022 Developer Edition (x64) on windows 11 i tried alot of things even setup a new windows i get this error code 0x84B40002 and it says The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair,…

Transfer SQL Server 2022 license

We have a SQL Server 2022 license in our Microsoft 365 admin center which we purchased for a customer. Is it possible to change the ownership of a license and transfer it to the admin center of our customer?

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2066119551Error description: Attempted to perform an unauthorized operation.