19,246 questions with SQL Server-related tags

Sort by: Updated
0 answers

Installing Full-Text using Evaluation version to my licensed standard version MSSQL

Hi, I have install licensed MSSQL standard version in my server, and I want to install full text addon to it, I lost my old ISO installer, I wonder if can I install the addon using eval version, will it broken my current license? Thanks

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,820 questions
asked 2024-10-11T07:43:07.2266667+00:00
Arson Marianus 0 Reputation points
0 answers

Installing Full-Text using Evaluation version to my licensed standard version MSSQL

Hi, I have installed MSSQL standard version in my server with a license, but I lost yang original ISO installer, I wonder, if I want to add addon like Full Text, can I do it using eval version, without broker my current license? Thanks

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,820 questions
asked 2024-10-11T07:38:50.2833333+00:00
Arson Marianus 0 Reputation points
2 answers

How to fix my shared datasource when I cannot find it?

My shared datasource was set up before I began to work with SSRS. I have reports that run well except when I change them in production they do not accept the current shared datasource any more. What do I do to fix this so I can modify a SSRS report in…

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,924 questions
asked 2024-10-10T19:46:23.6233333+00:00
Melvin, Sylvia (NIH/NIEHS) [C] 0 Reputation points
answered 2024-10-11T05:30:40.96+00:00
Olaf Helper 44,656 Reputation points
1 answer

OBCD Native Client Error

Currently receiving this error when trying to operate within a module in our WMS. -checked timeout session; set to 0 -Tried most recent drivers OBDC 17/18; along with OLE DB driver Currently running Windows Server 2022 & SQL Server Management Studio…

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,820 questions
asked 2024-10-10T23:55:47.1+00:00
Nicolas Aranda 0 Reputation points
answered 2024-10-11T04:37:41.36+00:00
Olaf Helper 44,656 Reputation points
0 answers

Sql Server problem on windows 11

hello guys, I have been facing this issue on windows 11, about sql server not working. I got a solution from here https://video2.skills-academy.com/fr-fr/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size It was able…

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,820 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,652 questions
asked 2024-10-10T07:50:54.36+00:00
vet mckye 0 Reputation points
commented 2024-10-11T04:34:27.7166667+00:00
Olaf Helper 44,656 Reputation points
1 answer One of the answers was accepted by the question author.

Error while running .dtsx package in development server

Hi Team, I have six .dtsx packages. The packages read flat files and insert the data from the flat files into the database tables. I reset the password of the DB account(account name , say VISH) in the DB server. After resetting, I cloned the MyAppETL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
asked 2024-09-29T08:59:20.51+00:00
Vishnu Narayan 20 Reputation points
accepted 2024-10-11T03:21:53.3366667+00:00
Vishnu Narayan 20 Reputation points
2 answers

good database design - is it safe to use identity column in table a in table b

Greetings, I am trying to make my database better. I have a table called location. It has the following fields defined: locid (PK, smallint, not null) location_code (smallint, not null) description (nvarchar(50), null) Several other tables in my…

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,820 questions
asked 2024-10-10T21:05:00.3466667+00:00
Darryl Hoar 181 Reputation points
answered 2024-10-11T02:54:05.3333333+00:00
LiHongMSFT-4306 27,026 Reputation points
1 answer

EF Core 8 Shadow Properties incur a 255 limit on columns

We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields To get that in EF, we engaged Shadow Properties, and that is working well Unfortunately we found Shadow Properties incur a limit of 255…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,559 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,820 questions
asked 2024-10-01T15:21:02.83+00:00
Bill Stamp 1 Reputation point
commented 2024-10-11T02:38:00.2966667+00:00
JasonPan - MSFT 5,551 Reputation points Microsoft Vendor
2 answers

Use of Unique Index in TSQL

In TSQL what is the significance of having Unique constraints with Not Enforced enabled? Even after creating this I am able to insert duplicates within the table…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,921 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,820 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,639 questions
asked 2024-10-10T07:16:10.43+00:00
SRIVASTAV, SOMYA 0 Reputation points
answered 2024-10-11T02:25:39.1866667+00:00
LiHongMSFT-4306 27,026 Reputation points
1 answer

How to fix this error "Could not load file or assembly System.Runtime ,Version=6.0.0.0..." when opening a query window or any object from SSMS

While opening a new query window or any object from SSMS, it says "Could not load file or assembly System.Runtime ,Version=6.0.0.0 When I am trying to open a query window or click modify a stored proc or create script of any obj table/view etc ,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,820 questions
asked 2024-10-09T07:02:47.8933333+00:00
Vishnu Priya Ravi 0 Reputation points
commented 2024-10-11T02:25:07.27+00:00
CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
2 answers

How to configure AD account to access to MSSQL database ?

