Microsoft SQL Server 2005 CTP Setup - Could not open a connection to SQL Server [2]

Hi,
Here is the error that I get during install. Does anyone have an idea how to solve this?
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

TITLE: Microsoft SQL Server 2005 CTP Setup
-

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. 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%20SQL%20Server&ProdVer=9.00.1116&EvtSrc=setup.rll&EvtID=29545&EvtType=lib%5Codbc_connection.cpp@.Do_sqlScript@.OdbcConnection::connect@.x80070002

-
BUTTONS:

&Retry
Cancel
-

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
In the log file I can see the folowing information at the bottom:

Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 16 08:15:46 2005
Service MSSQLSERVER with parameters '-m -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 16 08:15:46 2005
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Thu Jun 16 08:16:10 2005
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Client unable to establish connection
sqlstate=HYT00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Login timeout expired
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Mar 18 08:21:13 2005
Function Name: OdbcConnection::connect
Source Line Number: 140

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070002 (2)
lScript
SqlScriptHlpr

Error Code: 2
MSI (s) (DC!54) [08:16:43:920]: Product: Microsoft SQL Server 2005 CTP -- Error 29545. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. 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 29545. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. 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.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 16 08:16:43 2005
Service MSSQLSERVER with parameters '-m -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 16 08:16:43 2005
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Thu Jun 16 08:16:43 2005
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
sqlstate=08001, level=-1, state=-1, native_error=2, msg=[Microsoft][SQL Native Client]Client unable to establish connection
sqlstate=HYT00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Login timeout expired
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Mar 18 08:21:13 2005
Function Name: OdbcConnection::connect
Source Line Number: 140

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070002 (2)
Do_sqlScript
SqlScriptHlpr

Error Code: 2

Probably better to ask this in the Setup/Upgrade group...

However, do you have SQL 2000 installed? If so are named pipes enabled in cli config? If not enable them and re-run setup.

-Euan|||Hey Edwin.

I just had this very same problem.

The way that I got around it was to run the SQL server install, and when it came up with this error I went into my services MMC snapin and restarted the SQL Server (MSSQLSERVER) service.

Then I pressed retry in the install window and it worked.

See if that helps

Cheers
Beric Holt
e-Media Ltd
Dunedin
New Zealand|||Hi Beric

work around suggested by you worked for me as well.thanks.|||

I had the similar issues, and this has been resolved by running command Setup\sqlncli.msi REINSTALL=ALL REINSTALLMODE=omus /qb.
More informations is available on link :http://download.microsoft.com/download/E/1/1/E1196B19-DE92-4AB2-BAFD-5B5AD26E67B4/AprilCTPNotes.mht
Thanks!

Merging two reports into one excel workbook.

Hallo all,
Its vey urgent for me ,please help me to solve the problem.
I am having two reports in a report project. when exporting to excel , I
have to export these two reports into a single excel workbook. Each report
should be exported to different sheets in same workbook. How is it possible?
Please help me.
I am really badly in need of help
thanks in advance to all
miikaOk, it can be done. Place a Subreport control in the main report (Report1)
and refer the other report(Report2) and place a Rectangle on the subreport
and on the properties check "insert before rectangle" there by it gives
pagination, which is the main thing for creating multiple sheets. now export
the main report you get both the reports in a single workbook but 2 sheets.
Check out.
Amarnath, MCTS.
"aka" wrote:
> Hallo all,
> Its vey urgent for me ,please help me to solve the problem.
> I am having two reports in a report project. when exporting to excel , I
> have to export these two reports into a single excel workbook. Each report
> should be exported to different sheets in same workbook. How is it possible?
> Please help me.
> I am really badly in need of help
> thanks in advance to all
> miika|||Hi,
Thanks alot for your valuable suggestion.
It worked fine, but I am having parameters in the two reports.
So If I make any one of the two as main report,and the second one that is
declared as subreport cannot be run as the parameter is null.It is gtting
exported into same excel workbook in two dofferent sheets. The sub report is
displaying only header part as the parameter is null.
How can I deal with parameters?
Can you please reply be as soon as possible.
Its very urgent to fix this task.
thanks in advance
miika
"Amarnath" wrote:
> Ok, it can be done. Place a Subreport control in the main report (Report1)
> and refer the other report(Report2) and place a Rectangle on the subreport
> and on the properties check "insert before rectangle" there by it gives
> pagination, which is the main thing for creating multiple sheets. now export
> the main report you get both the reports in a single workbook but 2 sheets.
> Check out.
> Amarnath, MCTS.
> "aka" wrote:
> > Hallo all,
> > Its vey urgent for me ,please help me to solve the problem.
> > I am having two reports in a report project. when exporting to excel , I
> > have to export these two reports into a single excel workbook. Each report
> > should be exported to different sheets in same workbook. How is it possible?
> > Please help me.
> > I am really badly in need of help
> >
> > thanks in advance to all
> > miika|||And also When exported to excel,in excel sheet ,I am having the main report
page header in the subreport also.
How can I avoid the main report page header in the subreport sheet?
Can you please help me?
I also want to have the sheet1 and sheet2 names as report names.
not simply sheet1 and sheet2.
IS it possible?
Please help me as soon as possible.
waiting for your suggestions
miika
"aka" wrote:
> Hi,
> Thanks alot for your valuable suggestion.
> It worked fine, but I am having parameters in the two reports.
> So If I make any one of the two as main report,and the second one that is
> declared as subreport cannot be run as the parameter is null.It is gtting
> exported into same excel workbook in two dofferent sheets. The sub report is
> displaying only header part as the parameter is null.
> How can I deal with parameters?
> Can you please reply be as soon as possible.
> Its very urgent to fix this task.
> thanks in advance
> miika
>
> "Amarnath" wrote:
> > Ok, it can be done. Place a Subreport control in the main report (Report1)
> > and refer the other report(Report2) and place a Rectangle on the subreport
> > and on the properties check "insert before rectangle" there by it gives
> > pagination, which is the main thing for creating multiple sheets. now export
> > the main report you get both the reports in a single workbook but 2 sheets.
> > Check out.
> >
> > Amarnath, MCTS.
> >
> > "aka" wrote:
> >
> > > Hallo all,
> > > Its vey urgent for me ,please help me to solve the problem.
> > > I am having two reports in a report project. when exporting to excel , I
> > > have to export these two reports into a single excel workbook. Each report
> > > should be exported to different sheets in same workbook. How is it possible?
> > > Please help me.
> > > I am really badly in need of help
> > >
> > > thanks in advance to all
> > > miika|||Aka, sorry for the late reply. You need to have group header in subreport so
that you dont have to rely on the main header. Unfortunately you dont get the
sheet's name. it will be sheet1, sheet2 etc... If the parameters are similiar
then you can select the parameter from the subreport properties from the
expression. if not then you need to hard code it, there is no way.
Amarnath,MCTS
"aka" wrote:
> And also When exported to excel,in excel sheet ,I am having the main report
> page header in the subreport also.
> How can I avoid the main report page header in the subreport sheet?
> Can you please help me?
> I also want to have the sheet1 and sheet2 names as report names.
> not simply sheet1 and sheet2.
> IS it possible?
> Please help me as soon as possible.
> waiting for your suggestions
> miika
>
> "aka" wrote:
> > Hi,
> > Thanks alot for your valuable suggestion.
> > It worked fine, but I am having parameters in the two reports.
> > So If I make any one of the two as main report,and the second one that is
> > declared as subreport cannot be run as the parameter is null.It is gtting
> > exported into same excel workbook in two dofferent sheets. The sub report is
> > displaying only header part as the parameter is null.
> > How can I deal with parameters?
> > Can you please reply be as soon as possible.
> > Its very urgent to fix this task.
> > thanks in advance
> > miika
> >
> >
> > "Amarnath" wrote:
> >
> > > Ok, it can be done. Place a Subreport control in the main report (Report1)
> > > and refer the other report(Report2) and place a Rectangle on the subreport
> > > and on the properties check "insert before rectangle" there by it gives
> > > pagination, which is the main thing for creating multiple sheets. now export
> > > the main report you get both the reports in a single workbook but 2 sheets.
> > > Check out.
> > >
> > > Amarnath, MCTS.
> > >
> > > "aka" wrote:
> > >
> > > > Hallo all,
> > > > Its vey urgent for me ,please help me to solve the problem.
> > > > I am having two reports in a report project. when exporting to excel , I
> > > > have to export these two reports into a single excel workbook. Each report
> > > > should be exported to different sheets in same workbook. How is it possible?
> > > > Please help me.
> > > > I am really badly in need of help
> > > >
> > > > thanks in advance to all
> > > > miika