Can I Use Sql Server 2005 Developer Edition With Windows Xp Home Edition SP2 For MCTS Exam 70-431 Preparation?
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?
Thanks
gifty
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
64 Bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 Bit - New!
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit,Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new!Windows Liberty 64bit 8403Windows Limited Edition 64 Bit Edition 8764Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610If you have Googled your butt off, and haven't come up with anything...., and for 14,000 more reasons, please send e-mail,Join Bytes!, Join Bytes!, Join Bytes!,
View Replies !
View Related
SQL Server 2005 Developer Edition On Vista Home Premium??
I could not install SQL Server 2005 Developer edition on my notebook with os Vista Home Premium. I know about the SP2 thing...but before coming that point, I can not either install the SQL Server 2005... When installing,when the database services point comes it gives an error about user thing...and then installation starts to rollback... I check the IIS configuration from the net...And see that while activating IIS there is no option for Windows Auth. in Home Premium in Control Panel>Program...>Windows Programs.....etc.... SO ON VISTA HOME PREMIUM is SQL SERVER 2005 Dev. Edition can be installed or not?
View Replies !
View Related
Error - Installing SQL Server Developer Edition 2005 On Vista Home Premium
Hi, I have Vista Home premium edition and trying to install SQL Server developer edition 2005 as local administrator. I have already enabled IIS 7 and have Office Ultimate 2007 installed. When I run the set up program, I get a warning titled "Program Compatibility Assistant" that my Operating system may not be compatible with the version of sql server I am installing. It says after setup is complete, I should run SP2 of SQL Server 2005 with 3 buttons as "Check for solutions online", "run this program" and "cancel"... My question, should I select "run this program" and after the setup completes, download SP2 and apply the patch? I read some articles in forums that sounds like lot of issues to get sql server working on vista. Can some one direct me to correct options. This is my wife's machine so I dont want to experiment too much and blow her machine away. Please help. Thanks, Gaja
View Replies !
View Related
SQL Server 2005 Developer Edition On Windows XP With SP2
I have Visual Studio 2005 Professional on windows xp. I am getting error installing SQL Server 2005 Developer Edition on windows XP. My Hardware is P4 1.6 GHz with 256MB RAM (Though BOL says setups shouldnt fail because of this ). Is there ANY solution for installing SQL Server 2005 Developer Edition on Windows XP. The error at end I am getting is : ======================================================================================= TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The feature(s) specified are not valid for this edition of SQL Server. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rl l&EvtID=70031&EvtType=sqlchaining%5csqlchainingactions.cpp%40DeterminePackageTransformsAction%40sqls%3a%3aDete rminePackageTransformsAction%3a%3aperform%400x1118f ------------------------------ BUTTONS: OK ------------------------------ ======================================================================================= I can reinstall Visual Studio 2005, if this is the solution? . Please Help regards
View Replies !
View Related
Versions Of Windows Allowed For SQL Server 2005 Developer Edition
Hi, I am going to get a new laptop and was wondering in particular which versions of Windows Vista will run SQL Server 2005 Developer Edition. I want to be able to use all the features of SQL Server 2005, so IIS is needed for example ( I will be building end to end BI soutions using SQL Server Management Studio, SSIS, Analysis Services and Reporting Services. Chris
View Replies !
View Related
Change From Developer Edition To Enterprise Edition Of SQL Server 2005 64 Bit
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. Thank you, Matt
View Replies !
View Related
Windows XP Home Edition And SQL Server
I am new to servers and when I try to learn about them I get confused, because the information does not list a server in XP, but they keep it separate from Microsoft SQL Server, like XP has it's own server. Can someone help clarify for me what the versions of SQL servers are? SQL 2000 1.0, SQL 2002, SQL 2003........?
View Replies !
View Related
How Can I Run SQL Server 2005 Developer Edition On Standard Edition
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 appreciate any help Thanks
View Replies !
View Related
Sql Server Express Edition Installation (OS Windows Home XP)
Hi, I am trying to install SQL Express on Window Home XP and SCC is returning the following error: The SQL Server Configuration Checker cannot b execute due to WMI configuration on the machine ..... Error 2147942405 (0X80070005). I tried running the following batch file which I believe resolved the same issue that someone else raised earlier (though I am not sure whether the OS was Home XP) Will upgrading from XP Home to XP Professional (academic version) help me install SQL express successfully> The Batch file I ran looks like this: FIXWMI.CMD ------------------------ @echo on cd /d c: emp if not exist %windir%system32wbem goto TryInstall cd /d %windir%system32wbem net stop winmgmt winmgmt /kill if exist Rep_bak rd Rep_bak /s /q rename Repository Rep_bak for %%i in (*.dll) do RegSvr32 -s %%i for %%i in (*.exe) do call :FixSrv %%i for %%i in (*.mof,*.mfl) do Mofcomp %%i net start winmgmt goto End :FixSrv if /I (%1) == (wbemcntl.exe) goto SkipSrv if /I (%1) == (wbemtest.exe) goto SkipSrv if /I (%1) == (mofcomp.exe) goto SkipSrv %1 /RegServer :SkipSrv goto End :TryInstall if not exist wmicore.exe goto End wmicore /s net start winmgmt :End Any suggesstions will be geatly appreciated.
View Replies !
View Related
SQL Developer Edition - For Learning At Home?
I wish to start learning about SQL server 2005. Right now I am out of work and wish to build my database skills and get a certification on SQL server 2005. I used SQL 2000 at my last work at an entry level, so I have some experience. I want to get some books and if possible and SQL 2005 on my home computer to learn on. Would SQL server 2005 developer edition be the one I want for learning? I know some books come with a trial software but they only last 180 days, I don't want to feel pressured in trying to learn that quickely since I do have a 1 year old to take care of.I did notice that it was only $50 dollars, which is a plus since I need to watch the money. Does this editoin give me query analyzer and the SQL server enterprise manager? I do have some school background but that was back in 2003 in VB6, Oracle, Java, javascript, HTML.
View Replies !
View Related
Connect From 2005 Developer Edition To 2000 Developer Edition
Hi, all - 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 haven't needed to do this before. Suggestions?
View Replies !
View Related
Installing SQL Serer 2005 Developer Edition On Windows Vista
Dear friends... I am having this problem since I installed the new windows Vista. I am trying to install the SQL Server 2005 developer edition on Windows Vista, but After installation finish successfuly I open the start menu to surprise that I could not find the Shortcuts to open the SQL Server and create new database and tables etc... I opened the full path of the exe files "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE" but there are not any file there, even that I searched for the exe files names but they are not existed. It looks that after instalation complete that the SQL Server is not installed on Windows Vista. So, my question is: After installing the SQL Server 2005 SP2 for windows Vista, will the problem be solved? Or there is something else to do ON WINDOWS VISTA. Please, I need the answer for this problem, because I need to work on SQL Server 2005 very hard. Thanks in advance for your help...
View Replies !
View Related
Windows XP And SQL Server Developer Edition
Hi Team,Is anyone else out there struggling with SQL Server on XP? Specifically, isthere anyone struggling with starting the Agent Service using theNT_AUTHORITY "security" role? I am having no end of grief.I started with a perfectly clean XP install. I performed an absolutelyclean, default install, and the installation hung. It appeared to freezewith the Agent startup. killed the install after 30 minutes of "freeze"time, and re-booted. The SQL Server Service started up no problem, but theAgent would not.I attempted to repair the installation, which seemed to work fine, but theAgent was still not working. I had used the "Local System Account" settingsto start the Agent, then tried a few different settings, all to no avail.Finally, I tried to apply some of the suggestions in the various newsgroups.I finally did get the Agent working, but now there are other problems.God! What a PAIN IN THE ASS! I can't believe this. I have given my life toBill, and his SQL Team apparently can't get XP and SQL Server to worktogether easily. It's such a pain.Bob
View Replies !
View Related
Windows CE 5 Device With SQL Server 2005 Compact Edition Sync With SQL Server 2005 Express Edition
I have: A server computer running SQL Server 2005 Enterprise Edition. A industrial computer running SQL Server 2005 Express Edition. And now also a Psion WorkAboutPro with CE 5 that should run SQL Server Compact Edition. The industrial computer syncs its data with the server, basically saying "this has happened". Now I want the Psion to sync with the industrial computer, but this sync must two-way. I have tried to find a guide or something that can tell me "do this to sync" but the information i have found is sketchy at best. If someone could point me in the right direction of a guide or something else it would be much appreciated. Regards, Björn
View Replies !
View Related
Confused About Whether I Need .Net Framework 2.0 With Windows Vista Home Edition!
I wanted to install SQL Server 2005 Express Edition, instead of installing .Net Framework 2.0, I installed .Net Framework 3.5. When I tried to install SQL Server 2005 Express Edition I received the following error: SQL_ERROR (-1) in OdbcStatement::execute_batch sqlstate=42000, level=16, state=2, native_error=7404, msg=[Microsoft][SQL Native Client][SQL Server]The server could not load DCOM. Error Code: 0x80071cec (7404) Windows Error Text: Source File Name: libodbc_statement.h Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcStatement::execute_batch@sysdbupg.sql@56 Source Line Number: 91 I then decided maybe I do need .net framework 2.0, but when I try to install it it says it's already included with the OS. But the "Programs and Featuers" only list .Net Framework 1.1 and .Net Framework 1,1 Hotfix (KB92979). I uninstalled .Net Framework 3.5 and tried to install .Net Framework 2.0 again, but it still says it's included in the OS. After uninstalling .Net Framework 3.5, I tried to install SQL Server 2005 Express Edition, but still received the above error message. Is .Net Framework 2.0 included with Windows Vista Home Edition? If it is, any ideas in solving the Server 2005 Express Edition installation error? Thanks in advance for your help!
View Replies !
View Related
MCTS Exam For Business Intelligence SQL Server 2005
Hi All, I would like take MCTS exam in Business Intelligence(Dataware Housing).For this I want to know about the MCTS Certification Business Intelligence (SQL Server 2005 ). Any one can suggest how to prepare for this exam and what is the CODE for this Exam? And also is SQL Server 2008 has been released or not??? Please respond to this mail and thanks in advance. Thanks& Regards, Maruthi
View Replies !
View Related
SQL Server 2005 Developer Edition
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 ? tia Mark.
View Replies !
View Related
SQL Server 2005 Developer Edition. Any One Seen This
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.
View Replies !
View Related
SQL Server 2005 Developer Edition
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. Many thanks MIke Thomas
View Replies !
View Related
How To Downgrade Windows Server 2003 Enterprise Edition From X64 To X32 Edition
I recently bought a Dell server with Windows 2003 enterprise edition. I wanted the X32 version and metnioned of the same to the sales people, but somehow they put the x64 edition on the server. The database I am planning to use does not work on X64 edition as of now. How do I downgrade the OS to X32 version? Do I need to send the system back to Dell? Machine not opened yet. Or is there a way I can get software CD and downgrade to X32 version? Thanks, Prasad
View Replies !
View Related
Install SQL Server 2005 Express Edition - Advanced Services, XP Home SP2 Error 29521.
I am installing SQL Server 2005 Express Edition with Advanced Services on Windows XP Home Edition SP2 and received error 29521. I am installing with an account that has administrator rights. The summary.txt file contains: Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information. Error Number : 29521 Does anyone have suggestions as to the problem?
View Replies !
View Related
Installing SQL Server 2005 Developer Edition
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
View Replies !
View Related
SQL Server 2005 Developer Edition Limitations
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?
View Replies !
View Related
Problem With Sql Server 2005 Developer Edition
HI there C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0002.cab well i tried to install sql server 2005 developer edition in one of my cvlient computers so thats i can attach database;s to this server and do plan maintainance on the main server The prob is i have tried installing sql server 2005 default instance .And wen i tried doing that it was showing reporting services error message and also warning in required hardware . somehow its getting completed but on completing it was showing sql server isn't installed Strangely its is diaplayed in start menu and wen i try to connect it to the main database server its connnecting and wen i try to connect to the local server using windows or sa account it was stating error 26 "error locating instance/server prior to this we had sql server express edition whic i uninstalled before installing sql server developer edition Please suggest some changes thnx in advance
View Replies !
View Related
Upgrading To SQL Server 2005 Developer Edition?
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. Many thanks!!!!!
View Replies !
View Related
Problems Installing SQLServer 2000 Developer Edition On Windows XP Pro
Hello!When trying to install SqlServer 2000 Developer (as Administrator) on myWindows XP Professional I get the following message at the point wherethe system asks Local Account or Domain account:The logon account cannot be validated for the SQL server service. Verifythat the user name and password entered are correct. The logon attemptfailed.Anyone an idea what goes wrong here?Thanks for your info.Daniel*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
View Related
First Time Installation Of SQL Server 2005 Developer Edition
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.... Thanks for your help
View Replies !
View Related
Failed Install Of SQL Server 2005 Developer Edition On Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.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." This is the bottom of the SQLSetup0001_<machine name>_SQL.log Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006 <Func Name='InstallMOF'> Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. An error occured while processing item 1 defined on lines 16 - 18 Error occured in phase 3, Error number: 0x80041001 Compiler returned error 0x80041001 <EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'> Error Code: 0x80077349 (29513) Windows Error Text: Source File Name: sqlcasqlmofca.cpp Compiler Timestamp: Tue Aug 9 01:14:18 2005 Function Name: Do_sqlMofcomp Source Line Number: 608 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Error Code: 29513 MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.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. Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.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. <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006 <Func Name='InstallMOF'> Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. An error occured while processing item 1 defined on lines 16 - 18 Error occured in phase 3, Error number: 0x80041001 Compiler returned error 0x80041001 <EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'> Error Code: 0x80077349 (29513) Windows Error Text: Source File Name: sqlcasqlmofca.cpp Compiler Timestamp: Tue Aug 9 01:14:18 2005 Function Name: Do_sqlMofcomp Source Line Number: 608 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Error Code: 29513 I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at. ANY recommendations would be helpful!! Thank you, Jay A. Moritz
View Replies !
View Related
Problem In Installing Sql Server 2005 Developer Edition
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 Can Anyone help me out on this? Thanks VG
View Replies !
View Related
Unable To Apply SP2 To SQL Server 2005 Developer Edition
I can't install the client tools of SQL Server 2005 SP2. I'm doing it on a fresh re-install of SQL Server 2005 Developer Edition (without SP1). It's been a rollercoaster -- I tried it on SP1 and that didn't work, so I decided to uninstall altogether, then couldn't re-install; I had to install most pieces of SQL Server 2005 individually (executing each msi file separately), then I had to install most pieces of SP2 individually, too. I could get everything to work except for the SP2 client tools. I get this error in the event log: Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup followed by this one: Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log. Here is my summary.txt file: Time: 02/04/2008 23:06:40.328 KB Number: KB921896 Machine: KRISTER OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.2.3042 x86 Database Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER Analysis Services (MSSQLSERVER) ENU SP2 2005.090.3054.00 x86 DEVELOPER Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 DEVELOPER Notification Services ENU SP2 9.00.3054.00 x86 DEVELOPER Integration Services ENU SP2 9.00.3054.00 x86 DEVELOPER SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU RTM 9.00.1399.06 x86 DEVELOPER MSXML 6.0 Parser ENU 6.10.1129.0 x86 SQLXML4 ENU 9.00.3042.00 x86 Backward Compatibility ENU 8.05.2004 x86 Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86 ********************************************************************************** Products Disqualified & Reason Product Reason Database Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates. Analysis Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates. Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates. Notification Services The product instance NS been patched with more recent updates. Integration Services The product instance Integration Services been patched with more recent updates. ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID ********************************************************************************** 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): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance MSSQLSERVER been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance MSSQLSERVER been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance MSSQLSERVER been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance NS been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance Integration Services been patched with more recent updates. ---------------------------------------------------------------------------------- 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): 1399 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log Error Number : 1721 Error Description : MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. ---------------------------------------------------------------------------------- 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: 1721 Here is an error message from my hotfix.log file: 02/04/2008 17:37:49.921 MSP Error: 1721 There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. 02/04/2008 17:40:06.468 MSP returned 1603: A fatal error occurred during installation. 02/04/2008 17:40:06.625 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller" 02/04/2008 17:40:06.671 Registry: Cannot read registry key value "Debug" 02/04/2008 17:40:07.984 Copy Engine: Error, unable to install MSP file: C: empdownloadsMicrosoftSQLServer2005SP2-KB21896-x86-ENUHotFixToolsFilessqlrun_tools.msp 02/04/2008 17:40:08.031 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/04/2008 17:40:08.031 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800 02/04/2008 17:40:15.562 Watson: Param1 = Unknown 02/04/2008 17:40:15.625 Watson: Param2 = 0x6b9 02/04/2008 17:40:15.796 Watson: Param3 = Unknown 02/04/2008 17:40:16.000 Watson: Param4 = 0x6b9 02/04/2008 17:40:16.078 Watson: Param5 = copyengine.cpp@800 02/04/2008 17:40:16.140 Watson: Param6 = Unknown 02/04/2008 17:40:16.171 Watson: Param7 = SQLTools9 02/04/2008 17:40:16.250 Watson: Param8 = Hotfix@ 02/04/2008 17:40:16.343 Watson: Param9 = x86 02/04/2008 17:40:16.500 Watson: Param10 = 3042 02/04/2008 17:40:16.625 Installed product: SQLTools9 02/04/2008 17:40:16.750 Hotfix package completed 02/04/2008 17:40:16.781 Attempting to continue the 32 bit ngen queue There is a value 3 in my SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log, but I don't really see anything more descriptive in that file. These are the lines above the value 3 that look interesting: MSI (s) (1C:30) [17:37:49:000]: Note: 1: 1721 2: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7B.tmp 4: ms-help://MS.SQLCC.v9 MSI (s) (1C:30) [17:37:49:078]: Transforming table Error. MSI (s) (1C:30) [17:37:49:078]: Transforming table Error. MSI (s) (1C:30) [17:37:49:078]: Note: 1: 2262 2: Error 3: -2147287038 Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_SQLCC.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7B.tmp, command: ms-help://MS.SQLCC.v9 MSI (s) (1C:30) [17:37:49:093]: Note: 1: 1721 2: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8 3: C:WINDOWSInstallerMSI1C7C.tmp 4: ms-help://Hx MSI (s) (1C:30) [17:37:49:171]: Transforming table Error. MSI (s) (1C:30) [17:37:49:187]: Transforming table Error. MSI (s) (1C:30) [17:37:49:187]: Note: 1: 2262 2: Error 3: -2147287038 Info 1721.There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: CA_HxMerge_Hx.3643236F_FC70_11D3_A536_0090278A1BB8, location: C:WINDOWSInstallerMSI1C7C.tmp, command: ms-help://Hx MSI (s) (1C:08) [17:37:49:234]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1C7D.tmp, Entrypoint: Set_CommitFlag <Func Name='LaunchFunction'> Function=Set_CommitFlag <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='87'> Doing Action: Set_CommitFlag PerfTime Start: Set_CommitFlag : Mon Feb 04 17:37:49 2008 <Func Name='Set_CommitFlag'> Set_CommitFlag called successfully.Committed <EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'> PerfTime Stop: Set_CommitFlag : Mon Feb 04 17:37:49 2008 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (1C:30) [17:37:49:859]: Note: 1: 1721 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup MSI (s) (1C:30) [17:37:49:906]: Transforming table Error. MSI (s) (1C:30) [17:37:49:906]: Transforming table Error. MSI (s) (1C:30) [17:37:49:906]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C:30) [17:37:50:031]: Transforming table Error. MSI (s) (1C:30) [17:37:50:046]: Transforming table Error. MSI (s) (1C:30) [17:37:50:046]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C:30) [17:37:50:046]: Product: Microsoft SQL Server 2005 Tools -- Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup Error 1721. There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. Action: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup I see lots of other people with problems posted online, but no answer has helped me. So, any help would be greatly appreciated. Thanks!
View Replies !
View Related
SQL Server 2005 (Developer Edition) W/ SP2 Won't Install On Vista
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 These always fail: OCW11 SQL Server Database Services Analysis Services Reporting Services Notification Services Integration Services Workstation Components; Books Online
View Replies !
View Related
Error Installing SQL Server 2005 Developer Edition
I get the following error installing SQL Server 2005 Developer Edition Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance. I am installing on Windows XP with Admin privs. There is nothing listed in COM+ Services for SQL. The Distributed Transaction Coordinator service is running. There is a previous installation of SQL 2000 Developer Edition installed. I have seen some pretty old posts with the same error. I was wondering if there was a final resolution, service pack, etc. that solves this problem?
View Replies !
View Related
|