SQL2K5 client tools and SQL2K

[wbodger]

Can I connect to a SQL2K server using the SQL2K5 x64 client tools? I am in a unique situation, just got a new box (desktop) where I would like to install a 64-bit OS and then the 64-bit SQL2K5, but I have not been able to upgrade my server to 2K5 yet.

And then on another note (I know I may have to take this elsewhere but figured I could ask while I was here), can I VPN from a 32-bit XP Pro into a 64-bit Vista computer if I am an admin on that box (yes, I can VPN into my 32-bit XP Pro machine)?

Thanks!

Willie

 

[mrdenny]

Yes you can connect to a SQL 2000 server with SQL 2005 tools. It doesn't matter if the tools are 32bit or 64bit.

There will be a few things that you'll need to RDP to the server for like DTS packages.

Yes RDP works between 32bit and 64bit machines.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[wbodger]

Great, thanks!

 

[wbodger]

So, I can do all of the DTS stuff from the SQL2K5 tools that I do from the SQL2K tools? And maintenance plans, can I modify or setup those in 2K using the 2K5 tools? Or do I need to setup the 2K tools as well?

 

[mrdenny]

If you are using the 32bit tools you can edit DTS packages. There is an addon which you can download which allows you to edit the packages. I don't think that this addon is available for 64bit SQL. I'm not sure however. When you try to open a DTS package the UI will give you the URL.

You will not be able to create SQL 2000 maintenance plans from the SQL 2005 tools. You will need to create the plan in the SQL 2000 tools. Once the plan is create you can edit it from within the SQL 2005 tools.

I would recommend simply remote desktoping to the SQL 2000 machine to do the few things which you can't do with the SQL 2005 tools. That's what I did at a prior job when I had a bunch of SQL 2000 machines and I was using the SQL 2005 UI.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[wbodger]

That makes sense. Perhaps a 64-bit OS on my desktop is not of much use at this point.

 

[mrdenny]

Unless you are doing a lot of number crunching on your desktop, 64bit won't do much for you. Especially since not much has been ported to 64bit yet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog