Db access

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.

@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

Done.Still the same issue.

pls let me know if anything else to be done.

@supermanPunch @ksrinu070184…???

URGENT PLS RESPOND…

@mitul_choudhary

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

Thanks


Hope it helps

@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

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.

@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

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.

@ksrinu070184…??

@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

pls do asap.

Thanks 4 help.

Hi @ksrinu070184 @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()

@mitul_choudhary

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

Try with this

Thanks

Same issue “Access Denied”

@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

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

same access denied for above.

@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

No,

I’m using connection string & Provider name