Help needed on installing Sql Server 2000 on Win2k3.

Hi All Gurus
I am trying to install SQL2K on Win2003 Ent.Ed.
I could successfully configure MSDTC as a resource , then i tried to install
Sql Server 2k (Ent Ed), After i provided all the information like ip name,
n/name all off a sudden , istallation failed saying cannot continue .
I checked, both the nodes , terminal services is not running.
Please help I am simulating this clustering as a proof of concept.and Once
this is done i need to do the same on production, in 15 days.
Please Please help
I looked at all the resouces but could not
Here are some helpful resources
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Note that Remote Desktop Connection is not Terminal services for the
purposes of this article.
PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
Nodes
http://support.microsoft.com/default...b;en-us;811054
This is probably the most common problem I see
PRB: 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
Finally, make sure you are launching the installer from a Domain-level
account that is a local administrator on all nodes. Log in to each of the
nodes using the launch account, the cluster account, and the SQL service
account before starting the installation.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> Hi All Gurus
> I am trying to install SQL2K on Win2003 Ent.Ed.
> I could successfully configure MSDTC as a resource , then i tried to
install
> Sql Server 2k (Ent Ed), After i provided all the information like ip name,
> n/name all off a sudden , istallation failed saying cannot continue .
> I checked, both the nodes , terminal services is not running.
> Please help I am simulating this clustering as a proof of concept.and Once
> this is done i need to do the same on production, in 15 days.
> Please Please help
> I looked at all the resouces but could not
>
|||Nikhil,
Is this the error you are getting? "An error occurred while creating
virtual server resources for clustering. Cluster specific registry entries
couldn't be written" If so, then make sure the remote registry service is
running on all nodes. I had this problem this morning and that work for me.
Kevin
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#3rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
> Here are some helpful resources
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
> Note that Remote Desktop Connection is not Terminal services for the
> purposes of this article.
> PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
> Nodes
> http://support.microsoft.com/default...b;en-us;811054
> This is probably the most common problem I see
> PRB: Installation of a named instance of SQL Server 2000 virtual server on
a[vbcol=seagreen]
> Windows 2003-based cluster fails
> http://support.microsoft.com/default...b;en-us;815431
> Finally, make sure you are launching the installer from a Domain-level
> account that is a local administrator on all nodes. Log in to each of the
> nodes using the launch account, the cluster account, and the SQL service
> account before starting the installation.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
> news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> install
name,[vbcol=seagreen]
Once
>
|||Thanks Geoff
I did exactly like the KB says.
Terminal Service Component is not installed on either nodes. But when i
check the services then Terminal Server says started but the buttons on the
top (start, pause and stop) are all grayed out.
Again i am not using named instance, it is default .
I cannot find any any sql logs either, nothing is in the data drive (shared
data on cluster)apart from program files\Mssql\Install\SetUp.iss.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%233rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
> Here are some helpful resources
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
> Note that Remote Desktop Connection is not Terminal services for the
> purposes of this article.
> PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
> Nodes
> http://support.microsoft.com/default...b;en-us;811054
> This is probably the most common problem I see
> PRB: Installation of a named instance of SQL Server 2000 virtual server on
a[vbcol=seagreen]
> Windows 2003-based cluster fails
> http://support.microsoft.com/default...b;en-us;815431
> Finally, make sure you are launching the installer from a Domain-level
> account that is a local administrator on all nodes. Log in to each of the
> nodes using the launch account, the cluster account, and the SQL service
> account before starting the installation.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
> news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> install
name,[vbcol=seagreen]
Once
>
|||Thanks Kevin
I have Remote Reg Services Started.
"Kevin Wheeler" <kevin.l.wheeler@.lmco.com> wrote in message
news:e%23zorvMyEHA.2260@.TK2MSFTNGP15.phx.gbl...
> Nikhil,
> Is this the error you are getting? "An error occurred while creating
> virtual server resources for clustering. Cluster specific registry entries
> couldn't be written" If so, then make sure the remote registry service is
> running on all nodes. I had this problem this morning and that work for
me.[vbcol=seagreen]
> Kevin
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:#3rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
Eight[vbcol=seagreen]
on[vbcol=seagreen]
> a
the
> name,
> Once
>
|||Install logs are in the Windows folder on each host node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:ObLwyaNyEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Thanks Geoff
> I did exactly like the KB says.
> Terminal Service Component is not installed on either nodes. But when i
> check the services then Terminal Server says started but the buttons on
the
> top (start, pause and stop) are all grayed out.
> Again i am not using named instance, it is default .
> I cannot find any any sql logs either, nothing is in the data drive
(shared[vbcol=seagreen]
> data on cluster)apart from program files\Mssql\Install\SetUp.iss.
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%233rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
Eight[vbcol=seagreen]
on[vbcol=seagreen]
> a
the
> name,
> Once
>
|||Thanks Geoff and Kevin
I got it working finally. I had to all the remote services automatic, some
were manual, but thanks a lot
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> Hi All Gurus
> I am trying to install SQL2K on Win2003 Ent.Ed.
> I could successfully configure MSDTC as a resource , then i tried to
install
> Sql Server 2k (Ent Ed), After i provided all the information like ip name,
> n/name all off a sudden , istallation failed saying cannot continue .
> I checked, both the nodes , terminal services is not running.
> Please help I am simulating this clustering as a proof of concept.and Once
> this is done i need to do the same on production, in 15 days.
> Please Please help
> I looked at all the resouces but could not
>

