ssms not seeing local sql server

#41

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#42

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#43

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#44

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#45

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#46

John A Grandy (johnagrandy@g-mail-dot-com) writes:

Quote:

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

Rather than typing the server name, a single dot should do.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#47

Also, it's the SQL Server Browser Service that provides that info. Is the
SQL Server Browser Service on the SQL Server computer running?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jeffrey Williams" <jeff.williams3188 (AT) verizon (DOT) ent> wrote

Quote:

John A Grandy wrote:
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 ...

When you browse - the dialog comes up browsing the network. There is
another tab in the dialog for local instances where you should see your
local instance.

#48

Also, it's the SQL Server Browser Service that provides that info. Is the
SQL Server Browser Service on the SQL Server computer running?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jeffrey Williams" <jeff.williams3188 (AT) verizon (DOT) ent> wrote

Quote:

John A Grandy wrote:
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 ...

When you browse - the dialog comes up browsing the network. There is
another tab in the dialog for local instances where you should see your
local instance.

#49

Also, it's the SQL Server Browser Service that provides that info. Is the
SQL Server Browser Service on the SQL Server computer running?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jeffrey Williams" <jeff.williams3188 (AT) verizon (DOT) ent> wrote

Quote:

John A Grandy wrote:
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 ...

When you browse - the dialog comes up browsing the network. There is
another tab in the dialog for local instances where you should see your
local instance.

#50

Also, it's the SQL Server Browser Service that provides that info. Is the
SQL Server Browser Service on the SQL Server computer running?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jeffrey Williams" <jeff.williams3188 (AT) verizon (DOT) ent> wrote

Quote:

John A Grandy wrote:
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 ...

When you browse - the dialog comes up browsing the network. There is
another tab in the dialog for local instances where you should see your
local instance.