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
[quoted text, click to view] "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...
>> 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
>>
>>
>
>
