Vista 64 fails to run sql script
Posted: Fri Mar 14, 2008 3:27 am
OK, i have developer license, i post here three questions and never had an answer... Please, answer this importan question, just this:
In my setup I install sqlexpress. When installed in msi code I put a sql script to enable clr in sqlexpress. With 32 system is all ok. Sql express is installed and cll is enabled. On Vista 64 bit, sql express is installed, clr is enabled BUT not working cause sqlexpress need to restart server to have clrenabled. I checked manually in the sqlinstance: clr is enabled but the query return "server must be restrated". If i restart the service, is ok. But I need to have IA made this. So I try to stop and start sqlinstance from msi code but is not working (acces denied). How can I do this? If I install a fress sqlexpress 64 bit version from outside IA, the sql express is nstalled, I enable clr and there is no nedd to restart the sqlinstance: What is the problem? Maybe a problem in the IA sqlruntime?
In my setup I install sqlexpress. When installed in msi code I put a sql script to enable clr in sqlexpress. With 32 system is all ok. Sql express is installed and cll is enabled. On Vista 64 bit, sql express is installed, clr is enabled BUT not working cause sqlexpress need to restart server to have clrenabled. I checked manually in the sqlinstance: clr is enabled but the query return "server must be restrated". If i restart the service, is ok. But I need to have IA made this. So I try to stop and start sqlinstance from msi code but is not working (acces denied). How can I do this? If I install a fress sqlexpress 64 bit version from outside IA, the sql express is nstalled, I enable clr and there is no nedd to restart the sqlinstance: What is the problem? Maybe a problem in the IA sqlruntime?