Showing posts with label managerwithout. Show all posts
Showing posts with label managerwithout. Show all posts

Thursday, March 22, 2012

Easiest way to determine if only client tools are installed?

Hi all,
I've been trying to register my local sql server in enterprise manager
without any success - I can see my remote sql server, but it just wont
connect to the local one on the laptop - I think I may have only install
"client tools" in the past because I thought I'd only want to connect to the
remote server - is there an easy to way to determine whether this is the
case? I've just checked under Add/Remove Programs and there's a SQL Server
entry for about 70mb...
Any info appreciated..
Regards
RobRob Meade (ten.bewdoowsgnik@.edaem.bbor) writes:
> I've been trying to register my local sql server in enterprise manager
> without any success - I can see my remote sql server, but it just wont
> connect to the local one on the laptop - I think I may have only install
> "client tools" in the past because I thought I'd only want to connect to
> the remote server - is there an easy to way to determine whether this is
> the case? I've just checked under Add/Remove Programs and there's a SQL
> Server entry for about 70mb...
Start->Programs->SQL Server. Do you see a Server Network Utility? If you
don't, you don't have the server installed. If you do, you have it
installed. If you also have a Service Manager, start it, and then find
the SQL Server service, and make sure it's running.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql