Jim Galbally

still trying to teach myself SQL

and NO ranj im not gonna post this on a proper forum

anyway, i wanna use the enterprise manager snapin on my own desktop PC and connect to the SQL server... saves me feckin about and keep moving desks when i wanna do something or VNCing in...

i thought you simply opened the snapin on the local machine n then set it up, but the snapin wont open n gives an error n dont work

anyone know what im probably doing wrong... lol

Adrian

Load enterprise manager on your local machine and add the server as a trusted connection.

Jim Galbally

my local machnie doesnt have enterprise manager...

i thught all i had to do was start..run... mmc then file.... open... SQL Server Enterprise Manager.MSC and i'd be able to add it... but it comes up with an error of snap-in failed to initialise and dont work...

do i need to install something on my local machine? (which does NOT have SQL server running on it)

Adrian

SQL Enterprise manager.

i have 6.5 and 2000 enterprise only installed on mine here.

All I then do is connect to the servers using a trusted connection.