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.
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. |
|
|
|
|
|
|