April CTP install is failing
Well, the SQL Server 2005 April CTP is failing on installing the database components.
In the Beta newsgroups, more people are popping up with the same issue, mostly Express Editions.
Some of the error:
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]SQL
Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
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.
The SQL Error log shows a clean startup and a clean shutdown at request from the installer.
The instance is running at the time of the failure and I have verified it is running in Services and process is there in Task Manager..
Looking at
*_SQL.log, it shows "Login timeout expired" as being the reason.
I will persist and get the issue......
UPDATE:
I seem to have nailed it.
When the dialogue pops up with the connection failure message, I ran "SQLServerManager.msc", the SQL Server Configuration Manager, and enabled for the SQL Native Client Configuration, under Client Protocols, Named Pipes and Shared Memory (TCP/IP is enabled by default).
Once I did this, I could press retry and the installation completed successfully.
sqlcmd and sqlcmd90 both retuned the same errors as the installation routine when they could no connect.
UPDATE 2:
"SQLServerManager.msc", the SQL Server Configuration Manager, is not installed by the time the failure occurs. What I did was to first install the client tools only, then re-run setup and install the Database Engine.
UPDATE 3:
Some people have hinted that this problem might be caused by SNAC importing the SQL Server 2000 client configuration settings. For me, TCP/IP and Named Pipes was enabled, and SNAC only chose to enable TCP/IP on the install. I don't think this is the cause.