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
1answer
26 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
90 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
102 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 ...
0
votes
1answer
89 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 ...
2
votes
1answer
38 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
0answers
32 views

How to install SSMS using Azure Automation DSC?

configuration InstallSSMS { #Import the required DSC Resources Import-DscResource –ModuleName 'PSDesiredStateConfiguration' Node InstallSSMS { Package SSMS { Ensure = "...
0
votes
0answers
15 views

How to specify overwrite file when creating a maintenance plan for full nightly backups

I don't see how to specify that the backup file (a full nightly backup of a particular database) should overwrite the previous night's file, when creating a maintenance plan using the Wizard or using ...
0
votes
1answer
68 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
58 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 ...
0
votes
1answer
97 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
33 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 ...
3
votes
1answer
133 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....
2
votes
0answers
803 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. ...
7
votes
3answers
1k 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 ...
0
votes
1answer
362 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....
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
579 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
237 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
798 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
234 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 ...
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 ...
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
0answers
192 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
276 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="...
7
votes
3answers
10k 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, ...
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 ...
1
vote
1answer
1k 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
1answer
563 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 ...
9
votes
2answers
4k 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 ...
2
votes
1answer
16k 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....
1
vote
0answers
364 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 ...
1
vote
0answers
24 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 ...
5
votes
1answer
62 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, ...
0
votes
1answer
45 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 ...
0
votes
1answer
51 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 ...
-1
votes
1answer
180 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 ...
1
vote
1answer
990 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 ...
1
vote
1answer
38 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, ...
2
votes
4answers
1k 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-...
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 ...
1
vote
1answer
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 ...
-1
votes
1answer
1k 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 ...
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 ...
0
votes
0answers
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, ...
1
vote
1answer
87 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
3
votes
1answer
5k views

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See http://technet....
1
vote
1answer
129 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...