Questions tagged [ssms]
SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.
1,255
questions
0
votes
1
answer
4k
views
SSMS error : The certificate chain was issued by an authority that is not trusted
Im getting the below error while logging into the database.By default only "Encrpt connection" is checked .
In this case should I need to uncheck "Encrypt connection" and "...
12
votes
3
answers
7k
views
Is it possible to filter the list of databases in the Object Explorer of the SSMS?
I know how to filter the list of tables - using the filter icon. However, this icon is disabled when the Databases node is selected.
Still, I am wondering whether it is possible.
0
votes
0
answers
18
views
SSMS How to set alternate row colors in Grid Results - Same as Oracle SQL Developer
How can I set alternating row colors in SSMS?
The ONLY answer close to what I'm looking for is here however is not for SSMS: Make Oracle SQL Developer act like PL/SQL Developer
However, the answer is ...
4
votes
4
answers
13k
views
SQL Server Management Studio (SSMS) is way too slow in its GUI
I know this question has been asked before here and here. But none of them could solve my problem. I have this environment:
Windows 10, build 1903 (freshly installed)
Microsoft SQL Server 2016 (SP2) (...
0
votes
1
answer
327
views
"Fatal scripting error" when parsing SQLCMD query
Similar issue seen here.
I am trying to run the following command from SSMS running in SQLCMD mode.
:r C:\dev\test scripts\sample.sql
But I get the following error:
A fatal scripting error occurred.
...
0
votes
1
answer
39
views
Why is Ignore Duplicate Keys not allowed on a Unique Key?
If I understand this answer correctly the difference between an Index with Is Unqiue on and a Unique Key is mainly cosmetic.
In the MSSQL interface when I switch to a Unique Key the Ignore Duplicate ...
2
votes
1
answer
122
views
SSMS User Mapping Slow to Load, or Not Responding
I have been experiencing an issue in SSMS versions 14, 18, and 19, where loading the User Mapping of any given Login takes an age to load, sometimes up to an hour, or just never loads at all and hits ...
1
vote
1
answer
617
views
Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer
I am new to MSSQL. I have a question about executing MSSQL Stored Procedure.
Let me briefly talk about my development environment first:
PC400 (Computer/Server A), where SQL Server 2012 is installed
...
0
votes
0
answers
53
views
How to convert a function into a Stored Procedure in Microsoft SQL?
I have this function that takes a decimal parameter and returns a varchar
CREATE FUNCTION dbo.NumberToWords(@Number DECIMAL(18, 2))
RETURNS NVARCHAR(MAX)
AS
BEGIN
DECLARE @Words NVARCHAR(MAX)
SELECT ...
0
votes
1
answer
1k
views
Unable to connect to Listener after rebuild
I dropped an AG with
DROP AVAILABILITY GROUP [MyDb]
it had a listener.
I left the listener open in the object Explorer of SSMS 17.3. While the AG and Listener were down. I hit refresh on the ...
-2
votes
2
answers
56
views
Replace "INSERT" by "UPDATE"
I'm working with some tables in an SQL-Server database, and I'm doing some crucial modifications. In order not to loose everything when I mess up, I decided to do a "Generate script" (data ...
2
votes
1
answer
3k
views
SSMS Not showing Status and Scheduled Jobs Not Running
Recently in SSMS, I have started getting a blue question mark next to the database and SQL Server Agent, when previously all was showing running. At the same time my scheduled jobs have stopped ...
-4
votes
2
answers
125
views
How does SSMS grab the name of my server?
In the bottom-right hand side of SSMS's main screen and to the left of where it shows my user-name and the name of the database that I'm in, it gives the name of the server that I'm on. This string is ...
0
votes
1
answer
470
views
Unable to create linked server to Power BI XMLA endpoint in SSMS
Unable to create linked server to Power BI XMLA endpoint in SSMS and getting below error:
The test connection to the linked server failed. Additional information: An exception occurred while ...
2
votes
3
answers
4k
views
Wrap identifiers automatically with brackets in SSMS text editor
Working in SQL Server Management Studio, when using the text editor:
Is there any way to automatically wrap schema names, table names, column names and other identifiers with brackets so I don't have ...
2
votes
2
answers
5k
views
SSMS 2012 / 2014 / 2016 Object Explorer hangs when Expanding Databases list on a server with many DBs
When accessing SQL Server with SSMS versions (2012/2014 and 2016), opening the databases list from the object explorer is really slow.
If I try it using SSMS 2008 R2 on the same instance the result is ...
1
vote
0
answers
37
views
Modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file
As per the title - modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file.
I wondered if anyone has come ...
0
votes
0
answers
536
views
SSMS Find matching parenthesis Highlighting Feature aka Brace Matching Half Broken - How to Fix
SSMS version 19.1
This feature also takes on the name of Automatic Matching of Syntax Pairs. Refer to this link. This feature for me however is failing to function as expected.
I used to be able to ...
1
vote
1
answer
553
views
Why does Bitlocker intermittently require SQL service restart after sleep?
I have a development machine that has two drives:
C:\ - Operating system (Win 10 Ent) and SQL Server 2012 Standard installation
D:\ - SQL Server databases, backups, logs
I recently activated ...
0
votes
1
answer
829
views
SSMS Query store keeps getting disabled
I activated query store about a month ago with the settings below. Now, every morning starting up SSMS I find the Query store folder gone and query store disabled. Initially I used 1 Gb size, but ...
0
votes
1
answer
886
views
Restrict access on specific database from windows users
Is there a easy way to deny all access from Management Studio to a specific db except from sa and 1 another SQL user that will be used to access db from a remote app ?
i'd like that users connecting ...
0
votes
1
answer
2k
views
SSMS18 - Default File Location (Changed ssms.Application.pkgdef)
I have changed the DefaultProjectsLocation (SSMS18) from the default (My Documents) to a folder on my network. But when I run SSMS18 and open Projects it is still looking at the default location. What ...
0
votes
1
answer
88
views
Unique Index on NULLable field isn't creating a Unique Constraint so I can make it a FK on another table?
I'm in MS SQL 2016. I'm a bit confused. I have a field that I have put a unique index on. The DocID is not a primary key, but it will be unique (and is NULLable):
CREATE UNIQUE INDEX [...
2
votes
2
answers
13k
views
"Untrusted Domain" error when connecting to SQL Server localhost and specifying port
I have two SQL Server 2016 instances running on localhost, and I can connect to both with no issues (localhost and localhost\test) using windows authentication. However, if I specify the port ...
2
votes
2
answers
3k
views
Why Sql Server management studio use English regional settings instead my local Windows settings?
Scenario:
I have a Sql Server instance on English Windows Server.
But I also have my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian.
So when I extract ...
1
vote
1
answer
1k
views
SSMS 2016 error "The client and server cannot communicate, because they do not possess a common algorithm"
I am trying to connect a database from SSMS 2016 it gets connected from one machine but other machine with exactly same version SSMS 2016 gives below mentioned issue.
Note: on server only TLS > 1.2 ...
0
votes
1
answer
66
views
How can I access table with Always Encrypted in SQL Server Authentication?
Working on Azure SQL Server
I approached Key Vault with Azure AD and generated a column master key and column encryption key to apply Always Encrypted to a specific table
Therefore, if login the ...
0
votes
1
answer
287
views
Cannot find sqlserver service
I installed Sql Server 2019 in Windows PC.
In Sql Server Configuration Manager into SQL Server Service I stopped all the instances.
But still I can loggin to Sql Server via SSMS.why is that? Where is ...
6
votes
2
answers
2k
views
When is the Query "Done"?
Scenario
I run a long, complex query that returns 30+ fields and 77,000+ rows in SSMS. The results are to grid. The results are all text-heavy. The SSMS grid starts populating with results after a few ...
1
vote
1
answer
628
views
Kerberos Issue - Anonymous Login
I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection;
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
4
votes
1
answer
5k
views
Which permissions are required to view Windows Event Logs in SSMS?
I'm trying to figure out which permissions are required to be able to view the Windows Event Logs via SSMS.
The SSMS Log File Viewer, where you typically view the SQL Server Errorlog, also has the ...
1
vote
1
answer
4k
views
Unable connect to SQL Server on SSMS and Got error 10054
I have an issue with connecting to a server on SSMS SQL Server. I got this error 10054 when i tried to connect :
SQL Server error 10054
===================================
Cannot connect to <IP>...
1
vote
1
answer
779
views
No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted
I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
8
votes
1
answer
7k
views
Does SSMS use ODBC?
I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances.
I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes ...
0
votes
2
answers
113
views
Open Management Studio with configured connections
Maybe this question is a little off topic, I will close if necessary, but, is there a way to configure Management studio, to when I open it, it starts already with x connections? So I don't need to ...
1
vote
4
answers
7k
views
How can I get SQL Server Management Studio 2012 to connect to multiple servers automatically on open?
When I open SQL Server Management Studio, it only connects to a single Database Server, but I would like it to automatically connect to multiple Database Servers.
How can I accomplish this?
1
vote
1
answer
744
views
How does one export/import registered servers with passwords?
I have a pretty extensive collection of registered servers on SQL Server Management Studio 2016 on my box. However, I got a new box and want to move the entire collection there. So I right-clicked ...
1
vote
1
answer
1k
views
Execute SSIS (package) in SSMS using T-SQL and return a value
Using VS (2019) I created an Integration Services Project to code an SSIS package. The goal was to call a Web API from an SSIS package using input variables like username/password/url and so on. I ...
0
votes
1
answer
953
views
SQL Server User permissions-Hide all tables and give/show access to some views
I am using SQL Server 2019. I have gone through some questions here and not found an answer. I am trying to not to show some tables (with a certain Schema e.g. Structure) for a SPECIFIC user in the ...
0
votes
1
answer
416
views
How to get SSIS to stop waiting/processing at task above time limit?
So I have a couple SSIS packages that are run sequentially, scheduled through SQL Server Agent. Right now, I'm getting some errors where certain input data steps just wait indefinitely-- i.e access ...
1
vote
0
answers
60
views
Is there a file that can be deleted to force SSMS to manually rebuild Intellisense?
I have a case where intellisense has stopped working completely.
I have tried Ctrl-Shift-R and waited a few minutes. This has no effect.
I changed the Maximum script size in 'Tools | Options > ...
0
votes
1
answer
2k
views
SSIS cannot deploy package to SQL server - An error occurred during decryption 15466
After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
=============================...
4
votes
1
answer
141
views
T-SQL: Iteration vs. Set-Based Operations When Independence of Ancillary Data is Needed
BACKGROUND
I am using Microsoft SQL Server Management Studio v18.9.1 on Windows 10.
I've created a database to store test results of our company's widget (not yet being produced). I am working on a ...
0
votes
1
answer
53
views
How to use sp_execute_external_script to fetch USD Rate from an API and update a table?
I have this code that gives this error
-- Set the API URL
SET @url = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF43718/dato/oportuno?token=...
0
votes
0
answers
82
views
SQL Server Network Configuration Tab is missing. Can't enable TP/IP Protocols
I am using SQL Server 2022 and the "SQL Server configuration manager" is not visible.
Further more I opened "Services and Applications" and in computer management and SQL Server is ...
0
votes
1
answer
155
views
Cannot drop the database encryption key because it is currently in use
I want to create a backup of my sql managed instance database to blob storage. However am encountering the below error after trying to turn off encryption key as follows:
use master
ALTER DATABASE [...
0
votes
0
answers
20
views
SSMS. Anyway to connect via AWS session-manager to an mssql instance?
I have a sqlserver (express) instance running on an ubuntu server ec2 instance. This is on an AWS private subnet so I cannot just open port 1433 for sql access. We use AWS session manager to connect ...
0
votes
1
answer
643
views
Cannot Connect (Internal connection fatal error. Error state: 15, Token : 23 (Microsoft.Data.SqlClient)
I had SQL Server 2019 Developer Edition installed and working correctly. Could access via SSMS without issue. About a month ago, I lost connection. Tried checking everything I could find online, no ...
0
votes
1
answer
50
views
Is there a keyboard shortcut to open a registered server?
Getting to the Registered Servers pane is easy enough with Ctrl-Alt-G.
Navigating thorugh the tree is easy enough with arrow keys.
Once the desired instance is found, is there a keyboard action that ...
2
votes
1
answer
674
views
Installing SSIS package outside of SSIDB catalog
I'm trying to simplify deployment of a SSIS package to a remote server. At the moment, I have
Local Visual Studio SSDT and SSIS package that has 4 connection managers - DEV environment
Remote server ...