As of May 31, 2023, we have updated our Code of Conduct.

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

2019 SSIS job step running as a proxy/credential getting "Login failed for user 'domain\user'."

I have a new 2019 SSIS instance with one agent job that runs a package that runs sprocs on another sql instance. The 2019 SSIS sql service and agent service are running under a gmsa. The target ...
Bobogator's user avatar
5 votes
1 answer

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
  • 69.1k
0 votes
1 answer

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,212
1 vote
0 answers

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

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

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's user avatar
  • 101
0 votes
1 answer

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

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

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,098
0 votes
1 answer

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