Questions tagged [ssms]

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

38 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
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 ...
2
votes
0answers
839 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. ...
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 ...
1
vote
1answer
74 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 ...
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 ...
1
vote
0answers
375 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 ...
1
vote
1answer
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 ...
1
vote
1answer
133 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 ...
1
vote
1answer
682 views

In SSMS, editing a table, can column names be sorted alphabetically?

SSMS Sorts column names alphabetically in all its dialogs - when choosing columns for indexes, relationships, etc. However, when editing ("Designing") a table, the columns are listed in the order in ...
1
vote
0answers
206 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
1
vote
0answers
78 views

What does this setting do when copying SSIS packages? “Duplicate package folder structure on destination for selected packages”

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder ...
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 ...
1
vote
1answer
761 views

Remote connection to SQL Server 2008 in LAN

I try many ways, but still doesn't work. MSSQLSERVER is running. SQL Agent is running. SQL Browser is running. TCP/IP is enabled (something else inside it must I change?) Named Pipes is enabled Allow ...
1
vote
0answers
104 views

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database ...
1
vote
1answer
68 views

How do I see processes from all users in SSMS2008?

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
1
vote
1answer
713 views

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the ...
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
128 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
1answer
887 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 ...
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="...
0
votes
1answer
603 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 ...
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
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
1answer
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 ...
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, ...
0
votes
0answers
976 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
0
votes
1answer
453 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
0
votes
1answer
932 views

windows 7 - sql server 2012 - Maintenanace Cleanup Task

My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there ...
0
votes
1answer
37 views

SSMS doesn't show all installed Instances

I've installed two named instances (SQLEXPRESS & MSSQLSERVER) but in SMSS, it only shows SQLEXPRESS when I try to connect. How can I connect to MSSQLSERVER from SMSS. Note. SQLEXPRESS was ...
0
votes
1answer
328 views

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark ...
0
votes
1answer
128 views

Dialogs appear on wrong monitor with SQL Server Management Studio 2008

I am running SSMS 2008 on Windows 7 with a dual monitor setup (one large, one small). SSMS is running on the secondary monitor, but everytime a dialog is opened, the dialog is placed on the primary ...
-1
votes
1answer
183 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 ...