Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bootybean
Starting Member
1 Post |
 Posted - 2008-04-04 : 09:55:07
|
| I have a .net program that uses SQL Express as a backend for various internal doings. I am currently working on using the Visual Studio installer to install SQL Server Express along with my program. The installer works fine, SQL Server Express is installed by the bootstrapper along with my program.My problem is that I don't know what connect string to use without having to rely on the user input. I'd like to install SQL Express in such a way that my program can access it with a standard connection string that would work for any install on any computer name. Here are the install options I'm using for the SQL install:-q /norebootchk /qb reboot=ReallySuppress addlocal=all INSTANCENAME=MyProgramDatabase SECURITYMODE=SQL SAPWD=MyPassword DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1I've tried different connect strings but I'm not use what to use. Maybe I should be delivering a database file with my program and accessing that? Any thoughts? |
|
|
|
|
|
Have installer install SQL Express along with prog