Network Connection

I installed MSDE on a 2003 server machine in an AD environment. During the
setup I used the disablenetworkprotocols=0 switch to enable network
connections. I also enable mixed mode authentication. However, I still
cannot connect to the server from a XP sp2 machine on the network. (firewall
is disabled) The error returned is sqlserver does not exist or access denied.
I tried connecting via windows autehntication and specifying a SQL account.
Does anyone know why I cannot connect or maybe a site that will help diagnose
the problem?
hi Joe,
Joe Kiaser wrote:
> I installed MSDE on a 2003 server machine in an AD environment.
> During the setup I used the disablenetworkprotocols=0 switch to
> enable network connections. I also enable mixed mode authentication.
> However, I still cannot connect to the server from a XP sp2 machine
> on the network. (firewall is disabled) The error returned is
> sqlserver does not exist or access denied.
>
please have a look at
http://support.microsoft.com/default...06&Product=sql
for some potential causes of this kind of problem..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I discoverd it was problem with DNS. <Webserver> was pointing to the wrong
IP so when we tried to connect using <webserver> it would fail. I
discovered this after pinging <webserver> and it returned 120.0.0.21...our
WSUS server. I just updated the DNS to point <webserver> to 120.0.0.23 and
it works flawlessly.
"Andrea Montanari" wrote:

> hi Joe,
> Joe Kiaser wrote:
> please have a look at
> http://support.microsoft.com/default...06&Product=sql
> for some potential causes of this kind of problem..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
sql

Net-Lib Question

Hi,
In the Server Network Utility (sql server 2000), if I do not select or enabl
e any net-libs such as TCP/IP, Names Pipes, Multiprotocol in the server, use
rs from client machine will still be able to connect to the server? How is t
his possible?
When the client is connecting to the server, which is the default network pr
otocol it uses and can it be changed?
Also If I want to clients to use Multiprotocol net-lib to connect to the ser
ver, what are the configurations I need to make both at the server and clien
t?
One more question is; If I have 2 instances of sql server 2000 on the same
machine, on the named instance, in server network utility, I Cannot see Mult
iprotol net-lib, any idea why?
Thanks
GYKThere is not default server side net library.
Multiprotocol cannot be enabled on a named instance. See the CLient and
Network Net-Libraries topic in Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Net-Lib Question

Hi,
In the Server Network Utility (sql server 2000), if I do not select or enable any net-libs such as TCP/IP, Names Pipes, Multiprotocol in the server, users from client machine will still be able to connect to the server? How is this possible?
When the client is connecting to the server, which is the default network protocol it uses and can it be changed?
Also If I want to clients to use Multiprotocol net-lib to connect to the server, what are the configurations I need to make both at the server and client?
One more question is; If I have 2 instances of sql server 2000 on the same machine, on the named instance, in server network utility, I Cannot see Multiprotol net-lib, any idea why?
Thanks
GYKThere is not default server side net library.
Multiprotocol cannot be enabled on a named instance. See the CLient and
Network Net-Libraries topic in Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

Nested Interactive sorting

Hi,
Is it possible to have nested interactive sorting in RS2005?

eg.
My report displays COUNTRY | STATE | CITY | SALES
I enable interactive sorting on COUNTRY and CITY.
First the I sort on COUNTRY and then if a user clicks on CITY, then it should be sort combination of COUNTRY and CITY.

Is this possible?AFAIK, you will have to group that to make a nested sorting.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

You have to use shift+click to sort by multiple items at the same time if they share the same context.

-- Robert