Hi Joe,
The little server icon is called Service Manager and it does not list the
named instances.
To check the status of the named instance that you have installed, you can
type the server name in the Severbox. It is a dropdown cum text box. So you
will be able to type the SQL Server Name.
For a named instance, the SQL Server name would be
<computername>\<Instancename>.
In your case it would be <computername>\JoesDB01.
After typing the server name, click on Refresh Services button and it
should show you the state of the different services, like the SQL Server,
SQL Server Agent, Distributed Transaction Coordinator.
You can control the state of each Service,
1. Start - Click on this to start/Continue the service, if it is Stopped or
Paused
2. Stop - Click on this to stop the Service.
3. Pause - Click on this to pause the service. Pausing, will allow the
current users to work and will not allow new users to connect to the SQL
Server.
You can also installed the SQL Web Data Administrator, to create and manage
Database from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Great! This helped a lot. Things seem to be working fine now
Thanks Ashish!
-- Joe
sql
Showing posts with label status. Show all posts
Showing posts with label status. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
Installation Stalls at "Detecting Installed IIS"
I try to install but once it gets to Installation Status window it freezes at Detecting Installed IIS. What do I do to get past this wonderful step? And who tested this installation process? Better yet, who let it be releases with so many bugs?
do you have Norton/Symantec antivirus software running on your machine? If so, temporarily disable it and rerun setup.
|||Thank youl. I finally had success.
Seems like turning it off (Symantec Antivirus) was not a guarantee for success -- I did turn it off before with no success; uninstalling all might have helped too where I then installed it fresh.
Subscribe to:
Posts (Atom)