I needed to change the service account with the one that my network admin just gave. My sql server and sharepoint portal server 2003 are both on the same windows 2003 server. I added the new service account to local admin of the server.
Then I logged in as with the new service account on the server and changed services to run using the new account. The services changed were:
Microsoft SharePointPS Search
MSSQLSERVER
SharePoint Portal Administration
SharePoint Portal Alert
SharePoint Timer Service
SQLSERVERAGENT
I also changed under the IIS->Application Pools -> Identity tab -> Configurable to use the new userid and password
I restarted the server all services came up fine and the Application Pools too showed as running.
Now when I launched IE and went to the Sharepoint site, it simply gave me "Service Unavailable"
Don't know what I am missing...
Any help is appreciated