ssms not seeing local sql server

#**201**

Can't speak for reporting services, but for database engine you should be
able to switch to registered servers view, right-click the registered
servers or local server group node and choose to update local registrations.
I only have 2008 SSMS in front of me and I know the option is now in a
slightly different spot, but the concept is the same.

On 3/4/09 2:40 PM, in article QrDrl.43304$1N5.39561 (AT) newsfe21 (DOT) ams2, "Lucas D"
<noreply (AT) test (DOT) com> wrote:

Quote:

John A Grandy wrote:
Windows Server 2003 x64 Enterprise Edition

SQL Server 2005 Developer Edition

Why would SSMS run locally not see a local sql server instance , when SSMS
run on another box on the network can see this instance and connect to it ?

I have never had to do any config for SSMS ... it always works
out-of-the-box ...

Somebody knows the answer to this issue?

Also having this issue on Sql Server 2005 Std Edition x64 , with SP2-
Local servers don't show up in SSMS - not a problem to connect with
dbserver (typing a dot), but it is not possible to connect to reporting
services neither (via SMSS) - heard that typing http:\\localhost\reports
in SSMS when trying to connect woult also work, but didn't try that yet.

I have to say that
1) the services run with the local built-in account (set during
installation)
2) at first the sql browser service was not enabled - i enabled it after
installation when i saw the problem - after this, i could connect to my
local server via "browse for severs, network servers", but still not via
the "local servers"-tab
2)when installing sqlserver the IIS-website was stopped, and I
configured reportingservices afterwards (after i had started the default
iis-site).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ssms not seeing local sql server

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: ssms not seeing local sql server - 03-04-2009 , 06:08 PM