help needed on configure reporting service

report server: sql2005
remote database server: clustered server, sql2005
while configure on report server failed on the step:
create a grant scripts
with the error message:
System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts (Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
set to 1 on the database srever. Also no firewall on the database server.
Any one have some hint on this one, any help is welcome.
ThanksWhat user are you using to run the services?
daw
"green hand" wrote:
> report server: sql2005
> remote database server: clustered server, sql2005
> while configure on report server failed on the step:
> create a grant scripts
> with the error message:
> System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> unavailable. (Exception from HRESULT: 0x800706BA)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementScope.InitializeGuts (Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> set to 1 on the database srever. Also no firewall on the database server.
> Any one have some hint on this one, any help is welcome.
> Thanks|||the user to run the RPC and to configure the report ingservice has the System
admin for the systme and database.
"daw" wrote:
> What user are you using to run the services?
> daw
> "green hand" wrote:
> > report server: sql2005
> > remote database server: clustered server, sql2005
> >
> > while configure on report server failed on the step:
> > create a grant scripts
> >
> > with the error message:
> > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > unavailable. (Exception from HRESULT: 0x800706BA)
> > at
> > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > errorCode, IntPtr errorInfo)
> > at System.Management.ManagementScope.InitializeGuts (Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > set to 1 on the database srever. Also no firewall on the database server.
> >
> > Any one have some hint on this one, any help is welcome.
> >
> > Thanks|||I'm not familiar with the problem, but hopefully one of these links will help:
http://support.microsoft.com/kb/224370
http://msdn2.microsoft.com/en-us/library/ms365170.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/09/22/473012.aspx
daw
"green hand" wrote:
> the user to run the RPC and to configure the report ingservice has the System
> admin for the systme and database.
> "daw" wrote:
> > What user are you using to run the services?
> >
> > daw
> >
> > "green hand" wrote:
> >
> > > report server: sql2005
> > > remote database server: clustered server, sql2005
> > >
> > > while configure on report server failed on the step:
> > > create a grant scripts
> > >
> > > with the error message:
> > > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > > unavailable. (Exception from HRESULT: 0x800706BA)
> > > at
> > > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > > errorCode, IntPtr errorInfo)
> > > at System.Management.ManagementScope.InitializeGuts (Object o)
> > > at System.Management.ManagementScope.Initialize()
> > > at System.Management.ManagementObjectSearcher.Initialize()
> > > at System.Management.ManagementObjectSearcher.Get()
> > > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > > machine)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > > dbServer)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > > connectionString, String server, String database,
> > > ConfigurationCredentialsType credsType, String account, String password,
> > > Boolean upgrade, String dbVersion)
> > >
> > > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > > set to 1 on the database srever. Also no firewall on the database server.
> > >
> > > Any one have some hint on this one, any help is welcome.
> > >
> > > Thanks

