Re: Named Instance, Connectivity Question
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 04/02/04
- Next message: Mark: "Re: Can't grant permissions to a sql user"
- Previous message: JJ: "Re: Mixing SQL Server and MSDE and authentication"
- In reply to: Greg Chang: "Named Instance, Connectivity Question"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Apr 2004 19:22:58 +0200
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.aspx?scid=kb;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.shtm http://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
- Next message: Mark: "Re: Can't grant permissions to a sql user"
- Previous message: JJ: "Re: Mixing SQL Server and MSDE and authentication"
- In reply to: Greg Chang: "Named Instance, Connectivity Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
