Steps To Install 64 Bit Sql Server 2005 Standard Edition In Windows Vista 64 Ultimate
Hi
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
Thanks
Doug
View Complete Forum Thread with Replies
Related Forum Messages:
Steps To Install SQL Server Express (&& Reporting Serivces) On 64 Bit Windows Vista Ultimate
Steps to install SSX (& Reporting Serivces) on 64 bit Windows Vista Ultimate I struggled quite a bit over the past few days to complete this install. The sequence of steps is less obvious than those for Windows XP Pro on a 32 bit machine. I recorded all the steps in one place in cookbook style for non-technical (but database capable) users like myself. I have referenced appropriate other postings and sources for detail steps. These are steps I found useful, you may be in a different situation. My environment is as follows: -New HP dv9000 w/ 2GHz and 2GB memory -Factory installed Windows Vista Ultimate. Note this includes .NET Framework 2.0 so I did not have to deal with installing that. -I have no extant databases or SQL Server that I am trying to convert or upgrade! Setup Steps Before Install: 1) Turn off User Account Control. At present, I am a one-user operation with close control over my system and there seemed to be issues with getting reporting services set up right with UAC. I may come back and modify this step later on and certainly would change this for any releasable systems. 1a)Go to Control Panel Home --> User Accounts --> Turn User Account Control on or off. 1b)Unselect Use User Acount Control. 2)Set up your IIS 7.0 for Reporting Services. IIS 7.0 has IIS 6.0 Compatibility features turned off out of the box. You will turn them on with this step. This is needed for both Reporting services and to enable the Adminscripts that are used in Step 3 below. 2a) Use the Control Panel --> Programs --> Turn Windows features on and off function. This is quite nicely desribed with screen shots at: http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957 These steps worked for me although they are labeled Vista Beta 2. 3)Set up your 64 bit machine to run 32 bit ASP.NET This capability is needed to make sure you pass the System Configuration Check for Reporting Services. I don't know the full implications of this step and wonder if it might eventually bite me if I have to flip-flop between 32 and 64 bit ASP.NET or have them both run at the same time. 3a) Open a command line window by: Start --> Accessories -- Cmd Prompt 3b) In this window type: cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 At some point, you may wish to go back to 64 bit. For that, see the posting by MihaelaE as an Answer in the SQL Server Reporting Services Forum under a thread started by fagster on 3/8/2007. Now to actually install SQL Server. 1) Download the 64 bit SSX. This step fooled me for a while as the 64-bit downloads are 'below the fold' on the web page. 1a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/ 1b) Scroll down the page and below Step 5, Register, you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Express Edition, click here." 1c) Follow the "click here" to get the download. 2) Install the package from step 1c and you will get SQL Server Express. 2a) The install may fail and complain about not finding a valid SQL Server Native Client Install, sqlncli_x64.msi. You will have to extract the files manually and then run the sqlncli_64.msi package by itself. Then you can go back to step 2 and should be successful. To do this, see post of Mike Wachal on 4/5/2007 to SQL Server Express Forum, titled "Cannot Install SQL Server Express on Vista Ultimate -- cannot find MS SQL Server Native Client". 3) Now add in the SQL Server Management Studio Express 64 bit version. 3a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/ 3b) Scroll down the page and below Step 5, Register you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Management Studio Express, click here." 3c) Follow the "click here" to get the download. 4) Now add the SQL Server Reporting Services. 4a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/ 4b) Scroll to Step 3 Download and Install (in the middle of the page) and download SQL Server Express Edition with Advanced Services SP2. 4c) Install, but at the Feature Selection screen, disable all components EXCEPT Reporting Services. You already have the other components installed. 4d) In the install, you will get a screen called "Report Server Installation Options". Go ahead and select the "Install but do not configure the server" radio button. 5) Go ahead and configure SQL Server Reporting Services. I'm not highly skilled in this area so I recommend the SQL Server Express Video "Learning Video 10: Getting Started with Reporting Services". This is found at: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx I found this video to be cogent and useful. That's what it took me to get SQL Server Express installed with reporting services on a 64 bit Vista Ultimate system. Sorry if this is so long but I wanted to cover all the steps that hung me up. To forum moderators: If I have any errors that will lead people astray, I'm more than happy to correct them. This posting is "AS IS" with no warrantees and caveat emptor.
View Replies !
Cant Install SQL Standard Edition On VISTA Ultimate
I ve been coping with the follwing Error for 2 months , and i desperately need sb helping me out with a practical solution. the error has become a real pain in the neck 4 me .I want to install SQL 2005 standard edition on a vista ultimate however the error appears at almost the end of installation proceess .and the sql server database services fails to be installed on vista????? and doesnt get a check mark. this is the Error: sQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'computer-nameSQLServer2005MSSQLUser$computer-name$MSSQLSERVER' not found. Check the name again..
View Replies !
Can You Install SQL Server 2005 On Vista Ultimate Edition?
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released? When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though? All of the features are green ticked except the OS which has a compatabilty warning (which i expected). I feel im missing something really simple here.... Cheers Rob Macnair
View Replies !
Cannot Install Sqlserver 2005 Developer Edition With Vista Ultimate
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition. I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel. I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005. 1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over? I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working... 2) What should I be doing to install SQLServer 2005 Developer Edition successfully? I have been a strong supporter of Microsoft, but this is getting me very frustrated. Please help, - Chaz
View Replies !
Vista X64 Ultimate + SQL 2005 Enterprise Edition (fresh Install)
Hi Everyone, I was playing around with SQL2k5 Express, but decided to download Enterprise using my MSDN subscription. I installed it, but none of the services are running. I don't understand why? I've checked the requirments and I notice that Vista x64 is not on the list for compatible OS's. I do get this when trying to install: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Also, during the install, Componoents to Install: All the services are greyed out... is that because they can't be installed or because they're going to be installed by default? Anyone else have it running on Vista Ultimate x64? Am I doing something wrong or does it just not install on this version of Vista? Cheers, Mike Avelar
View Replies !
Problem To Install SQL 2005 Express In Windows 2003 Server Standard Edition X64
I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems. It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64. I Check all request systems requirements many times and looks ok. How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express. Regards Leandro
View Replies !
Installing SQL Server 2005 On Windows VISTA ULTIMATE
Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help.
View Replies !
Sql Server Dev 2005 Install Problem On Vista Ultimate
I am getting the error message below when installing sql server 2005 dev edition on windows vista ultimate. I just bought a new hp notebook and installed visual studio 2005 pro and office 2007. Works very well. Then I'm trying to install sql server 2005 dev edition and get the error below. Please help SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'SAVIOURSQLServer2005MSSQLUser$SAVIOUR$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
View Replies !
Unable To Install SQL Server Express 2005 Sp2 On Vista Ultimate
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 6000) Time : Thu Jul 26 21:21:43 2007 Machine : CHARLIE Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Thu Jul 26 21:23:43 2007 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SNAC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SCC.log c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
View Replies !
SQL SERVER 2005 ENTERPRISE EDITION Installing Problem On Vista Ultimate RTM
when i was installing ss2005 i got two warnings: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility I-IS Feature Requirement (Warning) Messages IIS Feature Requirement then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Wed Dec 06 13:01:54 2006 TJM-PC : The current system does not meet the minimum hardware requirements for this SQL Server release. For system requirements, see Hardware and Software Requirements, in the readme file or in SQL Server Books Online. TJM-PC : 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. Machine : TJM-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_PPESku_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_OWC11_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BOL_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : TJM-PC Product : Microsoft SQL Server 2005 Tools Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_Tools.log -------------------------------------------------------------------------------- could any one tell my how could i intall the sql server database services and other services? thanks
View Replies !
SQL Server Management Studio Don't See Local SQL Server 2005 Developer Edition X64 On Vista Ultimate X64
SQL Server Management Studio don't see local SQL Server 2005 Developer Edition x64 on Vista Ultimate x64 Hi, I have strange problem with SQL Server Management Studio on Vista Ultimate x64. Nothing change after installing all newest service packs or hot fixes. I have two running SQL servers on my local machine and all surrounding SQL services running as well. I have turn on TCP/IP and Named pipes on both of this servers. Actually I have reinstalled second server after first one wasn't contactable in any way... After finished installation of second one and after applying service packs I turn on SQL Server Management Studio and still nothing in local servers pane when Browsing for servers to connect but in network servers after few seconds I see one of my local servers (first one installed) and one SQL Server 2000 on other machine (on this one I can't connect because of time out error). Also when browsing for servers in Local Servers I see my machine in Integration Services. Only difference between this running services is that Integration service log on as Network Service and all other SQL services log on as Local System account and on SQL Server that is invisible I have also SQL Server Reporting Services running. Services looks like this: Name Status Startup type Log On AsSQL Server (KONGORA) Started Automatic Local System SQL Server(MSSQLSERVER) Started Automatic Local System SQL Server Active Directory Hel Automatic Network Service SQL Server Agent (KONGORA) Started Automatic Local System SQL Server Agent (MSSQLSERVER) Started Automatic Local System SQL Server Analysis Services (KONG Started Automatic Local System SQL Server Analysis Services (MSSQL Started Automatic Local System SQL Server Browser Started Automatic Local System SQL Server Full Text Search (KONG Started Automatic Local System SQL Server Full Text Search (MSSQL Started Automatic Local System SQL Server Integration Services Started Automatic Network Service SQL Server Reporting Services (MSSQL Started Automatic Local System SQL Server VSS Writer Started Automatic Local System Thanks Stjepan
View Replies !
SQL 2005 Express SP2 Don't Allow Remote Connetions On Windows Vista Ultimate
Hi, I have the following scenario in my lab: 1. Windows Vista Ultimate with an fresh SQL 2005 Express SP2; 2. Developer machine with Windows XP and SQL Manag. Studio. Problem: Windows Vista isn't allowing a SQL connection from XP >> Vista. I've tried: 1. Configured surface area (the same configurations works on XP); 2. Configured all services and windows firewall base on online docs from MS. After 6 hours arround i didn't find any solution. Any ideas?
View Replies !
Error Installing SQL 2005 Client Tools On Windows Vista Ultimate
Hi, I am getting the following error: 0:Watson 1:1304 2treamSupportFiles 3treamBinaryToDisk 4:5 5:tyukonsqlsetupdarwinsqlcastubstreamca.cpp 6:238 7qlcastub.dll 8qlrun.msi While installing "SqlRunTools.msi" on a Microsoft SQL Server 2005 Developer's Edition Disc 2 on Windows Vista Ultimate. I am trying to install the Sql Server 2005 Client Tools, Enterprise Manager, Query Analyzer, on Windows Vista Ultimate. Any ideas as to what is causing this error and how to fix it? Thanks, Mark
View Replies !
Problem With Debugging SSIS 2005 (32bit) Component Under Windows Vista Ultimate
Hi, I have a problem when i want to debug an ssis component under visual studio 2005. I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista. When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm. however when i begin debugging,it's always skip breakpoint However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function. When execute the the package it works fine. I use this debug parametres : Start external program : C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe Command line arguments /FILE "D:ProjectsIntegration Services Project1Integration Services Project1TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI I execute visual studio 2005 as Administrator Please, can some one help me!
View Replies !
Installing Sql Server 2005 Standard On Windows Vista Beta 2 Build 5384
When sql server setup is installing de instance of the db, shows this error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x15 Thanks for your help, Ing. David Azouth
View Replies !
SQL Server 2005 SP2 Windows Updates Install On Vista X64
I'm currently running Windows Vista x64 and SQL server 2005 on an HP laptop with a AMD Turion 64 processor. I've install all of the Windows Vista x64 update so far with no issues. However, I'm unable to install SQL server 2005 SP2 via Windows updates. I was able to successfully download the service pack with no issues and it is currenly on my machine ready to install. The system does take a check prior to the install process beginning to perform the install. I continuely get and "Error Code A91" when the install process is running. As a result the install does not complete successfully. When I used the "Get Help" option I get a list of possible error conditions but none of them seem be useful. I checked each one and none of them provide any help with a solution. I've successful installed SP2 on Vista x32 system with no problem. Is this a "Windows Update" issue? Thanks
View Replies !
Sql Server 2005 Standard Edition Install Problem
I am planning to work with replication topic and i have a problem with it. I have installed a SQL server 2005 standard edition.When i try creating a new publication it comes out with this error "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of sql server. for information about installing replication,see installing replication in sql server books online Additional information: Execute permission denied on object 'sp_MS_replication_installed",database'master',owner'dbo'. (Microsoft SQL server ,Error:229) I have tried inserting the CD and reinstalling it.but didnt work. When i tried to Remove sql server from control panel add/remove programs it shows me the following components to be deleted.but then even after restarting my machine i find everything in start->all programs. what do i need to do?? Please help me.
View Replies !
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 !
Slow SQL 2005 X64 Standard Edition Performance On Windows Server 2003 X64
I am having major performance issues with Microsoft SQL 2005 x64 Standard Editions performance on Windows Server 2003 x64. The PC has two quad core cpu's with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb. I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance. I have also found that the bottle neck in the SSIS package is the backup and restore process of an 11gb database which takes about 1 hour (backup takes 1 hour and restore takes 1 hour) when it should take about 11 minutes. Is there anything I can do to make these processes run faster or to find out why they are taking so long? Any ideas would be a great help. Thanks, 100011
View Replies !
SQL Server 2005 Standard Edition Install Fails; An Instance With The Same Name.../
Good Morning I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled. I have selected the default instance and everything I try results in the error: An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. Log file says; -------------------------------------------------------------------------------- Machine : ISAINTERNET Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ISAINTERNET_SQL.log Last Action : DetectInstanceClash Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. Error Number : 28086 -------------------------------------------------------------------------------- Ian Smith
View Replies !
Unable To Install SQL Server 2005 Express Edition On Vista
Hi, Past one week I have been struggling to install SQL server express edition on my laptop which is preinstalled with Vista Basic. After it commences installation, it says the .net 2.0 on the system in corrupted. Please let me know how to proceed ASAP... i have a project due for submission this week! Thanks
View Replies !
Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client
I am trying to install SQL Server Express - (the non ADV version) and get the following error. "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'". I have 64 bit Vista Ultimate running on an HP dv9000. I am using the download from the bottom of the download page for SSX where it says 64 bit version. Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem. I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days. I would appreciate being pointed at the right downloads for what seems to be a simple install.
View Replies !
Slow SQL 2005 64bit Standard Edition Performance On Windows Server 2003
Greetings, We are having major performance issues with Microsoft SQL 2005 64bit Standard Editions performance on Windows Server 2003. We have an SSIS package running very slowly (and other sql tasks) on our two quad core cpu system with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb. Does anybody have any suggestion we could try to increase the performance of the server? I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance. Thank you.
View Replies !
Error Installing SQL Server 2005 (32Bit) On A Laptop With Windows 2003 Standard Edition
I am attempting to install SQL Server 2005 on a Laptop with Windows 2003 Standard Edition. The installation fails and the File Summary.txt has the following entries: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Time : Fri Nov 30 09:36:53 2007 Machine : SAPDEMO Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log -------------------------------------------------------------------------------- Machine : SAPDEMO Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Fri Nov 30 09:38:41 2007 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_MSXML6_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0 LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SNAC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SCC.log The Log File, SQLSetup0004_<hostname>_Core.log, has the following entries: Microsoft SQL Server 2005 Setup beginning at Mon Dec 03 08:54:09 2007 Process ID : 2980 C:SAP_CDCD2x86EnterpriseEditionServerssetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/11/3 8:54:9 Complete: LoadResourcesAction at: 2007/11/3 8:54:9, returned true Running: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9 Loaded DLL:C:SAP_CDCD2x86EnterpriseEditionServersxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9, returned true Running: ValidateWinNTAction at: 2007/11/3 8:54:9 Complete: ValidateWinNTAction at: 2007/11/3 8:54:9, returned true Running: ValidateMinOSAction at: 2007/11/3 8:54:9 Complete: ValidateMinOSAction at: 2007/11/3 8:54:9, returned true Running: PerformSCCAction at: 2007/11/3 8:54:9 Complete: PerformSCCAction at: 2007/11/3 8:54:9, returned true Running: ActivateLoggingAction at: 2007/11/3 8:54:9 Complete: ActivateLoggingAction at: 2007/11/3 8:54:9, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2980" returned false. Running: PerformSCCAction2 at: 2007/11/3 8:54:9 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042 Complete: PerformSCCAction2 at: 2007/11/3 8:54:9, returned true Running: PerformDotNetCheck at: 2007/11/3 8:54:9 Complete: PerformDotNetCheck at: 2007/11/3 8:54:9, returned true Running: ComponentUpdateAction at: 2007/11/3 8:54:9 Complete: ComponentUpdateAction at: 2007/11/3 8:55:6, returned true Running: DetectLocalBootstrapAction at: 2007/11/3 8:55:6 Complete: DetectLocalBootstrapAction at: 2007/11/3 8:55:6, returned true Running: LaunchLocalBootstrapAction at: 2007/11/3 8:55:6 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1605 Aborting queue processing as nested installer has completed Message pump returning: 1605 Regards
View Replies !
SQL Server 2005 Standard Edition VS Windows Server 2008
Dear All, I would like to ask you all a few questions. Please kindly inform me the related links if this topic is already brought before. Is SQL Server 2005 Standard Edition compatible with Windows Server 2008? Can it run well there? If not, what do I need in order to install it on my server? Thank you so much for your kind attention and look forward to hearing from you all soon. Warm regards, Newbie_Newbie
View Replies !
Sql Server 2005 On Vista Ultimate
Hey All, I have a notbook with vista ultimate and i am trying to install sql server 2005 (developers edition ) on it. The setup fails during the installation giving the message thaht the database service didnot start succesfully. I ahve tried a number of solutions for the issue but all in vain. The user i am using to install the server is an admin user.Plus i am very sure taht there are no h/w dependencies taht are causing the problem. Can some one please help me . I have been banging my head withteh issue for the past 4-5 days and some some will be reallyy appreciated ========================A section of the SQL.Log file============================== <EndFunc Name='Do_sqlServiceSDDL' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlServiceSDDL : Thu Aug 23 16:25:37 2007 MSI (s) (8C:14) [16:25:37:484]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:37:486]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof) MSI (s) (8C:70) [16:25:37:491]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7517.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:37 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007 MSI (s) (8C:14) [16:25:39:605]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:39:607]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl) MSI (s) (8C:2C) [16:25:39:612]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7D61.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl <EndFunc Name='InstallMOF' Return='0' GetLastError='14007'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007 MSI (s) (8C:14) [16:25:40:091]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'> MSI (s) (8C:14) [16:25:40:093]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof) MSI (s) (8C:CC) [16:25:40:098]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7F46.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007 MSI (s) (8C:14) [16:25:42:371]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:42:373]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\. ootMicrosoftSqlServerServerEventsMSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof) MSI (s) (8C:14) [16:25:42:374]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) MSI (s) (8C:14) [16:25:42:375]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof) MSI (s) (8C:2C) [16:25:42:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSI882D.tmp, Entrypoint: Do_sqlMofcomp <Func Name='LaunchFunction'> Function=Do_sqlMofcomp <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007 <Func Name='InstallMOF'> MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof <EndFunc Name='InstallMOF' Return='0' GetLastError='14007'> PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:173]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'> MSI (s) (8C:14) [16:25:47:230]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA)) MSI (s) (8C:A4) [16:25:47:236]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B21.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerServerEvents ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA) <Func Name='SecureWMINamespace'> <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:286]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:288]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerServerEventsMSSQLSERVER(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;[SQLServer2005SQLAgentUser$ADNAN-PC$MSSQLSERVER])) MSI (s) (8C:4C) [16:25:47:292]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B61.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerServerEventsMSSQLSERVER ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;S-1-5-21-3043782012-3745310101-388358720-1076) <Func Name='SecureWMINamespace'> <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:348]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:349]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\. ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)) MSI (s) (8C:40) [16:25:47:354]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BA0.tmp, Entrypoint: Do_WMISecurity <Func Name='LaunchFunction'> Function=Do_WMISecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_WMISecurity PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007 <Func Name='Do_WMISecurity'> Configuring ACL for WMI namespace \. ootMicrosoftSqlServerComputerManagement ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD) <Func Name='SecureWMINamespace'> No need to protect the namespace security <EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'> <EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'> PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007 MSI (s) (8C:14) [16:25:47:387]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:47:389]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn) MSI (s) (8C:54) [16:25:47:394]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BD0.tmp, Entrypoint: AddCertificate FTECa.DLL: INFO: FTE: AddCertificate(), Entering... FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn MSI (s) (8C:14) [16:25:47:452]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,) FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll MSI (s) (8C:14) [16:25:47:453]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn MSI (s) (8C:14) [16:25:47:458]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9C0F.tmp, Entrypoint: InstallPerfCounters FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering... FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn: FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained: FTECa.DLL: INFO: InstallPerfCounters: Instance home path: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn FTECa.DLL: INFO: Setting acls on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll FTECa.DLL: INFO: successfully allowed access to PerfLoggingUsers and PerfMonitoringUser on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnfdcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnftecntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnidxcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini have been installed. FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini have been installed. FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini have been installed. MSI (s) (8C:14) [16:25:51:273]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,) FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting... MSI (s) (8C:14) [16:25:51:274]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM) MSI (s) (8C:78) [16:25:51:279]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAAFE.tmp, Entrypoint: SetLaunchPermissions MSI (s) (8C:14) [16:25:51:327]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1]) MSI (s) (8C:14) [16:25:51:329]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000) MSI (s) (8C:14) [16:25:51:329]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:330]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00) MSI (s) (8C:14) [16:25:51:332]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:333]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00) MSI (s) (8C:C4) [16:25:51:338]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB2E.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:370]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:371]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00) MSI (s) (8C:14) [16:25:51:373]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:375]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00) MSI (s) (8C:28) [16:25:51:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB5E.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:426]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:427]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00) MSI (s) (8C:14) [16:25:51:429]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:430]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00) MSI (s) (8C:04) [16:25:51:435]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB9D.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:477]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:478]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00) MSI (s) (8C:14) [16:25:51:480]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,) MSI (s) (8C:14) [16:25:51:502]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00) MSI (s) (8C:C0) [16:25:51:508]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABDD.tmp, Entrypoint: Do_sqlFileRename <Func Name='LaunchFunction'> Function=Do_sqlFileRename <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlFileRename PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 <Func Name='Do_sqlFileRename'> <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'> PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007 MSI (s) (8C:14) [16:25:51:526]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1]) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (8C:14) [16:25:51:527]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server30329600lpc:ADNAN-PC) MSI (s) (8C:14) [16:25:51:528]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1]) MSI (s) (8C:14) [16:25:51:532]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (8C:C8) [16:25:51:537]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABFD.tmp, Entrypoint: Do_sqlScript <Func Name='LaunchFunction'> Function=Do_sqlScript <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Aug 23 16:25:51 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:25:51 2007 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 301 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Error Code: 1067 MSI (s) (8C!B0) [16:28:16:318]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Aug 23 16:28:16 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:28:16 2007 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 301 ---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER Error Code: 1067 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5520 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 4116 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 2800 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5220 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 532 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5320 could not be cancelled. Error: 1168 MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5836 could not be cancelled. Error: 1168 MSI (s) (8C!B0) [16:28:22:408]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. .
View Replies !
SQL Server 2005 On Vista Ultimate
Hello Everyone, A've installed Visual Studio 2005, SQL Server 2005 and all the SP's necessary. My Problem is I do not have the possability to install a SQL Server Instance of any kind, therefore it is not possible to start any of the SQL Server 2005 Configuration Tools. I Get the Warnings during the Installation process: Edition Change Check SQl Server Edition Operating System Campatibility Any help at all is very much appreciated, thanks a lot.
View Replies !
Sql Server 2005 Installation On Vista Ultimate
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation : SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility * Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)? Any work around for this issue? P.S.: I didn't install VS.NET 2005 yet, can this solve the problem? I am running on Vista Ultimate and Installing Sql Server 2k5 enterprise edition Thanks.
View Replies !
Problem While Installing SQL Server 2005 Express Edition On Windows 2000 PRO SP4...Can't Install!!!
Hi everyone... I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4. After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation. I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else??? Thank you all, HERE IS THE LOG FILE: "Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007 Process ID : 2684 c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/2/14 7:45:33 Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33 Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, 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: 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" 02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: Class not registered. Failed to create CAB file 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 "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2"
View Replies !
How To Install Sql 2005 Server Express On Windows Server 2003 X64 Edition
hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition. because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net , when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....." any idea?
View Replies !
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 !
Failure Installing Sql Server 2005 Express On Vista Ultimate X64, Error 29506
Whenever I try to install SQL Server 2005 Express Edition on my Vista Ultimate x64 platform I get error 29506. All I could find on the web was that this is probably due to an access control problem. I have tried installing it as the local administrator, as a member of domain admins, and as the domain administrator. All get the same error. My domain is a Small Business Server domain. This may be part of the problem, but I can't imagine how. When trying to force access to the domain administrator, I also seem to get an access problem. Any suggestions?
View Replies !
Unable To Install Client Tools (SQL 2005) On Windows Vista
have removed bsn contact manager and all sql related files from previous installation attempts, rebooted so should be a clean install - but still it fails what did I miss or what am I doing wrong? here are the logs with ref to the two items that fail ~~~ Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Professional (Build 6000) Time : Tue Mar 20 18:30:20 2007 Product : OWC11 Error : Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. -------------------------------------------------------------------------------- Product : Microsoft Office 2003 Web Components Product Version : 11.0.8003.0 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0012_PATRICES-XPS_OWC11_1.log Last Action : InstallExecute Error String : Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM. Error Number : 1706 thanks for any help/light/suggestions you can share
View Replies !
Install SQL Server In Windows Vista
Dear All, Hope everyone is doing well. I want to ask a question, I am using Windows Vista Home Premium Edition in my notebook, I installed Visual Studio 2005 in it, it is working properly. Now I want to install SQL Server 2005 Enterprise Edition in it, in the begining it was giving me errors while installing Sql Server 2005 Enterprise Edition, but then it installed properly, but the problem is I cant see the "SQL Server Management Studio" in installed SQL Server, I think it is not installed properly. Can anyone help me regarding this? Thanks & Regards Rafiq
View Replies !
SQL 2005 And Vista Ultimate
I am tring to install SQL standard edition on a laptop with vista ultermate, I have ISS 7 instaled and active (test by http:\localhost) but when SQL install does is system check it reports that ISS is not install or not enabled, hence the rest of the installation fails also get a error 1706 Can someone help please
View Replies !
SQL 2005 Dev && Vista Ultimate
Hi all, I'm trying to install just the client components of SQL 2005 on my clean Vista Ultimate machine and am not having a great deal of luck. From what I can see in this forum I'm not the only one. I apologise if this post is going over old ground but none of the other threads quite deal with my query so here goes. I'm installing from a SQL 2005 Dev DVD. Compatibility checks are being passed fine but once the actual installation starts I get an OWC 11 failure followed by workstation components etc failure. None of the workstation tools are installed. I have tried installing OWC 11 but because I am using Office 2007 it won't let me do it. I can't understand why OWC should cause a failure of the workstation tools installation. The intention is to use the Vista box as a development client with VS 2005 to work on a Windows 2003 server hosting SQL 2005 Enterprise. I would really apreciate a steer on this one as I am close to abandoning Vista and going back to XP Pro which would be a real shame. Many thanks Nick Bowling
View Replies !
Installing MSDE On Windows 2003 Server (Standard Edition)
I've tried every which way I can from the docs and but I can't seem to get MSDE to install correctly. Found out that Win2003 only runs SP3a, downloaded and tried it. tried these different commands from the prompt: setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only) setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first) setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a) Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager either. What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up... Thanks... PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
View Replies !
Sql 2005 Express Installation (Vista Ultimate)
While installing SQL Server 2005 Express Edition SP2 or SQL Server 2005 Express Edition with Advanced Services SP2 on Vista Ultimate, I get the error "The feature(s) selected are not valid for this edition of SQL server". Then the installation stops and exist. The only feature selected is Database Services, data files and shared tools. HELP!
View Replies !
Developer Limitation Under SQL 2005 Under Vista Ultimate 64 Bit
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration: TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'ZAPHOD42MSSMLBIZ'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ =================================================================================== The following is the Help obtained when clicking on the button on the error msg and the references in the error msg: =================================================================================== Details ID: Attach database Server Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. -------------------------------------------------------------------------------- Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx. ================== Details ID: 1827 Source: MSSQLServer We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information. ==========End of reproduction of error messages and help text ==================================== The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
View Replies !
Windows 2003 Server SP2 To Be Applied On SQL Server 2000 Standard Edition SP3
We got SQL Server 2000 Standard Edition SP3 running on Windows 2003 Standard Edition server. Now, we would like to apply windows 2003 SP2 to the Operating System. We are concerned that whether windows 2003 SP2 is compatible with SQL server 2000 (SP3)? I was looking at the application compatibility chart for Windows 2003 SP2.Among them Microsoft SQL Server Standard (2000) was listed but with no Service pack details. And also does Standard means standard edition there? My Question - Is windows 2003 server SP2 compatible with SQL Server 2000 (SP3) Standard Edition? And what if I plan to apply SP4 to Sql Server ? Please help. Thanks
View Replies !
Installing SQL Server 2005 Enterprise Trial Edition And Standard Edition On Same Machine
Hi -I have istalled sql server 2005 standard edition , I want to install sql server 2005 enterprise edition on the same machine. Is it possible? I have Microsoft windows server 2003 SP2 and 1GB RAM. I want to use partition function with the enterprise edition, will the trial version of sql server work for me? -If I have already created a database and tables using the standard edition, will I be able to access and use the database using the installed trial version or will I have to start a fresh creating a new database? - Is it possible to access the same database with any of the installed versions? BTW, I am prety new to sql server and databases , I am trying to learn by myself Thanks
View Replies !
Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...
Hallo there, I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available. My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs. I enabled all the protocols and all the ports I disabled windows firewall and antivirus (eset nod32) I installed all service packs available I have also installed Visual Studio 2005 without installing sqlexpress But nothing happens! Please i am very desperate, any information will be gratefully accepted. This is my installation Information Code Snippet Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000 Microsoft .NET Framework 2.0.50727.1434 Operating System 6.0.6001 Thank you in advance, Patonios
View Replies !
|
TRACKER
