SQL Server vs. Local Data File

I am creating a standalone database application that will not be connecting to a remote computer.

Would it be better to create an SQL Server database for my program or just use a local data file

I have tried to create an SQL Server database from within VB Express 2005, but it gives me an error stating

that remote connections are not permitted and says that I need to change my default settings to allow this.

I have no idea how to fix that.  What are the advantages and disadvantages of using an SQL server vs. a local

data file if the program is only going to access the data from the computer that the program is installed on

snuffnit
When you say "Local Data File" are you talking about using SQL Server and attaching to the SQL Server database file using the connection string or do you mean hatching your own storage method using local data files (ala XML or something)

If you mean using SQL Server data files, given your scenario I think that's fine. You also might want to look into the new SQL Server Everywhere (which was SQL Server Mobile. http://www.microsoft.com/sql/CTP_sqlserver2005everywhereedition.mspx).
CliffDC

SQL Server is better in terms of data management, you can store/update/organize etc... all your data. Storing it in a local file (depending on the type of file also) is not a good idea (example a comma delimited file or something of that nature) as it can be messy to handle, where as SQL Server, you just need to give the appropriate values/command and everything is done for you.

SQL Server is kind of a requirement these days to be learned about, since its pretty essential in most businesses and it doesnt hurt to know about it! You will learn more about it and never know when it can become handy.

As for your error, take a look at this:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=579914&SiteID=1

does this help
SQL Server vs. Local Data File