18,298 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 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,254 questions
asked 2024-05-31T06:52:56.3233333+00:00
Aravind K Pachaiyappan 0 Reputation points
edited a comment 2024-06-11T11:51:23.16+00:00
Aravind K Pachaiyappan 0 Reputation points
0 answers

How to copy an SSAS cube

Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks

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,254 questions
asked 2024-06-11T10:33:17.89+00:00
Zimiso 121 Reputation points
0 answers

Hey team, I am using uaa login url for custom authentication while accessing web reports.

The problem is that when I am using windows authentication, I am able to see the cookie for the ServiceState API, but if I configure it to use the custom authentication which is by using uaa as mode of authentication mechanism I am not able to see the…

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.
2,848 questions
asked 2024-06-11T10:07:54.39+00:00
Vuppala, Sahit 0 Reputation points
commented 2024-06-11T10:11:17.6933333+00:00
Vuppala, Sahit 0 Reputation points
3 answers

SQL SSMS 20.1

On SQL Management studio, I used to be able to filter in Object Explorer the database list by highlighting databases and select the filter icon. This icon is now grayed out?? Any ideas. Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-05T21:30:17.47+00:00
OAlex 0 Reputation points
commented 2024-06-11T09:46:48.88+00:00
MikeyQiaoMSFT-0444 1,085 Reputation points
3 answers

while installing the sql server 2022 i am getting an error

exit code(Decimal): 2061893606 Error Description: wait on the database engine recovery handle failed. check the sql server error log for potential causes Getting this error while installing sql

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-10T11:57:09.7833333+00:00
shanta swaroop 0 Reputation points
answered 2024-06-11T09:43:01.17+00:00
MikeyQiaoMSFT-0444 1,085 Reputation points
0 answers

My business software was having occasional inability to plug in while connecting to SQL Server

Hello，experts！ My business software encountered an occasional inability to insert problem when connecting to SQL Server, there is no troubleshooting idea at present, please provide some suggestions

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-11T09:18:44.16+00:00
周赟(Zhou Yun 昆仑联通) 0 Reputation points
edited a comment 2024-06-11T09:39:57.56+00:00
周赟(Zhou Yun 昆仑联通) 0 Reputation points
1 answer

Receiving error message locating server

one main PC uses SAGE 50 and we had issues with that system. Since that has been up and running our other computers are not able to access TBW work stations. We get the following error messeage SQL Network interfaces Error locating server We have…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-08T19:13:59.6933333+00:00
Ruby Moshenko 0 Reputation points
answered 2024-06-11T09:25:02.88+00:00
MikeyQiaoMSFT-0444 1,085 Reputation points
3 answers

How to ensure SQL Cluster is running properly after failover

How to ensure SQL Cluster is running properly after failover?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,390 questions
asked 2024-06-08T00:45:09.9433333+00:00
WANG Yuzhi 20 Reputation points
answered 2024-06-11T08:42:42.85+00:00
MikeyQiaoMSFT-0444 1,085 Reputation points
2 answers

Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11

Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,582 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.
13,027 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,480 questions
asked 2024-06-10T20:42:40.8233333+00:00
Majid KH 0 Reputation points
commented 2024-06-11T08:25:21.9633333+00:00
Olaf Helper 42,361 Reputation points
1 answer

Get Global Primary details from All the replicas in Distributed AlwaysOn

In Distributed AlwaysOn, I could not find any DMVs in SQL Server which could provide the details about Global Primary from replicas in Forwarder side (both Primary Forwarder and its local replicas). Is there a way to at-least pull the Global Primary…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,574 questions
asked 2024-06-10T14:06:34.08+00:00
Sajal Bagchi 0 Reputation points
edited an answer 2024-06-11T07:53:36.82+00:00
LucyChenMSFT-4874 2,010 Reputation points
2 answers

How to fix Component error code: 0x80004005 Error description: Unknown error (0xe0000235) during the SQLEXPRADV_x64_PTB (2017) installation?

