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?

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 (AT) newsgroups (DOT) nospam> wrote

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:

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.
================================================== ====



--------------------

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 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.
================================================== ====



--------------------
<FF62A3E0-4CC5-4730-AD7A-DB6EF99AF9E0 (AT) microsoft (DOT) com>
<wypPfTnwGHA.5368 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>

Hi Martin,

I am just writing to see how everything is going. If you have any updates
or need any further assistance on this issue, please feel free to let me
know. I am glad to be of assistance.

Have a nice day!

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.
================================================== ====



--------------------
<FF62A3E0-4CC5-4730-AD7A-DB6EF99AF9E0 (AT) microsoft (DOT) com>
<wypPfTnwGHA.5368 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<DE32D474-943D-4E2B-A26B-A299B9F892A8 (AT) microsoft (DOT) com>

Vincent,

I have the same situation: 2 named instances of SQL 2000 and 1 named
instance of SQL 2005 on a W2003 server. I have EM on one workstation and I
can register the 2000 instances. I have Management Studio on another
workstation and I can register the 2005 instance, but I have not been ablet
to register the 2000 instances from it.

I can see all 3 instances on 1434 UDP using Portquery. Any suggestions?

Cam

"Vincent Xu [MSFT]" wrote: