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
107 views

Use scoped credential when running database backup

I'm trying to use credentials in scoped manner, since I don't have access to create credentials in server, where I need to run database backup. When trying to backup database with scoped credentials, ...
user avatar
  • 109
0 votes
1 answer
189 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 ...
user avatar
  • 3,152
1 vote
0 answers
103 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 ...
user avatar
2 votes
1 answer
798 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 '(...
user avatar
  • 75
0 votes
1 answer
33 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 ...
user avatar
  • 101
0 votes
1 answer
35 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 ...
user avatar
  • 13
0 votes
1 answer
168 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 ...
user avatar
3 votes
1 answer
394 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?...
user avatar
  • 2,006
0 votes
1 answer
1k 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 ...
user avatar