Questions tagged [ssms]

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

Filter by
Sorted by
Tagged with
1
vote
1answer
70 views

SSMS via SSH tunnel

I'm trying to use SSMS to connect via a SSH tunnel (using Putty) to a SQL Server default instance running on an AWS server. I can establish the tunnel and access data in the DB using SQLCMD from a ...
0
votes
1answer
1k views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
0
votes
0answers
16 views

SQL instance IP address pointing to the SQL server hostname

Our SQL instances IP addresses are pointing to the same DNS entry (which is the SQL server name) although the TCP/IP is enabled. My question is, how do you set up the SQL instances IP address and ...
0
votes
0answers
18 views

Whenever I log onto SQL Server using SSMS with SQL Server authentication the logs show my connection plus two others immediately afterwards

When I log into SQL Server 2017 from my desktop using SSMS with SQL Server authentication as user sa, the logs show my connection and IP address plus two others immediately afterwards from local ...
0
votes
1answer
1k views

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system ...
1
vote
1answer
3k views

Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
16
votes
4answers
31k views

Timeout saving table in SQL Server

I'm trying to add a column to a table with much data in SQL Server 2005, using SSMS. So I browse to the table, select Modify, and add the new column. Then, when I press Save, I get the following ...
0
votes
1answer
127 views

sp_xp_cmdshell_proxy_account on a SQL Server Express

I am trying to find information about if there are limitations in SQL Server Express to not being able to run the sp_xp_cmdshell_proxy_account and adding a proxy account for the cmdshell command? ...
0
votes
0answers
10 views

What are the reasons SSMS shows data in a table that doesn't actually exist?

I have never experienced this before. SSMS is displaying data tables with data, when no data actually exists. I have an application (MVC) that interfaces to an SQL server. When I run the ...
0
votes
0answers
159 views

Starting MSSQL's SSIS on Linux and making sure it works

I'm trying to connect with SSIS that was installed on MySQL Server (on RHEL 7). It was installed and configured according to documentation. I can connect to server using SSMS (as Database Engine), ...
0
votes
2answers
180 views

How to allow remote connection to SQL Server instance only to specific public IP Address (white-list) & restrict access to all other IP's [closed]

How do I allow remote connection to SQL Server instance only to specific public IP Address (white-list)? For example, login from SSMS to SQL Server instance hosted on Windows dedicated server ...
1
vote
4answers
9k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...
12
votes
4answers
30k views

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one ...
0
votes
1answer
165 views

SSMS Designer Removing Square Brackets

I am designing a view that accesses tables in a linked server. Every time I paste this query into the SQL pane, Intellisense removes the square brackets, and then complains that there's more than 3 ...
4
votes
4answers
13k views

Results copied from SSMS splitting across columns when pasted into Excel

SSMS 2008 -> Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to ...
2
votes
1answer
43 views

Why can't I restore encrypted backup through front end?

I'm just starting to experiment with encrypting backups, I think I now understand it and have got the process working, but something strange is happening with restoring. On Server A (SQL 2014 ...
0
votes
1answer
430 views

How to install SSMS on a client workstation using Azure Automation DSC?

I found the following post - https://blogs.msdn.microsoft.com/troy_aults_blog/2017/01/13/automating-installation-of-ssms-with-dsc/ Great, all I need to know now is the Product Id of SSMS-Setup-ENU....
3
votes
1answer
1k views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
7
votes
3answers
2k views

SQL Server Management Studio - “Restore from Device” dialog is slow

Whenever I try to restore a database in SQL Server the dialogs take an excessively long time to open. The worst offender seems to be the "Select backup devices" modal sub-dialog from the Restore ...
7
votes
3answers
11k views

Can't run SSMS as another user - requires elevated permissions

On Windows 10 and SSMS 2016, I can no longer start SSMS as another user. I need to be able to do this in order to use trusted authentication to connect to some of my databases. This used to work fine, ...
1
vote
3answers
3k views

Option do not show schema names in SQL Server Management Studio

I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you. This works in ...
0
votes
1answer
69 views

changed the name of the computer - SQL server

i changed the computer name, and entered this commands in SQL server management studio (ssms) sp_dropserver <old_name>; sp_addserver <new_name>, local; i press this query select * ...
1
vote
1answer
2k views

SQL Server 2012 constant CPU load

I'm trying to diagnose an abnormal CPU usage of the sqlservr.exe process from a SQL Server 2012 Express installation. The installation is running in a VM with Windows Server 2012 R2, 8-core Xeon E5 ...
0
votes
2answers
3k views

Export SSMS database connections to a new version

I just installed SSMS 2012 and realized it didn't copy my database list (the one that appears on the 'Connect to Server' dialog). I have a ton of entries there, is there any way I can export them ...
3
votes
0answers
2k views

Restoring database from SSMS UI freezes SSMS

