Cant See SQL instance from one machine

Hello,
What would cause the inability to see a SQL instance from one machine. I
may not be asking correctly, so I will try to explian.
On 3 out of 4 network workstations (XP SP2), I can see the instance (
servername\instancename ) of the SQL db on the Win2003 server. On the
fourth identical workstation I see the ( servername ) but no actual
DBinstance name. What could be the issue here? Any help really
appreciated!
Thank you
Chris Knapp
Hi,
Looks like for the 4th instance you have installed a Default instance of sql
server. In that case you will have only Server name.
Thanks
Hari
SQL Server MVP
"Chris Knapp" <sboldman_at_gmail_dot_com> wrote in message
news:Oda352bUFHA.3952@.TK2MSFTNGP15.phx.gbl...
> Hello,
> What would cause the inability to see a SQL instance from one machine. I
> may not be asking correctly, so I will try to explian.
> On 3 out of 4 network workstations (XP SP2), I can see the instance (
> servername\instancename ) of the SQL db on the Win2003 server. On the
> fourth identical workstation I see the ( servername ) but no actual
> DBinstance name. What could be the issue here? Any help really
> appreciated!
> Thank you
> Chris Knapp
>
|||Hello, and thank you for the reply.
I'm not sure I understand correctly.
I have MSDE installed on the Win2003 server named 'server1' and it's
instance is called 'manufacturing' so it's name should be (
server1\manufacturing ). That is the only place SQL is installed. Then
there are four XP workstations that connect to the databases on
(server1\manufacturing). Three of the workstations see the (
server1\manufacturing ) when they look at available SQL instances. The
fourth system , when looking for available SQL instances, sees (server1) but
without the instance name (manufacturing).
Thank you so much for any other help you can provide.
Chris Knapp
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23wUlRMiUFHA.2892@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Looks like for the 4th instance you have installed a Default instance of
> sql
> server. In that case you will have only Server name.
> Thanks
> Hari
> SQL Server MVP
> "Chris Knapp" <sboldman_at_gmail_dot_com> wrote in message
> news:Oda352bUFHA.3952@.TK2MSFTNGP15.phx.gbl...
>