Cannot Set Unattended Execution Account For RS
Apr 21, 2008
We cannot set the "Unattended Execution Account" on any Sql Server 2005 Report Server. This problem occurs on new installations and existing installations of Report Server. We have several servers that have the account already set from prior install and configuration, but now it cannot be changed. No domain policy changes have been applied, only MS Patches.
All attempts to set the account using the Report Server config tools return a UnauthroizedAccessException, as shown below. I have been unable to find any documentation on the permissions required for this action. Can anybody help?
System.UnauthorizedAccessException
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetUnattendedExecutionAccount(String userName, String password)
View 1 Replies
ADVERTISEMENT
Aug 15, 2006
When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.
I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.
As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.
I've tried:
SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM
SQLACCOUNT=BUILT-INSYSTEM
etc.
and even some different SID as:
S-1-5-18
S-1-5-19
All with no password with the SQLPASSWORD parameter:
SQLPASSWORD=
I still getting the same error while validating the service account.
Is there someone else who knows what I'm doing wrong?
Best regards,
Mattias
View 5 Replies
View Related
Dec 27, 2007
my local instance of reporting services is named and therefore I think causing me a problem when I issue the following command to set up an unattended account...
rsconfig -s localhostinstance name -e -u domain nameuser name -p password
the message I keep getting is "No Reporting Services instance found on local host.". I tried a couple of things including replacement of the word localhost with my computer name but to no avail. I tried single and double quotes around the -s parameter but no success.
Anybody know how to do this?
View 2 Replies
View Related
Mar 19, 2008
We have a client-server product making use of SSRS. We have done dozens of installs, all with no issues, until this one. We have created an NT account specifically to run our reports. We'll call it "ReportUser". We have made it a local account on the server with the appropriate access to run reports. We set it up as the execution account and gave it the necessary permissions on the SQL Server. When we log onto http://localhost/reportserver on the server, we can access and run reports just fine. However, when we run it from a client through http://<servername>/reportserver, we receive the RSAccessDenied error. However, it does not list the execution account (i.e. <servername>ReportUser) as the prolem, but instead the given user's username (i.e. <domain><username>).
As a side note, we also cannot access the Report Manager from anywhere. We log onto it from the server even, and it only shows the Top portion of the screen. No published reports, no menu options, nothing.
Can anyone provide some insight?
View 8 Replies
View Related
Jan 5, 2006
During install of SQL Server 2005, we can of course use a domain account or the built-in system account for running the services. I lean toward domain for obvious reaons but would like to know a +/- to each option and why I'd choose one over the other and what consequences or limitations one may encounter if I choose one over the other.
View 6 Replies
View Related
Dec 4, 2006
I have been running a script in SQL Server 2000 as sa also as a Active Directory user who has administrator rights (I tested both approaches SQL Server then Windows Authentication) in Query Analyser which grants execute rights to the stored procedures within the database instance and Query Analyser does not give any errors when I run the script. I have made sure that each transaction has a go after it. I then return to Enterprise Manager, check the rights (I apply them to roles so that when we create another SQL Server user we just grant him/her rights to the role) and discover that the role has not been granted the rights. I seems to be occurring only with 2 of the procedures. Is there a known bug that might be causing this?
yours sincerely
Craig Hoy
View 9 Replies
View Related
May 9, 2002
I have several DTS jobs that runs well as a job with my nt login account for the SQL agent service startup account, but if I use the System account
they fail with this error.
" Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider"
The data has change access to the System account under the NT security.
Thank you in advanced.
Jorge
View 2 Replies
View Related
Mar 2, 2004
Hi all, i hope you can help me.
Basically a dts package has been setup that pulls in data from another companies server, this data requires to be on-demand i.e individual users can pull in updates of the data when they require it.
I am using xp_cmdshell and dtsrun to pull in the data. This obviouly works fine for me as i am a member of sysadmin.
Books online quotes " SQL Server Agent proxy accounts allow SQL Server users who do not belong to the sysadmin fixed server role to execute xp_cmdshell"
So i went to the SQL Server Agent Properties 'Job System' tab and unchecked 'Non-sysadmin job step proxy account' and entered a proxy account.
The proxy account has been setup as a Windows user with local administrator privilages and even a member of the sysadmin server role - just in case.
Now when i log onto the db with my test account - a non-sysadmin - and attempt to run the stored proc to import the data i recieved the message 'EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo' '
hmm... so basically i have either misunderstood BoL or there is something not quite right in my setup.
I have search the net for a few days now and yet i can find no solution.
Can anyone help?
View 2 Replies
View Related
Jul 20, 2005
Hi there,BOL notes that in order for replication agents to run properly, theSQLServerAgent must run as a domain account which has privledges to loginto the other machines involved in replication (under "SecurityConsiderations" and elsewhere). This makes sense; however, I waswondering if there were any repercussions to using duplicate localaccounts to establish replication where a domain was not available.Anotherwords, create a local windows account "johndoe" on both machines(with the same password), grant that account access to SQL Server onboth machines, and then have SQL Server Agent run as "johndoe" on bothmachines. I do not feel this is an ideal solution but I havecircumstances under which I may not have a domain available; mypreliminary tests seem to work.Also, are there any similar considerations regarding the MSSQLSERVERservice, or can I always leave that as local system?Dave
View 1 Replies
View Related
Jul 7, 1999
How can one perform upgrade to SQL 7.0 from 6.x without using the upgrade wizard? Is there any unattended upgrade option that one can exercise?
Also, if SQL 7.0 is already installed, can one do a selective upgrade of some SQL 6.5 objects? For instance, can one upgrade only the tables, views and triggers from 6.5 to a 7.0 database?
Any pointers, help, info in this regard would be greatly appreciated!
Rnathan
View 2 Replies
View Related
Mar 31, 2004
Using an unattended file (.iss) is there a way to incorporate the SP3 (or any) patch within an .iss file so that there is only only install that incorporates the patch?
View 1 Replies
View Related
Apr 27, 2004
Does anybody know of any good links
Cheers
View 2 Replies
View Related
Mar 23, 2007
I am trying to do an unattended install using the following commad
Setup.EXE /settings C:/setup.ini /qn
but i am getting a messaged saying
"Please go through control panel to install and configure system component"
I already have one instance of sql server installed on the server.
Please can some one help with this
View 2 Replies
View Related
Nov 28, 2007
Hi guys i am trying to install 2005 SQL server(enterprise) on 80-100 servers, mostly with default instances and some with named instances( may be 30 of htem) on 2003 Windpws enterprise platform. i wanted to unattended installation and also if all the configurations are the same, can i install on all servers at time.
Some pros and cons are appreciated and also if you got better scripts please do share it,
Thanks
Derek
View 3 Replies
View Related
Aug 16, 2007
Hello,
I have a problem with an unattended installation of the SQL Server 2005. I am trying to convert a manual-installation to unattended but am stuck with the service accounts. According to the manual I have to install the server using the built-in system account without customization for each service account.
Installation takes place on a machine with German Windows XP Professional Service Pack 2. It stopped the installation with a message telling me to specify sqlaccount, rsaccount, etc.
I did this and still get an error. According to http://msdn2.microsoft.com/en-us/library/ms144259.aspx I tried NT AuthoritySystem and Nt Authority, but I can't get the unattended install to work.
The manual installation works fine on this system so I think it must be a problem with the parameters I'm using.
Best Regards
Dominik Brosent
View 3 Replies
View Related
Feb 14, 2006
Hi,
I have tried to do a new SQL 2005 install via an unattended install script. I have tried both a modified version of the template.ini and just from the command line.
The installation starts and successfully installs some of the components I have selected through the ADDLOCAL option. Unfortunately it then reports an execution error and exits.
The errors I find in the install log files are as follows...
SQLSetup..._Core.log:
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed
Message pump returning: 1603
SQLSetup..._Core(Local).log
Running: InstallToolsAction.10 at: 2006/1/14 14:58:11
Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "10"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlchainingsqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
WinException caught while installing package. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: packageengineinstallpackageaction.cpp
Compiler Timestamp: Fri Jul 1 01:28:25 2005
Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework 2.0 LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Upgrade Advisor.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Windows Installer.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Windows Installer LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/1/14 14:58:39
Message pump returning: 1603
The files reported as failing to be added to the .cab file do not exist, although .Net 2.0 was successfully installed. All other log files do not seem to contain errors.
When calling the install from the command line I am running the following
setup /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQLXML,SQL_WarehouseDevWorkbench,Tools_Legacy,SQL_Documentation,SQL_BooksOnline INSTALLSQLDIR="D:NTAppsMicrosoft SQL Server" INSTALLSQLSHAREDDIR="D:NTAppsMicrosoft SQL Server" INSTALLSQLDATADIR="F:Data" INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT="DomainSQL" SQLBROWSERPASSWORD="******" SQLACCOUNT="DomainSQL" SQLPASSWORD=="******" AGTACCOUNT="DomainSQL" AGTPASSWORD="******" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SECURITYMODE=SQL SAPWD="*******" SQLCOLLATION=SQL_Latin1_General_Cp1_CI_AI
Note: I've changed the usernames and passwords
Any ideas anyone?
View 7 Replies
View Related
Jul 19, 2006
I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch
but I need to do either a Silent or Unattended install.
Does anyone know how to do this? Does anyone know the
command-line command to do this?
I tried using...
sql70sp4.exe -a -f1 "unattend.iss"
....but that didn't work. It popped up a window asking where I
should extract the contents of the .exe (that shouldn't be appearing
either) and then after it extracted it didn't do anything else.
Any help is greatly appreciated.
View 1 Replies
View Related
Apr 25, 2007
I have a situation that I have discovered in our QA database that I need to resolve. When I looked at the Activity Monitor for our server, I discovered that a process is running under a domain user account for one of our .Net applications. The problem is that that domain user account has not been created as a SQL login account on the server. I am trying to figure out how someone can log in to the database server with a domain user account that has not been added to SQL Server as a login account.
Does anyone have any insight on this? I don't like the idea of someone being able to create domain account that can access the database without me granting them specific access.
- Larry
View 6 Replies
View Related
Nov 1, 2001
I need to install the above to various PC's in our company. Has anyone done this before and could they give share any advice please.
Thanks in advance..
View 1 Replies
View Related
Sep 22, 2006
Hey guys -
I am busy testing SQL 2005 Server Unattended installations and have a quick question. Microsoft specifies the following code for command line installation:
Start /wait <CD or DVD Drive>serverssetup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=All PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>
SQLACCOUNT=<domainuser>
SQLPASSWORD=<DomainUserPassword>
AGTACCOUNT=<domainuser>
AGTPASSWORD=<DomainUserPassword> SQLBROWSERACCOUNT=<domainuser>
SQLBROWSERPASSWORD=<DomainUserPassword>
Here is a link to the installation pages: Click Here (http://msdn2.microsoft.com/en-us/library/ms144259.aspx)
My question is what are all the different accounts for?
Any help will be appreciated.
Thanks
Reghardt
View 1 Replies
View Related
Mar 23, 2004
We're trying to use the unattended installation method for installing SQL 2000 on Windows 2000 servers. I've installed it (through terminal server) on two machines successfully, and two machines unsuccessfully. On the unsuccessful machines, it fails with no errors, and no SQL files are installed (bombs out almost immediately).
Anyone else had this problem? Could it possibly be a hardware issue?
View 8 Replies
View Related
Sep 10, 2007
Hello,
I have a quick question about automating installation of SQL 2005. This question doesn't relate as much to SQL 2005 as it does setting up a database server.
I know that it's usually standard practice to allow SQL to "lock pages in memory". What I am trying to do is find a command line utility that will allow me to add this step to the SQL install script. Any help is appreciated. Thank you.
View 3 Replies
View Related
Jun 20, 2006
I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?
Thanks for any help.
View 1 Replies
View Related
Jul 24, 2006
I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.
Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.
Is there a way to do this with a command-line parameter (etc)?
Thanks in advance
Josh
View 6 Replies
View Related
Oct 13, 2007
Good afternoon,
I have written a .NET app that kicks off an unattended install of SQL Server Express Advanced. After the install, the same app tries to connect to SQL Express adn run a script that creates a database plus a few other things.
However, the problem I am having is that my app cannot connect. I get the error:
"An error has occurrred while establishing a connection to the server. This failure may be casued by the fact that under the default settings SQL Server does not allow remote connections."
However, the unattended install goes great. No problems there. I know this because I can Open SSMS, run queries, created DB's, etc. I also know that it is not the remote connections issue because the unattended install is set to allow remote connections (both names pipes and TCP/IP).
So, why can't i connect? I don't need to reboot after the install do I? Please tell me i don't...and please tell me it is something simple I am overlooking.
Thanks...
View 3 Replies
View Related
Mar 6, 2008
Hello SQL Knowledgeable Crowd,
I'm trying to install SQL Server 2005 from the command line without using an .ini file and without having IIS installed. I know that I need to pass all the parmeters and I think I have them all.
My .bat file will install when IIS is installed, but I can not get it to install without IIS. The GUI gives me a warning and allows me to ignore this, but I can't figure out the switch that will do the same thing.
Can someone please point out my mistakes.
Here are my command line parameters:
(Win 2k3 x64, SQL2005 Enterprise)
"P:SoftwareMicrosoftSQL Server 200564-bitEnterpriseCD1setup.exe" /qn
INSTANCENAME="MSSQLSERVER" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_FullText,Notification_Services,NS_Engine,NS_Client,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQL_Documentation,SQL_BooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_AnalysisServiceSamples,SQL_Samples
PIDKEY=
SAPWD="NT AUTHORITY"
SQLACCOUNT="NT AUTHORITY"
AGTACCOUNT="NT AUTHORITY"
RSACCOUNT="NT AUTHORITY"
SQLBROWSERACCOUNT="NT AUTHORITY"
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=1
RSAUTOSTART=1
View 2 Replies
View Related
Nov 28, 2006
Hi!
I'm trying to do the following in a batch-file:
1) Install SQLExpress unattended providing settings in an .ini-file
2) Run an osql-command which creates a database and some tables etc.
My batch-script looks like the following:
REM Install SQLExpress
start /wait .SQLExpresssetup.exe /qb /settings %CD%mysettings.ini
osql -S (local)MyExpress -U sa -P passwd -i .createdb.sql
...
The problem is that the SQLExpress setup updates the %PATH%, but the change is not visible in my cmd-context . So, the osql-command fails.
It seems like I have to start a new cmd-window from the windows shell to get the updated environment.
Is there any way to make the environment changes visible to my script?
This might be more a sort of general batch-programming topic, but any help is appreciated. :)
Regards,
Sigurd Ringbakken
View 4 Replies
View Related
Oct 19, 2007
Hi All,
I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.
Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?
Any help on this will be great.
Cheers
Raxso
View 3 Replies
View Related
Mar 15, 2007
I'm able to install SQL 2005 Express using a template.ini, and use the option DISABLENETWORKPROTOCOLS=2 in order to enable TCP/IP. However, I then manually need to open SQL Server Config Manager > SQL Network Config > Protocols for SQL > TCP/IP > "IP Addresses" tab > change all "enabled" options to "yes".
Is there an automated way to do this?
Thanks,
James
View 1 Replies
View Related
Jan 17, 2008
Hello All, I am trying the following script to upgrade SQL Server 2005 SP1 to SP2. I have an Active Passive cluster configuration. I have default instances of SQL Server. I am using the following script.
start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /allinstances /quiet.
The sql server install fails to run. When I used the above command with just
start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /quiet still the summary.txt file came with authentication success and that is all. I changed the above script and did
start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /instancename=instancename of the cluster
This worked, however the install patched the passive node (DB engine, all the cluster unaware components) but failed to patch the DB engine on the Active node. I had to run the SQL Server sp2 install manually but still it did not patch the DB engine on the primary node
1. Can someone please help me with this issue as I want the unattended install to work. so it installs both active and passive node. I will post the final output and also the ADS script to do this as a bonus if this works.
Here is the summary.txt file.
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
msftesql Database Services Service 5152
MSSQLSERVER Database Services Service 4412
ResrcMon.exe Database Services Application SHOMSCSService 4688
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file D:Microsoft SQL ServerMSSQL.1MSSQLData for user sqlservice. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29506
View 1 Replies
View Related
Mar 30, 2007
1. Extracted SQL Server 2005 Express Service Pack 1 files to local filesystem.
2. Ran setup.exe from local filesystem.
3. Changed all installation paths to D. Specified data files go to D:Data
3. Set all services to run as Local System.
4. Did not reboot.
5. Extracted SQL Server 2005 Express Service Pack 2 files to local filesystem.
6. Attempted an unattended installation using /settings and a modified template.ini file.
7. Checked C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt which did not show any errors.
8. SELECT @@VERSION showed the version number is 9.00.2470.00, which indicates the upgrade was not actually successful.
This is what was in the modified template.ini file:
INSTANCENAME=MSSQLSERVER
INSTALLSQLDIR="D:Program FilesMicrosoft SQL Server"
UPGRADE=SQL_Engine
INSTALLSQLSHAREDDIR="D:Program FilesMicrosoft SQL Server"
ENABLERANU=0
Tried added this, which did not help:
REINSTALLMODE=vomus
Also tried adding this, which did not help, either:
INSTALLSQLDATADIR="D:Data"
What does it take to have a successful unattended upgrade of SQL Server 2005 Express from SP1 to SP2?
View 3 Replies
View Related
Dec 19, 2006
Hi,
I'm currently trying to develop an unattended installation of the Client Tools to be distributed to developers workstations.
All is well on 'clean' machines, but the problems arise when an instance of SQL Server Express is already present. The install fails, and the reason isn't clear from the log files.
I know Express installs a couple of the Client Components (like Config Manager), and I believe this is what it blocking me.
Has anyone tried this scenario?
Would I be best to REMOVE the Client_Components first, and then re-install them with SSMS etc.? Or is there a better method?
I have to leave the Express Database instance untouched as I'm not responsible for its installation or maintenance.
Thanks,
Gordon.
View 1 Replies
View Related
Aug 23, 2007
after moving off VS debugger and into management studio to exercise our SQLCLR sp, we notice that the 2nd execution gets an error suggesting that our static SqlCommand object is getting reused from the 1st execution (of the sp under mgt studio). If this is expected behavior, we have no problem limiting our statics to only completely reusable objects but would first like to know if this is expected? Is the fact that debugger doesnt show this behavior also expected?
View 4 Replies
View Related
