SQL 2005 Server Unattended Installation
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
ADVERTISEMENT
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
Apr 27, 2004
Does anybody know of any good links
Cheers
View 2 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
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
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
Apr 10, 2007
I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?
Regards.
Yusuf Incekara
View 5 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
Jan 10, 2008
The scenario I have is as follows:
Our product ships with a bootstrapper that installs SQL Server 2005 silently for our clients - basically it's a pre-req which we load for them if it's not already installed.
The bootstrapper supplies the service account identity parameters for the SQL Server install command line in English. It supplies the local system account (NT AUTHORITYSYSTEM).
The problem occurs when we tried to install the product onto a French version of XP. We got the error message "SQL Server setup could not validate the service accounts. Either the service accounts have not been provided for all the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account."
Having read the page http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Localized_service_names we have discovered that the system account identity has a different name for French (AUTORITE NTSYSTEM) along with some other languages ... but we're not sure how to resolve the problem.
Can anyone out there tell me whether we ...
1) Can get the machine being installed on to tell us the local system account identity so we can substitute it into our command line in the bootstrapper?
2) Have to write a different bootstrapper for each language that names the local system account identity differently?
3) Have overlooked some other solution?
Also, does anyone know how many languages and which they are that give the local system account a name that's different to "NT AUTHORITYSYSTEM"??
Thanks,
Sara
<EDIT>
Sorry, omitted a vital bit of information. The bootstrapper is written in C++.
We know the .NET code to retrieve an NT account given a well known SID. Can we do the same in C++ somehow??
</EDIT>
View 3 Replies
View Related
May 2, 2008
Hi,
I have a script that performs an unattended installation of SQL Server and works fine.
However, if I un-install via the control panel all the files are removed apart from the databases that are created by me when SQl server was installed. This is good and ensures data is not deleted.
The files left over are in the following directory:
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
and contains:
MyDatabase.mdf
MyDatabase_log.LDF
The problem I have is after performing the re-installtion of SQL server (unattended) I am unable to create a new database with the same name (in this instance called "myDatabase").
The actual files are physically there so this is the reason a new database with the same name cannot be creacted.
Again this is ok again because it ensures I cannot overwrite existing data. However I am unable to re-attach this database to SQl server so I can continue to use it!
The question is:
How do I make this database usable again after an unattended install? Is there a parameter I am missing?
Below are the commands I use that are passed to the installation of SQL Server as command line parameters:
#define SQL_SILENT "-q /passive /norebootchk /qn reboot=ReallySuppress"
#define SQL_USERNAME "username=MyUserName"
#define SQL_COMPANYNAME "companyname=MyCompanyName"
#define SQL_ADDLOCAL "addlocal=ALL"
#define SQL_DISABLENETWORKPROTOCOLS "disablenetworkprotocols=0"
#define SQL_INSTANCENAME "instancename=MSSQLSERVER"
#define SQL_SQLAUTOSTART "SQLAUTOSTART=1"
#define SQL_SECURITYMODE "SECURITYMODE=SQL"
#define SQL_SAPWD "SAPWD=#Password#"
#define SQL_SAVESYSDB "1"
#define SQL_USESYSDB ""
#define SQL_INSTALLSQLDIR ""
#define SQL_INSTALLDATADIR ""
#define SQL_PARAMETERS SQL_SILENT + " " + SQL_USERNAME + " " + SQL_COMPANYNAME + " " + SQL_ADDLOCAL + " " + SQL_DISABLENETWORKPROTOCOLS + " " + SQL_INSTANCENAME + " " + SQL_USESYSDB + " " + SQL_INSTALLSQLDIR + " " + SQL_INSTALLDATADIR + " " + SQL_SAVESYSDB + " " + SQL_SQLAUTOSTART + " " + SQL_SECURITYMODE + " " + SQL_SAPWD
The last four commands I have played around with but for some reason SQL Server service will not start when these are used! (This is a different issue though!).
Any advice would be gratefully accepted.
Thanks
Paul
View 3 Replies
View Related
Oct 2, 2006
Hi every one,
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
View 11 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
Jul 6, 2006
Hi there,
I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled.
Is there anyway to do this? I can't seem to find any switches in the INI file to allow this.
Thanks
Joseph Beckett
View 7 Replies
View Related
Sep 3, 2007
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
Chuck
View 4 Replies
View Related
Jan 28, 2007
Hi: I try to install SQL Server 2005 but it gives warning message. My computer configuration is Pentium III 900 HZ, 512 RAM with operating system windows 2000 Pro and service pack 4 and 10 GB free space. It gives warning on operating system. Also Visual Studio. Net 2005 is already installed on my comupter.
- SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
View 1 Replies
View Related
Mar 1, 2007
hi,
I have to install SQL Server 2005 on SBS Standard 2003. I am already running Sql Server Desktop Engine with three instances: MSSQL$SHAREPOINT, MSSQL$SBSMONITORING, MSSQL$BLUECOAT. I am wondering how the installation is gonna affect my system. I do need SQL Server 2005 for the new financial software which is intalled 2morrow. What shall I put as the instance during the installation. Is Sql Server Desktop Engine gonna be replaced by SQL Server 2005?
help!
View 1 Replies
View Related
Mar 19, 2007
i had downloaded .Net and SQL Server 2005 from microsoft site. In SQL Server 2005 after installation i get only Configuration Tools and 3 subtopics. I am able to create table only through . NET but am not able to work independantly with SQL Server 2005. Can anyone advice me!!
View 2 Replies
View Related
Jul 7, 2007
--------------------------------------------------------------------------------
Dear Sir,
While Installing Sql 2005 Express in IBM POS machine, the following Error comes.
The Sql Server Service has failes to Start
MESSAGE ID : 29503
Message Source : Setup.rll
evt Type : Sqlsetuplibservice.cpp@do_sqlscri
i Tried to other pos machine also , same problem Comes. But Normal Desktop pc it is running fine.
Please guide me
Thanks
View 6 Replies
View Related
Jan 6, 2008
Hi All,
I trying to Install on Windows XP with Service pack 4, OS.
I am trying to install the Developer Edition of SQL Server 2005 version for which it is not able to load many packages as it says IIS services, Integration Services Etc,. were not installed and if they were ignored then rest will be loaded and thereafter I could not either login or invoke either any.
Can anyone suggest me where it went wrong and what I need to do with instructions.
Thanks in advance.
View 2 Replies
View Related
Mar 21, 2008
Unfortunately for me, I am not a DBA - even though I have always filled that role where ever I have been. That being said, I have always been fortunate enough to have someone else more knowledgeable than I to perform the initial build of the SQL Servers I have used and managed. So, I have the following question...
I just finished installing and configuring a new dedicated SQL Server (it is nice too). One of the included discs it he MSDN Library. Do I need to install that too? Is there any reason to or not to install it? I would appreciate any feedback.
- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
http://blog.strohlsitedesign.com/
http://skins.strohlsitedesign.com/
View 5 Replies
View Related
Sep 24, 2007
Hi,
SQL Server 2005 has been installed on windows server 2003 machine by the support team.
Microsoft SQL Server Management Studio 9.00.3042.00
Now this machine has been passed on to me to create databases, tables, etc...
On this server, I open the management studio and I get the connect to server windows.
What should the entries in the connect to server window be for me to get to the next stage where I can start building databases.
At present, I tried local or localhost and windows/sql authentication.
Still can not get to the management studio window.
Any thoughts please?
Thanks
View 1 Replies
View Related
May 4, 2007
Hi,
I have a couple of questions reagrding SQL Server 2005 SP2?
1) Do I need to install SP1 and its accumulative hotfixes before applying SP2??
2) Anyone know what is SQL Server 2005 V 9.0.3033?? I saw it in a couple of SQL 2005 servers that suppose to have SP2 installed. I thought SP2's version is 3042??
Thanks for any input.
View 10 Replies
View Related
Jul 26, 2007
Hi,
We have the Windows server 2003 R2 Service PAck 2 , we got updated to this version after i installed automatic updates today,and i am having problems with setting up maintenance plan in SQL server 2005 (9.0.1399)
Hence i am trying to install Sql server 2005 SP1, but the read me file says that this installation is compatible only with Windows server 2003 SP1
Also, i received this error when i tried to install SQL server 2005 SP1 yesterday
"The image file hotfix.exe is valid, but is for a machine type other than the current machine"
I am confused, Can someone help me out in this regard?
Thanks in advance
View 1 Replies
View Related
Oct 15, 2007
Hi,
I'm trying to re-install the ms sql server 2005 but I keep getting the following message:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
------------------------------
This is my second time installing the ms sql server. I couldn't create a new database connection using odbc, I constantly got error messages so i decided to install it with windows and sql authentication (earlier i installed it only with windows authentication).
But I can't complete my installation.
Can some please help me with this.
Thank you!!
Soen
View 2 Replies
View Related
Jun 14, 2007
Hello Experts,I have a Windows Server 2003 For Small Business Server SP 2. Is it possible to install SQL Server 2005 on Windows Server 2003? I am intending to switch to SQL Server 2005 from SQL Server 2000 (on Windows Server 2000).Please advice. Thanks in advance.Regards,Suman Ghosh
View 6 Replies
View Related
Oct 2, 2006
I have just purchased SQL Server 2005 and a new Dell 2800 server to run it on. I was told by my Dell rep to configure the server with the following drives. 2 - 36GB drives in a RAID 0 (15,000 RPM), 2 - 73GB drives in a RAID 0 (10,000 RPM) and 3 - 146GB drives in a RAID 5 (10,000 RPM). Dell pre-installed the OS on the 36GB drive. I was told to install SQL on the 73GB drives and the data (primarily TIFF images) on the 146GB. The server is a 64bit machine with Windows 2003 Server and 4GB of RAM. I was told to put the transaction logs on a different physical drive that the database to speed the writes. Is this a correct installation? Is there any information on a best practice installation? I have spent about 6 hours on MS and Google trying to find an answer. Thanks for any help you can give. Recap of Dell recommendation:
2 - 36GB Mirrored Drives = OS
2 - 73BG Mirrored Drives = SQL Server 2005
3 - 146GB RAID 5 Drives = Data (Images)
Is this correct?
Where should the Transaction Logs Be?
View 1 Replies
View Related
Oct 22, 2007
While installing Microsoft SQL Server 2005 Express Edition the installation did not complete because of WMI configuation of my system.
Can somebody help!
View 2 Replies
View Related
Sep 1, 2007
I have sql server 2000 on my PC. If I want to upgrade to SQL Server 2005 should I have to uninstall the Sql server 2000 and install Sql server 2005. Or can i install the sql server 2005 directly.
View 2 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
