I have installed SQL Server 2005 Express on a client's network.
Today I seem to be unable to logon to the database, either using my MS Access "project" application or the SQL Server Management Studio Express program.
When I use the SQL Server Surface Area Configuration program, I see that the SQLEXPRESS Database Engine has stopped even though the "Startup type" is set to "Automatic". When I click on the "Start" button a progess bar appears for about 10 seconds then I'm told the operation has timed out and I need to have administrator privileges to perform that action.
I am logged on to the hosting Server (running Windows Server 2003) using an "Administrator" logon from a Windows XP PC using a Remote Desktop connection. I used this method to install SQL Server on the server in the first place and up until now have been able to run the SQL Server Management Studio Express program to maintain the database.
Does anyone have any suggestions on how I can re-start my SQL Server Database Engine, and why I now appear to not be recognised as an Administrator?
Many thanks. Colin.