Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Most credentials contain a Windows user name and password. The information stored in a credential enables a user who has connected to SQL Server by way of SQL Server Authentication to access resources outside the server instance. When the external resource is Windows, the user is authenticated as the Windows user specified in the credential. A single credential can be mapped to multiple SQL Server logins. However, a SQL Server login can be mapped to only one credential.

Microsoft Documentation is available here.

10 questions
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. Sometimes, an example is good, so take a look at…
Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323
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…
igelr
  • 2,162
  • 3
  • 26
  • 56
2
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 this credential as a proxy, but can't add the…
Greg
  • 3,292
  • 5
  • 33
  • 57
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 '(username)'.". errors and the SSIS package fails to…
mcv110
  • 75
  • 1
  • 8
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 SSISProxyCredentials. The expired error "user" is referring to my predecessors…
Wyvernstail
  • 11
  • 2
0
votes
0 answers

Running an Agent Job using Azure Shared Access Key Credential

I'd like to have a SQL agent job that copies a file up to Azure Storage using a Shared Access Key Credential. The credential is set up and works for backup and restore process, but I'd like to use it for copying files up to blob storage. I don't…
AlexP012
  • 53
  • 3
0
votes
1 answer

Is best practice to Web Application users credentials using same database users credentials

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 new user add the user also on the database with…
Hazim Eid
  • 101
  • 2
0
votes
1 answer

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

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 offline and are periodically kept updated with…
db-hopper
  • 13
  • 2
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 client. Login attempts through any database…
Andrew Ross
  • 1
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 to read from the share. EXEC…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48