MS Project Server 2002 & SQL Server 2000 sa account

MS Project Server 2002 is installed on SQL Server 2000. SQL Server sa account has blank password at the moment. What will happen, if sa updated with not blank password? I mean, will MS Project continue to work normal, or something should be done additionally.
Evgeniy ShakhovskeyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Your connection strings will need to include password.

If you use integrated security, it will make no difference.

SQL 2000 is seriously out of date, ......

You've not included any detail that may clarify your concern.
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Hi,

Project Server 2002 stores the connection to SQL Server in the registry. Go to HKLM\Software\Microsoft\Office\10.0\MS Project\WebClientServer\ProjectServer. The last is the name of your ProjectServer instance and might be different.
Now open the DataSets/Application folder and edit the ConnectInfo entry. This is a standard SQL connection string where you need to enter the password for the sa account.

And yes, you should really walk away from this version and use PPM 2010 oder PPM 2013! Serious!

Thomas

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Evgeniy ShakhovskeyAuthor Commented:
Thank you very much.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Evgeniy ShakhovskeyAuthor Commented:
SQLSERVERAGENT does not start any more :-(
"SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
What should be changed to make it work again?
arnoldCommented:
What errors if any are reflected?  What credentials does the SQL agent is configured to use?
Evgeniy ShakhovskeyAuthor Commented:
SQL Agenet is configured to Log on as Local System. Thr errors from sqlagent.out:
2015-08-11 17:54:31 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2015-08-11 17:54:31 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start

I did not reconfigured anything. It worked since ling ago untill I set password to sa.
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Hi,

I recommend you open a NEW request as this is out of scope for Microsoft Project questions. You can expect more feedback if you label it as SQL question! Most experts just have their search criteria set on "buzz" words that appeal to their expertise.

Regards

Thomas
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.