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
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
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…
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 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…
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…
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…
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…
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…
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…
How to configure AD account to access to MSSQL database ?
How to configure access to MSSQL database using AD service account ?
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…
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…
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
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…
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…
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…
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 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…
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'.…