I am using SSMS 17.3. I try to restore a database from the UI, click on 'Device' radio button and click on the ... to select a file, SSMS freezes. I have to kill it. I have to restore databases using ...
1
vote
1answer
94 views

Local Computer drives are not visible when creating backup through wizard

When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are ...
14
votes
4answers
29k views

SSMS: Where does SQL Server store its server names?

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio: Where are ...
0
votes
1answer
169 views

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\...
3
votes
1answer
3k views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on Azure SQL with Active Directory Admin via SSMS

When I attempt to connect to an Azure SQL Server via SQL Server Management Studio using the "Active Directory - Universal with MFA support" method with an account that is configured as the Active ...
1
vote
1answer
38 views

Why do I get different memory numbers using TSQL versus the GUI?

I'm preparing to bump up our max server memory value after a RAM upgrade on our server. I'm testing the commands out on a test SQL Server and I'm not sure why I'm seeing different results with T-SQL ...
2
votes
2answers
4k views

SQL Server Managment Studio 2016 fails to open; multiple errors

Installing this was nothing short of a headache. I had countless issues. In order to install this (16.5.1), I had to uninstall C++ redistributable 14.0.24210, and install version 14.0.23026 in order ...
10
votes
4answers
11k views

Sql Server Management Studio 2008 has suddenly become unresponsive

I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is ...
3
votes
1answer
150 views

Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1

Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10. I can create databases, save data to ...
0
votes
1answer
48 views

Need to add a login to a database for SSMS (Sql server) 2008 r2

I need to add a login to a database for SSMS (Sql server) 2008 r2 There is an answer to a very similar question here: How to add users to SQL Server 2008 Management Studio: https://stackoverflow....
7
votes
1answer
3k views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
2
votes
0answers
837 views

Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user

Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error: Failed to connect to server ___.database.windows.net. ...
11
votes
6answers
19k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
0
votes
1answer
3k views

SQL 17.5 SSMS Install Fails

On a Windows 10 computer, the SQL 17.5 SSMS installation fails. From the logs, it appears that the error is in the VSTA 2015 installation. Running that (vsta_setup.exe) directly fails with the ...
0
votes
1answer
656 views

Automatic deletion of backups and transaction logs leaves broken backup points

TLDR: default log shipping job and maintenance plan are deleting old files from disk but backups are still displayed in SSMS making it very slow to display "Restore" window. How to delete old .trn/....
1
vote
1answer
257 views

Restore incorrect syntax near 'dbname'

I'm trying to restore a db to a new location, using the following in SQL Server Management Studio for Server2012: RESTORE [newdb-name] FROM DISK = '..\backupfile.bak' WITH MOVE 'olddb-name.mdf' to '.....
0
votes
1answer
885 views

Requirements to set up “Run as different user” for SQL Server 2016

Our organization has two types of accounts for server administrators. Both are individual user accounts in Active Directory tied to a given employee. However, they only give system (server and ...
0
votes
1answer
252 views

How to run maintenance plan task on success of two other tasks

I need to run the maintenance plan task on success of two other tasks and only after those tasks have completed. At the moment task2 starts straight away after one of the other two completes and it's ...
2
votes
1answer
3k views

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table ...
1
vote
1answer
71 views

Connecting local SSMS to Sql Server High Availability running on virtual machines in Azure

We are currently running a High Availabilty SQL Server using two VMs in Azure with a Load Balancer. We would like to be able to connect SSMS running locally on our machines to that SQL Server and are ...
4
votes
1answer
6k views

Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio

I'd like to have a list of my database servers (I am a developer), I currently have a list of RDP files for different machines I connect to. Is there a similar feature in SQL Server Management Studio ...
4
votes
2answers
4k views

Weird bug when copying from sql server management studio to excel in windows 7 [closed]

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in Excel....
1
vote
4answers
5k views

Add conditions to maintenance plan sequence on SQL Server

I would like to add a condition to a sequence in my SQL Server 2008 Maintenance Plan. This condition is based on the variable set by a T-SQL Statement Task: declare @primary bit = 0 select @primary=1 ...
2
votes
0answers
214 views

SSMS context menu on temporal (system-versioned) table doesn't show table actions

After enabling Temporal on my table, SSMS groups it with history table and context menu on my table doesn't show table actions, like "Select Top 1000 Rows", "Edit Top 200 Rows", etc. Is there some fix ...
0
votes
1answer
315 views

Interpreting a Deadlock Log / XDL file

I've generated the following XML + XDL: <deadlock> <victim-list> <victimProcess id="processc1eaf13468" /> </victim-list> <process-list> <process id="...
4
votes
8answers
15k views

SQLServer - need to access an ACT! database for data migration

I'm looking for a way to access data in an ACT! database for a data migration to a custom application. The ACT! software uses SQLServer 2005. The data conversion script and new application will be ...