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…
ERROR: +[MSACDBStorage
Microsoft Remote Desktop[6123:433755] [AppCenter] ERROR: +[MSACDBStorage executeQuery:inOpenedDatabase:withValues:usingBlock:]/357 Failed to finalize SQLite statement, result=13 database or disk is full
SQL connection to server error
After i installed Microsoft SQL server i face this problem while trying to connect 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…
How to resolve install failures for SQL Server 2022 Developer edition
I have been trying to install SQL Server 2022 Developer edition without success. After more than 10 attempts I am at a complete loss as to what to do next. I have attached the log of my last attempt and hopefully someone can shed some light on my issues…
How do I fix MSSQL Server 2022 Database Engine Services failing to install?
I have been struggling with this for far too long now. I've reinstalled it twice now with 9 repair tries. Still no luck. I need some help because my classes require it to be installed. Overall summary: Final result: Failed: see details…
How to handle text file with delimiter as ~|~ in SSIS Package
I received text file from external vendor with appears to be Pipe Delimited but it has very unusual character before and after Pipe (|). I am using SSIS Package (VS 2019) to import the data into SQL Server database 2019. I am using SQL Agent Job to…
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
How do I transfer an on-premises license from one corporate user to another?
I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?
Is there any way to connect Hadoop to SSMS other than ODBC Driver.
We have jobs in SSMS. We are experiencing ODBC Error constantly when the job fails. but we could see other job which are running with same ODBC Driver its succeeding. To avoid this issue, we want to know is there any other way that we can connect Hadoop…
how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…
Named Pipes Provider: Could not open a connection to SQL Server
Hi, Named Pipes Provider: Could not open a connection to SQL Server error (53) from public facing Server to Local SQL Server but Local to DMC Server possible Please any one can you advice to me Kind Regards R.Raja
How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation
Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: Database…
Unable to add a index hint to a simple query
I have a table with milions of records CREATE TABLE documents ( id bigint primary key, external_system nvarchar(50), external_docid nvarchar(50)) and non clustered filtered unique index CREATE UNIQUE INDEX documents_ix19 ON…
Do ODBC Linked Servers (MariaDB) support XA Transactions?
My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server with…
How to fix, Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
We have setup the domain controller. Two machines (Windows Server 2019 Standard, 10.0.17763) are added to the same domain(Mac1 and Mac2). From Mac1, we are trying to connect remotely to SQL Server 2019 installed on Mac2. We are using Mix mode…
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
How to verify if a backup "*.bak" is encrypted?
Is there a way to verify if the sql server backup file is encrypted or not? I have a script to turn off encryption before backup; however, I like to verify the backup file *.bak is in fact NOT encrypted before I send out to vendor.
Problem with FINDSTRING in SSIS Expression
Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…
Using SSDT on a build server
I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…
Unable to install Microsoft SQL server 2022
Hi, Recently, I was trying to install Microsoft SQL Server, but the installation stops and this problem appeared I found a summery.txt file in this direction [C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log] and that's what was on it: …