SQL Database won't connect

Good morning,
On Monday we had a power outage and my UPS's couldn't keep my servers up long enough to perform a soft shutdown.  As a result, I've had to fix my AD/DNS server.  My SQL server will not connect to my fsas_live database (old Navision).  I have made several screenshots for viewing.  I believe the issue is related to failed authentication.  

A few weeks ago, I had changed the Administrator password, I think that the SQL is seeing the old password?  How can I manually update the corrected Administrator password?

Please give mr your expert advise based on the error screenshots I have provided.
Thank you in advance for your help. I am truly grateful!!
lamrski
Can-t-connect-fsas-live.docx
LamrskiAsked:
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.

Jim P.Commented:
Change the authentication to Windows Authentication and try it.
Authentication
If you aren't logged in as the administrator account then try doing a RunAs or log off and log in as the FNAS\administrator account.
0
lcohanDatabase AnalystCommented:
Looks like you are running SQL 2005 RTM with 1 hot fix on the top according to this:
http://myexperienceinmssql.blogspot.ca/2011/03/microsoft-sql-server-2005-builds.html
And on the top the issue by looking at the screenshot is not authentication but the fact that your database is not in a on-line state.

In my opinion you should run at least SQL 2005 SP4, and besides that I hope you have good backups for "fsas_live" database.

Try bring it on line - see:
http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx


You can run this command in SQL SSMS to see what is its status:

use master
go
SELECT DATABASEPROPERTYEX ('fsas_live', 'Status')
SELECT DATABASEPROPERTYEX ('fsas_live', 'UserAccess')
go
0
LamrskiAuthor Commented:
Neither of these answers were the solution.
The answer was to stop and restart the services.
Thank you though!!
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
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 2005

From novice to tech pro — start learning today.