Hello! I'm having some issues with the SQLEXPRADV_x64_PTB installation (2017 version). I use an MAC MacBook Air Apple M2 (masOS Sonoma 14.1) and Parallels ARM Virtual Machine to run Windows 11 Home 64 bits. In summary, the problem is as follows: Detailed…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-07T12:07:27.27+00:00
PauloMoreira-5852 0 Reputation points
answered 2024-06-11T07:02:13.5366667+00:00
MikeyQiaoMSFT-0444 1,085 Reputation points
2 answers

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-09T22:09:54.9333333+00:00
Eghost 0 Reputation points
edited an answer 2024-06-11T06:01:32.1466667+00:00
LucyChenMSFT-4874 2,010 Reputation points
0 answers

Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when __$operation = 1 or __$operation = 3. how to resolve this.

Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-11T05:26:26.9866667+00:00
UDAY KIRAN 0 Reputation points
commented 2024-06-11T05:46:05.5066667+00:00
Olaf Helper 42,361 Reputation points
1 answer

SQL Server Import and Export Wizard is showing error while importing files

I am trying to import an excel file into SQL Server Management Studio and this error comes up: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-10T18:28:21.98+00:00
Deborah Dollesin 0 Reputation points
answered 2024-06-11T05:39:58.6733333+00:00
ZoeHui-MSFT 34,351 Reputation points
3 answers

SQL login issue

I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-10T10:03:55.5233333+00:00
Gurpreet Khaira 0 Reputation points
answered 2024-06-11T05:35:58.9033333+00:00
ZoeHui-MSFT 34,351 Reputation points
3 answers

MSSQL Server 2019 std edition EOS date

When is the end of support (EOS) date for Microsoft SQL Server 2019 Standard Edition?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-07T11:16:05.56+00:00
Sariethv 0 Reputation points
answered 2024-06-11T05:20:49.1233333+00:00
Olaf Helper 42,361 Reputation points
2 answers

SQL 2012 error

Does anyone know how to solve this error? TITLE: Microsoft SQL Server 2012 Setup The following error has occurred: Locating the SQL Server Browser service component failed with Windows Installer return code '2'.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
asked 2024-06-08T19:38:49.3433333+00:00
ramon corvo 0 Reputation points
answered 2024-06-11T05:20:17.8466667+00:00
ZoeHui-MSFT 34,351 Reputation points
0 answers

Unexpected truncation error when inserting from UTF8 to non-UTF8 collation

I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,574 questions
asked 2024-06-11T00:42:42.9533333+00:00
Ben 0 Reputation points
edited a comment 2024-06-11T05:05:36.5966667+00:00
Viorel 113.7K Reputation points
2 answers One of the answers was accepted by the question author.

NTWDBLIB.DLL is not loadable

When I run the SQL Server Client Network Utility, the DB-Library Options show the ntwdblib.dll as not loadable.And the service is legacy which has to use the same ntwdblib.dll and can't afford to use latest/different sql library. Does anyone know why the…

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.
13,027 questions
asked 2024-06-06T12:19:16.49+00:00
Gnanasoundari 20 Reputation points
accepted 2024-06-11T04:34:34.67+00:00
Gnanasoundari 20 Reputation points
2 answers

WHY Index Scan Instead Of Seek While Joining Big Table With #Temp Table

In my sql server 2016 database, I have a table 'BigData' having around 50 million rows and a Temporary table #TempID which contains 600 rows. CREATE TABLE BigData (ID INT IDENTITY(1,1) PRIMARY KEY, OtherID INT, Comment nvarchar(max),…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,027 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,574 questions
asked 2024-06-10T11:46:44.9033333+00:00
Vikrant Sirohi 0 Reputation points
edited a comment 2024-06-11T03:45:37.8833333+00:00
Vikrant Sirohi 0 Reputation points