19,185 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Razor core app connects to DB, but integration test fails with Microsoft.Data.SqlClient.SqlException

I have an app that I've been writing and its working well. When I introduced an integration test, its unable to connect to the DB using the exact same connection string. Microsoft.Data.SqlClient.SqlException: 'A network-related or instance-specific…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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,771 questions
asked 2024-09-28T14:36:46.4833333+00:00
Walter 1 Reputation point
edited the question 2024-10-03T09:20:34.05+00:00
Jack J Jun 24,491 Reputation points Microsoft Vendor
2 answers

Microsoft SQL Server, Error: 10054

I have a problem with Microsoft SQL Server Management Studio when I'm at home with a internet that does not have IP address as usually when I'm not in my condo unit and almost sometimes impossible to connect or even list the tables.. but if i use SQL…

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,771 questions
asked 2024-10-02T15:38:06.3566667+00:00
LA METISSE 0 Reputation points
answered 2024-10-03T03:41:20.8333333+00:00
Alberto Morillo 33,861 Reputation points MVP
1 answer

I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.

Please help me fix the following error

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,566 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,804 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,771 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.
532 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,566 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,804 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,771 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.
532 questions
asked 2024-10-02T10:16:50.4933333+00:00
võ thị tuyết ngân 20 Reputation points
edited the question 2024-10-03T01:03:17.45+00:00
Tianyu Sun-MSFT 30,561 Reputation points Microsoft Vendor
1 answer

I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.

Please help me fix the following error

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,566 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,804 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,771 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.
532 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,566 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,804 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,771 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.
532 questions
asked 2024-10-02T10:16:50.4933333+00:00
võ thị tuyết ngân 20 Reputation points
edited the question 2024-10-03T01:03:17.45+00:00
Tianyu Sun-MSFT 30,561 Reputation points Microsoft Vendor
1 answer

Unable to enable Microsoft Entra authentication for SQL Server 2022 in Azure Arc page in azure portal

I tried enabling Entra ID in Microsoft Entra ID and Purview for my on premise SQL Server 2022 server registered successfully in Azure Arc. I have also added key vault access policy to the server name, and enabled network access from the server ip. I…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
411 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,771 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,669 questions
asked 2024-02-20T12:09:59.7666667+00:00
Chew Kok Hoor 30 Reputation points
commented 2024-10-02T23:30:54.57+00:00
Dan Decker 0 Reputation points
3 answers

What is the best choice for this scenario - CTE or View

Hello Team, I have a scenario where in the source data is in an Azure SQL DB. The data in the source is stored in the form of snapshots. For Ex:- Day1 - 500K Records, Day2 - 510K Records - Day3 - 520K Records (Total - 1.53M records). All the tables 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,771 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-02-07T11:11:16.49+00:00
Nagesh CL 646 Reputation points
edited an answer 2024-10-02T22:22:32.6966667+00:00
Raja S 0 Reputation points
1 answer

Logic App Action Get Rows not working

In an azure logic app I have a Sql Server Get Rows action that grabs a value from a previous step to get a result from a Sql Server table. It worked perfectly until recently when I started getting this 500 error: The service provider action failed with…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,125 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,771 questions
asked 2024-09-06T17:08:55.6166667+00:00
Andy Guschwan 6 Reputation points
commented 2024-10-02T20:32:56.9133333+00:00
LeelaRajeshSayana-MSFT 15,076 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Allocated vs. Used Memory in SQL Server Elastic Pool

Hello! I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated…

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,771 questions
asked 2024-10-01T00:41:03.21+00:00
Sinara Medeiros 20 Reputation points
accepted 2024-10-02T19:54:25.6133333+00:00
Sinara Medeiros 20 Reputation points
1 answer

TITLE: Microsoft Visual Studio ------------------------------ Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. ------------------------------ BUTTONS: OK -------------------

i have changed the data types to DT_DBDATE as instructed but when trying to map the fields, it keeps saying I cannot map the currencyDate to the lookup column, FulldatealternateKey, because datatypes do not match

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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-08-14T12:50:28.01+00:00
Joel Manhede 0 Reputation points
commented 2024-10-02T16:34:46.6766667+00:00
Jeremy Rutherford 0 Reputation points
1 answer

TITLE: Microsoft Visual Studio ------------------------------ Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. ------------------------------ BUTTONS: OK -------------------

i have changed the data types to DT_DBDATE as instructed but when trying to map the fields, it keeps saying I cannot map the currencyDate to the lookup column, FulldatealternateKey, because datatypes do not match

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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-08-14T12:50:28.01+00:00
Joel Manhede 0 Reputation points
commented 2024-10-02T16:34:46.6766667+00:00
Jeremy Rutherford 0 Reputation points
6 answers

