Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssms]

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

0
votes
0answers
5 views

How do I generate SQL scripts in UTF8 encoding? [migrated]

When I generate SQL scripts for a given database, output files are encoded in UTF16-LE. Is there any way to generate them using UTF8 encoding?
3
votes
1answer
59 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
16 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....
1
vote
0answers
246 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. ...
0
votes
0answers
39 views

Error 1222 when trying to refresh my database

Hoping some more server-savvy fellows can help me I've been using SSMS for some time with the product our team develop here just to run simple queries etc. Basically my problem is that I went to do ...
3
votes
0answers
178 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
105 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
1k 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
108 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
45 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
0answers
8 views

SQLExpress - Domain Group added to sysadmin, however permissions don't apply

I have been experiencing issues lately on several different servers where I have to manage a SQL database made from SQLExpress. When the database for the application was created, it was specifically ...
0
votes
1answer
332 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
85 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
55 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 ...
2
votes
0answers
199 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
138 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
833 views

SQL Server Management Studio Failing to open

Hi I've been running SQL server 2014 on a Windows Server 2008R2 for many months now but all of a sudden this error displays when trying to open Management Studio. I've tried to repair the install (...
0
votes
1answer
69 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
2answers
6k 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, ...
0
votes
0answers
512 views

Can't find my local integration services to connect

I have SQL Server 2014 Entreprise Edition with SSIS, SSRS, SSAS, and SSMS 2016 installed on my machine. When i want to connect to my SSIS from SSMS 2016, unlike for SSAS and SSRS i can't see the ...
2
votes
2answers
3k 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 ...
0
votes
1answer
733 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
317 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 ...
5
votes
2answers
2k 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
7k 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
219 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
23 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
56 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
44 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
50 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
166 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
653 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
36 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
988 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
1k 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
1k 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
81 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
99 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
502 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
votes
1answer
658 views

SQL Server Maintenance Plan Wizard

Using SQL Management Studio 2012, when I right-click on an existing Maintenance Plan, and select the "Maintenance Plan Wizard" option from the context menu, what launches is a wizard to create a new ...
0
votes
2answers
29 views

Looking for SSMS 2008 Express Only

I downloaded SQL Server 2008 Express from here..... But it still did not install the SQL Server Management Studio that I need to connect to my databases.....see image below....looking for this. ...
0
votes
2answers
3k views

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL ...
0
votes
0answers
856 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
2answers
3k views

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL ...
0
votes
1answer
7k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
10
votes
4answers
9k 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 ...