Power Bi to SQL
Details: "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'"
Help with SQL Express installation
Hello guys, I need help in installing SQL express. I've been getting this error whenever I try to install it.
errors in Cart Count update, items not adding Cart, and Cart Total is not updating
Thank you in advance, Can you help me remove the errors? My github Link:Thibaut501/Mango. errors are Count of items cannot be updated, Items is not adding to Cart and Order Total is not updating on Applying Coupon .Discount is not appearing also. its…
SQL and Power BI
Hey Everyone, hope you all are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect…
find mds team
hello I need to speak directly with Mr. Tyler Graham from the master data services team
the request failed or the service did not respond in a timely fashion sql 2022
59 I have the following error while I connect to SQL Server Configuration Manager I changed the built in account to Local System according to internet advices but it didnt work. This error message occured. I also replaced the files in…
CXSYNC wait type appearing on Queries that didnt normally have it and TimeOuts occurr
In Azure SQL Managed Instnace: Queries that are complex but run in a timely way normally ... sometimes start getting this wait: CXSYNC_PORT and run until our App timeout threshold of 30sec. This has happened for various databases on the same Managed…
Error Deploying Azure QuickStart API Builder: SQL Database Unavailable in any location
Hi all, I'm new to azure and am on the free trial and I have been trying to follow this guide to get started on APIs within Azure, https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart-azure-sql. But once I get to deploying the static web…
Remove SQL 2022 Web Edition Product Key
We need to export a small SQL server and hand it off to another organization. The problem is the SQL server is using our product key for SQL. Is there a way to remove the SQL product key so it will be blank and make them enter in a new key? I have been…
SSIS Tutorial Lesson-1-6 cant Find dbo.DimDate table in AdventureWorks2012 Database
Hi, I recently started practicing SSIS-tutorial, and am in Tutorial -- Lesson 1-6; While executing the steps in the document, under the Heading "Add and configure the Lookup Date Key transformation" I couldn't find 'dbo.DimDate' table in…
Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”
Hello, I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.” I have attached a screenshot of the deployment details and included the error message…
In the UK South region, we face SQL Server login issues. The ensureCreated method fails with “Login failed for user ‘myUsername’.”
In the UK South region, we are experiencing issues with the SQL Server login. Although we are using the correct username and password, the login fails when attempting to call the method ensureCreated from Entity Framework, we encounter the error:…
How to fix 400 error in logic app with form recognizer data to database
I'm trying to process blob invoices through a form recognizer and straight into a table in my database but get a 400 error stating, "A value must be provided for item". I mapped the data correctly and it goes to the appropriate rows when i…
How Create a linked server to Dataverse from SQL Server
How Create a linked server to Dataverse from SQL Server ? I would like to know if i can use linked servers to do this and what are the correct properties for the connection. Thanks!
Procedure to Restore a Replica to a More Recent Backup in SQL Server Replication
I'm encountering an error while synchronizing the replication schedule. Here is the error message: The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading…
SQL Server 2022 upgrade fails
I have 3 instances; I was able to upgrade 2 of them no problem. However, I get a bogus error when upgrading the last one, The drive containing the sql binaries have 7GB free, the upgrade needs 115MB, yet it fails due to lack of space! Error: …
tsql sum amount recursively without recursive cte
Hi, I need help creating recursive query to sum up Amounts of all ChildIDs for parent ID=1 node. Table definition and data below. This is for SQL serverless where Recursive CTE is not supported. So left join would do, The table is large and the query…
I Cannot Install SQL Server Due To "Target principal name is incorrect. Cannot generate SSPI Context" Error
I have issues about installing SQL Server on my PC. So as I didn't install it, I can not connect to any database server and really couldn't find a solution on other platforms like stackoverflow. Any help will be appreciated
SQL Server Login with view to only one database
Hi I have a request to create a SQL account on my Instance of SQL 2014 I want the user to connect to instance - Done And have read write access to only 1 schema - Done view only 1 database - Not working out How i can i restrict user to see only 1…