20,145 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

SSMS Startup. Package did not load correctly.

I have installed SQL server and SSMS. Upon starting SSMS i get the following error message. This is followed with about 4 other popup boxes saying things like “visual studio common IDE package” did not load correctly. Please help me diagnose this error.

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
148 questions
asked 2025-03-11T22:56:29.6466667+00:00
Blake Judson 0 Reputation points
commented 2025-03-12T01:58:29.7633333+00:00
LiHongMSFT-4306 31,081 Reputation points
1 answer

Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller

facing issue with connecting sql server to power bi service, in desktop this is working properly and also able to refresh but in service getting error.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
asked 2025-03-11T04:29:49.5633333+00:00
Nirmala Jawalkar 0 Reputation points
answered 2025-03-12T01:55:57.26+00:00
LiHongMSFT-4306 31,081 Reputation points
8 answers

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 15 Reputation points
commented 2025-03-11T23:42:14.8233333+00:00
Kim Scott 0 Reputation points
8 answers

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 15 Reputation points
commented 2025-03-11T23:42:14.8233333+00:00
Kim Scott 0 Reputation points
1 answer

Private endpoint as cloud witness for clustering supported ?

Windows cluster in Azure , two VMS ( for now ) Storage account standard gen 2 with min TLS 1.0 ( just in case ) and network access cut ( only to be done via PE) Private endpoint lies in a nearby subnet of the source, auto approved, dns registered.…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,410 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
537 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,027 questions
asked 2023-09-14T19:07:44.4666667+00:00
Andrei Bathory 0 Reputation points
commented 2025-03-11T23:36:49.9+00:00
Wagoner, J. Allen 0 Reputation points
1 answer

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…

SQL Server Database Engine
asked 2025-03-11T04:22:35.8266667+00:00
Khalid Thwiny 0 Reputation points
answered 2025-03-11T22:42:19.9666667+00:00
Erland Sommarskog 119.3K Reputation points MVP
0 answers

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 Database Engine
asked 2025-03-11T16:15:50.7233333+00:00
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
commented 2025-03-11T22:31:47.4966667+00:00
Erland Sommarskog 119.3K Reputation points MVP
0 answers

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 Server Database Engine
asked 2025-03-11T18:23:21.0033333+00:00
Frankie 0 Reputation points
commented 2025-03-11T22:29:10.85+00:00
Erland Sommarskog 119.3K Reputation points MVP
1 answer One of the answers was accepted by the question author.

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…

SQL Server Database Engine
asked 2025-03-09T21:41:21.0333333+00:00
Caleb Cosgrove 20 Reputation points
commented 2025-03-11T22:25:23.5166667+00:00
Erland Sommarskog 119.3K Reputation points MVP
2 answers One of the answers was accepted by the question author.

SSMS Query Store Regressed queries - buttons don't have tooltips

Hi, I'm trying to analyze information in the Query Store. I started from the top report Regressed Queries which showed nothing for me, but I noticed that several buttons on the right don't have tool tips and it's hard to figure out what they are for. My…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
asked 2025-03-10T13:24:05.16+00:00
Naomi Nosonovsky 8,291 Reputation points
commented 2025-03-11T22:21:02.53+00:00
Erland Sommarskog 119.3K Reputation points MVP
1 answer

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…

SQL Server Database Engine
asked 2025-03-10T15:16:49.2033333+00:00
Sean Meadows 20 Reputation points
commented 2025-03-11T22:08:58.28+00:00
Erland Sommarskog 119.3K Reputation points MVP
1 answer One of the answers was accepted by the question author.

SSIS XML write file task - how to preserve empty values?

Hi, We have SSIS package that writes XMLs into files. We have stored procedure that generates XML and outputs it as XML with tags like this <MiddleName> </MiddleName>. In other words, there is a space (intentional) inside the tags. We have…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,663 questions
asked 2025-03-10T21:32:16.3566667+00:00
Naomi Nosonovsky 8,291 Reputation points
edited a comment 2025-03-11T21:30:32.6333333+00:00
Viorel 120.4K Reputation points
1 answer

SQL Server xp_copy_files security thoughts and able to specify files older than only?

Hello noticed somewhat of a new recent feature xp_copy_files (for SQL Server2019 & higher) which we have SQL Server 2022 (believe most things similarly were done previously via xp_cmdshell which had security concerns). Is it correct to say…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
148 questions
asked 2025-03-08T22:37:16.5733333+00:00
techresearch7777777 1,921 Reputation points
commented 2025-03-11T16:25:51.1266667+00:00
Dan Guzman 9,276 Reputation points
7 answers

SSMS 18.6 Object Explorer Details view no longer working?

Hi everybody, I want to confirm something. I believe I used to be able to highlight a table in SSMS, click F7 and bring its columns into separate window and then can highlight columns I need and drop them into code window. I'm using the latest SSMS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
asked 2020-10-14T17:52:32.66+00:00
Naomi Nosonovsky 8,291 Reputation points
commented 2025-03-11T16:21:45.0233333+00:00
David McKinney 0 Reputation points
0 answers

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…

SQL Server Database Engine
asked 2025-03-10T09:22:44.1433333+00:00
Santosh 41 Reputation points
commented 2025-03-11T12:29:11.12+00:00
Santosh 41 Reputation points
1 answer One of the answers was accepted by the question author.

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,…

SQL Server Database Engine
asked 2025-03-10T17:00:02.34+00:00
mark 20 Reputation points
accepted 2025-03-11T09:09:37.54+00:00
mark 20 Reputation points
4 answers One of the answers was accepted by the question author.

i get an error when connecting sql server using SSMS .

Cannot connect to PANKAJ\SQLEXPRESS. =================================== A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,327 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,327 questions
asked 2023-03-01T10:47:14.23+00:00
pankaj prajapati 20 Reputation points
commented 2025-03-11T08:06:09.14+00:00
SubbaRao P V 0 Reputation points
4 answers One of the answers was accepted by the question author.

i get an error when connecting sql server using SSMS .

Cannot connect to PANKAJ\SQLEXPRESS. =================================== A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,327 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,327 questions
asked 2023-03-01T10:47:14.23+00:00
pankaj prajapati 20 Reputation points
commented 2025-03-11T08:06:09.14+00:00
SubbaRao P V 0 Reputation points
6 answers

Cannot connect to SQL Database. Please contact SQL server team for further support

Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,009 questions
asked 2022-12-20T17:10:54.27+00:00
Venkateswarlu Y 6 Reputation points
answered 2025-03-11T06:05:32.82+00:00
Varsha 0 Reputation points
1 answer

Metric Storage space used

I see this value in the attached screenshot and would like to clarify its meaning. Additionally, I need to determine how much free storage space is available in my SQL Managed Instance. Ideally, I should see a clear breakdown, such as "10 GB…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
asked 2025-02-06T20:27:19.7933333+00:00
GP 16 Reputation points
commented 2025-03-11T04:41:16.0866667+00:00
Sai Raghunadh M 2,875 Reputation points Microsoft External Staff