Board index MS SQL Server

Error code 183 when running the Cluster Wizard

Error code 183 when running the Cluster Wizard

Post by Juan Sanche » Thu, 25 Jul 2002 23:07:52



Hi :
Has anybody encountered any problems when running the cluster wizard. I keep
receiving Error code 183 (Cannot create a file when that file already
exists)
I followed the step by step cluster installation guide in technet. Then used
WindowsUpdate to apply every patch to Windows.
Then I installed SQL Server 7 in the first server (containting the Cluster
Group and the group I created to have the shared disk). Installed SQL 7 SP4
and rebooted.
After that I moved the Cluster group to the second node and installed SQL
there too, in an another shared disk (Im trring to make an active/active
configuration).
Applied SP4 and rebooted.
After that I moved back the cluster group containing MSDTC to the first node
and tried to run the wizard.
First I received the error that it could not upgrade some files and that I
should close System Manager and Control panel on both nodes, wich I did.
I clicked on retry and the process continued.
The it comes the last part of the process when it starts making changes to
the registryand making the SQL Cluster.
About half this it gives me the error code 183  (Cannot create a file when
that file already exists).

Can anybody help me ?

Juan Sanchez

 
 
 
Top

Error code 183 when running the Cluster Wizard

Post by Juan Sanche » Fri, 26 Jul 2002 04:52:23


One thing I did not do is create a MSDTC IP Address and Name as a cluster
resource, because I assumed COMCLUST does this.
Am I right ?

Juan Sanchez


Quote:> Hi :
> Has anybody encountered any problems when running the cluster wizard. I
keep
> receiving Error code 183 (Cannot create a file when that file already
> exists)
> I followed the step by step cluster installation guide in technet. Then
used
> WindowsUpdate to apply every patch to Windows.
> Then I installed SQL Server 7 in the first server (containting the Cluster
> Group and the group I created to have the shared disk). Installed SQL 7
SP4
> and rebooted.
> After that I moved the Cluster group to the second node and installed SQL
> there too, in an another shared disk (Im trring to make an active/active
> configuration).
> Applied SP4 and rebooted.
> After that I moved back the cluster group containing MSDTC to the first
node
> and tried to run the wizard.
> First I received the error that it could not upgrade some files and that I
> should close System Manager and Control panel on both nodes, wich I did.
> I clicked on retry and the process continued.
> The it comes the last part of the process when it starts making changes to
> the registryand making the SQL Cluster.
> About half this it gives me the error code 183  (Cannot create a file when
> that file already exists).

> Can anybody help me ?

> Juan Sanchez


 
 
 
Top

Error code 183 when running the Cluster Wizard

Post by Juan Sanche » Sat, 27 Jul 2002 02:53:29


Thanks a lot. That was it. I had the same names of the cluster groups and
the virtual server ...
Is that error documented ? because I could not find it anywhere .

Regards,
Juan Sanchez


Quote:

> What is the group name in cluster admin where you are trying to install
SQL
> to?. Can you check if virtual server name you are creating is called the
> same group name ? If this is the case, change the group name to something
> different (other than the virtual server name) and retry.

> Regards,
> Suresh.

> This posting is provided "AS IS" with no warranties, and confers no
rights.

> Are you secure?  For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

 
 
 
Top

1. SQL2K SP2 fails to install on either node of active/passive cluster (code 183)

Shaun,

Are you logged on with an account that has adminstrative privleges on both
nodes?

John Gose
MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS", with no warranties, and confers no rights

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------


| Subject: Re: SQL2K SP2 fails to install on either node of active/passive
cluster (code 183)
| Date: Thu, 6 Dec 2001 09:18:58 -0000
|
<Snip of Header Stuff>
|
| I have found this one on the second node - the times seem to tie up (did
| think it looked like an old file version with the 0 in the name, or is
this
| correct for another nodes log?)
|
| I don't see anything that looks like an error in this file, in fact it
would
| suggest that the whole thing installed OK?!
|
| Shaun
|
|
|


| > Shaun,
| >
| > You should also have a log file on node two.  Since this is where the
| > failure occurs, this is the log we need to see.
| >
| > John Gose
| > MCDBA
| > Microsoft SQL Server Support
| >
| > This posting is provided "AS IS", with no warranties, and confers no
| rights
| >
| > Are you secure? For information about the Microsoft Strategic Technology
| > Protection Program and to order your FREE Security Tool Kit, please
visit
| > http://www.microsoft.com/security.
| >
| >
| > --------------------

| > | Subject: SQL2K SP2 fails to install on either node of active/passive
| > cluster (code 183)
| > | Date: Wed, 5 Dec 2001 09:35:37 -0000
| > | Lines: 718
| > |
| > <Snip of Header Stuff>
| > |
| > | I am trying to install SQL2KSP2 onto a 2 node cluster
(active/passive).
| > |
| > | I've followed the readme, backed up, closed other apps and run setup.
| > After
| > | entering the virtual server name and then the user/pw info it gets as
| far
| > as
| > | performing remote operations and then gives an erro stating that it
| > "cannot
| > | create a file when one already exists" - setup then rolls back and
| exits.
| > |
| > | Looking through the sqlsp.log file I found the error (code 183) and a
| > | statement saying "Remote files could not be removed", but cannot see
| where
| > | to go from there in tracking down which file is the culprit.
| > |
| > | The log is attached, so please if anyone can help I would be most
| > grateful.
| > |
| > | Shaun
| > |
| > |
| > |
| > |
| > |
| > |
| >
|
|
|

2. How to determine OS and SP?

3. ALTER TABLE ... ADD COLUMN

4. SQL 7.0 Active - Active cluster setup error 183

5. Jro Populate Problem?

6. IO Error 183

7. ORA-20001 error in Recovery Manager

8. Exception EInOutError in module..........I/O Error 183

9. Dbase IV 2.0 error #183

10. sql cluster - failover cluster wizard error

11. Startup parameters missing after running cluster wizard on sql 7

12. Cannot Run the Cluster Wizard HELP!!!


All times are UTC
Board index