Saturday, February 25, 2012

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

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] checkODBCConnectError: sqlstate = 01000; native error = 35;
message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(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
Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
news:00C5C9F2-B09B-4211-B713-673844262E42@.microsoft.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] checkODBCConnectError: sqlstate = 01000; native error = 35;
> message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (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
>

No comments:

Post a Comment