|
|
|
|
XP / SQL personal: Cannot find localhost
Hi,
I installed SQL Server 2000 personal edition on my Win XP sp2. In the
enterprise manager, I can manage my local database, but if I try to connect
via the Query analyzer, it says it cannot find the server or the access is
denied.
I added localhost in the Client network utilities and it still doesn't work.
Why can't I see my server via the Network? My ASP.Net web pages on my local
web server too can't connect to the server. It used to work well with Win
2000.
Why is the server not found?
Thanks,
Stephane
Mon, 10 Jan 2005 08:59:01 -0800
"=?Utf-8?B?U3RlcGhhbmU=?="
|
RE: XP / SQL personal: Cannot find localhost
Hi,
I found that Win XP sp2 is the trouble...
B+SQL Server will have access to the local subnet by means of file and print
sharing, which will enable access to named pipes, also known as
multi-protocol, that use Port 445. TCP/IP and UDP will be turned off by
default. Applications that connect to a SQL Server database by means of a
network will not be able to accept or make connections. This setting change
helps protect the
Mon, 10 Jan 2005 10:11:02 -0800
"=?Utf-8?B?U3RlcGhhbmU=?="
|
|