Named Instance, Connectivity Question

I had XP Machine, with SQL Server 2000 Client
preinstalled.
This week, I installed MSDE 2000 under Named Instance.
After this, I restart my PC, I can see the Names Instance
is up running under Service window.
By My SQL server Enterprise Manager and SQL Analyzer wont
see the instance or any MSDE server.
Then I installed default Instance(no name), then
Enterprise Manager and SQL Analyzer can see MSDE sever
under LOCAL name, I assume this is the default instance.
My VB Data Enviroment can see a MSDE server under my
Computer name.
My Questiona are:
1. How do I login the named instance?
2. can I installed Named instance alone without a default
instance? if not, does the install sequence matters?
3. how to rollback my installation in case I want retry?
Greg Chang
hi Greg,
"Greg Chang" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:176dc01c418d4$3cb51410$a501280a@.phx.gbl...
> I had XP Machine, with SQL Server 2000 Client
> preinstalled.
> This week, I installed MSDE 2000 under Named Instance.
> After this, I restart my PC, I can see the Names Instance
> is up running under Service window.
> By My SQL server Enterprise Manager and SQL Analyzer wont
> see the instance or any MSDE server.
> Then I installed default Instance(no name), then
> Enterprise Manager and SQL Analyzer can see MSDE sever
> under LOCAL name, I assume this is the default instance.
> My VB Data Enviroment can see a MSDE server under my
> Computer name.
thi can be due to
http://support.microsoft.com/default...b;EN-US;814132 ...
there are other undocumented issues regarding instance names not showing up
in the service manager list thought...

> My Questiona are:
> 1. How do I login the named instance?
you must provide the full name as ComputerName\InstanceName

> 2. can I installed Named instance alone without a default
> instance? if not, does the install sequence matters?
yes, you can install only a named instance, only a default instance, or upt
to 15 named instances and 1 default instance...

> 3. how to rollback my installation in case I want retry?
you have to fully uninstall it... go in control panel and use the
install/uninstall applet...
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

my value doesnt reset when i used sum(field, scope)

pls help what seems to be the problem? my sum doesnt restart as the group changes. instead it accumulates the sum? thanks.

use

RunningValue(Fields, Sum, scope)

my value doesnt reset when i used sum(field, scope)

pls help what seems to be the problem? my sum doesnt restart as the group changes. instead it accumulates the sum? thanks.

use

RunningValue(Fields, Sum, scope)