Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts

Monday, March 19, 2012

Errors on install of SQL Svr 2005 Enterprise

Greetings,

I have attempted a full install of 2005 Ent on our W2k3 Enterprise

server. When attempting to install all services (SQL Svr database,

analysis, reporting, notification, integration, client

services/components) I get the message: "The features specified are

not valid for this edition of SQL Server". I got the same thing

when attempting to install with various subsets of services. Then I

tried just database services and client components and got the

message: " There was an unexpected failure during the setup

wizard. "

Perusing the core.log, I see:

Fatal Exception caught while installing package: "10"

Error Code: 0x80070002 (2)

Windows Error Text: The system cannot find the file specified.

Source File Name: sqlchaining\sqlprereqpackagemutator.cpp

Compiler Timestamp: Tue Aug 9 01:14:20 2005

Function Name: sqls::SqlPreReqPackageMutator::modifyRequest

Source Line Number: 196

Has anyone encountered this? One of our guys downloaded the install

files from Microsoft. We don't use CDs anymore. I think there are

files missing.

Thanks for any assistance with this.

Windows Server 2003 SP1 is the minimum OS required. Do you have SP1 installed?

Michelle

|||Windows Server 2003 R2 SP1 is installed.|||

Oop! I found the answer, I think:

http://support.microsoft.com/kb/916760

This problem occurs because the folders that contain the files that are required

during the installation of SQL Server 2005 do not have a correct

layout.

This problem is most likely to occur if you start the SQL Server

2005 installation from a folder on a network share or on a hard disk when the

folder was copied from the SQL Server 2005 installation CDs.

Thanks!

marge

|||

That was going to be my next guess we see that alot.

Michelle

Friday, February 24, 2012

Error:1418 during Mirroring

I am trying to do mirroring using SQL Server Ent. 2005 SP1 on two machines. I was able to create end points on both the machines at the port no.s 5091 and 5092 respectively. I have all the security setting settings for both the users. I am getting error no. 1418 while starting mirroring sessions.
Can anybody tell me how to troubleshoot this error?

Google Error 1418, there are helpful pointers

e.g. check your SQL is listening on TCP, and the correct port

maybe SQL Browser?

you pointed to the correct ports?

Our mirroring works off the box, because I just used the wizard and used the default ports

|||

There are some troubleshooting hints in the paper: http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

|||

Try editing the C:\WINDOWS\system32\drivers\etc\hosts file on each server to include

IP addressDNSname for each server.