January 3, 2015 at 7:06 pm
Hi,
I'm new to SQL server. I'm programming in vb.net and want to use SQL Server on my PC for development however I've had SQL Server 2012 and 2008 installed before, tried to uninstall everything and now it all seems messed up and I can't install an instance of SQL Server 2008 Express that will work (errors such as database engine missing, protocol failed, etc.). I was planning to reinstall Windows but I wondered if it's possible to instead connect to a remote database with a hosting provider to get around needing to have SQL Server installed locally but I'm unsure how that would work and if I still need to run services locally on my PC. Advice appreciated!
Thanks
January 4, 2015 at 4:04 am
You can set up SQL Server on a different machine (hosted or not). In order to use it for your development, you just need to make sure you set up the network connections so that you can get to it from your machine. You'll need to ensure that you have your network connection configured, the firewall has to have the appropriate ports open (1433 by default) and then you can connect to SQL Server remotely. What you have to have installed locally depends on what you want t do. You can just have the ADO.NET libraries so you can make connections from .NET code, you can have that and SQL Server Management Studio or all kinds of other tools and set ups. It just depends on what you're trying to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 4, 2015 at 4:47 am
Thanks. Are you available for a fee to log in remotely and see if my installation can be saved or if you can figure out why it won't install? Don't have much in the way of money mind you!
January 5, 2015 at 4:14 am
Ha! No, no thanks.
I'm sure your install can be saved. I have yet to see one that couldn't be cleaned up in some fashion. You just have to work through the errors to understand what went wrong. However, sometimes, starting from scratch can be a lot easier.
One suggestion, instead of installing everything to your native OS on your laptop/desktop, set it up inside a virtual machine. That way, you can screw it up 100 different ways without messing up your computer. That's how I do it. It's a lot safer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply