Set the Audit level to "All" in SQL Server 2000 and "Both Failed and Successful logins" in SQL Server 2005. After restarting the services, you can see both failed and...

Since this error message is not affecting SQL Agent, I assume that some job which was executing during the server restart is causing these messages to be logged.

You may find this script[/url] on SSC useful.

Even I faced this issue and blogged about it here[/url]. It was again because of SAN/Storage issue.

Is the path correct? I see two \\ everywhere

SSMS would open because the "Client Components" were installed. You cannot find the SQL Server instance (local) because the Database Engine is not installed.

Are you sure that you are...

Are you sure that you are trying to install SQL Server 2005 Express. Was this downloaded from here?

Like you said these are warning messages. If you do not want to install SSRS you may ignore those warning and proceed with the installation.

@sangeetha,

You may find these posts useful.

http://blogs.msdn.com/b/craigfr/archive/2009/06/24/maximum-row-size-and-query-hints.aspx

http://www.sqlservercentral.com/Forums/Topic498820-149-1.aspx

Looks like the previous installation of SQL Server has some left over files. Please uninstall the previous one. Refer this for more information.

Going by the logs, I don't see the setup failing anywhere. It seems to have installed whatever was selected.

Glad to know that it worked !

@Vamsy,

If your account is part of the Local Administrators group on Windows, it will have access to Instant File Initialization by default.

Read this article on how to configure Instant File...

Hi Patti,

I hope you have used the script in "Method 2". Execute that script on the SQL Server 2000 instance and run the output in SQL Server 2008 instance. It...

What was the error message? The Error Log can be found at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG