All, Just to let you know that I have solved my problem.
I did a NetMon on the webserver to see what PORT it was trying to talk to on the database server. I discovered that TCP port 1433 needed to be allowed in my firewall. So I opened this port in my Firewall on the DB server and it allowed the connection. If anyone has any issues with this I'd love to hear about them. I am not a firewall guy so if this is a problem then please let me know. Cheers, David ------------------------------------------------------------------------------------ This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prior, David Sent: Wednesday, 12 September 2007 11:39 AM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: Errors creating a new farm using the SharePoint Products and Technologies Configuration Wizard Ok, I turned off my Windows Firewall on my database server and I can get through....problem is I don't want to turn off the firewall. Does anyone know what PORT should be opened in the firwall to allow the SharePoint Products and Technologies Configuration Wizard to do it's thing? Cheers, David ----------------------------------------------------------------------------------------- This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prior, David Sent: Wednesday, 12 September 2007 11:00 AM To: listserver@ozMOSS.com Subject: RE: [OzMOSS] RE: Errors creating a new farm using the SharePoint Products and Technologies Configuration Wizard John, I am allowing Remote Connections using both TCP/IP and named pipes. Cheers, David Prior Senior Developer KAZ ACT | Professional Services | KAZ Group Pty Ltd 19 – 25 Moore Street | Turner ACT 2612 (02) 6219 0880 | 0411 449 496 [EMAIL PROTECTED] | www.kaz-group.com Have you checked out the new portal? https://practiceportal.cbr.kaz-group.com/index.htm ----------------------------------------------------------------------------------------- This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hodgson, John Sent: Wednesday, 12 September 2007 10:53 AM To: listserver@ozMOSS.com Subject: [OzMOSS] RE: Errors creating a new farm using the SharePoint Products and Technologies Configuration Wizard I expect its SQL Surface area configuration... John Hodgson | Hewlett-Packard Australia Solution Architect | HP & Microsoft Solutions for the People Ready Business Mobile: 0411 242 880 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prior, David Sent: Wednesday, 12 September 2007 10:38 AM To: listserver@ozMOSS.com Subject: [OzMOSS] Errors creating a new farm using the SharePoint Products and Technologies Configuration Wizard Hi, I am having issues trying to create a new farm using the SharePoint Products and Technologies Configuration Wizard. My farm topology is as follows: 2 WFE servers with MOSS complete install 1 Application Server with MOSS complete install 1 Database Server with SQL Server 2005 I am logged onto the 1st WFE server as my MOSSService domain account which has local admin privs on all farm machines, and in the database server it has dbcreator and securityadmin roles. When I use the below settings I get the error shown. My database domain account MOSSDatabase has dbcreator, securityadmin and sysadmin roles for the database server and is also in the local admin group. This should be the minimal permissions required for these accounts. (http://claytonj.wordpress.com/2007/04/23/moss-2007-setup-accounts/ ) I can ping the database server from my WFE machine and I can log in locally to my database server as these accounts and can quite happily create databases. Does anyone have any ideas on what I am missing? I’ve done this before using domain accounts that have greater permissions but I need to be able to do this with minimal permissions for a client. Cheers, David ----------------------------------------------------------------------------------------- This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ________________________________________ This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ;Imzrmr>ʕnui ̃Iʦ欲y蚘bXǧuƠyڭ颲ܢ欲y-뮮7O yֲzv稘fj o,0·v' ;3 I'(.˛mkab ֦zrKhpn˛m欶ruj)^y&.+-ځ[ 0杉 This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ;3 I'(.˛mkab ֦zrKhpn˛m欶ruj)^y&.+-ځ[ 0杉 This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ;3I'ڞ˱mkɲzˁrKˊ؞˱mruj)y.+ This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ;3I'(��.�˛���m���ka��b�� �֦z����rKh����p��n�˛���m欶����r�����u��j)^���y�&.+-��ځ�[� 0�杉
