18,504 questions with SQL Server-related tags

Sort by: Updated
4 answers

DataSource.Error: Microsoft SQL - Power BI

Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process.…

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,207 questions
asked 2024-07-04T14:38:30.8166667+00:00
Gaston N Escobar 0 Reputation points
answered 2024-07-05T05:18:53.1833333+00:00
Olaf Helper 42,761 Reputation points
4 answers

Index Rebuild

I read somewhere that in index rebuild, sql server first creates new index and then drops old on. Is it correct? OR it drops the old index and then creates new index?

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,207 questions
asked 2024-07-01T15:15:18.72+00:00
Chaitanya Kiran 776 Reputation points
edited a comment 2024-07-05T03:13:17.6033333+00:00
MikeyQiaoMSFT-0444 1,590 Reputation points
1 answer

sql server install not properly

TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…

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,207 questions
asked 2024-07-04T04:46:59.23+00:00
Ashutosh Olekar 0 Reputation points
commented 2024-07-05T02:35:55.69+00:00
MikeyQiaoMSFT-0444 1,590 Reputation points
1 answer

SQL SERVER 2022 The system cannot find the specified path

I had previously downloaded SQL SERVER 2022 to my personal computer, but I got an error so I wanted to delete it and install it again. I'm getting a lot of errors when reinstalling, thank God I solved them all but now I can't solve this error, can 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,207 questions
asked 2024-07-04T07:29:39.15+00:00
MERT CAN ÖZBAY 0 Reputation points
edited an answer 2024-07-05T01:57:59.5+00:00
LucyChenMSFT-4874 2,825 Reputation points
1 answer

ISNULL - Clarification on how Nullable on data type affects for resultant columns

Data Creation: Create Table: create table tone_12 ( col_1 varchar(20) NULL, col_2 varchar(40) NULL, col_3 varchar(20) NOT NULL, col_4 varchar(40) NOT NULL, col_5 as isnull(col_1,col_4), col_6 as isnull(col_2,col_3) ) Insert statement: Insert into tone_12…

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,207 questions
asked 2024-07-04T16:13:24.5433333+00:00
Ashwin Kanumoori 40 Reputation points
answered 2024-07-04T20:20:43.8133333+00:00
Erland Sommarskog 105.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

SQL Server 2022 Import and Export Wizard & Microsoft.ACE.OLEDB.12.0

Hello All Please advise on what needs to be done to fix this error << The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine >> All feedback welcome Thanks Steve Microsoft SQL Server 2022 (RTM-CU13) (KB5036432) -…

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,207 questions
asked 2024-07-04T11:21:48.9433333+00:00
Stephen Keogh 20 Reputation points
accepted 2024-07-04T15:50:20.36+00:00
Stephen Keogh 20 Reputation points
3 answers

Training database PUBS

Dear friends, I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please? Thank you very much, Anna

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,207 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,592 questions
asked 2021-05-07T16:47:27.23+00:00
BIVS Databaze 1 Reputation point
answered 2024-07-04T12:13:44.9366667+00:00
Anthony Lesar 0 Reputation points
2 answers

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 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,258 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
commented 2024-07-04T11:55:51.04+00:00
gmuir 0 Reputation points
2 answers

where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit

hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards

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,207 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,518 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
asked 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2024-07-04T11:11:44.27+00:00
Chandrasekar N 0 Reputation points
1 answer One of the answers was accepted by the question author.

can I rearm sql server 2019 trial period? We need to change the server in October and purchase the correct licenses together but the trial time is running out now

We need to change the server in October and purchase the correct licenses together but the trial time is running out now

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,207 questions
asked 2024-07-04T08:57:15.2166667+00:00
Luca Guenzi 20 Reputation points
accepted 2024-07-04T09:38:10.54+00:00
Luca Guenzi 20 Reputation points
4 answers

could not load file or assembly'Microsoft.data.sqlclient'

