March 26, 2009 at 6:18 pm
Hi,
We have a sql server 2000 Reporting Services Standard edition installed in Server A (Production).For this:
1) Report Server service(Services.msc) running under local system
2) Enterprise manager->Logins->We DO NOT have NT AUTHERUTY\NETWORK SERVICE and NT AUTHORITY\SYSTEM
We are planning to move this reporting Services to Server B(Test Server). Here:
1)Installed Reporting Services standard edition
2)while installing we choose NT AUTHORITY\SYSTEM
3)Report Server service(Services.msc) running under local system
4)Enterprise manager->Logins->We have NT AUTHERUTY\NETWORK SERVICE and NT AUTHORITY\SYSTEM
Then we did in-place upgrade to SSRS 2005 in Server B and it went well. Now we would like to upgrade Server A Reporting Services to SSRS.
But before doing that I would like to know why in Server A has NO NT AUTHERUTY\NETWORK SERVICE and NT AUTHORITY\SYSTEM logins and Why Server B has these 2 logins.
Iam thinking this may block the upgrade.
Please clarify me
thank you
March 26, 2009 at 6:51 pm
Upgrade from SSRS 2000 to SSRS 2005 in standard edition comes with known issues so you need to take one to two days read everything in the thread below before any upgrade.
http://www.sqlservercentral.com/Forums/Topic675962-5-1.aspx
Kind regards,
Gift Peddie
March 27, 2009 at 12:14 pm
I followed the given link and Iam able to Migrate and upgrade to SSRS in Server B. But my question is
why in Server A (Production)has NO NT AUTHERUTY\NETWORK SERVICE and NT AUTHORITY\SYSTEM logins and Why Server B has these 2 logins.
Having with these 2 logins in Server B, Iam able to upgrade. But in Server A, we DO NOT have these logins, So Iam thinking it may cause to fail the upgrade of Production? please clarify me NOT having these 2 logins will fail the upgrade or Not?
March 27, 2009 at 12:20 pm
The reason is Server A must be Windows 2000 which comes without the network service account which was introduced in Windows 2003. You could run SSRS with Domain Admin account without using network service account. And good to know you have finished migration.
🙂
Kind regards,
Gift Peddie
March 27, 2009 at 12:51 pm
Server A is WINDOWS 2003 Standard edition with Servicepack2.
March 27, 2009 at 12:55 pm
Then your IIS 6 installation may be wrong because in Windows 2003 IIS comes uninstalled and during installation you have to make sure you enable all the features needed to run Asp.net. If you think there will be issues you could use a Domain account to run SSRS in Configuration manager.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply