SQL Server Security Logins Have All PC's Listed?

[Kyle_Rholl]

I was going through my SQL Server Security logins and found that all of the PC names from AD are listed there. Each one is mapped to our OnBase Database as the PC name for User and a Default Schema as hsi. I am guessing that the previous Sys. Admin has some sort of script to pull all the PC's in but I have never seen this before.

It does not pull any new PC's that have been created and added to the Domain into this area. Has anyone else experienced this and if so do you know why it is occurring or how to clean it up and get those removed without "breaking" anything.

Thanks!

[Christian_Jones]

Hi Kyle,

I would recommend contacting your FLOS.

When a user, logs into OnBase using the Client, the workstation is then added to this list. This would be normal functionality.

New PCs added to the Domain would not automatically get added to this list.

[Kevin_Perron]

Kyle

As Christian stated this is default behavior but what could also be confusing is you can change that default behavior.  In configuration, under the Users menu, choose the Global Client Settings and look at the Security tab.  There is a check box to Disable workstation account creation.  This will stop the clients from creating a SQL server account for each Workstation. 

Hope this helps

KP

[Ansley_Ingram · Accepted solution]

Hi Kyle,

The logins you are seeing are what's referred to as Workstation Logins. The Database Reference Guide contains additional information on these starting on PDF page 11.

Hope that helps.

Ansley