Hany, Your link was about Named Pipes and TCP/IP, not about the SQL alias. I just saw your previous message about aliases in my junk folder, I'll read that, but my TCP/IP and Named Pipes are enabled, I tried restarting the SQL service but that didn't help, so I rebooted the machine and still no go. I'm pursuing the alias recommendation now. [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 Hany AlSheikh Khamees Sent: Thursday, February 04, 2010 12:32 PM To: [email protected] Subject: Re: [Bes-admins] Fresh install BES v5.0.1 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]<mailto:[email protected]>> wrote: Send Bes-Admins mailing list submissions to [email protected]<mailto:[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]<mailto:[email protected]> You can reach the person managing the list at [email protected]<mailto:[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]<mailto:[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]<mailto:[email protected]>> Message-ID: <[email protected]<mailto:[email protected]>> Content-Type: text/plain; charset="iso-8859-1" Fwiw both are enabled on mine. From: [email protected]<mailto:[email protected]> [mailto:[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><http://www.papamurphys.com> From: [email protected]<mailto:[email protected]> [mailto:[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]> [mailto:[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><http://www.papamurphys.com> From: [email protected]<mailto:[email protected]> [mailto:[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]> [mailto:[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><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]<mailto:[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 ****************************************** ------------------------------------------------------------------------------------ Consumer-voted "Best Pizza Chain in America" 2003-2009
<<inline: image001.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 ---------------------------------
