newbie: sql server problem

Hey
I have a little network consisting of 2 computers (1 winXP computer and 1
windows server 2003 computer)
I installed windows server 2003 a week ago... and now it works as domain
controller in my little domain (set up because I want to learn more about
domain/AD etc)...
3 days ago I installed Windows Sharepoint Services on this windows server
computer.
Now when I on the windows server computer look at the bottom of the screen I
see 1 icons to the right... the icon is the sql server service icon. But
this is strange to me... Usually this icon should have a green symbol or a
red symbol telling the status of sql server.. But it shows nothing... The
icon shows a computer and in front of the computer bubble is placed.
Usuallly this bubble has a green arrow or red sign telling the status of sql
server but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
What am I doing wrong here?
JeffOn your 2003 Server machine, go to Start -> Administrative Tools ->
Services. Find the MSSQLSERVER service, and if it doesn't have a
status of "Started", right-click on it and start it. Check the
SQLSERVERAGENT service as well.|||Hey
Thanks for helping me!
But I cannot find those services, the only services I find that are related
to sqlserver are these:
SQLAgent$SHAREPOINT (not running, set to start manually)
MSSQL$SHAREPOINT (started)
MSSQLServerADHelper (not running, set to start manually)
I'm considering to do a complete reinstall of windows server 2003 on this
computer...
Jeff
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1148648757.026292.309250@.j55g2000cwa.googlegroups.com...
> On your 2003 Server machine, go to Start -> Administrative Tools ->
> Services. Find the MSSQLSERVER service, and if it doesn't have a
> status of "Started", right-click on it and start it. Check the
> SQLSERVERAGENT service as well.
>|||Jeff wrote:
> Hey
> Thanks for helping me!
> But I cannot find those services, the only services I find that are relate
d
> to sqlserver are these:
> SQLAgent$SHAREPOINT (not running, set to start manually)
> MSSQL$SHAREPOINT (started)
> MSSQLServerADHelper (not running, set to start manually)
> I'm considering to do a complete reinstall of windows server 2003 on this
> computer...
>
Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
must use the MSDE engine, a quick google search would seem to verify this|||So is this correct then?:
Now when I on the windows server computer look at the bottom of the screen I
see 1 icon to the right... the icon is the sql server service icon. But this
is strange to me... Usually this icon should have a green symbol or a red
symbol telling the status of sql server.. But it shows nothing... The icon
shows a computer and in front of the computer bubble is placed. Usuallly
this bubble has a green arrow or red sign telling the status of sql server
but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
Is this as it should be?..
Jeff
"Chris Vowles" <NO_SPAM_PLEASE_chris_vowles@.hotmail.com_NO_SPAM_PLEASE>
wrote in message news:e570b5$6dd$1$8300dec7@.news.demon.co.uk...
> Jeff wrote:
> Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
> must use the MSDE engine, a quick google search would seem to verify this
>|||On Fri, 26 May 2006 15:20:38 +0200, Jeff wrote:

>I'm considering to do a complete reinstall of windows server 2003 on this
>computer...
Hi Jeff,
Hold it - no need to rush into re-installs.
The icon you are seeing in the system tray bellongs to SQL Service
Manager. This tools, which can be used to start and stop the main SQL
Server services, is installed with any edition of SQL Server 2000
(including MSDE, which was appparently installed as part of your Windows
Sharepoint Services installation). It is also added to yoour startup
group, so that the icon will show after each restart. Personally, I
remove it from the startup group and start and stop my services from
other tools, like Enterprise Manager or SSMS. But since MSDE doesn't
include those tools, you might prefer to keep using the Service Manager.
Now, you can have multiple instance of SQL Server and/or MSDE installed
on a single machine - zero or one "default" instance, and zero or more
"named" instances. But the Service Manager shows only one red or green
status dot. So you'll have to tell it which instance to monitor. (And
you can change it as often as you want).
The empty circle without greenn or red status symbol shows that Service
Manager is not yet set to watch a specific instance, and it didn't find
a default instance to watch either. So you'll have to tell it where to
look.
Right-click the system tray icon and select "Open SQL Server Service
Manager" from the pop-up list. Since you repport the Server dropdown
list to be emmppty, you'll have to type the name yourself. The service
name of a named instance consistts of two parts: the name of the
computer where the service runs (in your case the name of your WinXP
computer, unless I misunderstood your messages) and the instance name,
seperated by backslashes.

>SQLAgent$SHAREPOINT (not running, set to start manually)
>MSSQL$SHAREPOINT (started)
>MSSQLServerADHelper (not running, set to start manually)
From these names, I can see that a named instance is installed on your
computer, and that it's name is SHAREPOINT.
So assuming that the name of your WinXP computer is JEFF, you should now
type "JEFF\SHAREPOINT" (without the quotes) in the server field. Then
click the "Refresh services" button. Finally, select "SQL Server" in the
"Services" dropdown.
Hugo Kornelis, SQL Server MVP