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

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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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?
0
arnoldCommented:
What errors if any are reflected?  What credentials does the SQL agent is configured to use?
0
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.
0
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
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.