Azure SQL Database
An Azure relational database service.
5,692 questions
This is resolved since I was using an invalid user. I added my server level user and it worked for me.
Getting Failed to determine members of SqlServerTarget (server name 'data-engineering-server-rnd.database.windows.net', server location 'data-engineering-server-rnd.database.windows.net'): Login failed for user 'sqladmin'. error with elastic job
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Shrivastava
100
Reputation points
I am trying to run a job inside my server.
Steps I followed
Created a SQL Server Agent on server 1.
Ran following queries and also the Elastic job agent is hosted in server1 only and the database is ElasticJobs.
- CREATE MASTER KEY
- CREATE DATABASE SCOPED CREDENTIAL refresh_credential WITH IDENTITY = 'sqladmin', SECRET = 'abcd1234'
- EXEC jobs.sp_add_target_group_member @target_group_name = 'DBLocal', @target_type = 'Sqlserver', @refresh_credential_name = 'refresh_credential', @server_name = 'server1';
- EXEC jobs.sp_add_job @job_name = 'AddNewTablel', @description = 'Create Table Test';
- Add job step for create table EXEC jobs.sp_add_jobstep @job_name = 'AddNewTablel', @command = N**'CREATE TABLE [dbo].[Employee] ([Id] [int] NOT NULL, Name varchar(200), Address varchar(200));'**, @credential_name = 'refresh_credential', @target_group_name = 'DBLocal';
- EXEC jobs.sp_start_job 'AddNewTablel'
Now after doing all these I am getting this error.
Failed to determine members of SqlServerTarget (server name 'data-engineering-server-rnd.database.windows.net', server location 'data-engineering-server-rnd.database.windows.net'): Login failed for user 'sqladmin'.
I was also getting error that my ip is not listed and hence cannot access the server but I am still getting this error after adding my ip to the firewall as well.
Can someone please help with this. Am I missing some authentication thing here?
{count} votes
-
Vinodh247 21,226 Reputation points2024-07-11T00:25:29.92+00:00 - check if the auth is all good for 'sqladmin', the error says login failed hence validate the password used in the connection string & ensure they are correct and have not been changed or expired.
- ensure that the user is added to the database and has appropriate roles and permissions
- check if the connection string is correctly formatted
I was also getting error that my ip is not listed and hence cannot access the server but I am still getting this error after adding my ip to the firewall as well.
i would suspect if the ip has been added to the firewall, can you double check that?
Sign in to comment
2 answers
Sort by: Most helpful
-
Ayush Shrivastava 100 Reputation points
2024-07-15T12:11:55.96+00:00 -
Vinodh247 21,226 Reputation points
2024-07-15T13:33:46.88+00:00 ensure that the user is added to the database and has appropriate roles and permissions
you fixed it by mapping the database with your server level user?
-
Vinodh247 21,226 Reputation points
2024-07-18T00:18:19.7566667+00:00 Ayush Shrivastava : Just checking if you had a chance to look at this. if so, can you please update it?
-
Vinodh247 21,226 Reputation points
2024-07-20T09:52:29.75+00:00 Ayush Shrivastava: In case if you have any resolution, please share the same here with the community as it can be helpful to others. Else, please respond with more details and we will try to see if we can help further.
Sign in to comment -
-
Oury Ba-MSFT 19,176 Reputation points Microsoft Employee2024-07-15T16:12:37.4966667+00:00 @Ayush Shrivastava Thank you for reaching out.
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!
Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer. Accepted answers show up at the top, resulting in improved discoverability for others.
Issue: Getting login failed for user "sqladmin" error with elastic job
**Solution: "**This is resolved since I was using an invalid user. I added my server level user and it worked for me."
If your issue remains unresolved or have further questions, please let us know in the comments how we can assist. We are here to help you and strive to make your experience better and greatly value your feedback.