17,986 questions with SQL Server-related tags

Sort by: Updated
3 answers

How does large on-prem SQL database with multiple files fill up

I got a large database with one filegroup having multiple data files spread across 2 disks. But one of the 2 disks is larger than other, with all data files on both disks have Autogrowth disabled, and the value "is_autogrow_all_files" is set…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-30T07:00:47+00:00
Kumar 1 Reputation point
commented 2024-05-06T06:24:36.54+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…

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.
12,760 questions
asked 2024-05-04T23:34:12.1833333+00:00
Albert Kirpach 0 Reputation points
answered 2024-05-06T06:23:35.1266667+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
2 answers

Will the MS SQL Server 2022 STD License and Windows Server 2019 OS License works on same Hardware after System motherboard get replaced

Hello, I had a HP Proliant ML30 Server running Windows Server 2019 STD and MS SQL Server 2022 STD running with license. Recently the motherboard got issue and HP said to get it replaced. So i have a question about its license if it will work normally…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,173 questions
Microsoft Partner Center API
Microsoft Partner Center API
Microsoft Partner Center: A Microsoft website for partners that provides access to product support, a partner community, and other partner services.API: A software intermediary that allows two applications to interact with each other.
316 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
36 questions
asked 2024-04-30T11:08:19.5033333+00:00
Hitalkumar Chheda 0 Reputation points
commented 2024-05-06T06:23:25.2433333+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

Contact Microsoft support

How can i contact Microsoft for direct support for my issue?

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,245 questions
asked 2024-04-30T15:09:09.4633333+00:00
Jefferson 426 Reputation points
commented 2024-05-06T06:19:52.23+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Connect to Linked Server Database using Azure Data Factory

Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,604 questions
asked 2024-05-02T09:28:02.6766667+00:00
Keren Osler 60 Reputation points
accepted 2024-05-06T06:19:21.2933333+00:00
Keren Osler 60 Reputation points
2 answers

Migrate On prem to Azure Sql Managed instance

I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…

Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
950 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.
12,760 questions
asked 2024-04-23T17:46:35.1533333+00:00
commented 2024-05-06T06:18:14.07+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

Can i use SQL 2022 Express edition in production environment for my small business?

Can i use SQL 2022 Express edition in production environment for my small business?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-22T08:49:44.7+00:00
Amit Prakash Koli 0 Reputation points
commented 2024-05-06T06:17:48.1266667+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

unable to connect to our reports from ssrs

We are unable to connect to our Microsoft 2019 reporting server reports after installing certificate. I have try connect with with these option: http://ip/reports http://servername/reports I was also altered rsrepotsser.config file to get things…

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,807 questions
asked 2024-05-04T14:37:38.8466667+00:00
Gregg Pfeifer 0 Reputation points
answered 2024-05-06T06:17:20.36+00:00
Olaf Helper 40,901 Reputation points
5 answers

SQL Server Express 2022 Reinstall

Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled 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.
12,760 questions
asked 2024-04-19T06:14:14.86+00:00
Francois Timms 0 Reputation points
edited a comment 2024-05-06T06:17:17.1+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
1 answer

syspolicy_event_queue disabled automatically

The msdb service broker queue syspolicy_event_queue is disabled automatically, messages are not processed and keep growing until taking full drive space. Here is the error message from Log File Viewer : I have sql server 2022, CU12. I have executed the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-18T08:58:26.8+00:00
Hammi Amine 0 Reputation points
commented 2024-05-06T06:16:35.08+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
1 answer

SQL server backup in a 2019 VM to s3 using backup URL

Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,173 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,381 questions
asked 2024-04-18T04:47:01.0433333+00:00
Pradeep 21 Reputation points
commented 2024-05-06T06:16:19.87+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

How can you enforce restrictions on user access to a database table, preventing indirect access through views, procedures, or GUI operations, without relying on SQL scripts?

The question is about securing access to a database table in such a way that restrictions apply even when users access the data indirectly through views, procedures, or GUI operations, all without using SQL scripts.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-17T09:47:19.2133333+00:00
Shabnam A. Shaikh 0 Reputation points
commented 2024-05-06T06:16:01.04+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
4 answers

Tail log backup

Are tail log backups supported only in Full Recovery model?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-16T14:09:24.11+00:00
Chaitanya Kiran 696 Reputation points
commented 2024-05-06T06:15:42.9633333+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
4 answers

GDR upgrade path question

I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-15T20:47:18.0366667+00:00
Ryan Schmitz 0 Reputation points
commented 2024-05-06T06:15:02.7533333+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
3 answers

How to subscribe to Microsoft for CU updates

I will like to subscribe to Microsoft so that I can get the latest CU patches immediately Microsoft have a release. How do I go about this? Please can someone send the SPECIFIC LINK to get this done

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-15T14:05:36.84+00:00
Martins 0 Reputation points
commented 2024-05-06T06:14:25.98+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

How to Fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I am doing a Import Data from an Excel spreadsheet to a table. I get the following message : Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. What will resolve this error?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-12T15:06:30.7966667+00:00
Steve Clark 21 Reputation points
commented 2024-05-06T06:13:50.85+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

connect to server

TITLE: Connect to Server Cannot connect to.... ADDITIONAL INFORMATION: 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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-11T17:37:27.1566667+00:00
KKIRUI 0 Reputation points
commented 2024-05-06T06:13:11.9766667+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
1 answer

Azure Data Share to Share data from Azure Managed Instance SQL Server

As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
45 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.
12,760 questions
asked 2024-04-26T06:54:52.4633333+00:00
Balan Murugan 41 Reputation points
commented 2024-05-06T06:12:54.7266667+00:00
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee
1 answer

Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019

Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 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.
495 questions
asked 2024-04-09T20:16:55.67+00:00
Robert Carter 0 Reputation points
commented 2024-05-06T06:12:14.2366667+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
2 answers

TITLE: Microsoft SQL Server 2014 Setup ------------------------------ The following error has occurred: An error occurred during the installation of assembly 'Microsoft.VC80.CRT,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchite

i am unable to download it , i am gettimg an error

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions
asked 2024-04-04T12:27:47.1733333+00:00
Gaurav Thakare 0 Reputation points
commented 2024-05-06T06:11:00.4333333+00:00
LucyChen-MSFT 1,045 Reputation points Microsoft Vendor