18,493 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

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,196 questions
asked 2024-07-04T16:13:24.5433333+00:00
Ashwin Kanumoori 40 Reputation points
edited the question 2024-07-04T16:19:34.11+00:00
Ashwin Kanumoori 40 Reputation points
1 answer

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,196 questions
asked 2024-07-04T14:38:30.8166667+00:00
Gaston N Escobar 0 Reputation points
answered 2024-07-04T15:51:33.63+00:00
Erland Sommarskog 105.4K 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,196 questions
asked 2024-07-04T11:21:48.9433333+00:00
Stephen Keogh 0 Reputation points
accepted 2024-07-04T15:50:20.36+00:00
Stephen Keogh 0 Reputation points
1 answer

I am trying to access SQL Server hosted in Azure VM from Azure function app

I am trying to access SQL Server hosted in Azure VM from Azure function app, but getting connection timeout error while connecting through it.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,470 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,196 questions
asked 2024-07-04T13:03:53.9366667+00:00
Ritika Pandey 25 Reputation points
edited an answer 2024-07-04T15:48:21.93+00:00
Nikhil Duserla 645 Reputation points Microsoft Vendor
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,196 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 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,650 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,684 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,196 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,512 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,196 questions
asked 2024-07-04T08:57:15.2166667+00:00
Luca Guenzi 0 Reputation points
accepted 2024-07-04T09:38:10.54+00:00
Luca Guenzi 0 Reputation points
0 answers

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,196 questions
asked 2024-07-04T07:29:39.15+00:00
MERT CAN ÖZBAY 0 Reputation points
edited the question 2024-07-04T09:33:27.27+00:00
Erland Sommarskog 105.4K Reputation points MVP
1 answer

side effects of giving permissions to run traces

Hi All, I would like to know the downsides of giving permissions to run traces in lower environments (DEV/QA/UAT). Our DB team has only two members: one supports PST hours, and the other supports IST hours. The PST resource is on leave for a month, so I…

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,196 questions
asked 2024-07-04T08:23:42.3466667+00:00
Sam 1,456 Reputation points
answered 2024-07-04T09:28:58.5033333+00:00
Erland Sommarskog 105.4K Reputation points MVP
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,571 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,820 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,196 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,569 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
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,196 questions
asked 2024-07-01T15:15:18.72+00:00
Chaitanya Kiran 776 Reputation points
commented 2024-07-04T09:10:46.9166667+00:00
Erland Sommarskog 105.4K Reputation points MVP
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,196 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
2 answers

Automatic startup of SQL server when configured with SCCM.

I have configured SCCM with a remote SQL server in the same domain, and it is working fine. When I stop the SQL server in the remote machine, it gets started automatically in a few minutes. I want to know who is responsible for automatically starting…

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,196 questions
Microsoft Configuration Manager
asked 2024-07-01T13:52:21.2366667+00:00
Sathis Babu 0 Reputation points
edited a comment 2024-07-04T07:44:37.93+00:00
Sathis Babu 0 Reputation points
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,196 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,201 Reputation points Microsoft Employee
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,196 questions
asked 2024-07-04T04:46:59.23+00:00
Ashutosh Olekar 0 Reputation points
answered 2024-07-04T06:52:39.3333333+00:00
MikeyQiaoMSFT-0444 1,510 Reputation points
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,196 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,196 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,854 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,196 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,512 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,196 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,510 Reputation points