Hey,
TCP/IP and Named Pipes should be enabled.
All IP addresses should configured as per the attachment.
Active: Yes
Enabled: Yes
TCP Dynamic Port: {blank}
TCP Port: 1433 (or whatever static port your are using)Also, double check the SQL aliase, for more information about this, read: http://www.besadmin.info/view.php?title=How-to-enable-Transmission-Control-Protocol/Internet-Protocol-(TCP/IP)-and-Named-Pipes-protocols-in-Microsoft-SQL-Server&id=KB05057 Kindest Regards, On Thu, Feb 4, 2010 at 11:48 PM, <[email protected]> wrote: > Send Bes-Admins mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.dataoutages.com/mailman/listinfo/bes-admins > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Bes-Admins digest..." > > > Today's Topics: > > 1. Re: Fresh install BES v5.0.1 (Jeff Peters) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 4 Feb 2010 14:56:31 -0500 > From: Jeff Peters <[email protected]> > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > To: "A list for BES Admin's to discuss issues, etc." > <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Fwiw both are enabled on mine. > > From: [email protected] [mailto: > [email protected]] On Behalf Of Darhl Thomason > Sent: Thursday, February 04, 2010 2:50 PM > To: A list for BES Admin's to discuss issues, etc. > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > > Correct about blocking out local machine name on previous screenshot. > > And it looks like named pipes & tcp/ip are both disabled. Enable both? > > [cid:[email protected]] > > Darhl Thomason | SysAdmin | Business Technology > Papa Murphy's Int'l. | d 360-449-4044 | c 360-607-5617 | > www.papamurphys.com<http://www.papamurphys.com> > > From: [email protected] [mailto: > [email protected]] On Behalf Of Jeff Peters > Sent: Thursday, February 04, 2010 11:41 AM > To: A list for BES Admin's to discuss issues, etc. > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > > Launch SQL Server Configuration Manager instead of the Management Studio > app (in all programs, sql server..) > > Then select SQL Server network config on the left, then protocols, they > will appear on the right. > > From: [email protected] [mailto: > [email protected]] On Behalf Of Darhl Thomason > Sent: Thursday, February 04, 2010 2:36 PM > To: A list for BES Admin's to discuss issues, etc. > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > > Where do I find those settings? > > Darhl Thomason | SysAdmin | Business Technology > Papa Murphy's Int'l. | d 360-449-4044 | c 360-607-5617 | > www.papamurphys.com<http://www.papamurphys.com> > > From: [email protected] [mailto: > [email protected]] On Behalf Of Jonathan Barker > Sent: Thursday, February 04, 2010 11:34 AM > To: A list for BES Admin's to discuss issues, etc. > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > > There's also something called named pipes and tcp/ip to allow access to the > SQL db. Maybe this needs to be enabled? > > From: [email protected] [mailto: > [email protected]] On Behalf Of Darhl Thomason > Sent: Thursday, February 04, 2010 11:30 AM > To: A list for BES Admin's to discuss issues, etc. > Subject: Re: [Bes-admins] Fresh install BES v5.0.1 > > Questions asked: > Are you installing this as a local admin on that machine? using the > BESADMIN account? > Are you logged in with a local Admin account? SQL Services Running? If you > install the SQL Management Console, Can you connect to the SQL server using > it? > > Have you configured SQL security? > > Answers: > I am logged in to the server using the BESAdmin user > > SQL is running, I can connect to the SQL server using the SQL Management > Studio using both Windows Authentication (BESAdmin user) as well as SQL > authentication (sa user) <-- I assume this means that SQL security is > working, but I also know what happens when you assume. > > Darhl Thomason | SysAdmin | Business Technology > Papa Murphy's Int'l. | d 360-449-4044 | c 360-607-5617 | > www.papamurphys.com<http://www.papamurphys.com> > > > > > > ------------------------------------------------------------------------------------ > > Consumer-voted "Best Pizza Chain in America" 2003-2009 > > > > > ------------------------------------------------------------------------------------ > > Consumer-voted "Best Pizza Chain in America" 2003-2009 > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://www.dataoutages.com/pipermail/bes-admins/attachments/20100204/19c95762/attachment.html > > > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: image001.png > Type: image/png > Size: 13154 bytes > Desc: image001.png > URL: < > http://www.dataoutages.com/pipermail/bes-admins/attachments/20100204/19c95762/attachment.png > > > > ------------------------------ > > _______________________________________________ > Bes-Admins mailing list > [email protected] > http://www.dataoutages.com/mailman/listinfo/bes-admins > http://www.dataoutages.com > http://www.dataoutagenews.com > RSS Feed: http://feeds.feedburner.com/Bes-admins > --------------------------------- > > > End of Bes-Admins Digest, Vol 25, Issue 22 > ****************************************** >
<<attachment: sql-tcpip.jpg>>
_______________________________________________ Bes-Admins mailing list [email protected] http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins ---------------------------------
