cant see server

Hi,
Twice this has happened....
WinXP Pro SP2. SQL server 2000
When I have used a third party app (.net tool) to select my sql box from the
"available list" it pauses for a while and the drop down list is empty.
I manually type the name of the server in and it goes ahead just fine.
The same happened when I just tried to create a DSN via the MS Access upsize
wizard.

Why can't 3rd parties see the server instance?

JayIf your are using TCP. Sounds like WINS is working but something is
blocking UDP port 1434.

Could be a router, firewall, XP SP2's built in firewall blocks this...

"Jay" <nospam@.*here.com> wrote in message
news:WqUsd.22789$9A.392629@.news.xtra.co.nz...
> Hi,
> Twice this has happened....
> WinXP Pro SP2. SQL server 2000
> When I have used a third party app (.net tool) to select my sql box from
> the "available list" it pauses for a while and the drop down list is
> empty.
> I manually type the name of the server in and it goes ahead just fine.
> The same happened when I just tried to create a DSN via the MS Access
> upsize wizard.
> Why can't 3rd parties see the server instance?
> Jay|||Hi Danny,
More info...

Looked at network config and it says that named pipes and tcp are the
enabled protocols.
I don't use the XP SP2 firewall. I use Kerio.
I've checked the kerio app settings and SQL is set to "ask" as opposed to
permit or deny (so I'd expect a Kerio dialogue if anything was trying?)
The server installation (in EM) is listed simply as (local).

New DSN and the server drop down box is empty but, get this!, if I type in a
period "." and click next it goes ahead no problem and the connection tests
ok!

Jay

"Danny" <istdrs@.flash.net> wrote in message
news:mzYsd.29107$Rf1.16651@.newssvr19.news.prodigy. com...
> If your are using TCP. Sounds like WINS is working but something is
> blocking UDP port 1434.
> Could be a router, firewall, XP SP2's built in firewall blocks this...
>
> "Jay" <nospam@.*here.com> wrote in message
> news:WqUsd.22789$9A.392629@.news.xtra.co.nz...
>> Hi,
>> Twice this has happened....
>> WinXP Pro SP2. SQL server 2000
>> When I have used a third party app (.net tool) to select my sql box from
>> the "available list" it pauses for a while and the drop down list is
>> empty.
>> I manually type the name of the server in and it goes ahead just fine.
>> The same happened when I just tried to create a DSN via the MS Access
>> upsize wizard.
>>
>> Why can't 3rd parties see the server instance?
>>
>> Jay
>>

Cant get Reports Server page to work

hi I have sql 2005 Standard on WinXP and i cant get http://localhost/ReportServer to work.
I get the web page error
Server Application Error
The server has encountered an error while loading an application during the

processing of your request. Please refer to the event log for more detail

information. Please contact the server administrator for assistance.

I have re-installed sql 2005, reinstalled IIS .
I have run the aspnet_regiis -i and still nothing.

Please someone, anyone , help.

just a suggestion

have a look in your sql server configuration tools // configuration manager // expand the network configuration until you get protocols and then in the right hand pane you should see TCPIP - double click - it might say disabled. - double click and in the properties - then select IP addresses tab - 127.0.0.1 make sure this is enabled. Also check this for remote connections.

We have been down this road and that's what solved ours.

Hope it helps

jewel

|||Hi, I tried as you suggested. That was already enabled.
Still not working.|||what does your event viewer say?|||Event Type: Warning
Event Source: W3SVC
Event Category: None
Event ID: 36

Description:
The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found.|||

here is a link that may help :)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257267

|||Hi, i tried what was said in the post but still nothing.
i

dont have the file mentioned above in my c:\winnt\system 32. I think

the above is for win nt . I have win xp and my component services

doesnt hang.
|||This seems more like an IIS issue. How about trying to recreate the default web site? If you deploy an ASP.NET app on the default website, does it work? If you reinstall SQL and IIS, make sure you install IIS before SQL.