Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 New Installation and Report Manager-Interesting

Author  Topic 

savior faire
Posting Yak Master

194 Posts

Posted - 2009-12-04 : 16:46:13
Here is an interesting thing I just ran into.
I recently(Sept) bought the developer's edition of SS 2008, when I was having problems re-installing the evaluation copy of SS 2005. I am a student of SS and BI, so I splurged $60 and bought a licensed version.
I was having problems installing SS 2008 on my Vista-Home laptop and also on my Vista-Business desktop. It would fail or get an incomplete installation.
On my laptop(Vista-Home), last week, I did a system restore to the factory image.
Then I created new user called 'sqladmin' and gave it administration permissions.
I did the SS 2008 installation under the 'sqladmin' user login and it was 100% successful, even Report Manager(http://localhost/Reports) worked fine, and was accessible from the 'sqladmin' account, and my own personal login. When I say accessible I refer to the Report Manager home page with 'site setting' and the Contents, property tabs and menu bar available.

Today, I did the same process on my desktop(Vista-business) again, under the 'sqladmin' user login. I did have a hitch in the SS 2008 installation, but luckily got by it and in an hour or so I had a 100% successful installation.
First thing I did was bring up Report Manager under the 'sqladmin' login, and it was fine. So I go to my user login and Report Manager did not come up with the specs noted above. I checked the url, other settings, tried "http://saviorfair/Reports", and still nothing.
So I went to the 'sqladmin' session, and clicked 'site settings', then clicked 'security' to check what was setup. It was identical to how my laptop was, yet on the desktop(Vista-Business), it would not work. So I clicked on 'New Role Assignment' and added my user login and gave it system administrator capabilities, and it worked fine.
Note that the desktop is a 64 bit system, while the laptop is a 32 bit system.

Interesting. I'd be interested in hearing anyone else's experiences.

Talk sense to a fool and he calls you foolish.
   

- Advertisement -