edd_t Posted January 19, 2006 Share Posted January 19, 2006 Does anyone know if its possible to install the SQL Server Enterprise Manager onto a client PC running XP Pro, and be able to connect to the SQL databases on the servers? Link to comment Share on other sites More sharing options...
Pete Posted January 19, 2006 Share Posted January 19, 2006 Yup. In SQL 2005 they've made it a bit more obvious. Link to comment Share on other sites More sharing options...
Chase Posted January 19, 2006 Share Posted January 19, 2006 Yes. You can install the client tools only on the client and access the DB on another box. Link to comment Share on other sites More sharing options...
edd_t Posted January 19, 2006 Author Share Posted January 19, 2006 hmmm not sure we run SQL 2005, its the previous version. im guessing the client tools are on the SQL CD somewhere? Link to comment Share on other sites More sharing options...
HunterJ Posted January 19, 2006 Share Posted January 19, 2006 Just run the main setup program on the cd, and choose client tools option (its a couple of steps into the install)... Once running on the client, just register your servers. You may need to modify the clients network config (use the tool cliconfg) depending on the servers network settings (ie TCP/IP, Named Pipes etc and ports). Jamie Link to comment Share on other sites More sharing options...
edd_t Posted January 19, 2006 Author Share Posted January 19, 2006 nice one cheers dudes... Link to comment Share on other sites More sharing options...
Keith C Posted January 19, 2006 Share Posted January 19, 2006 Use the new SQL2005 Enterprise manager - still lets you connect to SQL2000 (and I think SQL7) databases, but is approx 5386239087 times better and faster than the old SQL2000 Enterprise manager. Link to comment Share on other sites More sharing options...
Pete Posted January 19, 2006 Share Posted January 19, 2006 Use the new SQL2005 Enterprise manager - still lets you connect to SQL2000 (and I think SQL7) databases, but is approx 5386239087 times better and faster than the old SQL2000 Enterprise manager. Nearly...it's. 5386239088 Link to comment Share on other sites More sharing options...
paul_y3k Posted January 19, 2006 Share Posted January 19, 2006 use Oracle Link to comment Share on other sites More sharing options...
Keith C Posted January 19, 2006 Share Posted January 19, 2006 use Oracle Certainly - into which orifice would you like me to insert this brick? Just in order to simulate the pain induced by paying the license fees Link to comment Share on other sites More sharing options...
Keith C Posted January 19, 2006 Share Posted January 19, 2006 Besides, much as a love Oracle, it's front end tools suck the big one compared to Enterprise manager IMO. Only database system I use which I *prefer* to use the command line over the GUI. (Caveat - last significant usage was 8i, so might have changed since) Link to comment Share on other sites More sharing options...
edd_t Posted January 19, 2006 Author Share Posted January 19, 2006 use Oracle haha my fantasic boss (yeah right hes a complete ar5e) has just employed an oracle programmer to look after our SQL databases (this is the person that need the client) surely it doesnt make sense to do that! Link to comment Share on other sites More sharing options...
Bobbeh Posted January 19, 2006 Share Posted January 19, 2006 Besides, much as a love Oracle, it's front end tools suck the big one compared to Enterprise manager IMO. Only database system I use which I *prefer* to use the command line over the GUI. (Caveat - last significant usage was 8i, so might have changed since) Agreed, the Java front end sucks. But all I use is the chui interface, as long as you know what you're doing that'll do, and on a lot of UNIX systems thats yer lot! Link to comment Share on other sites More sharing options...
Bobbeh Posted January 19, 2006 Share Posted January 19, 2006 haha my fantasic boss (yeah right hes a complete ar5e) has just employed an oracle programmer to look after our SQL databases (this is the person that need the client) surely it doesnt make sense to do that! What do you mean? Because hes an Oracle DBA looking after a SQL Server system its wrong?! Thats like saying a Supra driver isnt capable of driving a Mini Link to comment Share on other sites More sharing options...
Keith C Posted January 19, 2006 Share Posted January 19, 2006 Agreed, the Java front end sucks. But all I use is the chui interface, as long as you know what you're doing that'll do, and on a lot of UNIX systems thats yer lot! My Oracle life started on Solaris, so I had to learn to do it the 'proper' way. Link to comment Share on other sites More sharing options...
Guest chiefvinso Posted January 19, 2006 Share Posted January 19, 2006 Is sql 2005 that much better than 2000? Link to comment Share on other sites More sharing options...
edd_t Posted January 19, 2006 Author Share Posted January 19, 2006 What do you mean? Because hes an Oracle DBA looking after a SQL Server system its wrong?! Thats like saying a Supra driver isnt capable of driving a Mini sorry im not really into databases. thought there might be quite a large difference in the way they're coded and programmed etc... Link to comment Share on other sites More sharing options...
paul_y3k Posted January 19, 2006 Share Posted January 19, 2006 Besides, much as a love Oracle, it's front end tools suck the big one compared to Enterprise manager IMO. Only database system I use which I *prefer* to use the command line over the GUI. (Caveat - last significant usage was 8i, so might have changed since) lol yeah the java gui isn't great, but then commanline stuff is keeping it real !0G is all via the browser ... it's faster then 9 but I really dont like the layout. So I'm sticking to Toad. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now