Network Error...

Hi All,
I have a windows 2003 server and MS SQL Server 2000 Enterprise edtion
installed in it... From past few days I am the schedule jobs are getting
failed... its giving below error...
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Plz advice how to get rid of this...
Thanks in advance.
-Mohit.Refer this KB Article. This talks about similar error message when restoring
database.
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
It looks like it is MDAC bug and work around is change the SQL Server to use
TCP/IP
Ravi
"Mohit" wrote:
> Hi All,
> I have a windows 2003 server and MS SQL Server 2000 Enterprise edtion
> installed in it... From past few days I am the schedule jobs are getting
> failed... its giving below error...
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
>
> Plz advice how to get rid of this...
> Thanks in advance.
> -Mohit.
>

Network connection problem when trying to use SSMS

I have two SQL servers that are having the same problem. I have
recently installed SSMS on my laptop, and when I try to connect to one
of my SQL Servers using SSMS, the NIC card dies. I have two NICs in
both of these servers, one on the normal LAN, and the other NIC is
used on a separate VLAN that the servers use to talk to each other.
After a minute or two of being connected to the SQL database, the
server just stops responding. I can't ping it, I can't RDP into it,
and I can't connect to any of the DBs on it from the LAN. I can still
access the server from one of the other servers, however, because that
NIC is not affected. As soon as I open a web browser from that server
and try to go to an external website, the NIC reactivates and I can
access it from the LAN again. I can manage the DBs on the other
server using SSMS without a problem, however. An associate of mine,
is having the exact same problem, but with the other server. He is
able to manage the server that I can't from the LAN using SSMS, and
vice versa. I've done some googling, but haven't had any luck as of
yet.
Has anyone else seen this and know how to fix it'
Thanks, in advance.Hi Matt
I assume you have tried changing the NICs?
Have you looked at the perfmon counters to see the NIC activity?
Are you using any monitoring, AV, IDS or software update software on your
networks?
John
"Matt" wrote:
> I have two SQL servers that are having the same problem. I have
> recently installed SSMS on my laptop, and when I try to connect to one
> of my SQL Servers using SSMS, the NIC card dies. I have two NICs in
> both of these servers, one on the normal LAN, and the other NIC is
> used on a separate VLAN that the servers use to talk to each other.
> After a minute or two of being connected to the SQL database, the
> server just stops responding. I can't ping it, I can't RDP into it,
> and I can't connect to any of the DBs on it from the LAN. I can still
> access the server from one of the other servers, however, because that
> NIC is not affected. As soon as I open a web browser from that server
> and try to go to an external website, the NIC reactivates and I can
> access it from the LAN again. I can manage the DBs on the other
> server using SSMS without a problem, however. An associate of mine,
> is having the exact same problem, but with the other server. He is
> able to manage the server that I can't from the LAN using SSMS, and
> vice versa. I've done some googling, but haven't had any luck as of
> yet.
> Has anyone else seen this and know how to fix it'
> Thanks, in advance.
>

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

NET2 and Reporting Services

Is it possible to get Reporting Services running on a server wtih .NET2 beta1
installed?
thanksNot sure if order of install makes a difference but right now i'm
running XP Pro SP1, VS2002, VS2003, .NET1.0, .NET1.1, and .NET2.0 on
my machine with reporting services and i have no probs. .NET 2.0 was
the last thing i installed.
"marv" <marv@.discussions.microsoft.com> wrote in message news:<45C73938-019C-4402-A50D-87B6510CF5C8@.microsoft.com>...
> Is it possible to get Reporting Services running on a server wtih .NET2 beta1
> installed?
> thanks

Needing to run reporting services on SQL Server 2000

Hi
I want to install SQL Server 2000 Enterprise Edition on Windows XP but it isn't installing.
I have installed SQL Server 2000 Personal Edition but Reporting Services are not installing on the server.
PLZ some one help me out.

SQL 2000 Enterprise Edition is not supported on XP. Please see this link for requirements:

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

Thanks,
Sam Lester (MSFT)

Need urgent help.. for SQL Server reporting services installation..

hi,

I have SQL Server Express edition installed on my PC , but now I need to use SQL Server reporting service, there is SP1 for express edition contains reporting service with express edition. Here..

http://msdn.microsoft.com/vstudio/express/sql/download/

Do I need to download 213 MB SQL Server 2005 Express Edition Toolkit SP1 ?

or there is any other method to use reporting services ?

Thanks

You will have to download the full install again, there is no way of installing the components seperatly. With SQl 2000 there used to be a seperate DL for Reporting Services, but in the 2005 stream they are all included in the one package.