DCPROMO ruined my day

Posted on 2006-11-27
Last Modified: 2008-02-01
Greetings experts

Running Windows 2003 Server with SQL 2000  & Analysis Servives 8.0.2039. We had a custom app installed by a consultant and long story short we were forced to DCPROMO the SQL box. Not ideal but it needed to be done.  Anyway ever since the DCPROMO the cusom App hasn't worked.  The app uses IIS6 to disaply pages. This is intalled on the same box.  I was getting errors that were directly addressed in this article

I have set the permissions as descibed and those particular errors are not occuring. The app still doesn't work though.  I know you guys can't make it work for me but what pointers can you give me regarding IIS/Analysis Services and not working after a DCPROMO.

Cheers for any leads . . . .

Question by:robjeeves
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 11

Expert Comment

ID: 18025114
Have you tried reinstalling IIS?

Author Comment

ID: 18025543
Not yet mate.  I can try that.  Am waiting for the Vendor to suggest some things.  Might need to do your suggestion.


will reply back with some more news

LVL 13

Expert Comment

ID: 18025938
What's kind of custom App ? by ASP ? App should run with local MSSQL2000, rite ?

If true, I think it should be involved the MSSQL access right problem after DCPROMO, not IIS. MSSQL service can be started under default account ? You maybe need to change the MSSQL service startup logon or MSSQL connection (In MSSQL console) by domain account. please check !

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.


Author Comment

ID: 18026580
G'day Mr Rhinoceros :)

The App somehow connects to OLAP cubes and displays charts on ASP pages.  The permissions issues are no longer logged for the APS and i've been running Filemon & Regmon and am seeing no failures anymore.

I'm not too familiar with SQL, could you elaborate a little on you instructions for me?  Currently the box is running SQL2000 and that appears to be working ok.  When I look in services.msc none of the SQL services need starting, they seem to be running. In particular could you elaborate on You maybe need to change the MSSQL service startup logon or MSSQL connection (In MSSQL console) by domain account.

thanks for help so far mate.

LVL 13

Accepted Solution

rhinoceros earned 500 total points
ID: 18029307
Because you will not have local account again on DC after DCPROMO, so what's account can be used to start all MSSQL services.

1. So you should try to go "Administrative tools --> Service --> Log on Tab --> change the logon account as domain administrator" .

2. In MSSQL console --> SQL Server Group --> Servername (properties) --> Logon account by...

Author Comment

ID: 18140987

When i checked the services they were local system.  I tried a DA account and the App was still broken.  I ended up reinstalling analysis Services and it fixed it up a treat.

Thanks everyone for their ideas though


Author Comment

ID: 18169407
I'll give rhinoceros the points for having such a great name and the fact he was probably along the right lines on things to check.  Just turned out that Reinstall got it working rather than having to fiddle around any more.

Cheers and Happy Xmas to you


Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
GPO Access denied in AD 12 72
Unknown AD user under VMWare OU 4 76
DHCP server 6 67
How to rollback Windows updates with SCCM? 6 121
Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit If you want to manage em…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question