Questions tagged [ssms]
SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
192
questions
1
vote
0
answers
22
views
Haproxy blocking more TCP requests than expected
In short HAproxy is blocking my TCP requests while I expect not to be and found nothing in logs.
Here the interesting part of my haproxy file :
global
log /dev/log local0 debug
log /...
- 133
-1
votes
1
answer
39
views
Backup MSSQL database via disk (no SSMS no command line)
Our Windows server is having issues but before running disk repair, I want to take a backup. At the moment I'm using SystemRescure (the Linux utility) and I have successfully saved files.
The only ...
- 99
0
votes
0
answers
173
views
SSMS 19 issue with AWS RDS
still pretty new to SQL administration so please bear with me. We recently updated to SQL Server Management Studio 19 and have been running into issues.
The long and short of it is I am trying to get ...
0
votes
0
answers
537
views
How best to allow SQL Agent Jobs to be edited and run by a team of developers, without handing out Sysadmin rights?
I'm trying to find or devise a way to allow a team of developers to be able to amend SQL Agent Job steps and schedules, but that doesn't involve Sysadmin rights for the devs. As I can't assign ...
- 13
0
votes
1
answer
641
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 ...
- 11
0
votes
1
answer
495
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 ...
google-cloud-platform
1
vote
1
answer
2k
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 ...
- 11
0
votes
1
answer
385
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 ...
- 11
0
votes
1
answer
649
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?
...
- 101
0
votes
2
answers
873
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
1
answer
603
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 ...
- 8,214
2
votes
1
answer
168
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 ...
- 1,583
0
votes
1
answer
74
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
1
vote
1
answer
798
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 ...
- 111
0
votes
1
answer
2k
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:\...
- 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 ...
- 181
1
vote
1
answer
62
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 ...
- 195
3
votes
1
answer
375
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 ...
- 173
0
votes
1
answer
103
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....
- 229
2
votes
0
answers
1k
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.
...
- 141
8
votes
3
answers
3k
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 ...
- 264
0
votes
1
answer
729
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....
- 735
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 ...
- 455
0
votes
1
answer
1k
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/....
- 123
1
vote
1
answer
313
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 '.....
- 13
0
votes
1
answer
2k
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 ...
- 1,984
0
votes
1
answer
603
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
1
answer
119
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 ...
- 193
3
votes
0
answers
3k
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 ...
- 954
2
votes
0
answers
310
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 ...
- 21
0
votes
1
answer
497
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="...
- 33
8
votes
3
answers
16k
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, ...
- 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 ...
- 21
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 ...
- 11
0
votes
1
answer
815
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 ...
- 1
13
votes
3
answers
7k
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 ...
- 263
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....
- 173
1
vote
0
answers
463
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 ...
- 5,597
1
vote
0
answers
28
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 ...
- 43
5
votes
1
answer
92
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, ...
- 151
0
votes
1
answer
49
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
1
answer
53
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 ...
- 229
-1
votes
1
answer
217
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 ...
- 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 ...
- 127
1
vote
1
answer
47
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, ...
- 229
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-...
- 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 ...
- 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 ...
- 173
-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 ...
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 ...
