Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
0
votes
1
answer
248
views
After installing SQL Server Studio 2017 with Integration and Reporting services, in the Integration Services Catalogs- Create New Catalog shows error
SQL SERVER Management Studio 2017 - The error says "The catalog backup file 'C:\SQL\SHARED\X64\140\DTS\Binn\SSISDBBackup.bak" could not be accessed.
Is this error fixing requires "Integration ...
0
votes
1
answer
2k
views
SQL Studio Management Studio Import/Export wizard crashes when attempting to import a flat file
I'm having a strange issue with users who try to import a flat file into an SQL database. It happens immediately when they click Import Flat File, they never actually get into the Wizard. (right-click ...
0
votes
0
answers
12
views
SSMS runs very slowly if even a medium number of rows are returned in Results Pane
I'm using SSMS 2017 and have an issue that means as soon as I have even a small number of rows (10,000)the user experience lows down. I do have Redgate SQL tools installed, but colleagues have the ...
0
votes
1
answer
27
views
How to configure Microsoft SQL server management visual studio
TITLE: Connect to Server
Cannot connect to desktop-57.
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was ...
1
vote
1
answer
727
views
Check Status of All SQL Services
I wanted to List all the SQL Services including Reporting Services.
Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId
This one will give all ...
0
votes
0
answers
275
views
Allow access to SQL Server Management Studio only to admin account
I would like to allow only administrators to access to SQL Server Management Studio using "Windows autentication". How can I avoid simple users to access with Windows autentication? Or in alternative ...
0
votes
1
answer
253
views
failed to connect to server when using default instance
When trying to connect to a database using the default instance name [server]\[instance] I get:
Cannot connect to RT-WEB\SQLEXPRESS
--> A network-related or instance-specific error occurred ...
0
votes
1
answer
236
views
SQL Import/Export Provider not Registered
I am using SSMS "008 R2 on my Windows 10 64 Bit PC and when I try to use the import wizard to import from a spreadsheet (Office 365 ProPlus 64 Bit) I get an error message which says The 'Microsoft.ACE....
0
votes
1
answer
951
views
SSMS increase size of box Avaiable Databases
In SSMS (SQL Server Management Studio) there is a meny item Available Databases. I would like to increase the size of that box since there is some databases with long name that I would like to see the ...
0
votes
1
answer
39
views
using Sql Management Studio 2008 list past connections
when you open up sql management studio you can select server, and get a list of remembered connections. I don't care about getting pw and but I would like a list of remembered or past connections. ...
1
vote
0
answers
45
views
open SQL Server Management Studio from another machine
I have SQL Management studio installed on my VM and I use VDI to access VM. the only reason i login into VM to access the SSMS. Is there is any way i can open the SSMS from VDI without login in to VM? ...
2
votes
1
answer
4k
views
SSMS wont give up file associations
Apparently this is a known Win10 bug and should hopefully be fixed in an upcoming update.
I have installed SQL Server Management Studio v17.9 on a clean Windows 10 installation. This associated all ....
0
votes
0
answers
3k
views
I get "rsProcessingAborted" and "rsErrorExecutingCommand" randomly in my SQL Server Report builder report
I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first):
An error ...
0
votes
1
answer
84
views
How to get rid of mixed language in Microsoft SQL Management Studio 2017
A German version of SSMS 2017 is already preinstalled on my machine. I want to get the English version.
After re-installing the English version, my UI is mixed up with half English, half German.
How ...
45
votes
1
answer
14k
views
SQL Server Management Studio graphical glitches
I had installed SQL Server Management Studio 2014 and 2016 and the 2016 version had a strange behaviour. I uninstalled it and installed 2017, but it had the same behaviour. What happens is that some ...