Take the 2-minute tour ×

I'm just a beginner and I want to know how to create a server in ms sql 2005. Because I want to use ms sql as my database for vb.net database program. I'm only using a single desktop computer. What would you recommend. This will only be used as a database for a vb.net program

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

If it's a single computer and a single program, then you should consider SQL Server Express instead. This page has info about the 2008 version: http://www.microsoft.com/express/Database/

If you're beginning, consider whether you should begin with something other than VB.net. Is there a specific reason for using it? It could be a great opportunity to learn Visual C# or similar.

share|improve this answer
Even express edition is probably overkill here. –  Joel Coel Mar 10 '10 at 18:52
add comment

Read the documentation, get into some VB.NET tutorials (as in: everyone that is not totally trivial has some section about databases).

share|improve this answer
add comment

I'm only using a single desktop computer.

I'd recommend going with an in-process or desktop engine rather than a server-class engine like sql server. Even Sql Server Express Edition is usually overkill. Use something like Sql Server Compact Edition, Sqlite, or even Access instead.

share|improve this answer
add comment

Your Answer


