How to connect my c# application to my phpmyadmin database from my NAS?
Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…
How to parse SOAP XML in SQL Server and show as table
DECLARE @xml XML ='<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header /> soapenv:Body <ns0:GetListResponse xmlns:ns0="urn:Consultaurartmasiva1"…
What is the function difference between MS SQL Standard and Express
What is the function difference between MS SQL Standard and Express in MS SQL 2017
Removing database from AG
I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
SQL error during install
Getting the following error when installing SQL express 2022: The file SQLEXPR_x64_ENU.exe version 16.0.1000.6 must be in the same directory as this installer. Place the file in this directory and try again.
Is it correct to make connection string dynamic?
Hi, I'm currently working on a project which need data from other databases. The database where I'll get the datas are depends on users. Now I want to make my connectionString dynamic. Is it correct to make connection strnig dynamic. The user will enter…
How to fix this error in Microsoft SQL: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout expired...
Hello, Kindly advise how to solve below issue: we have one job that's failing is Microsoft SQL. This issue is affecting the Power BI reports as well. Below error is found: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query…
Why isn't code working as an expression for parameters in SQL Server Reporting with connection to Databricks SQL Warehouse using Simba Spark
Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)…
Unable to connect to private linked SQL server from azure web apps
I have a group of linux web apps with VNet Integration enabled on a subnet called web-tier and an azure server with private link configured on another subnet called data-tier. I have also added nsg rules to the data-tier subnet nsg to allow inbound…
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
sql data store is causing errors on sql server 2022
We have recently upgraded our servers to SQL Server 2022, and are currently hosting three Microsoft SQL servers running version 16.0.4015.1. We have enabled the query store on all of our databases, with between 5 to 9 databases hosted per server. Since…
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
Dataset format needed for azure blob storage
How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…
SSMS not flagging basic errors after IIF statement
DMF_SSMS_SQL_IIF_Err.pdf I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
SQL Server Snapshot Agent suddenly getting error 1130 when trying to connect to Azure File Storage
I have the following SQL Server Replication Setup Publisher server is an Azure SQL Managed Instance, Subscriber server is the same server Storage is Azure File Share I'm trying to setup replication from a database on a managed instance (DB_1) to another…
Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0 returns invalid HTML for Reserved.ReportViewerWebControl.axd?ResourceStreamID=Blank.gif
The HTML returned by the reporting services viewer is missing the " at the end of the src attribute. It's resulting in: <img…
how to specify folder for backup command when using sqlcmd
Sql Server 2019 express edition. I am trying to setup a backup (temporarily) using task scheduler in windows 10. I have sqlcmd as the command. I have -S mymachine\sqlexpress -U myuser -P myuserpass -i c:\mytools\backupdbcommand.sql In the…