ssms not seeing local sql server

#11

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#12

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#13

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#14

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#15

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#16

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#17

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#18

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#19

Sometimes it happens, I mean you don't see a locally installed instance on
the drop down list. I don't know exactly why it happens, but after typing it
manually and connected to that instance successfully, its recorded and can
be found on the drop down list.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy@g-mail-dot-com> wrote

Quote:

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to
connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network
?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote in message
news:A7AECB3D-8DFC-4D3C-B905-21F1FB79AEC9 (AT) microsoft (DOT) com...
What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...

#20

There is nothing listed in the dropdown and attempting to browse does not
find anything.

After I posted, I tried typing in the server name and I was able to connect.

But I'm wondering why can't SSMS auto-discover sql servers on the network ?

"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> wrote

Quote:

What do you mean "do not see a local instance"? Do you mean when you open
up SSMS, you can't see the instance which you want to connect in the
Connect to Server dialog box's Server drop down box?

If its name does not appear in this list, did you try to type it yourself
and connect to it this way? If you have tried this way and it does not
connect, do you see an error message or something? Tell us what happends
more detailed if possible.

--
Ekrem Önsoy

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:ukqr24DIJHA.1308 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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 ...