Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
118
questions
1
vote
1
answer
654
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
257
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
237
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
224
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
884
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
36
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
43
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
83
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 ...
1
vote
0
answers
795
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
0
votes
1
answer
118
views
Can Microsoft SQL Server Management Studio run on macOS?
I know Microsoft SQL Server 2016 can run on macOS in a Docker container. But does can Microsoft SQL Server Management Studio run on macOS?
4
votes
2
answers
12k
views
Unblocking Windows 10 Defender Firewall for MS SQL Server 2014
I have an instance of MS SQL Server 2014 (call it MSSQL) on a Windows 10 machine (call it WINTEN).
Running SSMS on WINTEN, I can connect to both the local SQL Server and also to SQL Server instances ...
0
votes
1
answer
55
views
Selecting the Correct Display Item Field when Adjusting Fonts in SSMS 2017
I am trying to use adjust the font color in SSMS 2017 and
it's hard to find which Display Items certain symbols fall under.
1) Where do T-SQL commas fall under?
2) How can I find out? Is there a ...
0
votes
0
answers
149
views
visual studio and SSMS flash and close instantly when openned
Yesterday I was working normally, left work with my computer open by simply locking it.
Today I come in and it's shutdown so I power it up, boots properly.
I try to start my workday by openning ...
5
votes
1
answer
4k
views
SSMS version number
I had SSMS version 13 on my Win 8.1 64bits machine, and just downloaded the latest 16.5.3 SSMS. After installation, the SSMS I opened is still under version 13.0.16106. I tried restarting the ...
5
votes
2
answers
10k
views
SQL Server Management Studio CPU and RAM usage keeps increasing for no reason
I have a weird problem with SQL Server Management Studio, version 11.0.2100.60. When I was writing some query, sometimes the CPU gets hogged, and RAM usage keeps increasing.
Usually closing and ...
7
votes
6
answers
36k
views
what can I do if an application doesn't recognize horizontal scrolling?
I have a mouse with a horizontal scroll wheel (the MX Master by Logitech), but the horizontal scrolling is only recognized by some applications (e.g. Excel and Chrome).
Other applications (like SQL ...
2
votes
1
answer
3k
views
Always encrypt connection from SQL Server Management Tool
I've noticed that the "Encrypt connection" checkbox seems to default to unchecked.
Is there a way to default this to being checked?
1
vote
1
answer
153
views
SSMS 2016 fails to save settings
By default, SQL Server 2016 is configured to store data and logs in
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA
and backups in
C:\Program Files\Microsoft SQL Server\MSSQL13....
1
vote
0
answers
907
views
Can't associate SSMS 2016 to .sql Files
I recently installed SSMS 2016 on my windows 7 machine. When I view a directory of .sql files, I notice that they all have a text file icon image for them and the file type is simply "SQL File". ...
0
votes
1
answer
1k
views
SQL query to count each person's longest string of consecutive scores of 7
I've got a SQL table that looks like this (with the name in column A and the score in column B):
N. Name Score
1. Jim 7
2. Jim 4
3. Jim 4
4. Jim 7
5. Jim 7
6. Jim ...
0
votes
2
answers
1k
views
SSMS 2016 16.3 (13.0.15700.28) Visual Studio 2015 Shell error
SSMS 2016 16.3 will not start displaying "Cannot find one or more components..." message.
Tried repair, uninstall, reinstall, no luck with any of that. Any ideas how to fix this issue?
0
votes
0
answers
400
views
Default to Windows Authentication for SSMS login
After launching SQL Server Management Studio 2012, the "Connect to Server" prompt is displayed. In the "Authentication" dropdown, it defaults to "SQL Server Authentication", which I have used in the ...
1
vote
2
answers
5k
views
SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation
I'm on Windows 7 Professional SP1.
I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
0
votes
1
answer
1k
views
SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only
I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
0
votes
0
answers
2k
views
Unable to open SSMS from run window
I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012.
For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
1
answer
805
views
Windows 7: unable to copy-paste directory path in "Save File As" dialogue box
I am attempting to save a .sql file from Sql Server Management Studio to a non-default directory location. I would like to be able to copy the directory path from an open Explorer window and paste it ...
1
vote
0
answers
151
views
SSMS2012 Help going to Chrome rather than MSIE
Running Win7 Ent 64bit
From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
0
votes
1
answer
66
views
SQL server connects after browser restart
I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled .
...
1
vote
0
answers
766
views
SSMS and SSDT requires administrator
I connect to a client's Server (Server 2012R2) via RDP.
I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
0
votes
1
answer
335
views
Why can't I select the font I want for the SSMS 2012 Text Editor?
I like to use the Source Code Pro font published by Adobe. When I try to change the font of the text editor in SQL Server Management Studio 2012 it doesn't appear in the list. If I select one of the ...
13
votes
5
answers
41k
views
Clean reinstall SQL Server Management Studio
I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well.
Then, I installed ...
1
vote
1
answer
373
views
SSMS view designer - how do I give a table an alias?
I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.
Case in ...
18
votes
8
answers
32k
views
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then ...
0
votes
1
answer
53
views
SSMS query editing: possible to remove a field and have the matching value removed?
I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for ...
1
vote
0
answers
615
views
Changing font color in SSMS for different database elements?
I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
1
vote
1
answer
1k
views
Can't open SSMS - stating I don't have permissions
Whenever I try and run SSMS I get the following error.
'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. '
The dialog box ...
0
votes
1
answer
73
views
Check for unique rows, but ignore one particular column
I have an XML document, that looks like this:
Column A to S with headers, and there are 1922 rows.
This is an backup of some SMS, and I want to get rid of duplicates.
The problem is, that the Time ...
1
vote
1
answer
161
views
SSMS 2008 is stuck because Connect to Server window is hiding
Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
1
vote
1
answer
85
views
Is there any way to Start SSMS connected to registered server
Is there any way to start SQL Server Management Studio to connect to a registered server?
I have managed to get it to start from the command line connecting to the desired DB with the use of the -S -...
2
votes
1
answer
2k
views
How can I connect to sql server from a different domain/network
I installed SQL Server 2008 R2 on 6 machines. They are to be placed in 2 offices, 3 in each.
I created a database instance and I used VB6 and was able to link both perfectly.
I was also able to ...
0
votes
2
answers
1k
views
SSMS starts without login prompt and stays inactive
recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
1
vote
1
answer
58
views
Default text for SQL scripts
In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text?
I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
1
vote
1
answer
1k
views
SQL server replication, subscription to remote server : issue while choosing the publisher
I am trying to create a subscription to a remote server having SQL 2008 R2
the client PC is connected through VPN to the server and can discover it successfully.
I can even connect to the database ...
1
vote
2
answers
6k
views
Errors during installation SQL Server Management Studio (ssms) on 64-bit Windows7
I have been trying to install SQL Server Management Studio (ssms) on a 64-bit Windows7 for two days now and it just doesn't work.
On a otherwise completely clean 64-bit Windows7 system I get the ...
0
votes
1
answer
230
views
SQL Server Management Studio 2005 SQL dump
How can i create a SQL dump (structure and data) with the Management Studio 2005 or the MS SQL server?
3
votes
1
answer
2k
views
How do I change the default format for an date time value copied from SSMS to Excel
I often copy the results of a query from Sql Server Management Studio to Excel because I can fiddle with sorting and filtering of results faster using Excel's built in tools than by changing the query ...
3
votes
1
answer
119
views
SSMS 2008 indent on line break
I'm tired of using Tab key when I pressed Enter and Tab Key in SSMS editor because when I have something like this:
CREATE PROCEDURE SP_Example
BEGIN
SET NOCOUNT ON
SET DATEFORMAT ...