| Author |
Topic |
|
vavs
Starting Member
24 Posts |
 Posted - 2010-09-05 : 07:46:30
|
| I would like to know if there is a way to set up SQL Enterprise Manager to run on my local machine rather than my server. This is not a major issue however it would allow me to do some things that I cannot right now. I have SQL 2005 with Management Console 3.0 and Enterprise Manager version 8 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-05 : 10:35:13
|
| just connect to your localhost (or your local machine) where you have your SQL Sequel running. |
 |
|
|
vavs
Starting Member
24 Posts |
Posted - 2010-09-05 : 10:49:02
|
| Enterprise manager is running on my server and the databases reside on the same server. Is there a way to install Enterprise Manager on my laptop so that I don't have to be on the server to manage it?I am currently using a remote desktop like session to view the server. I would rather not do it this way. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-09-05 : 11:46:55
|
| Yes, the client tools can be installed on your laptop. Are you having a problem getting them installed? |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-05 : 11:49:16
|
| either way you will need to create connection string to your server. yes, you can install Enterprise manager on your laptop, just make sure you can coonect to your server and database. your laptop ought to be in same domain as your server and you should create linked servers to connect to your server. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-09-05 : 16:28:26
|
quote:
Originally posted by slimt_slimt
either way you will need to create connection string to your server. yes, you can install Enterprise manager on your laptop, just make sure you can coonect to your server and database. your laptop ought to be in same domain as your server and you should create linked servers to connect to your server.
Sorry - but I don't know what you are talking about here. If you install the client tools to your desktop, all you then do is open the tools on your desktop and connect to the server.No need to create any linked servers - and the only requirement about being in the same domain is if you are using windows authentication. Even there, if the domains are trusted - you don't have to be in the same domain. The domains don't even have to be fully trusted - a one way trust (your local domain is trusted by the other domain) will work. The opposite is not true...Whether or not your local machine is on the domain - you can still use SQL Authentication to access the server, as long as you have a SQL login and the server is setup in mixed mode authentication. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-06 : 03:23:33
|
My memory is getting rusty for Enterprise Manager and SQL 2005 - but my recollection is that Enterprise Manager (which was the tool provided with SQL 2000) does not connect to SQL 2005 databases? Certainly it won't be capable of doing all the possible tasks available in SQL 2005.However, if "Enterprise Manager" is a generic term  and refers to what is now know as SSMS, which was the replacement for Enterprise Manager when SQL 2005 came out, then as the other have said above - install the client tools on your local PC and then you can make a connection to any Server / Database that you have access to |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-09-06 : 13:02:27
|
| Kristen, I cannot recall whether or not Enterprise Manager can connect to SQL Server 2005 or not either. But, I do know the Query Analyser can connect and run queries.I will only open the 2005 client tools when I need to do something specific with a 2000 or 2005 system that I cannot use the 2008 tools for. For example, BIDS in 2008 will not work against a 2005 system - nor can you connect to 2005 Integration Services using the 2008 tools. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-06 : 17:36:28
|
| "I do know the Query Analyser can connect and run queries."Indeed, and I still use QA against SQL 2008. But Object Explorer is limited - can't Script an object, for example |
|
|
|
|
Run enterprise manager from local machine