How to configure access to MSSQL database using AD service account ?

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,820 questions
asked 2024-10-09T17:03:38.24+00:00
AZZOUZ Mustapha 0 Reputation points
commented 2024-10-11T02:23:47.5433333+00:00
CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
4 answers

Entra ID Authentication Issues for SSIS Deployment in SQL Server 2022

The scenario involves two users, both configured with Entra ID and the sysadmin role for SQL Server 2022. While one user can successfully deploy SSIS projects to the target SSIS catalog, the other user encounters an error message stating: "The…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,123 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 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,789 questions
asked 2024-10-04T21:14:32.7466667+00:00
David B Forbush 10 Reputation points
answered 2024-10-10T21:32:42.68+00:00
Raja Pothuraju 6,445 Reputation points Microsoft Vendor
2 answers

Unable to install CU on SQL 2019 Express

We have a server running SQL Express 2019 build 15.0.2120. I am not able to install CU 28 or CU 1 for that matter. The remote registry service is running, I am running the installer with full admin rights, disk has ample space etc... The installer states…

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,820 questions
asked 2024-10-09T20:13:54.0466667+00:00
rr-4098 1,501 Reputation points
commented 2024-10-10T20:28:22.74+00:00
Erland Sommarskog 111.4K Reputation points MVP
5 answers One of the answers was accepted by the question author.

Exit code (Decimal): -2068052377Error Invalid command line argument. Consult Windows Installer SDK..please help me fixing this

Log folder path C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220218_192800

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,820 questions
asked 2022-02-18T14:25:57.053+00:00
Raman R 51 Reputation points
commented 2024-10-10T19:58:54.55+00:00
Erland Sommarskog 111.4K Reputation points MVP
1 answer

Setting up SQL server and database I did not have option to choose location US (East)

I got this error when setting up sql server: "Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another…

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,820 questions
asked 2024-10-09T18:12:13.83+00:00
Linda Mitchell 0 Reputation points
commented 2024-10-10T19:28:46.9466667+00:00
NIKHILA NETHIKUNTA 2,555 Reputation points Microsoft Vendor
2 answers

SSRS encryption key issue.

Ive done the deal to move SSRS to a new server. This server serves as both the new SSRS install as well as having SQL installed and houses the SSRS metadata DB's. It should be noted that both SSRS and SQL run under a different service account on the new…

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,924 questions
asked 2024-10-08T22:18:25.2566667+00:00
chrisrdba 431 Reputation points
commented 2024-10-10T18:56:20.2766667+00:00
chrisrdba 431 Reputation points
0 answers

Currently we are using Microsoft Azure SQL RTM developer edition 100 CAL licensed , my management asking me increase the Existing core values from 1 to 4 , how to do this with out any cost involving , is it possible ? pls share How to increase the cores .

Currently we are using Microsoft Azure SQL RTM developer edition 100 CAL licensed , my management asking me increase the Existing core values from 1 to 4 , how to do this with out any cost involving , is it possible ? pls share How to increase the cores…

Azure SQL Database
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
142 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
15 questions
Azure Business Process Tracking
Azure Business Process Tracking
An Azure Integration Environment feature used by organizations to set business context over the transactions that are being processed by Azure Logic Apps.
5 questions
asked 2024-10-10T07:56:40.1633333+00:00
Srinivas Naraipeddi 0 Reputation points
commented 2024-10-10T16:55:38.9733333+00:00
Vijayalaxmi Kattimani (Quadrant Resource LLC) 5 Reputation points Microsoft Vendor
1 answer

Access Azure Server database from azure portal without ip whitelist

I configure my Azure SQL server, such that Azure services is allowed to access my sql database server. But when login to azure and accessing my db, it is giving me error on ip not whitelisted. What need to be configured more if I do not want to add ip…

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,820 questions
asked 2024-10-10T12:21:08.26+00:00
Vanessen Munisamy 0 Reputation points
answered 2024-10-10T16:19:20.6066667+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
1 answer

Azure SQL Managed Instance - How does the new database created in the portal reference the restored database from on-prem?

Hi All, I`m in the process of migrating SQL databases from on-premise to Azure SQL Managed instance. I have followed the "back up and restore" outlined here…

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,820 questions
asked 2024-10-10T10:00:28.03+00:00
Scott Evans 0 Reputation points
commented 2024-10-10T15:24:19.35+00:00
Mahesh Kurva 240 Reputation points Microsoft Vendor
0 answers

SQL Server Linked Server Authentication Issue After Windows 11 Upgrade

After upgrading client machines to Windows 11, SQL Server Linked Servers configured with "Be made using login’s security context" authentication stopped functioning, resulting in the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.…

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,820 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,652 questions
asked 2024-10-10T14:24:57.1766667+00:00
Veronika Komarov - X 0 Reputation points