Showing posts with label nodes. Show all posts
Showing posts with label nodes. Show all posts

Monday, March 26, 2012

Install MSDE on 2003 server cluster

I've two server 2003 configurated as cluster. How to
install MSDE2000A on nodes ?
hi Carlo,
Carlo Dolenz wrote:
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?
AFAIK MSDE does not support cluster installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You can install MSDE as an instance (default or named) on each node of the
cluster but MSDE is not cluster aware so if you're thinking of a
mini-failover cluster, that's not gonna happen with MSDE.
joe.
"Carlo Dolenz" <anonymous@.discussions.microsoft.com> wrote in message
news:282d01c514ea$7f039090$a501280a@.phx.gbl...
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?

Friday, March 23, 2012

Install fails with a "..path specified...is invalid"

After running through all the pre-install questions, it begins by saying that
it is performing operations on the cluster nodes and then fails with the
message:
"The path specified in a command line argument is invalid:
\\<servername>\admin$\<servername>_MSSQLSERVER.iss "
Any thoughts?
Either the administrative shares have been disabled or you are running under
an account that does not have access to the administrative shares on all
nodes of the cluster.
Sincerely,
Anthony Thomas

"Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> After running through all the pre-install questions, it begins by saying
that
> it is performing operations on the cluster nodes and then fails with the
> message:
> "The path specified in a command line argument is invalid:
> \\<servername>\admin$\<servername>_MSSQLSERVER.iss "
> Any thoughts?
|||Actually I found the problem in a KB article. I had Terminal Services
installed on two of the nodes. SQL Clustering cannot be installed on a node
or nodes that have terminal services installed. Just thought I would post
that for anyone else how might run across the same problem.
"Anthony Thomas" wrote:

> Either the administrative shares have been disabled or you are running under
> an account that does not have access to the administrative shares on all
> nodes of the cluster.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
> news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> that
>
>

Install fails on x64 cluster nodes.

I can't seem to install SQL Server 2005 (x64 version) on an x64 Win2k3 two node cluster.

I get all the way through the configuration and setup fails because it cannot start a task on the remote node. The error message indicates to check the task scheduler log file, which I have and I cannot find any 'errors' in the file.

Google/MSDN/Technet turn up nothing on multiple searches. Has anyone else run into this problem?

My installation account is a local admin on both machines, so is the sql cluster account. For the life of me I cannot figure out what's different for an x64 install vs 32bit....

Fixed the problem...

My account was not authoritative for the "Domain Services" group.

|||

I have the same problem, can would appreciate it if anyone could elaborate on this "Domain Services" group. What do you mean by not "authoratative" for this group?

Thanks.

Install fails on x64 cluster nodes.

I can't seem to install SQL Server 2005 (x64 version) on an x64 Win2k3 two node cluster.

I get all the way through the configuration and setup fails because it cannot start a task on the remote node. The error message indicates to check the task scheduler log file, which I have and I cannot find any 'errors' in the file.

Google/MSDN/Technet turn up nothing on multiple searches. Has anyone else run into this problem?

My installation account is a local admin on both machines, so is the sql cluster account. For the life of me I cannot figure out what's different for an x64 install vs 32bit....

Fixed the problem...

My account was not authoritative for the "Domain Services" group.

|||

I have the same problem, can would appreciate it if anyone could elaborate on this "Domain Services" group. What do you mean by not "authoratative" for this group?

Thanks.

Monday, March 19, 2012

install cluster sql 2005

I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
cluster and analysis services cluster.
I must install sql 2005 and analysis services 2005 without upgrade 2000
instances.
can you help me ?
What do you need help with? Knowledge base articles, etc. etc.....
DatabaseAdmins.com,LLC
"Gigi73" wrote:

> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>
|||You will have to establish two new cluster groups, which will contain
dedicated IP addresses, network names, disks, and the SQL Server instance
for one, Analysis Services for the other.
You install SQL Server just like you normally would, but need to give it a
new unique Server Name and Instance Name.
Analysis Services on the other hand is truly clustered, whereas AS2000 only
used the general services resource.
Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005
Analysis Services cluster
http://support.microsoft.com/kb/910233
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
SQL Server 2005 Upgrade Technical Reference Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Sincerely,
Anthony Thomas

"Gigi73" <Gigi73@.discussions.microsoft.com> wrote in message
news:1E59C379-13BF-4C60-B6C4-BAFFA95E4251@.microsoft.com...
> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with
sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>