Technorati Tags:
Server 2008Remember to do one of two things if using Server 2008 for the first time:
1) Turn UAC off in Control Panel | User Accounts | Turn User Account Control on or off
or
2) Make sure you right-click every application’s icon every time! and choose “Run as Administrator”, every time unless you want to really give yourself a headache
Same goes for Vista of course but in Server 2008, you do not want to ignore UAC and view it just as a pest. You want to use properly or get rid of it entirely.
If you don’t, then you’ll go through weird security problems whereas you are seeing half or able to do half of what you are normally able to do.
Point in case, here are two oddities that came up if I did not do this:
1) There were a couple of databases in SQL Server Management studio I could see but when I tried to expand a couple, I got a generic “inaccessible” error and I was rubbing my head thinking what the heck else could be wrong here. I’m already in the local Admin group, and that group in SQL Server has access to this database. It ended up being UAC as I did not open Management Studio as an Administrator (#2 above).
2) Team Foundation System unfortunately requires setup of SSRS. If you don’t open up IE to get to the SSRS admin website for the first time As Administrator (#2 above), then you get an error saying you don’t have rights to access the site.
UAC, one of the worse security features by Microsoft ever…pain in the ass.
