question

dosberg avatar image
dosberg asked

Configure Sql Browser Service Account

Does anyone know of an article that has steps for configuring security for a service account running the Sql Browser service? I don't want to run the service as Local System. Thank you, David
securitysqlbrowser
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
Check out these articles [MSDN][1], [SQL Tips][2]. Hope this will help you. [1]: http://msdn.microsoft.com/en-us/library/ms181087.aspx [2]: http://www.mssqltips.com/tip.asp?tip=1946
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dosberg avatar image dosberg commented ·
Cyborg thank you for the links, I had already seen those. I tried granting the righs listed to the local browser group Sql Server creates on install but that didn't work. The registry permissions listed are vague to say the least. I tried granting full control at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server level but that wasn't right. I'm extremely leary of grant registry permissions until it works. One shouldn't have to manage security to that level. It seems like a bug to me that the local browser group doesn't have sufficient permission by itself. Despite published best practices to the contrary, the browser service needs to run as a local system or a local administrator equilvalent.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.