I am setting up a template.ini for my SQL2005 installs. The documentation on the INI file is great up until the "SQLCOLLATION" section.
How do I choose the SQL Collation: "Dictionary order, case-insensitive, uppercase preference, for use with 1250 Character Set" ?
SQLCOLLATION=???????
I have a desktop application in which I use Sql Server CE.
It all works well on my development machine.
It also works on other machines if I copy the sql dll files in the same path as the .exe
I'm trying to avoid all kinds of user interaction. They don't need to know that I'm about to install Sql Server CE really
So I'm hoping to avoid writing in the manual that the user should install SQLServerCE31-EN.msi, which I think is the correct install package.
So my question is: How do you silently/unattended install Sql Server CE on the desktop?
Hi,
how do Silent Installation with VBscript ? because I have some step for user interactive.
please anyone put an example about this or put a link to.
thank you very much.
Hi all,
After doing a silent install of the MSDE, my application cannot access the database that is loaded on the local machine -
I am getting an error stating - 'login failed for user 'sa'. Reason: Not associated witha trusted SQL server connection'
Is there are parameter or something that i need to change in my UDL??
or is there a way to tell the server to work in non-trusted inviroment via the OSQL program???
thanks
tony
Try to install SQL server Express
download from Microsoft site SQLEXP32.EXE version 9.0.3042.0
Expand this file using command line install "start /wait setup.exe /qn ADDLOCAL=All LOGNAME="c: empInst_SQLEXP.cab"
at installed computer just have C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGsummary.txt
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Feb 22 10:58:50 2008
and C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DC7660_TEST2_Core.log
Microsoft SQL Server 2005 Setup beginning at Fri Feb 22 10:58:50 2008
Process ID : 3884
C: empSQLEXPsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/1/22 10:58:50
Complete: LoadResourcesAction at: 2008/1/22 10:58:50, returned true
Running: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50
Loaded DLL:C: empSQLEXPxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3884"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/1/22 10:58:50
Complete: ValidateWinNTAction at: 2008/1/22 10:58:50, returned true
Running: ValidateMinOSAction at: 2008/1/22 10:58:50
Complete: ValidateMinOSAction at: 2008/1/22 10:58:50, returned true
Running: PerformSCCAction at: 2008/1/22 10:58:50
Complete: PerformSCCAction at: 2008/1/22 10:58:50, returned true
Running: ActivateLoggingAction at: 2008/1/22 10:58:50
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00DBCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
have a Unexpect error?
any advice welcome.
I can't get SQL Server 2005 to update to SP2 in either silent or unattended mode. None of the standard switches work. I've used -s, -m, /q, /qb, and /qn all with no favorable result. I am still prompted for user input at every screen. Suprisingly I've had no such problems with the express edition, just the server itself. Is there a way to make this thing work? Here is the line I've been feeding to the installer.
"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait setup.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart
I have also tried the following since it looks like the file that is unpacked by the SP2 install is actually hotfix.exe
"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait hotfix.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart
I also have tried the following generics:
"<SERVER_PATH>SQL Serversql2005SP2.exe" -s
"<SERVER_PATH>SQL Serversql2005SP2.exe" -m
"<SERVER_PATH>SQL Serversql2005SP2.exe" /q
Hi,
I'm doing a silent install of SQLServer Express 2005 as explained in http://msdn2.microsoft.com/en-us/library/ms144259.aspx .
I am setting DISABLENETWORKPROTOCOLS=2 because I want to enable TCP/IP protocol at install time.
However it seems that per default SQLServer is configured to use dynamic TCP/IP ports, forcing me to contact the SQLBrowser.
How can I switch to a fixed port, say 1433, at install time?
Thanks, in advance,
Dirk.
I'm still doing some research but I thought I'd slap a quick post up here anyway. I'm trying to create a small 'setup and deployment' project in studio 2005 that includes a prerequisite (sqlexpress). The one thing I've noticed is that there is not an option to install this silently by providing the executable with the appropriate switches. I could easily write my own small utility to do the work or I could use a third-party component like NSIS, however, I'm quite simply amazed that this feature was left out of studio 2005. It's quite possible I'm missing something...any feedback is appreciated 100 times over!
Thanks
Corey
I'm currently building an MSI to install SQL Express and want to install as a new instance, not the default instance, and not into the SQLEXPRESS instance either.
I saw the package.xml for Express in my VS Studio install. How would I go about using this? Or would I have to modify the MSI via Orca or something? I hope not. Wouldn't have a clue where to start.
In short, regardless if there is already an SQL Express instance on the machine or not, I need to silently install a fresh new instance of the server engine only, no client tools except sqlcmd.exe
I have seen that MS would advise that everyone use the SQLEXPRESS instance but I don't agree with it. I don't want other application installs trampling over my server settings and I don't want to trample over others. For example, expose others to TCPIP and CLR when they don't need it, and conversely others swithing them off in a shared server instance when I do need them.
Yet another roadblock: Does the standard SQL SE 2005 not install any of the query commands? (isql, isqlw, or osql.exe's). I could have sworn that they were, but every time I go to test the install on my VM none of them are ever installed. If it doesn't is it included in the advanced version of it (which I'd really rather not do)? If still no what's the easiest option I still have open? Can I have my app connect to the master db and run a restore script from the app? I've been arm wrestling with this install for over a week and it's just about brow-beaten me completely.
TIA,
Jayyde
Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
Here is the command line that fails :
"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
Interrestingly, when the following command line is used to launch the setup,
it completes successfully :
"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"
After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.
Any help appreciated.
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
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
Can anyone tell me how to get around this? Installing SQL- no issues, just when applying the sp
I have tried numerous things, including rebuilding the 2nd node again
Trying to install a service pack on SQL 2000 node, and Install shield keeps returning this error, .
[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-8
I have reset temp directories on both nodes,
I have made user permissions and profiles exist
I have copied install files to both local and remote locations
I know the response €“ Installshield cannot find the silent response file, but SQL setup creates this on its own.
Short of bringing this production system down and re-installing on both nodes ( I did test this on a non-prod box by the way, no issues), I am at a loss
Hi there,Is it posible to set the collation of SQL server 2005 like Oracle, which isthat objects names and column names are case-insensitive, but data issensitive;e.g:In Oracle:--create lower-case table and column namecreate table t1(c1 char(10));--Mike with upper-case Jinsert into t1 values('Mike');--follwoing I'm changing case in the table name, but it works, however'Mike' has to be with uppewr case Mselect * from T1 where c1='Mike'Above test fails in SQL server. Is there a collation which can make data'literals' sensitive, but data dictionary or the object names and columnnames case insensitive?TIA,Nasir
View 27 Replies View RelatedHi,
I would be very grateful if someone could take a look at my command line install and offer advice on if I am doing it correctly.
The reason I am asking is because I cannot seem to get the server installed without having errors during the installation:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error 17113 (0x42D9)"
Looking at the server error log indicates that master.mdf was not in the data directory (I have however specified a different data directory for ease of backup by our software and this is created during the install but does not have this database in the data directory - it is however in the template data directory!
I also get this error when the SQL Server service is started:
"The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59)."
All advice is welcome. Please see below my batch file. Also, if you think I should do this in a different way then please let me know. I basically want to install SQL server on a customer computer and automate the install so the custoemr does not need to enter any information.
The goal of this install is:
[1] Deply a custom .Net application and SQL server at the same time on the same computer without user input.
[2] Allow remote .Net applications (designed by myself also) to connect over a LAN (and later maybe over a WAN) to the database to the above database.
The command line is this (I have also included the batch file I am usign below). For ease of reading I have put the parameters on a new line below:
setup.exe /qb
username="CustomerUsername"
companyname="OurCompany"
addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
disablenetworkprotocols="0"
instancename="MSSQLSERVER"
INSTALLSQLDATADIR="c:SqlData"
USESYSDB="c:SqlData"
SAVESYSDB="1"
SQLAUTOSTART="1"
SECURITYMODE="SQL"
SAPWD="#StrongPaSSword#"
======= Batch file Start ======
SET MODE=/qb
SET SETUP_EXE=sqlfilessetup.exe %MODE%
SET SQLDATADIR=c:SqlData
SET SET_USERNAME=username="CustomerUsername"
SET SET_COMPANYNAME=companyname="OurCompany"
SET SET_ADDLOCAL=addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_DISABLENETWORKPROTOCOLS=disablenetworkprotocols="0"
SET SET_INSTANCENAME=instancename="MSSQLSERVER"
SET SET_INSTALLSQLDATADIR=INSTALLSQLDATADIR="%SQLDATADIR%"
SET SET_SAVESYSDB=SAVESYSDB="1"
SET SET_USESYSDB=USESYSDB="%SQLDATADIR%"
SET SET_SQLAUTOSTART=SQLAUTOSTART="1"
SET SET_SECURITYMODE=SECURITYMODE="SQL"
@REM === RE-INSTALL PARAMS - NOT CURRENTLY BEING USED?? SHOULD I ADD THESE ALSO? ===
SET SET_REINSTALLMODE=REINSTALLMODE="omus"
SET SET_REINSTALL=REINSTALL="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_REBUILDDATABASE=REBUILDDATABASE="1"
SET SET_SAPWD=SAPWD="#StrongPaSSword#"
@REM === START THE SETUP / RE-INSTALL ===
START %SETUP_EXE% %SET_USERNAME% %SET_COMPANYNAME% %SET_ADDLOCAL% %SET_DISABLENETWORKPROTOCOLS% %SET_INSTANCENAME% %SET_INSTALLSQLDATADIR% %SET_USESYSDB% %SET_SAVESYSDB% %SET_SQLAUTOSTART% %SET_SECURITYMODE% %SET_SAPWD%
======= Batch file End ======
Your advice is kindly welcome.
Thank you
Kind regards
Paul
Hey all,
Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.
Thanks in advance,
Bill
I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies View RelatedHi,
we've just installed SQL2005 and, as expected, are hitting problems with collation settings.
We have made sure that the collation of our new server is the same as the old (working) SQL2000 server (both are Latin1_General_CI_AS) but a function that works fine on the 2000 box just doesn't work on the 2005 box.
The problem is this...
Code Snippet
select *
from information_schema.[tables] as t
left join :: fn_ListExtendedProperty('MS_Description','user','dbo','table',null,null,null) as xp on ( xp.objname = t.table_name )
...where that string comparison on "table_name" results in...
"Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_CI_AI" in the equal to operation."
Now... I can't see where the "Latin1_General_CI_AI" is coming from. The two data sources are both "system" sources, so should, I would have thought, been the same. If I do...
execute sp_help "information_schema.tables"
...all the columns are Latin1_General_CI_AS. If I do...
execute sp_help fn_ListExtendedProperty
...the same collation is returned for all columns.
I've checked everything I can think of (server, master, tempdb, etc.), and everything seems to be "AS".
Where might this "AI" collation be defined ? We have only just installed 2005, so a re-install, while a pain, is not a massive problem, but what should we check/change ?
Thanks
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
Can anybody please advise?
I printed out several pages of documentation regarding the install of 2005. When I tried performing the installation from CD I double-click splash.hta, as indicated in "How to: Install SQL Server 2005 (Setup)". Under Install I see two options:
Server components, tools, Books Online, and samples
Run the SQL Native Client Installation Wizard
The documentation indicates I should be clicking on "Run the SQL Server Installation Wizard", which is not an option. If I select "Run the SQL Native Client..." it appears to be only installing the client and does not follow the remainder of the instructions. I can't find any information on Microsoft's site on how to perform an install from CD.
I'm guessing I should be using the DVD, but has anyone else noticed the "How to" documentation is a little off and have you found any other documentation that is more accurate?
Thanks, Dave
Hi, I need to change the collation when I install SQL Express 2005 to SQL_LATIN1_GENERAL_CP1_CI_AS but the drop down on setup only allows
LATIN1_GENERAL.
How do I get the correct collation to appear?
Thanks for any help/tips
I need a SQL Server 2005 SP2 instance with a collation of SQL_Latin1_General_CP850_BIN2. After installing SP2, the collation is SQL_Latin1_General_CP850_BIN, and none of the patches I can find seem to want to work (they are all apparently written for SQL Server 2000).
Any assistance is greatly appreciated.
working with Altiris Software deployment - when installing SQL 2005 i receive the follwing error "failed to set registry settings for server network libraries. the action is SetDefaults. The error is 111 (The file name is too long.)
I have the Install log (error log) and I'm looking at all these errors and pulling my hair out - any help would be appreciated!! Help GURUS!!
2008-01-25 09:35:30.25 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2008-01-25 09:35:30.57 Server (c) 2005 Microsoft Corporation.
2008-01-25 09:35:30.57 Server All rights reserved.
2008-01-25 09:35:30.59 Server Server process ID is 812.
2008-01-25 09:35:30.59 Server Authentication mode is MIXED.
2008-01-25 09:35:30.64 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2008-01-25 09:35:30.70 Server Registry startup parameters:
2008-01-25 09:35:30.75 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2008-01-25 09:35:30.75 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2008-01-25 09:35:30.75 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2008-01-25 09:35:30.92 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-01-25 09:35:30.92 Server Detected 2 CPUs. This is an informational message; no user action is required.
2008-01-25 09:35:32.12 Server Error: 8316, Severity: 16, State: 1.
2008-01-25 09:35:32.12 Server Cannot open registry key 'HKLMSYSTEMCurrentControlSetServicesMSSQL$XACTWAREPerformance'. SQL Server performance counters are disabled.
2008-01-25 09:35:35.48 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2008-01-25 09:35:38.79 Server Database mirroring has been enabled on this instance of SQL Server.
2008-01-25 09:35:39.23 spid5s Starting up database 'master'.
2008-01-25 09:35:40.06 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2008-01-25 09:35:40.76 spid5s SQL Trace ID 1 was started by login "sa".
2008-01-25 09:35:40.98 spid5s Starting up database 'mssqlsystemresource'.
2008-01-25 09:35:41.15 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.15 spid5s FCB::Open: Operating system error 21(The device is not ready.) occurred while creating or opening file 'D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.18 spid5s Error: 17204, Severity: 16, State: 1.
2008-01-25 09:35:41.18 spid5s FCB::Open failed: Could not open file D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf for file number 1. OS error: 21(The device is not ready.).
2008-01-25 09:35:41.28 spid5s Error: 5120, Severity: 16, State: 101.
2008-01-25 09:35:41.28 spid5s Unable to open the physical file "D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.mdf". Operating system error 21: "21(The device is not ready.)".
2008-01-25 09:35:41.70 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.70 spid5s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.70 spid5s File activation failure. The physical file name "D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf" may be incorrect.
2008-01-25 09:35:41.74 spid5s Error: 945, Severity: 14, State: 2.
2008-01-25 09:35:41.74 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2008-01-25 09:35:41.87 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
angela
How to install database and SQL logging separately on a NON system partition in sql2005.
View 4 Replies View RelatedHi
After SP1 install completes successfully, I checked the log file and next to all the products it shows "Not Applied" yet it seems to have worked. Can I ignore these messages?
Cheers
Hi!
We have a TFS server include this components:
windows standard R2 server + SP1
Microsoft SQL Server 2005 + SP1
Microsoft Visual Studio 2005 Team Foundation Server - ENU + SP1
Microsoft Windows SharePoint Services 2.0.
Can I install sql 2005 SP2 without any problem?
Best Regards,
Mihaly Demeczky
Hi,
I need to install SQL2000 onto a machine (W2K3 R2, SP2) that already has SQL2005, SP1 running. I can't disturb the SQL2005 installation.
Are there any problems or pitfalls to avoid? I've googled and looked on Technet but not yet found an answer.
Has anyone done this?
I know that if I install a separate instance of SQL2000 alongside a default installation of SQL2000 then I'll get a totally separate installation which won't affect the other one at all, so I reckon it could be done. But I have to be sure before I start!
Thanks in advance,
Steve
Hi All
I cannot complete the sql2k5 express update to sp2. I get the error no 1635. This patch package could not be opened. Verify that the patch package exists... etc. The log file states the following.
Trying source \DLc$5f3f0e35b9c57ea30accad3e6b66585fHotFixSqlSupportFiles.
Why is it looking here for the install when the patch files are located in c: empsp2 ??
What can i try
I ran a test upgrade of sql 2005, sp1, to SP2, on a Windows 2003 server. After the upgrade (which seemed to work well) I got an additional information dialog box:
"By default, users on Windows Vista and later Operaitng systems are not members of the System Administrator role for the Sql or Analysis services. To add users to the System adminstrator role.. launch the sql 2005 User Provisioning Tool for Windows Vista after SP2 installation completes...."
Huh? Are users on any OS, be default, members of the sysadmin role?
While I am "glad" for the extra information, it seems irrelevant to the current situation.
Barkingdog
Can SQL Server 2005 Standard and VS2005 Professional be installed and work on Windows XP Professional? Thanks.
View 1 Replies View RelatedI had a SQL2000 Server with a simple database. I did an "in place" upgrade to SQL2005 expecting the DB Server and databases to upgrade. However, now when I run SQL Server Management Studio and enter the query:-
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
I get the answer:-
8.00.2039SP4Enterprise Edition
Why didn't it upgrade? And how do I upgrade it now? I'm very confused!
Any assistance is appreciated.I would like to know if there is a way to specify the path for databaselog files to be located during the SQL2005 Standard installation.Under the Advanced button there is the ability to specify a differentpath for data files but nothing for logs.Thanks in advance,John
View 5 Replies View Related