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
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
asked 2024-10-11T07:43:07.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 49%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Arson Marianus
0
Reputation points
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
asked 2024-10-11T07:38:50.2833333+00:00
Arson Marianus
0
Reputation points
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…
asked 2024-10-10T19:46:23.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T23:55:47.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 69%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T07:50:54.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 71%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
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…
asked 2024-09-29T08:59:20.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 88%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T21:05:00.3466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 70%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-01T15:21:02.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 14.000000000000002%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T07:16:10.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-09T07:02:47.8933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 39%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
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 ?
asked 2024-10-09T17:03:38.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 40%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David B Forbush
10
Reputation points
answered 2024-10-10T21:32:42.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-09T20:13:54.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
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
asked 2022-02-18T14:25:57.053+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-09T18:12:13.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 53%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Linda Mitchell
0
Reputation points
commented 2024-10-10T19:28:46.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T07:56:40.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srinivas Naraipeddi
0
Reputation points
commented 2024-10-10T16:55:38.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T12:21:08.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-10T10:00:28.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Scott Evans
0
Reputation points
commented 2024-10-10T15:24:19.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
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'.…
asked 2024-10-10T14:24:57.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 40%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Veronika Komarov - X
0
Reputation points
asked 2024-10-10T14:24:57.1766667+00:00
Veronika Komarov - X
0
Reputation points