MS SQL Server Clustering - Cannot install second SQL virtual server on four node cluster...

Author

Cannot install second SQL virtual server on four node cluster...

Isaac Story

2005-10-28, 11:23 am

I am having some issues installing a second virtual server. The first VS
installed fine with no issues and has no issues operating. On the second VS
install, the install process makes it all the way through to the point where
it creates the cluster resources. But when it goes to bring the SQL Server
resource online it fails. It gives the following error in the log:

[sqsrvres] checkODBCConnectErro
r: sqlstate = 01000; native error = 35;
message = [Microsoft][ODBC SQL Server Driver]& #91;DBNETLIB]Connect
ionOpen
(Connect()).

I found a KB article that came close to this and it stated that if you are
having issues connecting to a SQL Cluster instance on Windows 2003 nodes it
is because SQL needs to be at SP3 for it to work. The only problem is I can't
get the intial install to work in order to apply the service pack. Any
ideas???

Isaac Story

Geoff N. Hiten

2005-10-28, 11:23 am

Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/defaul...kb;en-us;815431

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Isaac Story" < IsaacStory@discussio
ns.microsoft.com> wrote in message
news:00C5C9F2-B09B-4211-B713- 673844262E42@microso
ft.com...
>I am having some issues installing a second virtual server. The first VS
> installed fine with no issues and has no issues operating. On the second
> VS
> install, the install process makes it all the way through to the point
> where
> it creates the cluster resources. But when it goes to bring the SQL Server
> resource online it fails. It gives the following error in the log:
>
> [sqsrvres] checkODBCConnectErro
r: sqlstate = 01000; native error = 35;
> message = [Microsoft][ODBC SQL Server Driver]& #91;DBNETLIB]Connect
ionOpen
> (Connect()).
>
> I found a KB article that came close to this and it stated that if you are
> having issues connecting to a SQL Cluster instance on Windows 2003 nodes
> it
> is because SQL needs to be at SP3 for it to work. The only problem is I
> can't
> get the intial install to work in order to apply the service pack. Any
> ideas???
>
>
> Isaac Story
>
>

Sponsored Links