MS SQL 2005 on MS Windows Small Business Server 2003? Will it work?
Software installation seems to have caused a lot of problems with other programs. Our IT guy installed MS SQL Server 2005 on our version of MS Windows Small Business Server 2003. Now our email acts quirky, some email shows up late (1-3 months later) some software tries to reinstall itself when you try to run it. Our spam software (SpamBully) goes nuts and totally unlaods itself on some machines, ask to be registered multilpe times, does not retain the learning of email addresses for one day to the next.
We have been told that we need to upgrade our server to MS Windows Server 2005. My boss says that this sould not be happening. I also have been told that SQL 2005 should never have been loaded on our MS SB 2003.
Can anyone help before I lose it?
Max
We have been told that we need to upgrade our server to MS Windows Server 2005. My boss says that this sould not be happening. I also have been told that SQL 2005 should never have been loaded on our MS SB 2003.
Can anyone help before I lose it?
Max
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I might suggest that if it's your responsibility to manage this server that you get a better handle on where to find information and especially to get some training.
The Hub of the SBS Community is a good place to start:
http://www.microsoft.com/technet/community/en-us/windowssbs/default.mspx
This way you aren't relying on "I also have been told" to guide your decisions.
Jeff
TechSoEasy
The Hub of the SBS Community is a good place to start:
http://www.microsoft.com/technet/community/en-us/windowssbs/default.mspx
This way you aren't relying on "I also have been told" to guide your decisions.
Jeff
TechSoEasy
Jeff is completely correct,
To install SQL 2005 on SBS 2003, you need to follow the information on the Premium technology CD, it tells you step by step how to install it the right way.
To install SQL 2005 on SBS 2003, you need to follow the information on the Premium technology CD, it tells you step by step how to install it the right way.
ASKER
First, I wanted to explain my reason for asking the question.
1) The MS SQL 2005 was installed by the people that sold us our accounting package without notifying our IT as he was requested to do before he did anything.
2) Our IT people are the one that said we could not put MS SQL 2005 on our MS SBS 2003.
Our system:
Terabyte Server
Supermicro CSE 743T-R760/B, 760W N+1 HSR
Superrnicro X6DHT-G, Dual Xeon, 2x GbE
3.OGHz Intel Xeon 800MGz W/ 1MB Cache
512MB DDR333 ECC Registered Memory
500GB Seagate Sata-II 7200RPM HDD
3Ware 9550SX-4LP, 4-Port Sata-II Raid (0,1,5)
Integrated Dual Intel 10/100/1000GbE
MS Windows 2003 SBS Standard SPacic
We have been having problems with our system ever since the MS SQL 2005 was installed. He thinks the MS SQL 2005 on the MS SBS 2003 is the problem and we need to update to MS Windows Server 2003 R2.
3) My job is to be the liaison between our IT people and our staff. My questions are strictly trying to find out why things dont work like they are suppose to and also get me brownie points with my boss, if he thinks I might know something about the problems. My goal is not to try to run our network just know more about it. I schedule outages (work that needs to be done by the IT) or work that needs to be done (requests from our staff) on our system. My real job is the CAD Manager and Sr. Design Technician.
I will answer the replies one at a time. Although every time somebody's program, CPU, mouse or printer is not working I am called.
Vico1: That is what I thought also. The server software should be up dated.
TechSoEasy: (I am accepting your answer, by far the best)
a) Our IT person had said MS Windows Server 2003 with Microsoft Virtual Server 2005 R2. I just misunderstood him.
b) The IT person did not install the MS SQL 2005, which seems to be the crux of the problem.
c) I like the idea of the upgrade to SBS 2003 Premium R2, sounds a lot cheaper.
d) All of our software and hardware is less than 4 months old. That is why my boss is furious about putting more money in the system. Look at the list above, I think our hardware is sufficient for the task.
e) I appreciate the info on the SBS Community. I need to know as much as possible about our system. Even it is to know we are not being told something wrong or in this case two sides that are very different.
NoSit: You are right
Thanks for the help,
Max
1) The MS SQL 2005 was installed by the people that sold us our accounting package without notifying our IT as he was requested to do before he did anything.
2) Our IT people are the one that said we could not put MS SQL 2005 on our MS SBS 2003.
Our system:
Terabyte Server
Supermicro CSE 743T-R760/B, 760W N+1 HSR
Superrnicro X6DHT-G, Dual Xeon, 2x GbE
3.OGHz Intel Xeon 800MGz W/ 1MB Cache
512MB DDR333 ECC Registered Memory
500GB Seagate Sata-II 7200RPM HDD
3Ware 9550SX-4LP, 4-Port Sata-II Raid (0,1,5)
Integrated Dual Intel 10/100/1000GbE
MS Windows 2003 SBS Standard SPacic
We have been having problems with our system ever since the MS SQL 2005 was installed. He thinks the MS SQL 2005 on the MS SBS 2003 is the problem and we need to update to MS Windows Server 2003 R2.
3) My job is to be the liaison between our IT people and our staff. My questions are strictly trying to find out why things dont work like they are suppose to and also get me brownie points with my boss, if he thinks I might know something about the problems. My goal is not to try to run our network just know more about it. I schedule outages (work that needs to be done by the IT) or work that needs to be done (requests from our staff) on our system. My real job is the CAD Manager and Sr. Design Technician.
I will answer the replies one at a time. Although every time somebody's program, CPU, mouse or printer is not working I am called.
Vico1: That is what I thought also. The server software should be up dated.
TechSoEasy: (I am accepting your answer, by far the best)
a) Our IT person had said MS Windows Server 2003 with Microsoft Virtual Server 2005 R2. I just misunderstood him.
b) The IT person did not install the MS SQL 2005, which seems to be the crux of the problem.
c) I like the idea of the upgrade to SBS 2003 Premium R2, sounds a lot cheaper.
d) All of our software and hardware is less than 4 months old. That is why my boss is furious about putting more money in the system. Look at the list above, I think our hardware is sufficient for the task.
e) I appreciate the info on the SBS Community. I need to know as much as possible about our system. Even it is to know we are not being told something wrong or in this case two sides that are very different.
NoSit: You are right
Thanks for the help,
Max
Max,
Hardware looks fine only the ram could and I would say should be doubled at a minimum to handle exchange & SQL, I would recomend 2gb, the price of RAM is nothing.
Also if your IT guy said that SBS cant take SQL I would look for another IT guy. Dont mean to sound rude, but they should know that.
Hardware looks fine only the ram could and I would say should be doubled at a minimum to handle exchange & SQL, I would recomend 2gb, the price of RAM is nothing.
Also if your IT guy said that SBS cant take SQL I would look for another IT guy. Dont mean to sound rude, but they should know that.
I agree that you need to increase the amount of RAM on the Server. That is most likely the primary cause of any problems you are seeing. An SBS with SQL Server installed should have a minimum of 2GB RAM. If SBS is running as a Virtual Machine on top of Virtual Server 2005 then you probably just need to allocate more memory to it.
Jeff
TechSoEasy
Jeff
TechSoEasy
Removing SQL 2005 is not going to solve it.
Vico1