Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssms]

SQL Server Management Studio is an IDE for administering Microsoft SQL Server.

-1
votes
0answers
8 views

SSMS 2012 on a Windows 10 laptop [on hold]

I have a recently got a new Windows 10 laptop and have been experiencing issues with pasting from Sql Server management studio 2012. I have sql embedded in field in our database and so need to copy ...
0
votes
0answers
11 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
0answers
7 views

MSSMS freeze when closing down the application

My Microsoft SQL Server Management Studio keep freezing when trying to close. It use to go well then suddenly it start to do this. This is my third new PC in 2 years and this new one started to do it ...
0
votes
0answers
22 views

SSMS / Server Import and Export Wizard - which screen allow me to update the data during export

I am using SQL Server Management Studio 2016 to export data between databases. In particular, this time, i am using the option to "write a query to specify the data to transfer", but as part of this ...
0
votes
1answer
12 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
1answer
15 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
1answer
16 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
1answer
9 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. ...
0
votes
0answers
22 views

Login analysis service (ssas) using command prompt

I want to login SQL Management Studio (ssms.exe) using command prompt, but want to connect to analysis service server. I tried ssms.exe -S servername -U username -P password in cmd, which connected ...
1
vote
0answers
9 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? ...
0
votes
0answers
11 views

How to change font size? non-editor pane

I see how to change the font and size for editor windows in VS and SSMS. I do not yet see how to change the font size in the non-editor window panes such as Properties, Object Explorer, Registered ...
2
votes
1answer
882 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
0answers
296 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
1answer
36 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 ...
6
votes
1answer
825 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
0answers
309 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
1answer
54 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?
2
votes
2answers
3k 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
1answer
24 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
0answers
36 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 ...
0
votes
0answers
259 views

Sql SSMS slow on certain domain accounts

After days of googling I could not locate the issue. We are on a domain logging into a database on another server using Windows authentication. Some of the computers work super fast some are slow and ...
5
votes
1answer
2k 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 ...
1
vote
2answers
3k 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 ...
2
votes
1answer
557 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
1answer
768 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
1answer
74 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....
0
votes
0answers
495 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
1answer
531 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
2answers
829 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?
1
vote
0answers
352 views

SQL SERVER 2016 Plugin's not working [closed]

Recently I installed SQL SERVER 2016 in my PC Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
0
votes
0answers
131 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
2answers
3k 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
1answer
732 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
0answers
781 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
1answer
527 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
0answers
43 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
1answer
46 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 . ...
0
votes
0answers
464 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
1answer
287 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
5answers
37k 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 ...
0
votes
1answer
200 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 ...
15
votes
8answers
23k 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
1answer
51 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
0answers
523 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
1answer
822 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
1answer
60 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
1answer
109 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
1answer
51 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 -...
1
vote
1answer
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
2answers
461 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 ...