First Time Installation Of SQL Server 2005 Developer Edition
Oct 13, 2007
Just placed the SQL Server 2005 - Developer Edition into my Drive...
I get prompted with the following options..
This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin
x86-based operating systems
x64-based operating systems
Itanuim-based operating syystems
I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...
I will be installing it on my PC... i
Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2
My local Hard Drive remaining capacity is 12.6GB
External Hard Drive remaining capacity is 11.0GB
Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video....
Just placed the SQL Server 2005 - Developer Edition into my Drive...
I get prompted with the following options..
This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin
x86-based operating systems
x64-based operating systems
Itanuim-based operating syystems
I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...
I will be installing it on my PC... i
Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2
My local Hard Drive remaining capacity is 12.6GB
External Hard Drive remaining capacity is 11.0GB
Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video....
I've tried to installed sql server 2005 developer edition on windows vista home premium but failed many times, almost giving up. I've installed and turned on all the features of IIS 7.0 but it still failed and I tried to test IIS 7 by running the local host and received this error " HTTP Error 500.0 - Internal Server Error." I even ran the windows update SP1 for Vista and MDAC 2.8 SP1
I really appreciate any comments and help.
----- Here are the messages in the windows system check for the sql server 2005 installation:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
I've tried to installed sql server 2005 developer edition on windows vista home premium but failed many times, almost giving up. I've installed and turned on all the features of IIS 7.0 but it still failed and I tried to test IIS 7 by running the local host and received this error " HTTP Error 500.0 - Internal Server Error." I even ran the windows update SP1 for Vista and MDAC 2.8 SP1
I really appreciate any comments and help.
----- Here are the messages in the windows system check for the sql server 2005 installation:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
I have Windows Vista, and I am tryed to install SQL Server I downloaded from MSDN. I tried both Express and Developers Edition but both give me this error when trying to install SQL Database Services
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349
Of course the help link is useless, sure looks purdy though.
Anything you folks out there on WWW can do to help will be appreciated. Please put your posts in English. By that I mean I am not that good with computers when it comes to troubleshooting so keep the technical stuff short and sweet.
Is it possible to connect SSRS running on SQL Server 2005 enterprise edition (our production system) to a database running on SQL Server 2005 Developer's edition (our test system)
Hi I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance. I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system. I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.
Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version? I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer. According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system (NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?
As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?
We have an existing installation of SQL Server 2005 Developer Edition (64bit) that we are ready to go live with and would like to change the edition to Enterprise Edition (64bit). We have purchased all the appropriate licenses. We would like to avoid UN-installing the Developer Edition and RE-installing the Enterprise Edition. There must be some way to change a registry key, provide your serial number via a command line utility or re-run the setup with the license key provided and direct it to just change the edition from Developer to Enterprise and not change any of the other settings like service account, sa account, collation, etc. Any help is most appreciated.
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
I tried to download PerformancePoint Server Trial Version to ther server today and I got to the configuration point of the Analysis Services Setting, and when I clicked next to proceed with the configuration I got a popup error message: "Microsoft Analysis Server must be Evaluation, Developer or Enterprise Edition".
Now I have SQL Server 2005 Developer Edition Disc (Bought it with Visual Studio 2005) but on the server I have SQL Server 2005 Standard Edition, if I try to run the sql server developer Edition disc, I use the wizard download and it seems that the download is going through the SQL Server entire download, it's like I'm re-downloading SQL Server all over again.
Does that seem right? what is the best approach to work around this probelm?
I am currently downloading the mega-sized files for SQL Server 2005 Express Edition and was wondering if I was going to be able to install it onto my workstation alongside the SQL Server 2005 Developer Edition? Was hoping someone could advise. I did browse for an answer, but have not come across it yet. I know I'll find out once my download is complete, but that could be awhile :)
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?
Everytime I open SQL Server Studio Management I recieve the below error. I've un-installed and reinstalled but it continues to come back. I cna continue on and it'll work kind of, but after a while it'll jsut crash on me normally when I'm trying to save a script or create a new DB. Sql Server 2000 is installed on the same machine so I'm wondering if I can have them both installed like this. Has any one seen this one?Bruce See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text **************System.IO.IOException: Cannot create a stable subkey under a volatile parent key. at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str) at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity) at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey) at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName) at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser() at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies **************mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------AppIDPackage Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL----------------------------------------System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------Microsoft.SqlServer.SqlTools.VSIntegration Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL----------------------------------------Microsoft.VisualStudio.Shell.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.0.4054 CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll----------------------------------------Microsoft.VisualStudio.OLE.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.0.4054 CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll----------------------------------------System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------Microsoft.SqlServer.SqlTDiagM Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll----------------------------------------Microsoft.DataWarehouse.SQM Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL----------------------------------------Microsoft.SqlServer.Instapi Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll----------------------------------------ObjectExplorer Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL----------------------------------------ConnectionDlg Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL----------------------------------------Microsoft.SqlServer.RegSvrEnum Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll----------------------------------------Microsoft.SqlServer.CustomControls Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll----------------------------------------SqlWorkbench.Interfaces Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL----------------------------------------Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll----------------------------------------SqlMgmt Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL----------------------------------------SQLEditors Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL----------------------------------------Microsoft.VisualStudio.TextManager.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.0.4054 CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll----------------------------------------System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------Microsoft.SqlServer.ConnectionInfo Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll----------------------------------------EnvDTE Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll----------------------------------------Microsoft.SqlServer.SqlEnum Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll----------------------------------------Microsoft.ReportViewer.WinForms Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.42 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll----------------------------------------Microsoft.NetEnterpriseServers.ExceptionMessageBox Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll----------------------------------------System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll---------------------------------------- ************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled. For example: <configuration> <system.windows.forms jitDebugging="true" /></configuration> When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.
Ive installed SQL server 2005 developer edition onto my pc but when I use management studio, the only server I get is SQLEXPRESS. I did install the express version just to check it out, whats happend to the developer edition ? Is this named SQLEXPRESS as well ? and has overwritten the express version ? Has anyone else experienced this ?
I am in the early stages of migrating an extensive Access 2003 application to C#/SQL Server. The client already has SQL Server 2005, whereas I am using SQL Server 2000 Developer Edition. It has worked fine for me, but I'd like to upgrade to SQL Server 2005 Developer Edition and have a couple of questions.
In Access 2000 I am always using Query Analyzer and Enterprise Manager. Are these features available in 2005 Develper Edition?
Can more than one user connect to SQL Server at a time? That is, for testing concurrency, etc, can two people connect at the same time?
Is these any restriction on connecting to SQL Srever from another computer or workstation? Again for testing, one or two other workstations would be fine.
Finally, what is the street price? I've seen this advertised for $ 47 where I would have expected far more than that.
(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
Hi, I'm not sure if this is where I should post this, but I'm trying to find out what the limitations of SQL Server 2005 Developer Edition (DE) are. I've gone through the Microsoft SQL Server site and they have very little information about the developer edition.Is there a connection limit for DE like 2000 did?
Will SQL Server 2005 developer edition and Visual Web Developer Express work on the same machine? One reviewer of SQL Server 2005 developer edition on amazon.com stated won't work on the same machine? Is this true?
Hi Everyone, Recently I installed Visual Studio 2005 which also installed SQL Express Edition with it. I then installed SQL Server 2005 Developer Edition and am now able to see two instances SQLEXPRESS and MSSQLERVER. I do not want to use the Express version anymore, Do I have to have the Express version running or can I have just the Developer Edition ? Please help, can't find any help on the SQL website! Thanks
i am trying to find it, the only thing the MS site shows is enterprise licensing. is the developer edition still going to be like $100 or whatever it was?
Hi I currently have this edition of SQL server on my laptop:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
It is running on SQL Server Management Studio 2005.
I wish to upgrdade to Developer Edition (as my laptop won't support Enterprise as it's running on Windows XP).
I have some questions, which I would be grateful if somebody could help answering:
1- will all my database remain as they are? 2- Will I loose any functionality? 3- Will it upgrade or intstall a separate edition? 4- Can anybody recommend where to purchase Developer 2005 edition? 5- I currently have 2gb capped database limit on my version, will I get a no capped limit? 6- Will the 2gb Capped limit increase to uncapped once I install (i.e. can i use my previous 2gb database and add more data to above 2 gb)
The main issues are that I need an uncapped limit for my DB's and that I will keep my existing db's.
I'm installing SQL 2005 Developer Edition, instalation always fails with the error "Could not find a package to install on the installation media". The summary.txt is pasted bellow:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Mon Nov 05 10:47:30 2007
IA-PJPATRICIO : Could not find a package to install on the installation media.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I have an instance of SQL 2000 installed on the same machine, i'm trying to install Analises Services 2005 only, but instalation fails with any of the SQL Server 2005 components.
I tring to install SQL Server 2005 Developer Edition on Windows XP Pro but i not able to to so because of the following errors:-
Action "OpenPipeAction" failed during execution Action "CreatePipeAction" failed during execution. MsiOpenDatabase failed with 87 MsiOpenDatabase failed with 87 for MSI
Action "InstallDTSAction.9" failed during execution. Error information reported during run: Action: "InstallDTSAction.9" will be marked as failed due to the following condition: Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context: Prereq package will be failed due to the previous installation attempt returning: 1605
I downloaded SQL Server 2005 Developer Edition (x86) via MSDNAA (the package conatins 2 cd images the download program CRC checked them and all. I'm trying to install it on Windows XP prof. sp2).
When I mount the first CD, the installation menu comes up, if from the Install menu I select
"Server components, tools, Books Online, and samples"
an error message pops up saying:
"The application or DLL D:Setupsetupex.dll is not a valid Windows image. Please check this against your installation diskette."
When I press OK, it pops up again, then after clicking on OK one more time the Microsoft SQL Server 2005 Setup window comes up. After accepting the installation conditions and clicking next, it takes me to the "Installing Prerequisites" phrase, where when I press the Install button, it writes:
"Errors occured during the installation:
Error 193 installing .NET Framework 2.0"
Then the installation freezes, and I must press cancel (after that, the installation breaks saying: SQL Server Setup unexpectedly failed...)
If in the installation menu I choose
"
Install SQL Server Upgrade Advisor"
or
"
Run the SQL Native Client Installation Wizard"
a warning pops up saying:
"This installation package could not be opened.
Contact the application vendor to verify that this is a
valid Windows Installer package."
When I press OK, the warning disappeares, nothing happens.
I have .NET Framework 2.0, running VS2005 Prof. with no problem, had MS SQL Server 2005 Express Edition, but uninstalled it (never used), and just installed the latest MSI.
Searched the net for the "error 193" message, but haven't found anything that actually could help my case.
Has anyone tried an in-place upgrade from SQL Server 2005 Developer to Standard Edition?
It apears to be a valid upgrade path according to this: http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Is it just a case of changing the registered licensing info? (I presume all the functionality for Standard exists in the Developer Edition) Or is it a reinstall job?
I want to use a dev license for development on the server, then once its finished, just leave it in place on the box and upgrade the licensing to standard edition. (The client doesn't yet have a Standard License, but does have a Dev License - and wants me to start right away!)
If its going to boil down to having to do a full re-installation then I should get a Standard license from the start, if its just a minor license key change, then I can use a Dev license straight away!
I'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine.
I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch
I'm doing a named instance using the built-in system account with windows authentication mode.
Is there any COMPLETE guide as to how to work through all these installation problems?
I've gotten same results after about six attempts.
These always install:
SQL Setup Support Files SQL Native Client SQL VSS Writer SQL Server Backward Compatibility Files SQLXML4 SQL Server Books Online
