troubleshooting Question

SBS 2011 premium to use the SQL

Avatar of Robbills
RobbillsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerWindows Server 2003SBSDell
8 Comments3 Solutions780 ViewsLast Modified:
Hi Dont know where to start really but here goes:

A company I do work for has asked me to quote on a Server capable of running SQL for a database, they only have 10 staff but the database company want the full version of SQL on the server. Their current hardware is a 4+ year old Dell Power Edge 840 running a Dual core processor & 4 gig of ram which they use for Terminal services, AD & file sharing on a domain, it has Windows Server 2003 STD loaded onto it.
This is below the spec needed for the SQL database so I'm looking at a Dell with maybe a quad core processor & 8 Gig ram with raid 5 sata runnig SBS 2011 premium for the SQL side of it, now for starters the database company reckons I could have problems with the SBS 2011 Premium & SQL? Their recomendations at the end. Another problem I can see is who should control the AD & will 2011 run with a std 2003 server? would we be better moving the files to the new server & just keeping the old Server for TS persuming it will run with the SBS 2011?

Also at the moment they use Hosted Exchange so will it help stop the problem of SQL & Exchange if we disable the Exchange in the SBS 2011 & how effective is it at being disabled?

what am I best doing?

Any more information you need I can give you.

Their reccomendations to follow:

Server and Network Minimum Requirements

Server
•      Our Databse uses a Microsoft SQL Server Database and therefore requires Microsoft SQL Server Installed on the Server. Microsoft provide minimum requirements HOWEVER these are absolute minimum and you should aim to run RDB ProNet’s SQL Database and Client on the best hardware infrastructure you can provide in order to get maximum benefit from the system.
For more information on Microsoft SQL Server: http://msdn.microsoft.com/en-us/library/bb545450.aspx

•      Should be set to run in mixed mode (SQL and Windows authentication)
•      TCP and named ports need to be enabled
•      Port 1433 needs to be open through any internal firewalls or another port needs to be specified for the SQL database connection to use.
•      The  FCS account you provide needs admin rights for both Windows ( domain or local account)  and MS SQL Server.
•      UAC must be turned off
•      .Net framework 2.0 needs to be installed.
•       First Choice Software does not install or support the installation of SQL Server as part of the installation of ProNet.

Network
•      RDP connection to SQL Server using Windows admin account with SQL admin rights for First Choice Software. Our external IP address is 217.33.71.194. This connection is for the initial implementation and on -going support. If we don’t have access to the server, we will contact a named user or IT Support Company who will need to log us onto the server every time there is an issue. This method may cause a delay is reaching a resolution. Please provide the External IP/server connection name, our Username, Password and Domain we log onto.
•      FTP permissions to download installation files, data and updates. We would be grateful if you could install Filezilla client http://filezilla-project.org/download.php or allow us to, especially if the project includes installing a large database to your server.

Operating Systems
Microsoft’s Small Business Server is a popular solution, especially for new start-ups. The Premium Edition includes the full version of SQL Server with 5 client licences which is a cost effective method of purchasing SQL Server. However, we have experienced an issue when Small Business Server is installed. There appears to be a problem with the SQL installer which does not install all  of the associated tools by default although the installer indicates that it has included them. We do need SQL Management Studio to be included so please ensure that the SQLWB.exe tool has been installed.



Microsoft Exchange & SQL
•      Microsoft does not recommended running SQL and Exchange together on the same server.
Both SQL Server and Exchange mailbox servers consume a large amount of memory and disk

resources to operate optimally. Co-hosting SQL Server and Exchange Server on the same computer in a production environment will likely lead to poor performance by one or both of the servers. Additionally, troubleshooting and securing such an installation is not well understood.
Finally, there are a number of known interoperability issues that you may encounter if you are running SQL Server and Exchange Server on the same computer. Most of these issues are the result of version inconsistencies with files or programs common to the two servers, such as Microsoft Distributed Transaction Coordinator (MS DTC), Microsoft ActiveX® Data Objects (ADO), and OLE Database (OLE DB)."
http://technet.microsoft.com/en-us/library/aa997379(EXCHG.80).aspx

•      Email (MS Exchange)-      SMTP relaying should be turned on for all machines using the database.


Minimum Hardware recommendations for SQL Server from Microsoft:
SQL Server 2008: http://technet.microsoft.com/en-us/library/ms143506.aspx
SQL Server 2005: http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx



Client Systems
Operating System
•      All Client Machines require the Microsoft .Net Framework Version 2 to be installed. Clients should have the latest service packs and critical updates from Windows Update for the version of Windows being used:
1)      Windows 7
2)      Windows Vista
3)      Windows XP Professional
•      UAC must be turned off
•      Local admin rights on the machine
•      Users will need to know their SMTP Server details for sending emails .You need these ready prior to the installation of RDB ProNet or you will not be able to send emails
•       Monitor Screen Resolution – RDB ProNet is designed for use on 1024 x 768 as a minimum – if you are on 15” you may find 17” screens more comfortable


This has been tested in a Terminal Services environment.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros