[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1356
  • Last Modified:

MSSQL Enterprise Manager on Windows 7 when I only have a SQL Server 2000 disk?

I'm running MSSQL Server 2000 and need to get Enterprise Manager on my boss' new Windows 7 machine. SQL Server 2000 doesn't seem to be compatible with Windows 7, and I can't find any kind of compatibility pack or free Enterprise Manager download.

Is there a way to get a version of Enterprise Manager on Windows 7 without buying a newer version of SQL Server?
0
SysAdmin06
Asked:
SysAdmin06
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should try the sql 2005 or sql 2008 client (sql management studio) to connect to a sql 2000 instance (works fine).
it requires though proper licensing...
0
 
Vaidas911Commented:
workaround is to give your manager a Remote Desktop connection to computer (server) that has SQL 2000 Enterprise manager working in place
0
 
SysAdmin06Author Commented:
angellll:
Does the SQL Management Studio have all the functionality of Enterprise Manager? As far as licensing goes, do you have to license Management Studio, or does the software just require a legal copy of SQL Server to connect to? Our Server software is legit.

Vaidas911:
I had already offered up that solution to him, but he wasn't exactly thrilled about doing it that way. Thanks for the response, though.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
leakim971PluritechnicianCommented:
Hello SysAdmin06,

If your really want to use MSSQL Enterprise Manager :
- http://www.virtualbox.org/
- http://www.vmware.com/fr/products/ws/

If you have a windows 2008 server : You can deploy the application with RemoteApp and run it like it's installed on your boss machine : http://technet.microsoft.com/en-us/library/cc730673(WS.10).aspx

Regards.
0
 
SysAdmin06Author Commented:
I would have liked an explanation of the software, and a response to my question regarding your original post.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sorry, I was on vacation ...


>Does the SQL Management Studio have all the functionality of Enterprise Manager?
yes, and more


>As far as licensing goes, do you have to license Management Studio, or does the software just require a legal copy of SQL Server to connect to? Our Server software is legit.
yes, you need a 2005+ instance licenced.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now