Is it possible to install SQL2005 Express via InstallShield?
Has anyone had any experience doing this?
Any suggestions or recommendations?
Thanks
have a look at the following MSDN Article it might help..
Embedding SQL Server Express into Custom Applications
|||Hi,
Is this article actually accurate in terms of the statement that says that if you don't provide a value for the property SqlServiceAccountName then it defaults to LocalSystem? I'm finding that it defaults to Network Service.
Mind you, I'm using a command line, and either using SQLACCOUNT="" or not providing the SQLACCOUNT option at all.
It would be nice to work out how to run the service by default as LocalSystem. Any help would be appreciated.
Thanks
Sam
|||The default for SqlServiceAccountName is:
Network Service on Windows XP/2003
Local Service on Windows 2000
I assume that you should be able to set it to Local System using the command line, but you should be careful about account selection. Remember that SQL Express has all the permissions of the account that it runs as. What ever the Local System account can do, SQL Express will be able to do if instructed to do so via stored procedure or CLR function, etc.
The reason we chose to use Network Service (where available) in SQL 2005 is to reduce the "surface area" of risk when running SQL Express. By using a low permission account by default, we limit the ways that SQL Express can be exploited by "bad people."
If you want to give SQL Express higher level permissions, that is you're choice, but we expect you to understand the risks before you do so.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
Hi, Mike.
When I tried to install SQL Express 2005 from command line in Win VISTA, and not specify any SQLAccount value, the installation fails, saying that it must be specified.
How would you go about making sure that the installation would work and set SQLAccount to the default value in Windows Vista?
Thanks.
Cliff.
No comments:
Post a Comment