RC-Monster Forums - View Single Post

BrianG · 03.18.2012, 11:51 PM

Well, got IIS set up, but I didn't like MySQL. There were a few SQL inconsistencies compared to Microsoft's SQL Server (which is what I'm used to since I use it at work exclusively). So, I ended up uninstalling MySQL and using SQL Express 2012.

Getting SQL Express to work was pretty simple, but connecting SQL Server Management Studio client tools from my PC to the server was a bit of a chore. It's just a firewall issue, but even though SSMS is supposed to use port 1433, opening those ports on TCP and UDP didn't help. I ended up opening all ports, but only for traffic coming from my specific computer's IP address. Again, this was just for SSMS. If I wanted to stand at my TV screen and develop the DB part of the app from there, I wouldn't have needed to go through all that.

I started doing the web app coding. So far, just the basic site framework, menus, styles, images, etc is done, but at least it's a functioning site with database connectivity. I can access the site via IP address from any device/computer on my LAN, which was the intent.

Between all that, I'm still ripping DVDs to disc. What a PITA.

	(#45)
BrianG RC-Monster Admin Offline Posts: 14,609 Join Date: Nov 2005 Location: Des Moines, IA	03.18.2012, 11:51 PM Well, got IIS set up, but I didn't like MySQL. There were a few SQL inconsistencies compared to Microsoft's SQL Server (which is what I'm used to since I use it at work exclusively). So, I ended up uninstalling MySQL and using SQL Express 2012. Getting SQL Express to work was pretty simple, but connecting SQL Server Management Studio client tools from my PC to the server was a bit of a chore. It's just a firewall issue, but even though SSMS is supposed to use port 1433, opening those ports on TCP and UDP didn't help. I ended up opening all ports, but only for traffic coming from my specific computer's IP address. Again, this was just for SSMS. If I wanted to stand at my TV screen and develop the DB part of the app from there, I wouldn't have needed to go through all that. I started doing the web app coding. So far, just the basic site framework, menus, styles, images, etc is done, but at least it's a functioning site with database connectivity. I can access the site via IP address from any device/computer on my LAN, which was the intent. Between all that, I'm still ripping DVDs to disc. What a PITA.