Re: SQL 2000 EntMgr & SQL 2005 Management Console

My WS has the SQL 2005 Express - default install using Local Service account.
These are managed WS's and I do NOT have a "local" admin account. I am
granted Admin access using a domain account that has forced password changes
periodically. Guess I could live with that.

The SQL 2000 Servers are on W2K3 Servers. I support a number of them.

Ideally I want both SQL 2000 client tools/books online AND SQL 2005 client
tools/books online on my WS. If I was forced to use just the SQL 2005 client
tools/books online I would want to register the SQL 2000 servers I support.

I'm just assuming that SQL 2005 Management Console is the replacement tool
for SQL 2000 Enterprise Manager.

"Vincent Xu [MSFT]" wrote:

Hi Martin,

Thanks for posting.

My understanding of your issue is you cannot connect to named instance of
SQL 2000 in SQL 2005 Mgt Studio.

It is possible to run two instances of SQL Server (even a mixture of 2000
and 2005) on the same server. This install is supported as long as the
Windows and Hardware requirements in Books Online are met. However, I know
that SQL 2005 Express doesn't obtain a Management stuido, so I'd like to
know from where , you try to register the SQL 2000 instance?

For your scenario, I noticed that you have installed SQL 2005 Express.
Let's perform a test, use a tool query to port 1434 using such as PortQryUI
(see link below). Are you only able to the SQL 2005 instance? Based on my
experience, this is because by default the SQL 2005 Express Edition
installs the SQL Browser service and runs it under the NetworkService
account which has limited permissions in the registry. This account does
not have permissions to the registry hive where there port information is
for the SQL 2000 instances. My suggestion is: change the startup account
for the SQL Browser service to something that has permissions to access the
area of the registry where the information is stored. You can use 'Local
System', a domain account that is a local administrator, or the same
account that is starting the SQL 2000 instance(s). Once you change the
startup account stop and restart the service. Using PortQryUI you should
see that it returns the information for the SQL 2000 named instances as
well.

Link to PortQry and PortQryUI:
http://support.microsoft.com/default.aspx?kbid=832919

Hope my suggestions helps.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security

======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: SQL 2000 EntMgr & SQL 2005 Management Console
thread-index: AcbCOvCrx20kw0NQSnGIespytSPzNQ==
X-WBNR-Posting-Host: 171.159.64.10
From: =?Utf-8?B?ZG91Zw==?= <dmartin@xxxxxxxxxxxxxxxxx>
References: <090960B5-D8DA-4D53-9317-8C3462361258@xxxxxxxxxxxxx>
<uMXqCnjwGHA.1772@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: SQL 2000 EntMgr & SQL 2005 Management Console
Date: Thu, 17 Aug 2006 13:23:02 -0700
Lines: 39
Message-ID: <FF62A3E0-4CC5-4730-AD7A-DB6EF99AF9E0@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.clients
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.clients:32020
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.clients

Everytime I opted NOT to upgrade, it says my system software is current.

I'll try again on another similar PC configuration.

doug

"Keith Kratochvil" wrote:

I had the SQL Server 2000 tools on my system. I installed SQL Server
2005
Developer Edition and made sure that I did not indicate that I wanted
to
upgrade anything. The 2005 tools installed along side the 2000 tools.
I
can run them both without any problems.

I cannot remember what the install looked like, but perhaps you
indicated
that you wanted to upgrade your system.

--
Keith Kratochvil


"doug" <dmartin@xxxxxxxxxxxxxxxxx> wrote in message
news:090960B5-D8DA-4D53-9317-8C3462361258@xxxxxxxxxxxxxxxx
On my workstation I need SQL 2000 EntMgr for ongoing support. I
installed
MSVS .Net 2005 and it installed SQL 2005 Express. I know I have a
set of
directories under Microsft SQL Server\80 and \90. I had hoped I
would be
able to run SQL 2000 EnmtMgr side by side with the newer SQL 2005
Management
Console. My intent is to register the SQL 2005 Express databases,
get
used
to new look-n-feel and then register the SQL 2000 servers I support
on the
SQL 2005 MgtCon. When I tried this on one computer, it upgraded my
client
side so I only have the one upgraded suite of tools and books online,
but
I
haven't been able to search out my SQL 2000 servers to register them.

Any suggestions?






.

Relevant Pages

  • Re: Full-Text Search is not enabled for the current database
    ... This makes the SQL Server think that the Search service is ... shut down all affected services and ran the SQL 2000 install ... > Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control ... > the MSSearch & MSSQLServer? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL developement version could not install in Xp Pro.
    ... it is failing while it is trying to register ... The best way to avoid is install the latest version of these DLL's. ... Ptsfull.exe installs the PivotTable Service files ... Follow the instructions in the SQL Server 2000 PivotTable Service. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL and SBS2003
    ... each service', 'auto start sql service', 'use a domain user account' (e.g. ... > under "To install SP3a to a new instance of SQL Server") ... >>> password is invalid and if I try to use the Windows authentication it ...
    (microsoft.public.backoffice.smallbiz)
  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Is this value the SQL password hash ?
    ... services will use a Windows NT domain account instead of the LocalSystem ... and can only be obtained by running SQL ... Server setup interactively to generate a new .iss file. ... possible or practical in your circumstances, you must install MSSQLServer ...
    (Pen-Test)
Loading