Recent Discussions
SQL Server installer unable to download the required files
Dear Community, I wanted to install the developer edition, however, I keep getting this error message: "We failed to download the files we require. Please check your network connection and try again." My network connection is working fine; however, my local disk is almost full. If that's the reason the installer is failing, is it possible to force it to download to another disk? Thanks.Error with my SQL Server 2022 preview Import and Export Wizard
=================================== An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard) =================================== Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.DtsWizard.DTSWizardForm.GetPageSize() at Microsoft.SqlServer.Management.UI.WizardForm.OnLoad(EventArgs args) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard) ------------------------------ BUTTONS: OK ------------------------------
ODBC drivers for Ubuntu 22.04
I recently installed Lubuntu 22.04 and following these https://docs.microsoft.com/it-it/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu18 to install the ODBC drivers but apparently MS hasn't packaged msodbcsql18 or 17 for this version. Any ETA for those to be released? Related question: https://askubuntu.com/questions/1407533/microsoft-odbc-v18-is-not-find-by-apt Thanks, CaldeiraG
SQL server Installation Problem on Windows 10 (Windows is installed in MacBook)
Hello, The SQL server cannot be installed in windows 10, which is on MacBook. I tried many times, but I was unsuccessful. The error is: TITLE: Microsoft SQL Server 2019 Setup ------------------------------ The following error has occurred: The system cannot find the path specified For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0xF57C3D6F%25400xDC80C325 ------------------------------ BUTTONS: OK ------------------------------SQL Server not returning (all) rows (Schrödingers Database)
Hi, i haven't seen this in 20 years of my experience. We tried nearly everything to figure out what's happening here. I hope someone can explain this.. The facts: There is a view that returns a list of records. It has been noticed that rows are missing in the result set (at the end in powerbi reports). To make it clear what happens, please look at those queries. For my understanding this is impossible, but this is the real result: The record with id 9952 is missing in select * query. It's returned when selected explicitly ( where id = 9952). Its not returned when using >= or <=. What I tried: - rebuild all indexes - created a new table and new views even without indexes The behavior was still the same. So have you seen something like this before? This scares me and i want to understand it. And i need to fix our reports. Kind regards HolgerUpgrade values in table
Hello ALL, I need to retrieve values a cost, a rate to a table, which are stock in another table. It is table fs_sro_labor_mst and Those tables have a mutual column. It is work_code. Total count the work codes is 2 934. How can I figure out this issue? Thanks for all solutions
Need help to figure the solution for recent vulnerabilities report in my DB host server.
Dear Experts, During recent scans, below vulnerability was reported in my Stage database server, this is my current DB version Microsoft SQL Server 2019 (RTM-CU23) (KB5030333) - 15.0.4335.1 (X64). This scan item we keep coming on every scan item and need to a proper solution to fix. we have applied the patch- KB5030333 but still issue was reported. Even though planning to apply the Jan 2024 patch SQL db patch but i'm not confident if the patch will fix this scan or not as this scan item is coming from 2023 July onwards and after that we have applied JNS and OND patches as well. but again in jan scans this item came in. Need your expertise to understand the real cause of this scan and how to fix the same. Note: I'm very new to SQL DB and started learning from last 4-5 months. Vulnerability Title Vulnerability Description Vulnerability Proof Vulnerability Solution Microsoft SQL Server Obsolete Version: Remote An obsolete version of the Microsoft SQL database server is running. Note: When the support period ends for a Microsoft SQL Server product, no further patches will be provided even for serious security problems. * Running TDS service * Product SQL Server 2008 found in fingerprint is not SQL Server 2000 * Product SQL Server 2008 found in fingerprint is not SQL Server 2005 * Product SQL Server 2008 exists -- Microsoft SQL Server 2008 10.0.2531 Upgrade to the latest version of Microsoft SQL Server Download and apply the upgrade from: https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftechnet.microsoft.com%2Fsqlserver&data=05%7C02%7Cmahesh.selagamsetty%40hcl.com%7C7feb58435e10487c1cd708dc05e2d187%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C638391719557359451%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YMtDgwTVRyJeloCDaST0gcvQwRB6hXT%2FucSzpuxtfbE%3D&reserved=0Using a Sequence
Consider this table: CREATE TABLE [Events]( [EventID] [int] NULL, << Other columns >> and this Sequence: CREATE SEQUENCE [NewEventID] AS [int] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CACHE and this Stored Procedure; CREATE PROCEDURE [Insert_Event] << Parameters >> AS BEGIN INSERT INTO [Events] ( EventID, << Other fields >> ) VALUES ( NEXT VALUE FOR NewEventID, << Other fields >> ) END GO When I run this procedure, I get this error message: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET. None of those conditions are true so why am I getting this error message?
how to upgrade Browser for SQL Server 2022 16.0.1000.6 and Microsoft VSS Writer for SQL Server 2022
We need to upgrade ‘Browser for SQL Server 2022 16.0.1000.6’ and ‘Microsoft VSS Writer for SQL Server 2022 16.0.1000.6’ in order to be SOC2 compliant, we use SentinelOne application vulnerability scan reports as SOC2 evidence and SentinelOne is reporting these as vulnerable and so we are forced to remediate. We have Microsoft SQL Server 2022 (RTM-CU14-GDR) (KB5042578) - 16.0.4140.3 (X64) installed on top of Windows Server 2022 Standard We bought the server(s) from Dell with Microsoft SQL Server 2022 (RTM-CU14-GDR) (KB5042578) - 16.0.4140.3 (X64) installed on top of Windows Server 2022 Standard and we have access to the installation files for both Windows Server 2022 Standard and Microsoft SQL Server 2022 however they are both the same versions as what we currently have. We installed the cumulative update(s) SQLServer2022-KB5038325-x64.exe but this did not upgrade Browser for SQL Server 2022 or Microsoft VSS Writer for SQL Server, after some research it seems that the way it is done is buy upgrading to the latest version of Microsoft SQL Server 2022, have I missed something? … we are surely not the first to be in this situation and would appreciate some guidance. Am I correct in thinking that the only way is to get ahold of a current installation ISO of Microsoft SQL Server 2022? Any input is appreciatedBACPAC: Could not import package. SQL72012
Hi SQL-guys, I'm running into this error during the last days and could not find a solution: I am trying to import a database .BACPAC file from SQL Azure into my local SQL Server. When doing so, I get this error on my local machine: Could not import package. Warning SQL72012: The object [mydb_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box. Warning SQL72012: The object [mydb_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box. I found this post (among with others...): https://www.sqlservercentral.com/Forums/PrintTopic1886371.aspx sp_configure 'contained database authentication', 1; GO RECONFIGURE; GO Interestingly, this reconfiguration worked once some days ago with another database. But now, I'm stuck, it doesn't work for me. [ I even installed the latest version of SQL Server Management Studio (SSMS) 17.2 from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms but without success. ] Tips anyone? thx! ToniOpen reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's like https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage at https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport might be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URL https://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?
Recent Blogs
- We’re happy to announce that SQL Server 2025 Release Candidate 1 (RC1) now includes preview support for Red Hat Enterprise Linux (RHEL) 10, expanding our commitment to modern, secure, and flexible Li...Sep 17, 2025
- English follows Japanese. こんにちは、 SQL Server サポート チームです。 今回は、SQL IaaS Agent 拡張機能と Azure 上の SQL 仮想マシン リソースについて解説します。 SQL Server IaaS Agent 拡張機能とは SQL Server IaaS Agent 拡張機能は、Azure Porta...Sep 17, 2025
