Hello All

I am wanting to set up a SQL database on my computer here at home that will contain a few basic tables.

The main thing I need is to be able to access it via C# code via user/pass over the internet. What I am setting up is just a tech demo, but I have no experience with database setup and how to make it so I can read/write to tables in it.

I installed SQL Server 2008 express. I believe this can do it, but I am not 100% sure.

Anyone done anything similar?

1/3/2011 11:17:37 AM

SQL Server 2008 Express will work fine

Do you need to have individual logins for it? If not, the easiest thing to do is to use the sa login that you can configure during the installation process (this is not a secure best practice for real scenarios, but for a demo it will work fine). if you need to provide multiple logins to other users to use, you'll need to worry about granting appropriate rights to whatever databases you create

as far as accessing over the internet, you need to open the sql server configuration manager (it's an option in the start menu) and enable TCP/IP. in the Services section of that tool, you may need to enable SQL Server Browser. Then you'll probably need to enable access to the appropriate ports on your firewall (1433). And if your computer is going through a router, you need to set up port forwarding as well

[Edited on January 3, 2011 at 11:41 AM. Reason : hope that helps in the slightest]

1/3/2011 11:39:19 AM