Help me: About Sql server Internet merge Replication

i am working on merge replication over internet
i configure each and everything as Paul told in artical
i configure TCP\IP port at client network utility as 1433, also server at
server network utility as 1433
also FTP port at publisher properties is 21
but it is not working
it show error as "sql server not exist or access denied"
i configure client computer using client network utility,
server computer by server network utility
also proper publication and subcriber and ftp root
please solve my problem
need u'r kind help
thanking you
amy
I'm still pretty new at some of this replication stuff. But I went and
pinged the subscriber from the publisher and vice versa. Then I set up
Aliases through the configuration tool using TCP\IP and setting the alias
name equal to that of the Server (i.e. My local server: S-HUNLEY). I don't
know if this is helpful, but it sounds like to me that your servers just
can't see one another and an alias, using TCP/IP or even a linkedserver may
help.
Good Luck!!
Scott E. Hunley (MCAD)
Measure Twice, Cut Once!!!
"amy" wrote:

> i am working on merge replication over internet
> i configure each and everything as Paul told in artical
> i configure TCP\IP port at client network utility as 1433, also server at
> server network utility as 1433
> also FTP port at publisher properties is 21
> but it is not working
> it show error as "sql server not exist or access denied"
> i configure client computer using client network utility,
> server computer by server network utility
> also proper publication and subcriber and ftp root
> please solve my problem
> need u'r kind help
> --
> thanking you
> amy
|||thanks for reply
please tell me how to set up
Aliases through the configuration tool using TCP\IP
i done pinging from subsciber from publisher and also publisher to subsciber
thanking you
amy
"Scott Hunley" wrote:
[vbcol=seagreen]
> I'm still pretty new at some of this replication stuff. But I went and
> pinged the subscriber from the publisher and vice versa. Then I set up
> Aliases through the configuration tool using TCP\IP and setting the alias
> name equal to that of the Server (i.e. My local server: S-HUNLEY). I don't
> know if this is helpful, but it sounds like to me that your servers just
> can't see one another and an alias, using TCP/IP or even a linkedserver may
> help.
> Good Luck!!
> --
> Scott E. Hunley (MCAD)
> Measure Twice, Cut Once!!!
>
> "amy" wrote:
|||If you were able to ping the machines successfully from one another then
that's a good sign. Now, in the Configuration Tool:
1. Right-Click the Alias node on the tree.
2. Enter the Name of the server you are communicating with (make sure these
are exactly the same.
3. Enter a port number, by default SQL uses 1433
4. choose TCP/IP
5. Enter the IP address of the server your communication with.
That should give you a way of communicating to the server.
Try that and let me know.
Scott E. Hunley (MCAD)
Measure Twice, Cut Once...
"amy" wrote:
[vbcol=seagreen]
> thanks for reply
> please tell me how to set up
> Aliases through the configuration tool using TCP\IP
> i done pinging from subsciber from publisher and also publisher to subsciber
> --
> thanking you
> amy
>
> "Scott Hunley" wrote:
|||I got the same error all morning while working with my Replication problems.
I got past this error by going into the properties for the publication and
adding my IUSR_MACHINENAME account to the publication access list. It started
working like a champ. This is with SQL 2005, I'm not sure of how to do it
with SQL 2000.
Hope this helps.
"amy" wrote:

> i am working on merge replication over internet
> i configure each and everything as Paul told in artical
> i configure TCP\IP port at client network utility as 1433, also server at
> server network utility as 1433
> also FTP port at publisher properties is 21
> but it is not working
> it show error as "sql server not exist or access denied"
> i configure client computer using client network utility,
> server computer by server network utility
> also proper publication and subcriber and ftp root
> please solve my problem
> need u'r kind help
> --
> thanking you
> amy