Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

MSDE over TCP/IP

  
   Database Forums (Home) -> MSDE RSS
Next:  Global temporary tables in Java DB -- Apache Derb..  
Author Message
Andrew Faust

External


Since: Dec 11, 2007
Posts: 3



(Msg. 1) Posted: Tue Dec 11, 2007 12:25 pm
Post subject: MSDE over TCP/IP
Archived from groups: microsoft>public>sqlserver>msde (more info?)
I've got a SQL Server Desktop Engine (version 8.00.2039 - SP4) installation
running our SharePoint site. I now need to connect to this database remotely
via TCP/IP, but can't get it to enable the protocol.

The log file always just says:

2007-12-11 12:13:46.39 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-12-11 12:13:46.39 server SQL server listening on Shared Memory.

I've tried all the suggestions I've heard on the internet. What I've tried:

Install the latest MSDE Service Pack (SP4)
Use SVRNETCN.exe to enable the TCP/IP Protocol
Enable TCP/IP, Set to Port 0, Restart Service, Set to Port 1433, Restart
Service.

I've hard reset the machine, I've installed all the latest service packs on
this machine. I've disabled the firewall. I've tried ports other than 1433.
I've tried enabling Named Pipes & NWLink at various times as well. No matter
what I do, the log still shows it listening only on shared memory.

Any assistance would be greatly appreciated as I'm completely stumped.

--
Andrew Faust
http://www.andrewfaust.com

 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Chris.Cheney

External


Since: Mar 20, 2007
Posts: 18



(Msg. 2) Posted: Wed Dec 12, 2007 6:00 am
Post subject: Re: MSDE over TCP/IP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
=?Utf-8?B?QW5kcmV3IEZhdXN0?= <andrew [at] andrewfaust.com> wrote in


> I've got a SQL Server Desktop Engine (version 8.00.2039 - SP4)
> installation running our SharePoint site. I now need to connect to
> this database remotely via TCP/IP, but can't get it to enable the
> protocol.
>
> The log file always just says:
>
> 2007-12-11 12:13:46.39 server Using 'SSNETLIB.DLL' version
> '8.0.2039'. 2007-12-11 12:13:46.39 server SQL server listening on
> Shared Memory.
>
> I've tried all the suggestions I've heard on the internet. What I've
> tried:
>
> Install the latest MSDE Service Pack (SP4)
> Use SVRNETCN.exe to enable the TCP/IP Protocol
> Enable TCP/IP, Set to Port 0, Restart Service, Set to Port 1433,
> Restart Service.
>
> I've hard reset the machine, I've installed all the latest service
> packs on this machine. I've disabled the firewall. I've tried ports
> other than 1433. I've tried enabling Named Pipes & NWLink at various
> times as well. No matter what I do, the log still shows it listening
> only on shared memory.
>
> Any assistance would be greatly appreciated as I'm completely stumped.

If you see no effects at all from using svrnetcn.exe, perhaps you have got
multiple instances installed. Drop down the "Instances on this server"
combo at the top of the General tab of the svrnetcn.exe dialog (similarly
the Server combo at the top of the SQL Server Service Manager dialog).

 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Andrea Montanari

External


Since: Sep 13, 2003
Posts: 851



(Msg. 3) Posted: Wed Dec 12, 2007 11:58 am
Post subject: Re: MSDE over TCP/IP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Chris.Cheney wrote:
> If you see no effects at all from using svrnetcn.exe, perhaps you
> have got multiple instances installed. Drop down the "Instances on
> this server" combo at the top of the General tab of the svrnetcn.exe
> dialog (similarly the Server combo at the top of the SQL Server
> Service Manager dialog).

and restart the service Smile
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply
 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Andrew Faust

External


Since: Dec 11, 2007
Posts: 3



(Msg. 4) Posted: Wed Dec 12, 2007 3:36 pm
Post subject: Re: MSDE over TCP/IP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks for the response.

Unfortunately, that's not the problem. There is only 1 instance installed on
this server. I forgot to mention this before and don't know if it makes a
difference, but this is a named instance. It's called DOCMGR\SHAREPOINT. It's
also running on Windows Server 2003 with all the latest service packs
installed.

--
Andrew Faust
http://www.andrewfaust.com


"Chris.Cheney" wrote:

> =?Utf-8?B?QW5kcmV3IEZhdXN0?= <andrew [at] andrewfaust.com> wrote in
>
>
> > I've got a SQL Server Desktop Engine (version 8.00.2039 - SP4)
> > installation running our SharePoint site. I now need to connect to
> > this database remotely via TCP/IP, but can't get it to enable the
> > protocol.
> >
> > The log file always just says:
> >
> > 2007-12-11 12:13:46.39 server Using 'SSNETLIB.DLL' version
> > '8.0.2039'. 2007-12-11 12:13:46.39 server SQL server listening on
> > Shared Memory.
> >
> > I've tried all the suggestions I've heard on the internet. What I've
> > tried:
> >
> > Install the latest MSDE Service Pack (SP4)
> > Use SVRNETCN.exe to enable the TCP/IP Protocol
> > Enable TCP/IP, Set to Port 0, Restart Service, Set to Port 1433,
> > Restart Service.
> >
> > I've hard reset the machine, I've installed all the latest service
> > packs on this machine. I've disabled the firewall. I've tried ports
> > other than 1433. I've tried enabling Named Pipes & NWLink at various
> > times as well. No matter what I do, the log still shows it listening
> > only on shared memory.
> >
> > Any assistance would be greatly appreciated as I'm completely stumped.
>
> If you see no effects at all from using svrnetcn.exe, perhaps you have got
> multiple instances installed. Drop down the "Instances on this server"
> combo at the top of the General tab of the svrnetcn.exe dialog (similarly
> the Server combo at the top of the SQL Server Service Manager dialog).
>
 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Chris.Cheney

External


Since: Mar 20, 2007
Posts: 18



(Msg. 5) Posted: Thu Dec 13, 2007 5:59 am
Post subject: Re: MSDE over TCP/IP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
=?Utf-8?B?QW5kcmV3IEZhdXN0?= <andrew [at] andrewfaust.com> wrote in


> Thanks for the response.
>
> Unfortunately, that's not the problem. There is only 1 instance
> installed on this server. I forgot to mention this before and don't
> know if it makes a difference, but this is a named instance. It's
> called DOCMGR\SHAREPOINT. It's also running on Windows Server 2003
> with all the latest service packs installed.
>

Well, it was something that was possible, given the symptoms you described.
Sorry, I'm out of further ideas. Good luck!
 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Andrew Faust

External


Since: Dec 11, 2007
Posts: 3



(Msg. 6) Posted: Thu Dec 13, 2007 9:26 am
Post subject: Re: MSDE over TCP/IP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I appreciate the effort. I've finally given up on trying to make it work and
have moved my SharePoint to a full install of SQL Server 2000 and gotten the
functionality I needed.

--
Andrew Faust
http://www.andrewfaust.com


"Chris.Cheney" wrote:

> =?Utf-8?B?QW5kcmV3IEZhdXN0?= <andrew [at] andrewfaust.com> wrote in
>
>
> > Thanks for the response.
> >
> > Unfortunately, that's not the problem. There is only 1 instance
> > installed on this server. I forgot to mention this before and don't
> > know if it makes a difference, but this is a named instance. It's
> > called DOCMGR\SHAREPOINT. It's also running on Windows Server 2003
> > with all the latest service packs installed.
> >
>
> Well, it was something that was possible, given the symptoms you described.
> Sorry, I'm out of further ideas. Good luck!
>
>
 >> Stay informed about: MSDE over TCP/IP 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MSDE 8 and MSDE 2000 - Hello, I have MSDE 8 installed on my Win2k server as it is is required by Veritas Backup Exec.I would also likw to use this server for WSUS, which requires MSDE 2000. Can these co-exist on the same server? Thanks

MSDE - Hi Trying to install Microsoft SQL Server 2000 Service Pack 4 on Win XP machine. MSDE 2000 Sp3 already installed on D: drive, instance name= db1 In enterprise manager the db appears as ABC-111\DB1 ABC-111 is the name of the machine I am using mixed..

SQL NS and MSDE - Hi, I develop an App with SQL 2000 and some customers run it under MSDE - no problems. I plan to add funtionality to the App and use NS (notification service) will this also run on MSDE, or do there exist any limitations (e.g. costs), so I shouldn't...

About the new MSDE - I am in the process of downgrading an MSDE database to a Jet (Access) database for the following reason: 1. Size: Deployment of an MSDE database engine is inflating my distribution file (Setup.exe) over 20 Megs! With an Access database this number is....

MSDE and SQL together - Can we have MSDE and SQL server on the same machine?
   Database Forums (Home) -> MSDE All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]