Re: SQL 2000 EntMgr & SQL 2005 Management Console

Hi Martin,

Thanks for your reply and clarifying.

Now, my understanding of your situation is: the Workstation (I suspect it
is Windows XP Pro SP2.) installed SQL 2005 express , SQL 2000 client tools
and SQL 2005 client tools. You are unable to register any SQL 2000 server
in SQL 2005 Mgt Studio. Please feel free to correct me.

For such situation, as I said in my previous reply, SQL 2000 can be
registred in SQL 2005 Mgt Studio. For troubleshooting reasons, I have
following suggestions:

1. Check if you can register those remote SQL 2000 server in SQL 2000
Enterprise Management?
2. You are unable to register all remote SQL 2000 server or some of them?
3. Try telnet "servername or IP" 1433 & telnet "servername or IP" 1434 to
check if the ports are opened.
4. Please let me know the exact symptom when you try to register the remote
sql 2000 server in SQL 2005 Mgt Studio.For example: Is there any error
message? When you browse the remote server, can you see any SQL server?

Please tell me the result of this issue at your earliest convenience. If
there is anything unclear, please don't hesitate to let me know. I'm
looking forward to your reply.

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: AcbC8PdlsXhL7zluQfCdmSoCWoGdVA==
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>
<FF62A3E0-4CC5-4730-AD7A-DB6EF99AF9E0@xxxxxxxxxxxxx>
<wypPfTnwGHA.5368@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: SQL 2000 EntMgr & SQL 2005 Management Console
Date: Fri, 18 Aug 2006 11:06:02 -0700
Lines: 147
Message-ID: <DE32D474-943D-4E2B-A26B-A299B9F892A8@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:32023
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.clients

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: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
    ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
    (microsoft.public.sms.installer)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)
Loading