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?
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…