Forum Widgets
Latest 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.Yao MingNov 02, 2017Copper Contributor139KViews3likes42CommentsError 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 ------------------------------Abdelrazek-rizkJul 29, 2022Copper Contributor115KViews1like31Comments"Object reference not set to an instance of an object. (SqlManagerUI)"
I have installed SSMS 18.10 and I have connected to Azure SQL Managed Instance, then trying to edit SQL Agent Job always failing to open and resulting is this error "Object reference not set to an instance of an object. (SqlManagerUI)". Here is the full error. Object reference not set to an instance of an object. (SqlManagerUI) ------------------------------ Program Location: at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.OnDeselecting(Object sender, TabControlCancelEventArgs e) at System.Windows.Forms.TabControl.OnDeselecting(TabControlCancelEventArgs e) at System.Windows.Forms.TabControl.WmSelChanging() at System.Windows.Forms.TabControl.set_SelectedIndex(Int32 value) at System.Windows.Forms.TabControl.ControlCollection.Remove(Control value) at System.Windows.Forms.Control.ControlCollection.Clear() at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.InitializeControls() at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition..ctor(CDataContainer dataContainer, IMessageBoxProvider messageProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems.CreateJobStepSubSystemSsis(AgentSubSystem agentSubSystem, CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems.CreateJobStepSubSystem(AgentSubSystem agentSubSystem, CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider, IServiceProvider serviceProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems..ctor(CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider, IServiceProvider serviceProvider) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.get_SubSystems() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.FilterStepCombo(DatabaseEngineEdition engineEdition) at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeStepCombo() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeData() at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.OnInitialization() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode() at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control) at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(ISqlControlCollection control, IServiceProvider provider) at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.OnDoubleClick(Object sender, MouseButtonDoubleClickedEventArgs args) at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseButtonDoubleClicked(HitTestResult htArea, Int64 nRowIndex, Int32 nColIndex, Rectangle rCellRect, MouseButtons btn, GridButtonArea headerArea) at Microsoft.SqlServer.Management.SqlManagerUI.SqlManagerUIDlgGrid.OnMouseButtonDoubleClicked(HitTestResult htArea, Int64 rowIndex, Int32 colIndex, Rectangle cellRect, MouseButtons btn, GridButtonArea headerArea) at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseDown(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at Microsoft.SqlServer.Management.UI.Grid.GridControl.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.RunDialog(Form form) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at System.Windows.Forms.Form.ShowDialog() at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()SolvedNamassivayaOct 27, 2021Copper Contributor114KViews2likes27CommentsOutlining not working in SSMS 18.x and 19.x
Edit, This problem is also present in SSMS 20.1, Does Microsoft care at all, or are they not capable of fixing this? In SSMS 18.x and 19.x, the outlining feature that allows you to collapse SQL code often stops working, i.e. the+/- next to the code disappears and neither shortcuts or clicking in the menu will collapse code. I have tried to uncheck outline statements in the option under intellisense and then recheck it, but that makes no difference. Closing SSMS and restarting sometimes helps, but after a while I'm back to the same problem. I have never had this issue in SSMS 17.x Does anyone else have this problem, and how do you solve it?SolvedMartinxNSep 15, 2021Brass Contributor7.6KViews2likes21CommentsODBC drivers for Ubuntu 22.04
I recently installed Lubuntu 22.04 and following these instructionsto 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, CaldeiraGCaldeiraGMay 11, 2022Copper Contributor75KViews9likes17CommentsSQL 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 ------------------------------Rouzbeh_TalebiMay 21, 2020Copper Contributor33KViews0likes16CommentsSQL 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 HolgerDixusNov 14, 2023Copper Contributor2.9KViews0likes15CommentsUpgrade 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 solutionsvaclavnaselAug 27, 2024Copper Contributor753Views0likes14Commentswhere should i start ssis or ssas
Hi i want to ask after installing and all .. first from where should i start.. like first i have SSIS package or SSAS paakcage? if SSIS first will be create then how i integrate that package in SSAS? kindly suggest.. i want to use adventurework databaseBakhtawar A.Mar 13, 2024Copper Contributor2.2KViews0likes14CommentsSQL Server 2019 CU22 (KB5027702) does not install correctly - crashes the server
Attempted to install SQL Server 2019 CU22 (KB5027702). Installation did not complete and I was unable to restart the database engine any more. Got the following error message: "SQL Server is in script upgrade mode" I had to uninstall this update, please investigate.SolvedM_RusuAug 17, 2023Copper Contributor6.5KViews1like14Comments
Resources
Tags
- Data Warehouse64 Topics
- Integration Services58 Topics
- sql server43 Topics
- Reporting Services41 Topics
- SQL36 Topics
- Business Intelligence35 Topics
- Analysis Services29 Topics
- Business Apps22 Topics
- Analytics18 Topics
- Big Data11 Topics