Miss-mapped columns in SSIS

I have a simple ETL that is selecting columns from tables in one SQL Server database and inserting them into a table in another SQL Server db. The ODBC Source uses a SQL Query. The ODBC Destination is loading directly to the table. All is working…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2020-12-10T18:55:29.767+00:00
Jeff 11 Reputation points
answered 2024-10-02T16:26:55.45+00:00
Clemmo 0 Reputation points
2 answers

What does ADF SSIS Error "Disk Full Exception Caught" mean

Hi, we are running an Azure-SSIS Type Integration Runtime in Azure Data Factory. This morning this IR suddenly got Unavailable for some reason. Fortunately we had the Diagnostic Settings ADFSSISIntegrationRuntimeLogs enabled and I found the following…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,666 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-25T10:26:26.61+00:00
Cedric Ahlers 35 Reputation points
edited the question 2024-10-02T16:20:36.3766667+00:00
Cedric Ahlers 35 Reputation points
1 answer One of the answers was accepted by the question author.

Which recommended included columns to really include in indexes?

Greetings. I just ran sql logScout and sql nexus against a heavily used reporting server during a peak time of day for 10 minutes just to see what it comes back with. About 20 indexes were recommended for the same table. Over the years Ive come to use…

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,771 questions
asked 2024-10-01T17:46:42.66+00:00
chrisrdba 431 Reputation points
accepted 2024-10-02T16:20:15.3966667+00:00
chrisrdba 431 Reputation points
1 answer One of the answers was accepted by the question author.

What ports are required for running SSIS?

What ports are required for running SSIS services? Is port 1856 needed? If so, why?

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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-10-02T13:36:33.2866667+00:00
Effie Lewis 20 Reputation points
accepted 2024-10-02T14:27:26.09+00:00
Effie Lewis 20 Reputation points
1 answer One of the answers was accepted by the question author.

What ports are required for running SSIS?

What ports are required for running SSIS services? Is port 1856 needed? If so, why?

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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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,771 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-10-02T13:36:33.2866667+00:00
Effie Lewis 20 Reputation points
accepted 2024-10-02T14:27:26.09+00:00
Effie Lewis 20 Reputation points
0 answers

SDDL permission changes to allow non-admin service account to SQL Services

I have managed service account with local admin privilege. I created non-admin service account and I want to give it the same permissions as the managed service account has. I got SID and SDDL string. I tried to make changes to SDDL and command prompt…

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,771 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,048 questions
asked 2024-10-02T14:21:50.7166667+00:00
Lucja Dolega 0 Reputation points
2 answers

SQL Server shared LocalDB instance is not automatically starting

I have an application that uses LocalDB. The named instance "PrivDb" is owned by whatever account installed the application. Part of the setup process is to grant "NT AUTHORITY\Authenticated Users" the sysadmin role so that any…

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,771 questions
asked 2024-10-01T15:33:46.8233333+00:00
Cory Riddell 0 Reputation points
edited a comment 2024-10-02T12:28:20.6966667+00:00
Cory Riddell 0 Reputation points
2 answers

Licensing for SQL Enterprise

Dear team, I need to inquire about the licensing of SQL Enterprise; As per Microsoft documentation, if we choose the "per core" licensing model, the required licenses would be based on the number of cores assigned to each server having 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,771 questions
asked 2024-10-01T11:20:32.3566667+00:00
Micheal Mallo 290 Reputation points
commented 2024-10-02T12:21:55.8833333+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

how can i rerun the sql script using DbUp with new modifications?

Hello I am new to using DbUp and when I run a script it runs successfully but when I add some modifications I get this message Beginning database upgrade Checking whether journal table exists.. Fetching list of already executed scripts. No new…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,482 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,771 questions
asked 2024-10-01T11:48:28.9266667+00:00
Saleh Salem 0 Reputation points
commented 2024-10-02T12:19:20.2633333+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

VBscript not running on windows server 2019

Hi All, Our VB Script has been integrated with SSIS package as script task and it work in fine in visual studio IDE . However, it is getting failed to run same VB script block in windows server 2019 environment inside SSISB as a SSIS Package. 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,771 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.
532 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,722 questions
asked 2024-10-01T22:49:57.54+00:00
MasterSQL 0 Reputation points
commented 2024-10-02T11:04:59.2233333+00:00
MasterSQL 0 Reputation points