Questions tagged [credentials]

Use for questions about how to implement or use SQL Server credential records. Credentials contain the authentication information required to connect to a resource outside SQL Server.

Filter by
Sorted by
Tagged with
0 votes
0 answers
14 views

Launch RDBMS Client GUIs from Delinea

I am using the delinea permission access management tool that I pointed to the application file of SSMS and it could launch my desired server instance with the secret server credentials configured on ...
franklwambo19's user avatar
0 votes
0 answers
109 views

How do RDS Proxy credentials work?

In AWS RDS, there exists an RDS Proxy managed service. The console requires supplying database credentials when setting up this proxy. Why is this? That is, why doesn't the proxy simply pass through ...
benjimin's user avatar
  • 101
5 votes
1 answer
666 views

Compare a credential secret against a known value

Suppose I have a SQL Server Credential saved in the database with a specific secret. I want to only modify the credential if the secret saved in the database is different from the actual secret. ...
Hannah Vernon's user avatar
  • 70k
0 votes
1 answer
966 views

Create a SQL Credential for a Managed Service Account

Is it possible to create a SQL Credential in SQL 2019 for a Managed Service Account? When I try, it asks for a password, which I don't know. I want to run a Powershell command from SQL Agent using ...
Greg's user avatar
  • 3,252
1 vote
0 answers
640 views

Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)

My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using ...
Wyvernstail's user avatar
2 votes
1 answer
3k views

How do SSIS connection strings send passwords?

I have a SQL server that pulls data from another SQL server via SSIS. We recently converted the server targeted by SSIS to VM. Since the VM conversion I have been getting "login failed for user '(...
mcv110's user avatar
  • 75
0 votes
1 answer
43 views

Is best practice to Web Application users credentials using same database users credentials [closed]

I have multiple Web applications using same database (MariaDB), so i want to using same user credentials as centralize, so: Is it best practice to using same database users credentials and when add ...
Hazim Eid's user avatar
  • 101
0 votes
1 answer
43 views

How to create a new user in a remote offline database without elevating roles [closed]

An enterprise C++ system that needs to be "translated", uses ODBC for connecting to SQL Server Database. The system has one central main database, many distributed local databases, which are actually ...
db-hopper's user avatar
0 votes
1 answer
592 views

Login failed for User 18456 State 5. User id works on other machines

I have a really weird login issue I've been pursuing. I experience this only on my Macbook Pro (2018) and only when logging into this one specific SQL Server 2016 database directly through a database ...
Andrew Ross's user avatar
3 votes
1 answer
670 views

SQL Server Credential Password and Secret Difference?

What is the difference between SQL Server secret and password for credentials(both server and db scope)? For example while reading the BOL I can see specifying a secret. Is this just the same password?...
igelr's user avatar
  • 2,132
0 votes
1 answer
2k views

Using sp_send_dbmail with SQL authentication to send attachments from UNC path

I'm trying to send emails with attachments using a SQL authentication account that I have granted credentials to. The login used in the stored Credentials is a domain account that has permissions ...
Sir Swears-a-lot's user avatar