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
0 votes
0 answers
62 views

Can't login to SSRS (SQL Server Reporting Services) using SSMS (SQL Server Management Studio)

I'm having an issue logging on to my reporting server via SSMS. I use the same hostname\instance found in the reporting server config GUI at the top. This used to work, but I have made some changes ...
user avatar
0 votes
0 answers
40 views

Can SQL Server Users have limited read only in SSMS and read-write in the .net application?

Our software requires the business users (of the software) to have read and write access to the database (MS SQL Server). The users are added to an active directory group with this SQL permission. The ...
user avatar
0 votes
0 answers
44 views

Azure Managed Instance - Virtual Machine Whitelisting

I am having quite a few problems with setting up an Azure VM that is linked to an Azure Managed Instance SQL Server. The aim of this is to be able to setup a linked server in SSMS that can connect to ...
user avatar
0 votes
1 answer
108 views

Accessing SQL Server Remotely - Connection fails when attempting to connect with new external domain

The Scenario is: Right now, we can remotely access SQL server using SSMS or a ODBC connection using the SQL driver. We are currently using sql1.mydomain.com We are switching to sql2.mydomain.com. When ...
user avatar
0 votes
1 answer
365 views

Which is my SQL server name for connecting to the online database by SSMS?

I created a database 'dbDemo' (MS SQL Server 2012) by Plesk on Google Cloud Platform and for connecting to this database from another local machine I changed the TCP Port 1433 on my online server ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
  • 11
0 votes
1 answer
170 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 ...
user avatar
  • 11
0 votes
1 answer
451 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? ...
user avatar
0 votes
2 answers
648 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 ...
user avatar
0 votes
1 answer
343 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 ...
user avatar
  • 8,204
2 votes
1 answer
100 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 ...
user avatar
  • 1,463
0 votes
1 answer
73 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 * ...
user avatar
  • 1
1 vote
1 answer
396 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 ...
user avatar
0 votes
1 answer
900 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:\...
user avatar
  • 1
3 votes
1 answer
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 ...
user avatar
1 vote
1 answer
53 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 ...
user avatar
  • 195
3 votes
1 answer
271 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 ...
user avatar
  • 173
0 votes
1 answer
59 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....
user avatar
2 votes
0 answers
940 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. ...
user avatar
  • 141
8 votes
3 answers
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 ...
user avatar
  • 264
0 votes
1 answer
639 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....
user avatar
  • 691
0 votes
1 answer
4k 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 ...
user avatar
0 votes
1 answer
932 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/....
user avatar
  • 123
1 vote
1 answer
292 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 '.....
user avatar
  • 13
0 votes
1 answer
1k 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 ...
user avatar
  • 1,864
0 votes
1 answer
341 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 ...
user avatar
1 vote
1 answer
94 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 ...
user avatar
3 votes
0 answers
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 ...
user avatar
2 votes
0 answers
293 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 ...
user avatar
  • 21
0 votes
1 answer
393 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="...
user avatar
  • 33
8 votes
3 answers
14k 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, ...
user avatar
  • 241
2 votes
2 answers
5k 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 ...
user avatar
1 vote
1 answer
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 ...
user avatar
  • 11
0 votes
1 answer
739 views

How to Set (and get as well) Minimum server Memory and Maximum server Memory of a SQL Server Instance using T-SQL Query

I want to set Minimum and Maximum server Memory for a SQL Server using T-SQL. I am able to do it using SSMS->Object Explorer->Server Properties but don't know how to do it using T-SQL commands. Along ...
user avatar
13 votes
3 answers
6k views

Can't see second azure sql database in SSMS object explorer

I have created a second database on my existing Azure SQL server. The first database works fine and I can see it using SSMS. I cannot see the second database in the object explorer. Autocomplete ...
user avatar
  • 243
3 votes
1 answer
20k views

Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"

On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016....
user avatar
1 vote
0 answers
410 views

Unable to remotely connect to SSIS catalog

I have an SSIS installation on which I can not connect through our Citrix hosted Sql Server Management studio. I can connect to it when running SSMS locally. But if I try to connect remotely, with ...
user avatar
  • 5,527
1 vote
0 answers
26 views

Azure DB Backup Using SQL Server Management Studio

I've read a number of articles here, but, really haven't come across a solution. I'm using SSMS 2016 to manually back up a Azure DB on a regular basis. I do this through the Generate Scripts ...
user avatar
5 votes
1 answer
70 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
user avatar
  • 151
0 votes
1 answer
48 views

How can I export a database to Azure in SQL Server Mgmt Studio 2008?

I'm trying to export a database to Azure using the most recent version of SSMS 2008, and I'm having trouble because I don't have the options listed under "Tasks" that the tutorials I've found indicate ...
user avatar
0 votes
1 answer
52 views

Can a sql job using a DTS package access data from the wrong column? (turned out to be bad join condition)

We are seeing a Sql job / DTS package fail because it is fed non-numeric character data into an int conversion routine. The data looks like with very high probability that it comes from another ...
user avatar
-1 votes
1 answer
195 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
user avatar
  • 131
1 vote
1 answer
1k views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
user avatar
1 vote
1 answer
44 views

SQL SSMS Window Dissappear

When I open SSMS, I choose windows authentication, but the window just goes away; it doesn't say I'm not allowed. I've accessed these db servers before, the exact same way, and it has worked. Now, ...
user avatar
2 votes
4 answers
2k views

Sql Management Studio 2014 wont connect to clustered instance

I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-...
user avatar
  • 71
0 votes
1 answer
2k 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 ...
user avatar
  • 217
1 vote
1 answer
2k views

Shut down operating system by killing task

I came across quite an odd error recently and was wondering if anyone has any insight into it. I can't find any reference to such a scenario on Google so here goes... The rough sequence of events is ...
user avatar
-1 votes
1 answer
2k views

Connect to SQL Server from different network (remote) [closed]

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
0 votes
0 answers
2k views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
user avatar
  • 101