Db access

mitul_choudhary · September 16, 2020, 10:50am

I’m able to login manually in DB server ,but not through uipath.
pls help @supermanPunch @Peter @Balamurugana @peter.jackson URGENT…!!

pfb credentials:
DB Server Name :- INDELDB150

DB Server IP :- 10.188.223.244

SQL Instance Name :- INDELDB150\BITLOCKER

Database Name :- [MBAM Compliance Status]

SQL account :- IN\ in-svc-itautomation

Permission :- Read permission on VIEW [ComplianceCore].[MachinesComplianceView]

This is what i entered in configuration box.

Srini84 · September 16, 2020, 11:12am

@mitul_choudhary

Check you have done as mentioned below in the post

You need to enable the tcp/IP connection

Mark as solution if this helps you

Thanks

mitul_choudhary · September 16, 2020, 11:28am

Done.Still the same issue.

pls let me know if anything else to be done.

mitul_choudhary · September 16, 2020, 11:43am

@supermanPunch @ksrinu070184…???

URGENT PLS RESPOND…

Srini84 · September 16, 2020, 11:45am

@mitul_choudhary

Can you share the screen of login from sql management studio, where you able to login?

Thanks

mitul_choudhary · September 17, 2020, 5:06am

Hope it helps

Srini84 · September 17, 2020, 5:10am

@mitul_choudhary

You are using Windows Authentication for login

But in UiPath you are using SQL Authentication

You can try with Windows Authentication

Hope this helps you

Thanks

mitul_choudhary · September 17, 2020, 5:11am

using window authentificaion in uipath it logins by default by IN-MITULCHOUDH(system id)

But i want to use in-svcitautomation for login as shown in screenshot.

Srini84 · September 17, 2020, 5:13am

@mitul_choudhary

Did you manually able to login with SQL authentication through SQL Management studio?

If not then share the screen of the error

Thanks

mitul_choudhary · September 17, 2020, 5:17am

yes i as shared in screen shot i was able to login manually.

process:
startbutton-----type ssms(sql studio)----open file location----right click—select different user-----popup appears-----enter username/pass as in-svcitautomation----now ssms opens-----click on connect–

hope it helps.

mitul_choudhary · September 17, 2020, 6:05am

@ksrinu070184…??

Srini84 · September 17, 2020, 6:37am

@mitul_choudhary

Yes, the process is same for login manually

If its connecting manually then it should also connect from UiPath

I will check and let you know if i have any thing

Thanks

mitul_choudhary · September 17, 2020, 6:46am

pls do asap.

Thanks 4 help.

mitul_choudhary · September 17, 2020, 10:14am

Hi @Srini84 @supermanPunch

I have done configuration of database

but having access denied.

connection String:
“Data Source=INDELDB150\BITLOCKER;Initial Catalog=[MBAM Complaince Status];User ID=IN\in-svc-itautomation”+“;Password=QWERasdf@12345678901”

Provider Name:
“System.Data.SqlClient”

pls help.

Error:
RemoteException wrapping System.ComponentModel.Win32Exception: Access is denied
at System.Diagnostics.ProcessManager.OpenProcess(Int32 processId, Int32 access, Boolean throwIfExited)
at System.Diagnostics.Process.GetProcessHandle(Int32 access, Boolean throwIfExited)
at System.Diagnostics.Process.OpenProcessHandle(Int32 access)
at System.Diagnostics.Process.set_EnableRaisingEvents(Boolean value)
at UiPath.Service.UserHost.AttendedServiceProxy.RegisterClientProcess(Int32 clientPid)
at UiPath.Service.UserHost.StudioOperations.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Service.Core.Utils.TaskUtils.d__0.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Service.UserHost.StudioOperations.<>c__DisplayClass5_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.CancellationHelper1.<Invoke>d__31.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.Server.d__22.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.Server.d__21.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.Server.<>c__DisplayClass4_2.<<-ctor>b__6>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.IOHelpers.d__10.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.CoreIpc.IOHelpers.d__16`1.MoveNext()

Srini84 · September 17, 2020, 10:20am

@mitul_choudhary

“Data Source=INDELDB150\BITLOCKER;Initial Catalog=MBAM Complaince Status;User ID=IN\in-svc-itautomation”+“;Password=QWERasdf@12345678901”

Try with this

Thanks

mitul_choudhary · September 17, 2020, 10:23am

Same issue “Access Denied”

Srini84 · September 17, 2020, 10:26am

@mitul_choudhary

Oops I missed + you keep

Check with this below

Data Source=INDELDB150\BITLOCKER;Initial Catalog=MBAM Complaince Status;User ID=IN\in-svc-itautomation;Password=QWERasdf@12345678901

Hope this helps you

Thanks

mitul_choudhary · September 17, 2020, 10:31am

Data Source=INDELDB150\BITLOCKER;Initial Catalog=MBAM Complaince Status;User ID=IN\in-svc-itautomation;Password=QWERasdf@12345678901

same access denied for above.

Srini84 · September 17, 2020, 10:32am

@mitul_choudhary

did you test the connection by the connection wizard?

Also check you have required permission with that username

Check with your DB team

Thanks

mitul_choudhary · September 17, 2020, 10:34am

No,

I’m using connection string & Provider name

Topic		Replies	Views
I'm unable to connect to a database from SQL Server Management Studio(SSMS) Studio uiautomation	4	887	November 16, 2021
UiPath Database Connection authentication with AZURE Active Directory Activities database , uiautomation , activities , question	4	1369	May 25, 2023
Database connection Help database , studio	15	18986	October 23, 2019
DB connection string Help studio	3	9472	October 29, 2018
SQL server data base connection in uipath Random and other categories studio	5	818	March 2, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
Yoichi
Julian3
sharazkm32
minako_tanaka
jast1631
A_Learner
Mr.BENJAMINE_STAIRRIERS
srdjan.suc
More details...

Db access

Related topics