installing MSDE and instance name

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

Installation Issues

I have installed MSDE2000A on both 2000 and XP Pro machines, the install
appears to go fine. After the reboot, the service manager icon is empty,
when I look for the services in the drop down in the Service Manager it is
empty. In the system services screen, I have made sure all three services
are running. I cannot restore a database on this machine or connect to it
with Enterprise Manager. Any thoughts or help is appreciated.
Hi ,
First of all when you say the msde installtion "appears" to be installed
fine , have you verified the setup log file to see if the msde did indeed
install sucessfully or if there are any messages
Please follow the steps mentioned below to solve the problem:
1) verify the setup log for any error messages (most probably the msde
wasnever installed properly in the first place)
2) Can you see the msde services in the services . Try to start them
manually
3) Connect to the instance locally with the followong command
<installdrive>\program files\microsoft sql server\80\tools\binn \osql -E
-Sservername\instancename
do not use the -S parameter if default instance is used.
4) If you connect successfully then the msde is correctly installed.
5) Ensure that the tcp/ip is enabled using the client configuration tool
(cliconfg.exe) and also the server network utility (svrnetcn.exe )
6) try manually typing the server name in the service manager when it comes
out empty and then try to connect
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I have seen this on Win 2003 where MSDE-Rel A is installed using an Instance
Name and there is no default instance.
Tim Morrison
"GrumpyOldMan" <GrumpyOldMan@.discussions.microsoft.com> wrote in message
news:7D74D170-FE18-4DAB-870C-DDCD89422968@.microsoft.com...
>I have installed MSDE2000A on both 2000 and XP Pro machines, the install
> appears to go fine. After the reboot, the service manager icon is empty,
> when I look for the services in the drop down in the Service Manager it is
> empty. In the system services screen, I have made sure all three services
> are running. I cannot restore a database on this machine or connect to it
> with Enterprise Manager. Any thoughts or help is appreciated.

Installation is not possible on W2003

I have tried to install SQL 2000 standard on W2003 Web edition. When I click
on "Install Database Server" (Installation pane) a small icon "Created with
DemoShield" appears for few second and than disappears. Then nothing
happend .. :o(
All web services (IIS, FTP, NNTP .) were stopped before installation.
Any tip will be greatly appreciated
VladIf I remember correctly, you cannot install ANY apps on Win2k3 Web =
Edition. This limit is imposed by the OS.
--=20
Keith
"Vlad" <volodimir@.get2net.dk> wrote in message =
news:O9$gL5CDEHA.2308@.tk2msftngp13.phx.gbl...
> I have tried to install SQL 2000 standard on W2003 Web edition. When I =
click
> on "Install Database Server" (Installation pane) a small icon "Created =
with
> DemoShield" appears for few second and than disappears. Then nothing
> happend .. :o(
>=20
> All web services (IIS, FTP, NNTP .) were stopped before installation.
>=20
> Any tip will be greatly appreciated
>=20
> Vlad
>=20
>=20
>=20
>|||You can install MSDE 2000 on the Web Edition but not SQL Server 2000
Standard or Enterprise.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Good to know. Thanks.
--=20
Keith
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message =
news:DsvgOiGDEHA.660@.cpmsftngxa06.phx.gbl...
> You can install MSDE 2000 on the Web Edition but not SQL Server 2000=20
> Standard or Enterprise.
>=20
> Rand
> This posting is provided "as is" with no warranties and confers no =
rights.
>

Installation is not possible on W2003

I have tried to install SQL 2000 standard on W2003 Web edition. When I click
on "Install Database Server" (Installation pane) a small icon "Created with
DemoShield" appears for few second and than disappears. Then nothing
happens .. :o(
All web services (IIS, FTP, NNTP .) were stopped before installation.
Any tip will be greatly appreciated
VladIf I remember correctly, you cannot install ANY apps on Win2k3 Web =
Edition. This limit is imposed by the OS.
--=20
Keith
"Vlad" <volodimir@.get2net.dk> wrote in message =
news:OY%23$L5CDEHA.2308@.tk2msftngp13.phx.gbl...
> I have tried to install SQL 2000 standard on W2003 Web edition. When I =
click
> on "Install Database Server" (Installation pane) a small icon "Created =
with
> DemoShield" appears for few second and than disappears. Then nothing
> happens .. :o(
>=20
> All web services (IIS, FTP, NNTP .) were stopped before installation.
>=20
> Any tip will be greatly appreciated
>=20
> Vlad
>=20
>