Quantcast

Maximum PC

It is currently Wed Apr 16, 2014 1:18 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: install MySQL & MS SQL Server on the same machine
PostPosted: Sat Nov 10, 2012 7:09 am 
Willamette
Willamette

Joined: Tue Feb 01, 2005 12:17 pm
Posts: 1435
Can you install Microsoft SQL Server 2008 (the full product, NOT the SQL Server Compact edition that comes with VS.Net), and MySQL on the same machine without conflicts?

I know that each uses different port numbers to communicate with apps, but want to make absolutely sure before I do this on a production PC.
The reason being that we have a purchase software package that uses MS SQL Server, and I've created a few in-house custom-written apps myself that use MySQL, but they both need to be on the same machine and running at the same time. My biggest concerns are communications issues (queries going to the wrong server, or one server not starting because it detects another SQL server program running on the machine).

Ideas, suggestions, or opinions?


Top
  Profile  
 
 Post subject: Re: install MySQL & MS SQL Server on the same machine
PostPosted: Wed Jan 02, 2013 9:10 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Mon Jun 14, 2004 4:04 pm
Posts: 985
Location: Earth
cbassett01 wrote:
Can you install Microsoft SQL Server 2008 (the full product, NOT the SQL Server Compact edition that comes with VS.Net), and MySQL on the same machine without conflicts?

I know that each uses different port numbers to communicate with apps, but want to make absolutely sure before I do this on a production PC.
The reason being that we have a purchase software package that uses MS SQL Server, and I've created a few in-house custom-written apps myself that use MySQL, but they both need to be on the same machine and running at the same time. My biggest concerns are communications issues (queries going to the wrong server, or one server not starting because it detects another SQL server program running on the machine).

Ideas, suggestions, or opinions?


Nope, no problems at all.


Top
  Profile  
 
 Post subject: Re: install MySQL & MS SQL Server on the same machine
PostPosted: Wed Jan 02, 2013 10:50 pm 
Willamette
Willamette

Joined: Tue Feb 01, 2005 12:17 pm
Posts: 1435
I figured so, with the port numbers being different. With two web servers I could understand if there is an issue since they all listen on the same ports, but since different SQL systems use different ports, this should work.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group