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 Contributor140KViews3likes42CommentsError 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 Contributor119KViews2likes31Comments"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 Contributor116KViews2likes27CommentsOutlining 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 Contributor8.1KViews2likes23CommentsODBC drivers for Ubuntu 22.04
I recently installed Lubuntu 22.04 and following these instructions 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, CaldeiraGCaldeiraGMay 11, 2022Copper Contributor77KViews9likes18CommentsChange the timezone for date/time - Arizona
Hello, I am in Arizona with no daylight saving. The SQL database I am pulling date/time codes has nightmarish Epoch (INT) fields for the date/time fields and it's in Eastern Time Zone. I figured out how to convert the code to date / time. However, HOW do I change the Eastern Time ZONE to either Pacific (Spring/Summer) or Mountain (Fall/Winter)?? Unfortunately, there is no Arizona Time Zone for MS SQL. Convert(varchar,DATEADD(MILLISECOND, CAST(RIGHT(Completed_Date, 3) AS INT) - DATEDIFF(MILLISECOND,GETDATE(),GETUTCDATE()), DATEADD(SECOND, CAST(LEFT(Completed_Date, 10) AS INT), '1970-01-01')),22)as 'PBI Completed Date' Thank you!SolvedHopeisgood1Mar 27, 2025Copper Contributor185Views0likes16CommentsSQL 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 Contributor3.2KViews0likes15CommentsUpgrade 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 Contributor850Views0likes14Commentswhere 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.4KViews0likes14Comments
Resources
Tags
- Data Warehouse68 Topics
- Integration Services58 Topics
- sql server54 Topics
- SQL44 Topics
- Reporting Services43 Topics
- Business Intelligence36 Topics
- Analysis Services33 Topics
- Business Apps22 Topics
- analytics22 Topics
- Big Data14 Topics