SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
Error loading report.rdlc,Unable to copy bin\debug\
Good afternoon again, I have already searched for information online, but I have not been able to find the error. The error is the following: An error occurred during local report processing. The report definition has not been specified, the file is not…
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…
Can I drop or disable the default NT Service Accounts from SSMS Logins?
The following accounts are automatically created upon SQL Server installation: NT SERVICE\SQLWriter NT SERVICE\Winmgmt NT SERVICE\MSSQLSERVER NT SERVICE\SQLSERVERAGENT If I am using a seperate domain account to use as SQL…
VS 2022 ReportViewer Error: "The report cannot be displayed. The report viewer could not find a report definition."
Please help me with this problem I'm having. I'll start by explaining my problem: I need to load reports, and for that I'm using the native reports of VS 2022. Here's what I've done so far: I created my .xsd file called DataSetInformes.xsd I added my…
SSRS report - image has phantom borders
I am showing an image in a table row. Image border is turned off, but it still shows some: Any idea why? Thanks
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
Ubuntu 22.04 - The install the ODBC driver error
Here is the result of the trying to build docker image with installing the ODBC driver: RUN apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql18: 0.361 Hit:1 http://ports.ubuntu.com/ubuntu-ports jammy InRelease 0.440 Hit:2…
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
How to use SSL Wildcard Certificate in SSRS 2016
I am trying to use an SSL wildcard certificate in SSRS but so far I have no luck. I am able to access http://ServerName:80/ReportServer but not https://myReports.mycompany.com/ReportServer. The error I am getting is that the page cannot be displayed. Do…
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
Logic app to on-premise SQL server connectivity using service principle (Azure AAD)
Hi Team, Our Agenda is to connect On-premise SQL server using Logic app with SQL server connector. We successfully setup Azure AAD with On-premise SQL. Also, using SSMS we are successfully able to make connection to on-premise SQL using service…
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
EvntAgnt event error 3007
Hi Support, Our SQL server have an error 3007 on the EvntAgnt: Error opening event Error opening event log file State. Log will not be processed. Return code from OpenEventLog is 87. Any idea?
inquiring about ldf rebuild and log restore
Hello, I am inquiring about ldf rebuild and log restore Recently, the ldf file failed during log restoration, and the LDF file was recreated through database detach, attach, and LOG REBUILD. After that, I wanted to proceed with the restoration of the…
How do I retrieve License Information(Software Assurance specifically) for my Microsoft SQL server ( 2012 Standard)
I have a "Microsoft SQL Server 2012 (SP4-GDR) (KB4583465)" standard edition installed on my Windows Ec2 instance (not AWS license, it is BYOL.) I do not have the information or ID to login to Microsoft volume licensing…
Connect to On-Prem SQL server in ADF using Azure Relay
Hi, I want to connect to on-prem sql server and run a SQL view to fetch data in ADF. I am looking for options how we can achieve this using azure relay? Need a detailed steps and answer for this.
Transferring MS SQL license from test server to production server
Hi all, I've seen the following below in the MS SQL licensing guide and would like to clarify if I am able to transfer my license from my test server to my production server, once every 90 days? We are looking to use standard editions for both MS SQL…
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …