Re: Web Server 2003 > Install SQL Agent
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 08/08/04
- Next message: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Previous message: Miha Pihler: "Re: 2 Domain Controllers"
- In reply to: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Next in thread: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Reply: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 8 Aug 2004 19:14:12 +0200
Hi
Run CLICONFG.EXE on the web server to allow named pipes and make sure that
the server has named pipes enabled too (svrnetcn.exe).
-- -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Johannesburg, South Africa Mobile: +27-82-552-0268 IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Jeff L" <***jeff@availabletech.net> wrote in message news:Oarzl7UfEHA.3988@tk2msftngp13.phx.gbl... > Thanks Steve, > > We have some code that uses Named pipes and rather then change the code we > were wondering if there was away to enable the use of named pipes from > webserver. > > Regards, > > Jeff Loucks > Available Technology > Solutions For Professionals > www.availabletechnology.com > > > "Steve Foster [SBS MVP]" <steve.foster@picamar.co.uk> wrote in message > news:xn0dlrpeg7vvbwa003@msnews.microsoft.com... > > Jeff L wrote: > > > > > Hi Folks, > > > > > > Bit of a hybrid situation here so I had to cross post. Sorry for that. > > > > > > I am aware of the SQL Server limitation on Webserver 2003. How do you > > > install the SQL Agent on this OS, since it is still fine for an app > > > to use a backend SQL Server. We want the webserver to use named pipes > > > to connect to the Full version of SQL Server on a separate box. Is > > > this possible? > > > > SQL Agent is a companion service to SQL Server and can only be > > installed on a SQL Server. > > > > WS2003 Web Edition has an ODBC driver for SQL Server already loaded, > > and MDAC2.8 would give you an OLEDB driver too (if there's not one > > present already). > > > > You can specify the SQL communication protocol in the connection string. > > > > -- > > Steve Foster [SBS MVP] > > --------------------------------------- > > MVPs do not work for Microsoft. Please reply only to the newsgroups. > >
- Next message: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Previous message: Miha Pihler: "Re: 2 Domain Controllers"
- In reply to: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Next in thread: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Reply: Jeff L: "Re: Web Server 2003 > Install SQL Agent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
