UCCX SQL access for third party application

Open the command line on your UCCX server and do the following:

Step 1: -

C:\>osql -L

Servers:

(local)\CRSSQL

Step 2: -

Connect to MSDE using Local account

osql -E -S SERVERNAME\CRSSQL

Step 3: -

List the current logins in SQL

exec sp_helplogins

go

Step 4: -

Create a user account and grant access to db_cra database:

use db_cra

go

exec sp_addlogin 'username','password'

go

exec sp_grantdbaccess 'username'

go

exec sp_addrolemember 'db_wallboard_read','username'

go

Eg:-

1> exec sp_addrolemember 'db_datareader','Muttil'

2> go

'Muttil' added to role 'db_datareader'.