Idea Details

Allow SDM With SQL mdb To Be Configured With Windows Authentication

Last activity 06-13-2019 09:57 AM
STUART MATTHEWS's profile image
11-17-2014 04:23 PM

Hello,

 

Currently if you are using a Microsoft SQL Database with CA Service Desk Manager, when running the pdm_configure command, at  the MS SQL Database Config stage you can only use SQL Authentication.

 

Microsoft do not recommend using SQL Authentication due to its security risks -> Using SQL Authentication

 

Can SDM please be modified so a Database Userid with Windows Authentication can be configured against.

ideas.png

Thanks

Stuart


Comments

08-22-2018 01:28 PM

This was originally moved to "not planned" due to low community interest.

 

However, due to recent community discussions, I have moved this back to "under review", and we will look at this idea again.  Please be sure to vote and comment if this idea is important to you.

08-20-2018 08:22 AM

This Idea is marked 'Not Planned' - which prevents us from voting on it - but there is no comment from CA as to why. 

 

J.W.

08-16-2018 06:55 PM

Any update on this? I'm trying to get approval to upgrade from SDM 12.9 to SDM 17.1 and this is a major security issue.

 

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authentication-in-sql-server

05-25-2017 08:09 AM

Thank you for submitting this idea. The product team is reviewing this idea and is looking for additional input from other community members.

 

Community Members: If you agree that this is a good idea, please vote and add comments with details about your requirements.

05-19-2016 06:22 AM

still not available in 14.1

/J

03-21-2016 04:01 PM

Totally agree, we need to configure the mdb administrator user db but using a Windows Authentication account in SQL.

Please comments, if it is possible now in this release 14.1.

 

Regards,

John V.

03-09-2016 03:42 PM

agree on top of security concerns raised above I prefer to use service account in general for better management that any app/db specific

/J

09-13-2015 05:39 PM

Don't forget to vote up SamirKS , thanks Stuart.

09-12-2015 03:02 PM

Yes I agree , this is a flaw even in 14.1 , this was not taken care.

06-23-2015 12:35 AM

Hi Stuart

I tested this on R12.9. It is still the same. IT expects the user to have SQL authentication. I vote for this

 

Regards

Nas

06-22-2015 12:28 AM

Hi Nas,

 

When I logged support ticket 21986793-1 last November, it was confirmed it wasn't possible with SDM 12.9. Perhaps someone out there with 14.1 could double-check it doesn't work in the new release.

 

Cheers Stuart

06-18-2015 10:04 PM

Hello Stuart

If SQL is configured for MIXED mode authentication then can't you use a Windows account to configure SDM? Can you check?

 

Regards

Nas

01-15-2015 03:48 PM

I'm surprised no one has voted up this idea. Our Database Team are strongly against SQL accounts, I would suggest you ask your Database Administrator on their thoughts regarding this. SDM at our organisation has been flagged as a legacy application due to this issue, and will not be allowed to be migrated to any future releases of Microsoft SQL Server unless it changes to Windows Authentication.