cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for SP)

Jump to solution

Hello!  I am trying to access a table in a SQL Server that isn't the SharePoint SQL Server Database Engine.  I am able to use the SQL Request control to access our SharePoint SQL Server Database Engine but not any other one.  Is there something I'm missing?  I know the control has found the server, but it is giving me a "Login failed" error.  Is this something I have to change within the SQL Server itself or in the control settings?

Any help is appreciated!!!

Owen

Labels: (1)
0 Kudos
Reply
7 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution
Hi,

The error is very clear that this is a permissions issue.
Add the webapplication service to the database that you want to access by the control and see if that helps.
Reply
Highlighted
Nintex Newbie

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution

Hello @SimonMuntz,

Thank you for the response!  I'm a little new to SQL Server, so I apologize for asking further questions.  Do you add the webapplication service in SQL Server Management Studio?  Or is there a different way to add it?

Thank you!

Owen

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution
Yes, add the user via SQL management studio to the permissions section of the database you want to access.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution

Thank you @SimonMuntz!  I really appreciate the help.  I have added the user to the database and have granted them the "Connect" permission, but I'm still getting the same error.  Is there another specific permission that the user needs to be given?  Also, why did I need to create the user?

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution
Hi,

What happens if you give the account full control?
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution

@SimonMuntz,

I do not have full control (I'm not allowed), so I've had to ask someone else to do things for me.  When they added the new user, I saw that they had the user in their list but I cannot see them...

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request control error: Login failed for user... (Trying to access SQL Server that isn't for

Jump to solution

Turns out, it was an issue with my Secure Store target application.  I had to make a new one to apply it to the user in the new SQL Server I was trying to connect to.  the user that had the failed login only existed in the previous SQL Server. Thanks!

View solution in original post

0 Kudos
Reply