Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.