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

ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

I've set up an AS400/DB2 as a linked server, all standard configs (V4R5) on a SQL server 2000 machine and can select all day long. When I go to update or insert it throws an error referencing my driver. I'm using the HIS/OLEDB2 driver. Any ideas? Someone mentioned turning on Journaling on the 400?

Anything at this point would helpRE:
Q1 I'm using the HIS/OLEDB2 driver and can select all day long. When I go to update or insert it throws an error referencing my driver. Any ideas? Anything at this point would help

A1 Perhaps DB2 Connect provides a better odbc driver? Per IBM, DB2 Connect: "Provides extensive application programming tools for developing client-server and web applications using industry standard APIs such as ODBC, ADO, OLE DB, JDBC, SQLJ, DB2 CLI and Embedded SQL."

See: http://www-3.ibm.com/software/data/db2/db2connect/|||I found an answer that worked from a colleague. Thanks.

Errors in the trace from Enterprise manager

Hi,
I was running a trace for few hours and noticed bunch of
exception events. I cannot find descriptions for most of
these exceptions. One was especially frequent, coming
from enterprise manager:
Error: 208, Severity: 16, State: 1.
What was that about?
By the way, in the BOL I read that for exception events,
severity, error, and state columns should be included in
the trace, for getting meaningful result. However, I
found that including these columns has no significance,
because text column contains everything that is contained
in these 3 columns anyway.
Thanks
OJ
OJ wrote:
> Hi,
> I was running a trace for few hours and noticed bunch of
> exception events. I cannot find descriptions for most of
> these exceptions. One was especially frequent, coming
> from enterprise manager:
> Error: 208, Severity: 16, State: 1.
> What was that about?
> By the way, in the BOL I read that for exception events,
> severity, error, and state columns should be included in
> the trace, for getting meaningful result. However, I
> found that including these columns has no significance,
> because text column contains everything that is contained
> in these 3 columns anyway.
> Thanks
> OJ
You can ignore most of them. They are "object not found" errors which
are often raised when a procedure accesses a temp table. The error is
important, but in order to figure out if it's relevant, you need to
examine the SQL statement running prior to the error.
David Gugick
Imceda Software
www.imceda.com

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Philyou might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:

> Has anybody ever had problems with strange characters appearing in the nam
es
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Phil
you might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:

> Has anybody ever had problems with strange characters appearing in the names
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Philyou might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:
> Has anybody ever had problems with strange characters appearing in the names
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including co
nstraints. However, the operation keeps failing. How do I find out the spe
cific reason for the failure? Enterprise Manager does not provide specifics
in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
Mark
If you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errorlog increase Message Field

Is there away to increase the number of characters the
line displays or writes out in the Message field within
SQL Server Enterprise Manager 2000. It would be very
helpful to resolve locking problems.
Thank You,
DanRight Click on the Message and choose properties option - it should display
the full text.
Else you can directly open the file from C:\Program Files\Microsoft SQL
Server\MSSQL\LOG.
Please replace the directory structure as per your installation.
HTH
Satish Balusa
Corillian Corp.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...

quote:

---

> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

---

|||Hi,
Best idea is to run the below command from Query Analyzer, This will display
the entire contents of current SQL error log.
xp_readerrorlog
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...

quote:

---

> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

---

Errorlog increase Message Field

Is there away to increase the number of characters the
line displays or writes out in the Message field within
SQL Server Enterprise Manager 2000. It would be very
helpful to resolve locking problems.
Thank You,
DanRight Click on the Message and choose properties option - it should display
the full text.
Else you can directly open the file from C:\Program Files\Microsoft SQL
Server\MSSQL\LOG.
Please replace the directory structure as per your installation.
--
HTH
Satish Balusa
Corillian Corp.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...
> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>|||Hi,
Best idea is to run the below command from Query Analyzer, This will display
the entire contents of current SQL error log.
xp_readerrorlog
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...
> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

Error-14010-remote server not defined as subscription server

Running SQL Server Personal Ed (Server A) on Tablet PC (publication and distribution setup here) trying to push data to SQL Server 2000 Enterprise Ed. (Server B). When I start sync I get two failures. First is 'remote server not defined as subscription server'. Second, subscription to publication xx not valid (error# -2147201019). The snapshot is succeeding fine. What do I need to setup on Server B? I have the same db on both servers.

Try with running sp_addsubscriber 'Server B' to see if it will be fixed.|||

I did run sp_add subscriber only to verify Server B already exists. A subscription shows up on server B; listed as never started.

I have not been able to succeed this task.

Server A db properties-replication tab-configure-subscribers tab-set agent connection to subscriber to impersonate-rerun PUSH suscription-response-login fail for anonymous logon.

How to setup both servers to accept anonymous logon?

|||

This issue has been resolved.

Security settings was the problem on both servers.

thx..bt