It's been a while since I've posted. Things have been going well for my project, but I'm coming back to the issue of setting up a SQL server on my user's computers.
Sknake was kind enough to give me the command line switches to get a MSSQL install set up in a good direction. The problem is that in the 2008 express version the sa user is disabled by default. If I assign it a password at install does it automatically enable the account? If not, I can't log in with it because it is disabled.
I would like to include with my software a user control panel interface for admins that allows server and network admins the ability to create, delete and modify user permissions on the SQL server. But I cannot do that without the sa account enabled. I know I can use windows authentication, but I'd prefer not to. I don't know enough about it to feel confident enough to use it.
My question is: is it possible to enable the sa user on install? If not, how can it be enabled using C# code or will the user have to enable it manually?