how to solve this error

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,574 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,396 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,822 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,207 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,574 questions
asked 2023-09-12T17:01:47.29+00:00
Niyati Savaliya 0 Reputation points
commented 2024-07-04T09:27:26.8866667+00:00
Steven Xi 6 Reputation points
6 answers One of the answers was accepted by the question author.

Microsoft SQL Management Studio for Mac

Hi, Is there any Mac version for Microsoft SQL Management Studio? Where can I get it from? Thanks, Jassim

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,207 questions
asked 2023-04-27T10:10:32.4133333+00:00
Jassim Al Rahma 1,546 Reputation points
answered 2024-07-04T09:03:49.37+00:00
Hitesh81 1 Reputation point
0 answers

System Database Backups for Azure SQL Managed Instance

I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…

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,207 questions
asked 2024-06-21T20:35:16.1766667+00:00
Chancellor, Joe 0 Reputation points
edited a comment 2024-07-04T07:26:05.82+00:00
ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
2 answers

Unable to install SQL Server. Exit code (Decimal): -2147467259

I tried to install it, and then after a few minutes i get this error: Unable to install SQL Server. Exit code (Decimal): -2147467259 and those is logs files. Summary_DESKTOP-GDTULCG_20240703_221010.txt Detail.txt

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,207 questions
asked 2024-07-03T19:36:17.05+00:00
Ali Azzam 0 Reputation points
edited an answer 2024-07-04T06:46:04.1+00:00
ZoeHui-MSFT 34,836 Reputation points
7 answers

How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?

I keep getting this error. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service 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,207 questions
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,855 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
asked 2021-05-10T21:06:09.8+00:00
CharlieLor 551 Reputation points
commented 2024-07-04T03:49:54.77+00:00
Ryan 0 Reputation points
1 answer

Opening the SQL "database" with the given login is not possible when utilizing Windows authentication without a username and password.

Machine A and Machine B are the two machines I own. My Java-based application server is on machine A, while my SQL server is on machine B. Both computers are logged in as the same domain user, Administrator, and are part of the 'TEST' domain. Machine B…

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,207 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,518 questions
asked 2024-07-03T11:40:23+00:00
Arivazhagan A 0 Reputation points
edited an answer 2024-07-04T03:25:43.9233333+00:00
LucyChenMSFT-4874 2,825 Reputation points
0 answers

SQL Server is terminating because of fatal exception c0000005

Facing this SQL Server access violation error on SQL Server 2016 (13.0.6435.1) running on Azure VM during startup! Error: 17311, Severity: 16, State: 1. SQL Server is terminating because of fatal exception c0000005. This error may be caused by an…

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,207 questions
asked 2024-07-03T08:08:08.9933333+00:00
Karthick 0 Reputation points
commented 2024-07-04T02:19:20.82+00:00
MikeyQiaoMSFT-0444 1,590 Reputation points
2 answers

MSSQL$MICROSOFT service won´t start automatically after a Win server 2022 restart

I have a client with a Win Server 2022 (10.0.20348) and a SQL server. It turns out that SQL service will not start automatically after a restart. Now, while a restart on a server does not happen every day, I would like to know if there's a way to fix…

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,207 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,518 questions
asked 2024-07-02T16:21:01.23+00:00
Matias G. Keib 0 Reputation points
commented 2024-07-04T01:49:27.1566667+00:00
MikeyQiaoMSFT-0444 1,590 Reputation points
2 answers

How to move images or symbols from folder to SQL server table

How to move images or symbols from folder to SQL server table.

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,207 questions
asked 2024-07-03T05:16:41.1233333+00:00
Anandhswarupp 20 Reputation points
answered 2024-07-04T01:44:49.3733333+00:00
LiHongMSFT-4306 25,326 Reputation points
2 answers

How to import images from folder to SQL server.

How to import images from folder to SQL server.

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,207 questions
asked 2024-07-03T04:37:15.3466667+00:00
nn 0 Reputation points
answered 2024-07-04T01:43:51.94+00:00
LiHongMSFT-4306 25,326 Reputation points