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 ------------------------------
BACPAC: 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! ToniUpgrade SQL Server 2016 to 2019
Is there any known issues in upgrading from SQL Server 2016 to 2019? Can it be done by a SQL novice or do you need to have more knowledge to perform the upgrade? We currently are using Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) Thank you for any suggestions or help you can provide.
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
database in suspect mode
Hi, there, I'm experiencing a tough issue for me. When I was updating the some columns into the database I have previously install, the main memory corruption led the database jump into the suspect mode. I follow the following steps to recovery the database: 1. EXEC sp_resetstatus 'dbNSFP'; 2. ALTER DATABASE dbNSFP SET EMERGENCY; 3. DBCC CHECKDB('dbNSFP'); 3. ALTER DATABASE dbNSFP SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 4. DBCC CHECKDB (dbNSFP, REPAIR_ALLOW_DATA_LOSS); 5. ALTER DATABASE dbNSFP SET MULTI_USER; When I was in 1st step, MS SQL Server Management Studio gives: Warning: You must recover this database prior to access. Completion time: 2020-06-21T11:33:19.6094013-04:00 When I was in 2nd step, the Studio reports error: Msg 5011, Level 14, State 7, Line 3 User does not have permission to alter database 'dbNSFP', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 3 ALTER DATABASE statement failed. Completion time: 2020-06-21T11:34:47.5199727-04:00 I've been search this solution for several days. Some cues are pointing change the alter permission to the user. However, I'm a SA user, SA should hold all CONTROL permissions. I have been stuck here for days. Hope someone could help me out.
How to increase SQL query performance of a view?
Hi everyone, I am new to Microsoft community, so please let me know if this post is not in the right forum and if so which one would be the right one. issue: - Update & query (using Power BI) of my Sales Weekly View takes forever (>30min) and I would like to understand how I could improve this Current setup: - Sales Daily View: View containing aggregation and joins of two main sales tables and a date table - Sales Weekly View: View joining the "Sales Daily View", a sales table and two dimension tables and containing extensive logics (mainly aggregations) Please let me know if you have any idea how to streamline this and improve the performance of the view.
SQL Server Connectivity Issues - Ideas
I have to admit that have no knowledge about connectivity and setup of remote SQL servers. I usually have everything set up by knowledgeable IT support. In my current case the best I can say about the support is that they are either not willing or able - choose either. Therefore, I have to check myself what I can do. I had to do the remote settings myself; in context of me doing it myself the first time, this might be useful information. The remote access works fully for out data integration tool (Jitterbit) and usually (:-)) on my own devise using SSMS 18.11.1. "Usually" means that I get error messages about network connectivity too often too work fluently. Product used on the remote server: SSMS 18.11.1 with SQL Express 2019 Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to connect to server 45.155.172.169. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ 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 accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-53-database-engine-error ------------------------------ The network path was not found ------------------------------ BUTTONS: OK ------------------------------ SQL Server Configuration: TCP Port enabled for Standard Port 1433 Windows Defender Firewall: Inbound Rules set for Standard Port 1433 Connectivity errors appear either with WLAN or LAN, in our office or in my home office. Any checks or recommendations to improve the accessibility that I can do myself are welcome. If it's server related I have to check with our support partner.
SQL 2019 Fails to Start - Error 17051
I have a fairly significant set of issues that I cannot figure out how to resolve that has brought down a bunch of systems. A windows update occurred and the SQL 2019 RC1 server rebooted itself (do not believe that this error is related just coincidental). This error indicates that the SQL Server evaluation period has expired. Upon reviewing the startup logs this concurs with my belief: I am confused about why I am running into this issue as I am running a developer version of SQL and not the evaluation version but none the less it currently appears to be a problem. To attempt to resolve this issue I have done the following: Attempted to do an edition upgrade and set everything back to developer and the process ran and completed successfully but the service will still not start. Attempted to upgrade editions to a licensed version of SQL (which I do also own) and I cannot complete the upgrade because the SQL server is not running. I attempted to follow instructions to turn back the computer time and set common files registry entry to "3" in an attempt to trick it into being active so that I could upgrade. My system automatically reverts the time back to the standard time almost immediately. Attempted to turn off network connection to disable time sync Defaulted the time settings for windows Unjoined the server from the domain thinking GPO might be interfering This system MUST be restored. Any ideas you have on how to get it back up and running again would be seriously appreciated!
SQL Server download version for university student
Hi I just download SQL server express edition which comes out with SQL Server Configuration Managment. I don't know if I download the right version of SQL Server for personal use. I need it to be install for school study and personal learning. The screenshot below doesn't look like a easy use software for sql. I tried to start with insert CSV files. Is anyone knows the instruction of the server? Thank You JLHelp - Cannot continue the execution because the session is in the kill state.
I try to execute a update query in SQL Server 2016 (v13.0.5026.0) and get these error messages: UPDATE tableName SET fieldName1 ='a long query with some html tags and all it has 3600 chars' WHERE fieldName2 = 12345 And get this error, Msg 596, Level 21, State 1, Line 0 Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. As Microsoft website suggested, I tried an update to Cummulative Update(CU6) and changed to 13.0.5292.0 It says CU1 update has to fix it but doesn't solve the issue. This query creates a dump file, and the log has the following message: SqlDumpExceptionHandler: Process ID generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. The same update query works on other table in the same database. Any help would be great.Can not able to import Excel File into SQL
Hi Team, I mostly working with Excel. Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns) For getting some results, excel is hanging or taking more time and more functions. But SQL is very fine to get results within seconds. Problem is while importing excel file (Ver. 2007) it shows an error (Please find attached file) But, It allows to import excel file of 97-2003 file format. i.e xls. For getting result, i am saving "xlsx" file into multiple "xls" files (Coz, xls having 65536 rows only) Single "Xlsx" file of 8 lakh records saved as 16 "Xls" files contains 50000 records per file. And importing them into MS SQL Server. Solve this.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 ------------------------------
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
