Hello:
On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
whenever you create a new database? Or, does the new database "contain" the
service pack already upon the database's creation?
Thanks!
childofthe1980sYou never need to reinstall.
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:4B00F4AF-662A-405F-900C-345B90966995@.microsoft.com...
> Hello:
> On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
> whenever you create a new database? Or, does the new database "contain"
> the
> service pack already upon the database's creation?
> Thanks!
> childofthe1980s|||For additional info: You will need to install SP of SQL Server for new
instances only, not for databases.
--
Ekrem Ã?nsoy
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:4B00F4AF-662A-405F-900C-345B90966995@.microsoft.com...
> Hello:
> On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
> whenever you create a new database? Or, does the new database "contain"
> the
> service pack already upon the database's creation?
> Thanks!
> childofthe1980s
Showing posts with label reinstall. Show all posts
Showing posts with label reinstall. Show all posts
Friday, March 23, 2012
Wednesday, March 21, 2012
Reinstalling MSDTC on Windows 2003
Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. Thanks
Hi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>
|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
|||Hi Martin
Did you see http://support.microsoft.com/default...b;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>
|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/default...b;en-us;294209
> John
> "Martin" wrote:
|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>
|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. Thanks
Hi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>
|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
|||Hi Martin
Did you see http://support.microsoft.com/default...b;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>
|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/default...b;en-us;294209
> John
> "Martin" wrote:
|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>
|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>
Reinstalling MSDTC on Windows 2003
Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generat
es
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be mu
ch
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>|||Hi Martin
Did you see http://support.microsoft.com/defaul...kb;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQ
L
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/defaul...kb;en-us;294209
> John
> "Martin" wrote:
>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generat
es
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be mu
ch
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>|||Hi Martin
Did you see http://support.microsoft.com/defaul...kb;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQ
L
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/defaul...kb;en-us;294209
> John
> "Martin" wrote:
>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>
Reinstalling MSDTC on Windows 2003
Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>> Hello,
>> Does anyone know how to reinstall MSDTC on Windows 2003?
>> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> problems
>> failing over to the other node. Failing over the MSDTC Group to the
>> other
>> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
>> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> generates
>> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> 'MSDTC
>> Group' failed").
>> I've been able to find an article explaining how to reinstall MSDTC on
>> Windows 2000, but not on Windows 2003. Any assistance on this would be
>> much
>> appreciated. Thanks
>>|||Hi Martin
Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> > Hi
> >
> > Searching Google for "RPC raised an exception with a return code
> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> > interest http://tinyurl.com/cnoqm
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Hello,
> >>
> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >>
> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> problems
> >> failing over to the other node. Failing over the MSDTC Group to the
> >> other
> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> generates
> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> 'MSDTC
> >> Group' failed").
> >>
> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> Windows 2000, but not on Windows 2003. Any assistance on this would be
> >> much
> >> appreciated. Thanks
> >>
> >>
> >>
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> Hi Martin
> Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> John
> "Martin" wrote:
>> Thanks for the reply
>> DNS seems fine as i can connect to and from the server across the
>> network.
>> No other errors are generated apart from the MSDTC and Cluster errors.
>> SQL
>> fails over successful, just not the MSDTC group
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> > Hi
>> >
>> > Searching Google for "RPC raised an exception with a return code
>> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
>> > of
>> > interest http://tinyurl.com/cnoqm
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Hello,
>> >>
>> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >>
>> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> problems
>> >> failing over to the other node. Failing over the MSDTC Group to the
>> >> other
>> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
>> >> an
>> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> generates
>> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> 'MSDTC
>> >> Group' failed").
>> >>
>> >> I've been able to find an article explaining how to reinstall MSDTC on
>> >> Windows 2000, but not on Windows 2003. Any assistance on this would
>> >> be
>> >> much
>> >> appreciated. Thanks
>> >>
>> >>
>> >>
>>
>>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> > Hi Martin
> >
> > Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Thanks for the reply
> >>
> >> DNS seems fine as i can connect to and from the server across the
> >> network.
> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> SQL
> >> fails over successful, just not the MSDTC group
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> > Hi
> >> >
> >> > Searching Google for "RPC raised an exception with a return code
> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
> >> > of
> >> > interest http://tinyurl.com/cnoqm
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >>
> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> problems
> >> >> failing over to the other node. Failing over the MSDTC Group to the
> >> >> other
> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
> >> >> an
> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> generates
> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> 'MSDTC
> >> >> Group' failed").
> >> >>
> >> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> >> Windows 2000, but not on Windows 2003. Any assistance on this would
> >> >> be
> >> >> much
> >> >> appreciated. Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >>
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>> Yes, but it seems relevant to Windows 2000.
>> There is a note on there at the bottom, which says if you're using
>> Windows
>> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
>> That
>> only goes through setting up MSDTC on 2003 initially.
>> I'm not sure if the method for rebuilding MSDTC in that article applies
>> to
>> Windows 2003 due to the note at the bottom, referring us to KB301600.
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>> > Hi Martin
>> >
>> > Did you see
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Thanks for the reply
>> >>
>> >> DNS seems fine as i can connect to and from the server across the
>> >> network.
>> >> No other errors are generated apart from the MSDTC and Cluster errors.
>> >> SQL
>> >> fails over successful, just not the MSDTC group
>> >>
>> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> >> > Hi
>> >> >
>> >> > Searching Google for "RPC raised an exception with a return code
>> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
>> >> > be
>> >> > of
>> >> > interest http://tinyurl.com/cnoqm
>> >> >
>> >> > John
>> >> >
>> >> > "Martin" wrote:
>> >> >
>> >> >> Hello,
>> >> >>
>> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >> >>
>> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> >> problems
>> >> >> failing over to the other node. Failing over the MSDTC Group to
>> >> >> the
>> >> >> other
>> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
>> >> >> raised
>> >> >> an
>> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> >> generates
>> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> >> 'MSDTC
>> >> >> Group' failed").
>> >> >>
>> >> >> I've been able to find an article explaining how to reinstall MSDTC
>> >> >> on
>> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
>> >> >> would
>> >> >> be
>> >> >> much
>> >> >> appreciated. Thanks
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>> >>
>>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> > Hi Martin
> >
> > From that it looks like you can add/remove it using the Add/Remove Windows
> > components in Control Panel?
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Yes, but it seems relevant to Windows 2000.
> >>
> >> There is a note on there at the bottom, which says if you're using
> >> Windows
> >> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
> >> That
> >> only goes through setting up MSDTC on 2003 initially.
> >>
> >> I'm not sure if the method for rebuilding MSDTC in that article applies
> >> to
> >> Windows 2003 due to the note at the bottom, referring us to KB301600.
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> >> > Hi Martin
> >> >
> >> > Did you see
> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Thanks for the reply
> >> >>
> >> >> DNS seems fine as i can connect to and from the server across the
> >> >> network.
> >> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> >> SQL
> >> >> fails over successful, just not the MSDTC group
> >> >>
> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> >> > Hi
> >> >> >
> >> >> > Searching Google for "RPC raised an exception with a return code
> >> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
> >> >> > be
> >> >> > of
> >> >> > interest http://tinyurl.com/cnoqm
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "Martin" wrote:
> >> >> >
> >> >> >> Hello,
> >> >> >>
> >> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >> >>
> >> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> >> problems
> >> >> >> failing over to the other node. Failing over the MSDTC Group to
> >> >> >> the
> >> >> >> other
> >> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
> >> >> >> raised
> >> >> >> an
> >> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> >> generates
> >> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> >> 'MSDTC
> >> >> >> Group' failed").
> >> >> >>
> >> >> >> I've been able to find an article explaining how to reinstall MSDTC
> >> >> >> on
> >> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
> >> >> >> would
> >> >> >> be
> >> >> >> much
> >> >> >> appreciated. Thanks
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>> Hello,
>> Does anyone know how to reinstall MSDTC on Windows 2003?
>> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> problems
>> failing over to the other node. Failing over the MSDTC Group to the
>> other
>> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
>> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> generates
>> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> 'MSDTC
>> Group' failed").
>> I've been able to find an article explaining how to reinstall MSDTC on
>> Windows 2000, but not on Windows 2003. Any assistance on this would be
>> much
>> appreciated. Thanks
>>|||Hi Martin
Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> > Hi
> >
> > Searching Google for "RPC raised an exception with a return code
> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> > interest http://tinyurl.com/cnoqm
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Hello,
> >>
> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >>
> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> problems
> >> failing over to the other node. Failing over the MSDTC Group to the
> >> other
> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> generates
> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> 'MSDTC
> >> Group' failed").
> >>
> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> Windows 2000, but not on Windows 2003. Any assistance on this would be
> >> much
> >> appreciated. Thanks
> >>
> >>
> >>
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> Hi Martin
> Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> John
> "Martin" wrote:
>> Thanks for the reply
>> DNS seems fine as i can connect to and from the server across the
>> network.
>> No other errors are generated apart from the MSDTC and Cluster errors.
>> SQL
>> fails over successful, just not the MSDTC group
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> > Hi
>> >
>> > Searching Google for "RPC raised an exception with a return code
>> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
>> > of
>> > interest http://tinyurl.com/cnoqm
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Hello,
>> >>
>> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >>
>> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> problems
>> >> failing over to the other node. Failing over the MSDTC Group to the
>> >> other
>> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
>> >> an
>> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> generates
>> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> 'MSDTC
>> >> Group' failed").
>> >>
>> >> I've been able to find an article explaining how to reinstall MSDTC on
>> >> Windows 2000, but not on Windows 2003. Any assistance on this would
>> >> be
>> >> much
>> >> appreciated. Thanks
>> >>
>> >>
>> >>
>>
>>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> > Hi Martin
> >
> > Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Thanks for the reply
> >>
> >> DNS seems fine as i can connect to and from the server across the
> >> network.
> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> SQL
> >> fails over successful, just not the MSDTC group
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> > Hi
> >> >
> >> > Searching Google for "RPC raised an exception with a return code
> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
> >> > of
> >> > interest http://tinyurl.com/cnoqm
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >>
> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> problems
> >> >> failing over to the other node. Failing over the MSDTC Group to the
> >> >> other
> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
> >> >> an
> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> generates
> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> 'MSDTC
> >> >> Group' failed").
> >> >>
> >> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> >> Windows 2000, but not on Windows 2003. Any assistance on this would
> >> >> be
> >> >> much
> >> >> appreciated. Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >>
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>> Yes, but it seems relevant to Windows 2000.
>> There is a note on there at the bottom, which says if you're using
>> Windows
>> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
>> That
>> only goes through setting up MSDTC on 2003 initially.
>> I'm not sure if the method for rebuilding MSDTC in that article applies
>> to
>> Windows 2003 due to the note at the bottom, referring us to KB301600.
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>> > Hi Martin
>> >
>> > Did you see
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Thanks for the reply
>> >>
>> >> DNS seems fine as i can connect to and from the server across the
>> >> network.
>> >> No other errors are generated apart from the MSDTC and Cluster errors.
>> >> SQL
>> >> fails over successful, just not the MSDTC group
>> >>
>> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> >> > Hi
>> >> >
>> >> > Searching Google for "RPC raised an exception with a return code
>> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
>> >> > be
>> >> > of
>> >> > interest http://tinyurl.com/cnoqm
>> >> >
>> >> > John
>> >> >
>> >> > "Martin" wrote:
>> >> >
>> >> >> Hello,
>> >> >>
>> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >> >>
>> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> >> problems
>> >> >> failing over to the other node. Failing over the MSDTC Group to
>> >> >> the
>> >> >> other
>> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
>> >> >> raised
>> >> >> an
>> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> >> generates
>> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> >> 'MSDTC
>> >> >> Group' failed").
>> >> >>
>> >> >> I've been able to find an article explaining how to reinstall MSDTC
>> >> >> on
>> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
>> >> >> would
>> >> >> be
>> >> >> much
>> >> >> appreciated. Thanks
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>> >>
>>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> > Hi Martin
> >
> > From that it looks like you can add/remove it using the Add/Remove Windows
> > components in Control Panel?
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Yes, but it seems relevant to Windows 2000.
> >>
> >> There is a note on there at the bottom, which says if you're using
> >> Windows
> >> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
> >> That
> >> only goes through setting up MSDTC on 2003 initially.
> >>
> >> I'm not sure if the method for rebuilding MSDTC in that article applies
> >> to
> >> Windows 2003 due to the note at the bottom, referring us to KB301600.
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> >> > Hi Martin
> >> >
> >> > Did you see
> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Thanks for the reply
> >> >>
> >> >> DNS seems fine as i can connect to and from the server across the
> >> >> network.
> >> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> >> SQL
> >> >> fails over successful, just not the MSDTC group
> >> >>
> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> >> > Hi
> >> >> >
> >> >> > Searching Google for "RPC raised an exception with a return code
> >> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
> >> >> > be
> >> >> > of
> >> >> > interest http://tinyurl.com/cnoqm
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "Martin" wrote:
> >> >> >
> >> >> >> Hello,
> >> >> >>
> >> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >> >>
> >> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> >> problems
> >> >> >> failing over to the other node. Failing over the MSDTC Group to
> >> >> >> the
> >> >> >> other
> >> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
> >> >> >> raised
> >> >> >> an
> >> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> >> generates
> >> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> >> 'MSDTC
> >> >> >> Group' failed").
> >> >> >>
> >> >> >> I've been able to find an article explaining how to reinstall MSDTC
> >> >> >> on
> >> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
> >> >> >> would
> >> >> >> be
> >> >> >> much
> >> >> >> appreciated. Thanks
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
ReInstalling Katmai.
I cannot reinstall Katmai.
Somehow, I created a situation where Management Studio could not connect to reporting services. Being unable to diagnose why, I decided to uninstall and reinstall. I had installed everything. After running about 10 uninstalls, I went to C:/Program Files/ and blasted the whole Microsoft SQL Server tree. I went to the registry and did the same thing in HKLM/Software/Microsoft/Microsoft SQL Server.
I rebooted. The error message: An instance with the same name is already installed on this computer. I'm guessing the setup program detected MSSQLSERVER in some registry key, and not another instance, but if I knew which one, I wouldn't be posting to this forum.
Somehow, I created a situation where Management Studio could not connect to reporting services. Being unable to diagnose why, I decided to uninstall and reinstall. I had installed everything. After running about 10 uninstalls, I went to C:/Program Files/ and blasted the whole Microsoft SQL Server tree. I went to the registry and did the same thing in HKLM/Software/Microsoft/Microsoft SQL Server.
I rebooted. The error message: An instance with the same name is already installed on this computer. I'm guessing the setup program detected MSSQLSERVER in some registry key, and not another instance, but if I knew which one, I wouldn't be posting to this forum.
It may be that Control Panel|Administrative Tools|Services has an SQL Server(InstanceName) entry.
sql
Reinstalling DB Server - Backup/Restore Help
Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>
Reinstalling DB Server - Backup/Restore Help
Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>
reinstalling As
good day to all!
well i'm having a problem: i had As installed in my computer. then i needed to unistall it and now that i nedd to reinstall analysis server i have a message "please unistall the previous version". but i had do it? can someone tell me what to do? ( i'm not thinking in installing windows again!)
thx!
Hi
Try doing it from the commandline with the switch SKUUPGRADE=1. SQLDIR\setup SKUUPGRADE=1
Reinstallation problem of SQL Server 2005 Developer Edition
I was forced to reinstall SQL Server due to a fault in the Full Text Engine.
I removed everything and got the message:
"A component that you have specified in the ADD_LOCAL property is already
installed. To upgrade the existing component, refer to the template.ini and
set the UPGRADE property to the name of the component."
when it reached the last section, Workstation Components.
In the installation report below (reduced for lack of space) you can find
the line:
Product: Microsoft SQL Server 2005 Tools -- Installation failed
Should be pleased to have you assistance
=== Verbose logging started: 12/04/2007 15:44:47 Build type: SHIP UNICODE
3.01.4000.2805 Calling process: C:\Programmer\Microsoft SQL Server\90\Setup
Bootstrap\setup.exe ===
MSI (c) (DC:00) [15:44:47:812]: Resetting cached policy values
MSI (c) (DC:00) [15:44:47:812]: Machine policy value 'Debug' is 0
MSI (c) (DC:00) [15:44:47:812]: ******* RunEngine:
******* Product: Z:\MSDN\SQL Server\SQL Server 2005 Developer
Edition\SQLTOOLS\Setup\SqlRun_Tools.msi
******* Action:
MSI (s) (F4:B4) [15:46:34:156]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (F4:B4) [15:46:34:156]: MainEngineThread is returning 1603
MSI (s) (F4:8C) [15:46:34:265]: Destroying RemoteAPI object.
MSI (s) (F4:70) [15:46:34:265]: Custom Action Manager thread ending.
=== Logging stopped: 12/04/2007 15:46:34 ===
MSI (c) (DC:00) [15:46:34:265]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:00) [15:46:34:265]: MainEngineThread is returning 1603
=== Verbose logging stopped: 12/04/2007 15:46:34 ===
yeah I've had a heck of a time with the SQL installer also
I just think that MS should stop trying to force a new version down our
throaats every 2 years-- and start taking usability seriously
SERIOUSLY
How many times do ou guys get prompted for missing Office components?
Doesn't it still happen in Office 2007?
I call for Ballmer to be fired and Ralph Nader to take over; MS doesn't give
a crap about customers and Nader is the only person that can save MS
"Peter Mller-Christensen - pmc@.niras.dk" <Peter Mller-Christensen -
pmc@.niras.dk@.discussions.microsoft.com> wrote in message
news:4333865F-9D40-416B-BA33-1EF122C492BF@.microsoft.com...
> I was forced to reinstall SQL Server due to a fault in the Full Text
Engine.
> I removed everything and got the message:
> "A component that you have specified in the ADD_LOCAL property is already
> installed. To upgrade the existing component, refer to the template.ini
and
> set the UPGRADE property to the name of the component."
> when it reached the last section, Workstation Components.
> In the installation report below (reduced for lack of space) you can find
> the line:
> Product: Microsoft SQL Server 2005 Tools -- Installation failed
> Should be pleased to have you assistance
> === Verbose logging started: 12/04/2007 15:44:47 Build type: SHIP
UNICODE
> 3.01.4000.2805 Calling process: C:\Programmer\Microsoft SQL
Server\90\Setup
> Bootstrap\setup.exe ===
> MSI (c) (DC:00) [15:44:47:812]: Resetting cached policy values
> MSI (c) (DC:00) [15:44:47:812]: Machine policy value 'Debug' is 0
> MSI (c) (DC:00) [15:44:47:812]: ******* RunEngine:
> ******* Product: Z:\MSDN\SQL Server\SQL Server 2005 Developer
> Edition\SQLTOOLS\Setup\SqlRun_Tools.msi
> ******* Action:
> MSI (s) (F4:B4) [15:46:34:156]: Cleaning up uninstalled install packages,
if
> any exist
> MSI (s) (F4:B4) [15:46:34:156]: MainEngineThread is returning 1603
> MSI (s) (F4:8C) [15:46:34:265]: Destroying RemoteAPI object.
> MSI (s) (F4:70) [15:46:34:265]: Custom Action Manager thread ending.
> === Logging stopped: 12/04/2007 15:46:34 ===
> MSI (c) (DC:00) [15:46:34:265]: Decrementing counter to disable shutdown.
If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (DC:00) [15:46:34:265]: MainEngineThread is returning 1603
> === Verbose logging stopped: 12/04/2007 15:46:34 ===
>
>
I removed everything and got the message:
"A component that you have specified in the ADD_LOCAL property is already
installed. To upgrade the existing component, refer to the template.ini and
set the UPGRADE property to the name of the component."
when it reached the last section, Workstation Components.
In the installation report below (reduced for lack of space) you can find
the line:
Product: Microsoft SQL Server 2005 Tools -- Installation failed
Should be pleased to have you assistance
=== Verbose logging started: 12/04/2007 15:44:47 Build type: SHIP UNICODE
3.01.4000.2805 Calling process: C:\Programmer\Microsoft SQL Server\90\Setup
Bootstrap\setup.exe ===
MSI (c) (DC:00) [15:44:47:812]: Resetting cached policy values
MSI (c) (DC:00) [15:44:47:812]: Machine policy value 'Debug' is 0
MSI (c) (DC:00) [15:44:47:812]: ******* RunEngine:
******* Product: Z:\MSDN\SQL Server\SQL Server 2005 Developer
Edition\SQLTOOLS\Setup\SqlRun_Tools.msi
******* Action:
MSI (s) (F4:B4) [15:46:34:156]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (F4:B4) [15:46:34:156]: MainEngineThread is returning 1603
MSI (s) (F4:8C) [15:46:34:265]: Destroying RemoteAPI object.
MSI (s) (F4:70) [15:46:34:265]: Custom Action Manager thread ending.
=== Logging stopped: 12/04/2007 15:46:34 ===
MSI (c) (DC:00) [15:46:34:265]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:00) [15:46:34:265]: MainEngineThread is returning 1603
=== Verbose logging stopped: 12/04/2007 15:46:34 ===
yeah I've had a heck of a time with the SQL installer also
I just think that MS should stop trying to force a new version down our
throaats every 2 years-- and start taking usability seriously
SERIOUSLY
How many times do ou guys get prompted for missing Office components?
Doesn't it still happen in Office 2007?
I call for Ballmer to be fired and Ralph Nader to take over; MS doesn't give
a crap about customers and Nader is the only person that can save MS
"Peter Mller-Christensen - pmc@.niras.dk" <Peter Mller-Christensen -
pmc@.niras.dk@.discussions.microsoft.com> wrote in message
news:4333865F-9D40-416B-BA33-1EF122C492BF@.microsoft.com...
> I was forced to reinstall SQL Server due to a fault in the Full Text
Engine.
> I removed everything and got the message:
> "A component that you have specified in the ADD_LOCAL property is already
> installed. To upgrade the existing component, refer to the template.ini
and
> set the UPGRADE property to the name of the component."
> when it reached the last section, Workstation Components.
> In the installation report below (reduced for lack of space) you can find
> the line:
> Product: Microsoft SQL Server 2005 Tools -- Installation failed
> Should be pleased to have you assistance
> === Verbose logging started: 12/04/2007 15:44:47 Build type: SHIP
UNICODE
> 3.01.4000.2805 Calling process: C:\Programmer\Microsoft SQL
Server\90\Setup
> Bootstrap\setup.exe ===
> MSI (c) (DC:00) [15:44:47:812]: Resetting cached policy values
> MSI (c) (DC:00) [15:44:47:812]: Machine policy value 'Debug' is 0
> MSI (c) (DC:00) [15:44:47:812]: ******* RunEngine:
> ******* Product: Z:\MSDN\SQL Server\SQL Server 2005 Developer
> Edition\SQLTOOLS\Setup\SqlRun_Tools.msi
> ******* Action:
> MSI (s) (F4:B4) [15:46:34:156]: Cleaning up uninstalled install packages,
if
> any exist
> MSI (s) (F4:B4) [15:46:34:156]: MainEngineThread is returning 1603
> MSI (s) (F4:8C) [15:46:34:265]: Destroying RemoteAPI object.
> MSI (s) (F4:70) [15:46:34:265]: Custom Action Manager thread ending.
> === Logging stopped: 12/04/2007 15:46:34 ===
> MSI (c) (DC:00) [15:46:34:265]: Decrementing counter to disable shutdown.
If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (DC:00) [15:46:34:265]: MainEngineThread is returning 1603
> === Verbose logging stopped: 12/04/2007 15:46:34 ===
>
>
Reinstall SQL Sever 2000
Hi all,
I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.
Now is there a way to reinstall 2000 and just getting the files that the server is missing?
Is there any guidelines or steps for reinstalling 2000 out there?
Thanking you in advance.
LystraDoes anyone have any answers?
Thanks
Lystra|||I have look everywhere in order to get detail for reinstalling 2000, and have come up with anything.
Will I need to uninstall SQL and then install it all over again to get the missing files?
Thanks
Lystra|||You can try to re-install the service pack. That will replace some files, but not necessarily all of them. And if you are missing enough files that SQL Server will not start up in the first place, you may end up having to just uninstall and re-install SQL Server, altogether.
And, of course, you may want to look into restricting the permissions so folks can not accidentally delete these files.|||Thanks for responding.
As for the data files once I uninstall will the files be remove?
Do I need to move the data files of the server??
Lystra|||I have not uninstalled SQL Server many times, so I do not know if the data files are left on the disk. It is best to save off backups of all of your databases (master and msdb included), before you start this sort of thing. Once you are certain you can get all of your data back from any mishap, then you can start trying to get SQL Server off the box.|||True, its always better to keep the upto date backup of the databases and store them in other location until the resinstallation process is completed.
There aren't any defined steps to reinstall just install the CD and continue as specified in the screen. Its better to do it from scracth by uninstalling current version , remot registery referenced keys, reboot the box and then reinstall SQL.|||Hi
I have found a MS Knowledge base article on How to manually remove SQL server 2000 Default, named, or virtual instance.
I help you with the reinstall process.
Article # 290991
Thanks for all your help
Lystra
I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.
Now is there a way to reinstall 2000 and just getting the files that the server is missing?
Is there any guidelines or steps for reinstalling 2000 out there?
Thanking you in advance.
LystraDoes anyone have any answers?
Thanks
Lystra|||I have look everywhere in order to get detail for reinstalling 2000, and have come up with anything.
Will I need to uninstall SQL and then install it all over again to get the missing files?
Thanks
Lystra|||You can try to re-install the service pack. That will replace some files, but not necessarily all of them. And if you are missing enough files that SQL Server will not start up in the first place, you may end up having to just uninstall and re-install SQL Server, altogether.
And, of course, you may want to look into restricting the permissions so folks can not accidentally delete these files.|||Thanks for responding.
As for the data files once I uninstall will the files be remove?
Do I need to move the data files of the server??
Lystra|||I have not uninstalled SQL Server many times, so I do not know if the data files are left on the disk. It is best to save off backups of all of your databases (master and msdb included), before you start this sort of thing. Once you are certain you can get all of your data back from any mishap, then you can start trying to get SQL Server off the box.|||True, its always better to keep the upto date backup of the databases and store them in other location until the resinstallation process is completed.
There aren't any defined steps to reinstall just install the CD and continue as specified in the screen. Its better to do it from scracth by uninstalling current version , remot registery referenced keys, reboot the box and then reinstall SQL.|||Hi
I have found a MS Knowledge base article on How to manually remove SQL server 2000 Default, named, or virtual instance.
I help you with the reinstall process.
Article # 290991
Thanks for all your help
Lystra
Reinstall SQL Server 2005 Problem (cannot connect to <server>)
I had installed SQL Server 2005 for the first time in order to study for the SQL SERVER 2005 Implementation and Maintenance exam. Everything was going ok until I got to the section on Partitions. When I attempted to follow the lessons on partitions, I received an error indicating that the Enterprise Edition was needed for Partitions.
I uninstalled SQL Server and re-installed the Enterprise Edition (MSDN disk). When I re-installed, I was not promopted for a new/default instance name). The old instance that had used for the original installation is presented when I attempt to "Connect to Server." When I select that instance and click Connect, I receive the "Cannot connect to <server name>" error message.
How do I re-establish that instance name or create another default instance?
Regards - Tony
Would you check Control Panel -> Add/Remove Programs? If there is still SQL Server 2005 entry, please choose it and click change, then click Report button to get all information about SQL Server 2005. The report will tell you which components of SQL Server 2005 are still existing on your machine.
Based on your description, maybe the previous SQL Server 2005 has not been uninstalled successfully.
If you do not mind, you can type in a new instance name to install another instance as multiple instacnes are supported provided that you have enough resourses such as free disk space.
Reinstall SQL Server 2005
Hi all,
I want to remove SQL Server 2005 sp2, so I need to reinstall SQL Server 2005. What steps I need to take before remove the SQL Server 2005. Because I don't want to loss any data on the Database Server, Analysis Servers, and Reporting Server.
Thanks,
Why do you want to uninstall SP2? It might be easier to solve the issue you are having with SP2 than completely reinstalling SQL Server 2005.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Hi WesleyB
My problem is the inscope funtion in Reporting Service, and it is the know issue in SP2. And I don't like there workaround solution, so I need to roll back to SP1.
Thanks,
|||You can uninstall service pack 2 after which you best install the previous fixes that were applied.
Take a backup of your databases before you try this however.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
Reinstall SQL Server 2005
Hi all,
I want to remove SQL Server 2005 sp2, so I need to reinstall SQL Server 2005. What steps I need to take before remove the SQL Server 2005. Because I don't want to loss any data on the Database Server, Analysis Servers, and Reporting Server.
Thanks,
Why do you want to uninstall SP2? It might be easier to solve the issue you are having with SP2 than completely reinstalling SQL Server 2005.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Hi WesleyB
My problem is the inscope funtion in Reporting Service, and it is the know issue in SP2. And I don't like there workaround solution, so I need to roll back to SP1.
Thanks,
|||You can uninstall service pack 2 after which you best install the previous fixes that were applied.
Take a backup of your databases before you try this however.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
Reinstall SQL SERVER
Hi,
I have a server with SQL Server 2000, and the sql are with
problems. Everyday a lot of people work on a base of data
in SQL. Can I reinstall the SQL in a normal day with that
all people working without harming her work?
Cheers
JoaoWHat are your problems? Reinstalling is a bit extreme of
a solution.
Unless you were installing a new instance and not
overwriting the existing one, you would definitely affect
the availability of SQL Server, because you are
essentially uninstalling and reinstalling. You would need
to back up any databases first, uninstall, reinstall SQL,
then restore the DBs.
Sorry.
>--Original Message--
>Hi,
>I have a server with SQL Server 2000, and the sql are
with
>problems. Everyday a lot of people work on a base of data
>in SQL. Can I reinstall the SQL in a normal day with that
>all people working without harming her work?
>Cheers
>Joao
>.
>
I have a server with SQL Server 2000, and the sql are with
problems. Everyday a lot of people work on a base of data
in SQL. Can I reinstall the SQL in a normal day with that
all people working without harming her work?
Cheers
JoaoWHat are your problems? Reinstalling is a bit extreme of
a solution.
Unless you were installing a new instance and not
overwriting the existing one, you would definitely affect
the availability of SQL Server, because you are
essentially uninstalling and reinstalling. You would need
to back up any databases first, uninstall, reinstall SQL,
then restore the DBs.
Sorry.
>--Original Message--
>Hi,
>I have a server with SQL Server 2000, and the sql are
with
>problems. Everyday a lot of people work on a base of data
>in SQL. Can I reinstall the SQL in a normal day with that
>all people working without harming her work?
>Cheers
>Joao
>.
>
ReInstall Sql Server
I lost access to sql server, "sa" is "Denied" "builtin"
is "Denied" before I have a login for a standart user but
I can't use it I get connection fail all the time. I want
to reinstall Sql Server am i going to lose the databases?
Is there any hope for this situation?
Please Help!!!!!!!!!
ShalomHello,
it depends on your NT-Account. If you have still access to the
server console you can login, shutdown the sql-services and
copy the database files to a secure place.
You can than use the rebuildm.exe tool to create new system-db's.
Reattach the user-db's and all is fine.
That would be my suggestion...but maybe some have a better one.
cu
p.s:
But how you have lost the rights?
You have made backups of your system and user databases?
"Shalom" <Telaviv7777777@.aol.com> wrote in message
news:009f01c3cbda$9c3c1c40$a301280a@.phx.gbl...
1. Restore master from a backup
2. Rebuild master then re-attach the user databases.
3. Attempt a Windows NT Athenticated connection with the NT admin account
on the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Christian,
Thank You for trying to help.
1) I selected security from the console root I epanded the
server than selected security clcked on login than
selected "sa" than selected "denied" for "sa" user.
2)I did not make a backup.
Shalom
to the
and
system-db's.
better one.
is "Denied" before I have a login for a standart user but
I can't use it I get connection fail all the time. I want
to reinstall Sql Server am i going to lose the databases?
Is there any hope for this situation?
Please Help!!!!!!!!!
ShalomHello,
it depends on your NT-Account. If you have still access to the
server console you can login, shutdown the sql-services and
copy the database files to a secure place.
You can than use the rebuildm.exe tool to create new system-db's.
Reattach the user-db's and all is fine.
That would be my suggestion...but maybe some have a better one.
cu
p.s:
But how you have lost the rights?
You have made backups of your system and user databases?
"Shalom" <Telaviv7777777@.aol.com> wrote in message
news:009f01c3cbda$9c3c1c40$a301280a@.phx.gbl...
quote:|||You have a couple of possible solutions.
> I lost access to sql server, "sa" is "Denied" "builtin"
> is "Denied" before I have a login for a standart user but
> I can't use it I get connection fail all the time. I want
> to reinstall Sql Server am i going to lose the databases?
> Is there any hope for this situation?
> Please Help!!!!!!!!!
> Shalom
1. Restore master from a backup
2. Rebuild master then re-attach the user databases.
3. Attempt a Windows NT Athenticated connection with the NT admin account
on the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Christian,
Thank You for trying to help.
1) I selected security from the console root I epanded the
server than selected security clcked on login than
selected "sa" than selected "denied" for "sa" user.
2)I did not make a backup.
Shalom
quote:
>--Original Message--
>Hello,
>
>it depends on your NT-Account. If you have still access
to the
quote:
>server console you can login, shutdown the sql-services
and
quote:
>copy the database files to a secure place.
>You can than use the rebuildm.exe tool to create new
system-db's.
quote:
>Reattach the user-db's and all is fine.
>That would be my suggestion...but maybe some have a
better one.
quote:
>cu
>p.s:
>But how you have lost the rights?
>You have made backups of your system and user databases?
>
>"Shalom" <Telaviv7777777@.aol.com> wrote in message
>news:009f01c3cbda$9c3c1c40$a301280a@.phx.gbl...
but[QUOTE]
want[QUOTE]
databases?[QUOTE]
>
>.
>
Reinstall SQL 2005 Management Studio
We are running SQL 2005 Standard Server. Apparently our server was slightly
"damaged" and SQL 2005 Management Studio is no longer installed.
How can I re-intall this? I have tried reloading SQL to no avail. I am not
seeing it as an option. I am selecting client tools during the installation.
SQL Server is running as Dynamics GP is functional.
I am wondering if it is installed and the shortcut is missing. Can anyone
tell me the executable program name and the location so I can check this.
All help greatly appreciated.Jerry
Try Start--Run--sqlwb.exe
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:63E1823D-01D7-435E-AF5B-25629A2CEF7B@.microsoft.com...
> We are running SQL 2005 Standard Server. Apparently our server was
> slightly
> "damaged" and SQL 2005 Management Studio is no longer installed.
> How can I re-intall this? I have tried reloading SQL to no avail. I am not
> seeing it as an option. I am selecting client tools during the
> installation.
> SQL Server is running as Dynamics GP is functional.
> I am wondering if it is installed and the shortcut is missing. Can anyone
> tell me the executable program name and the location so I can check this.
> All help greatly appreciated.|||THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
cryptic, I did not realize that the program was still even installed.
Jerry
"Uri Dimant" wrote:
> Jerry
> Try Start--Run--sqlwb.exe
>|||In SQL Server 2008, SQL Server Management Studio' s executable file name is
"ssms.exe".
--
Ekrem Ã?nsoy
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>|||The tool was, while in beta, called "SQL Server WorkBench", and the name for the exe file stayed...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>
"damaged" and SQL 2005 Management Studio is no longer installed.
How can I re-intall this? I have tried reloading SQL to no avail. I am not
seeing it as an option. I am selecting client tools during the installation.
SQL Server is running as Dynamics GP is functional.
I am wondering if it is installed and the shortcut is missing. Can anyone
tell me the executable program name and the location so I can check this.
All help greatly appreciated.Jerry
Try Start--Run--sqlwb.exe
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:63E1823D-01D7-435E-AF5B-25629A2CEF7B@.microsoft.com...
> We are running SQL 2005 Standard Server. Apparently our server was
> slightly
> "damaged" and SQL 2005 Management Studio is no longer installed.
> How can I re-intall this? I have tried reloading SQL to no avail. I am not
> seeing it as an option. I am selecting client tools during the
> installation.
> SQL Server is running as Dynamics GP is functional.
> I am wondering if it is installed and the shortcut is missing. Can anyone
> tell me the executable program name and the location so I can check this.
> All help greatly appreciated.|||THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
cryptic, I did not realize that the program was still even installed.
Jerry
"Uri Dimant" wrote:
> Jerry
> Try Start--Run--sqlwb.exe
>|||In SQL Server 2008, SQL Server Management Studio' s executable file name is
"ssms.exe".
--
Ekrem Ã?nsoy
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>|||The tool was, while in beta, called "SQL Server WorkBench", and the name for the exe file stayed...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>
Reinstall RS Client?
Hi,
I have purchased a new copy of SQL Server for running Reporting Service as
the Evaluation copy has expired.
I have installed Visual Studio with RS client on a workstation as I don't
want to install Report Designer on the Server.
I would like to know is it necessary for me to uninstall the Evaluation Copy
RS Client on my workstation before installing the new RS Client ?
Your advice is sought.I am pretty sure the evaluation expiration is only the server part of RS,
not the design tools. Are you getting a message saying that it has expired
when you try to design? You should still be able to design and preview. If
that is the case (I am trying to remember what I did but I don't think I did
anything with the client tools). Unless you have a problem my suggestion is
to leave the designer alone. After installing the new server you should
download SP2 and install that at both the server and the client.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%239RZUnfsFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have purchased a new copy of SQL Server for running Reporting Service as
> the Evaluation copy has expired.
> I have installed Visual Studio with RS client on a workstation as I don't
> want to install Report Designer on the Server.
> I would like to know is it necessary for me to uninstall the Evaluation
> Copy RS Client on my workstation before installing the new RS Client ?
> Your advice is sought.
>
I have purchased a new copy of SQL Server for running Reporting Service as
the Evaluation copy has expired.
I have installed Visual Studio with RS client on a workstation as I don't
want to install Report Designer on the Server.
I would like to know is it necessary for me to uninstall the Evaluation Copy
RS Client on my workstation before installing the new RS Client ?
Your advice is sought.I am pretty sure the evaluation expiration is only the server part of RS,
not the design tools. Are you getting a message saying that it has expired
when you try to design? You should still be able to design and preview. If
that is the case (I am trying to remember what I did but I don't think I did
anything with the client tools). Unless you have a problem my suggestion is
to leave the designer alone. After installing the new server you should
download SP2 and install that at both the server and the client.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%239RZUnfsFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have purchased a new copy of SQL Server for running Reporting Service as
> the Evaluation copy has expired.
> I have installed Visual Studio with RS client on a workstation as I don't
> want to install Report Designer on the Server.
> I would like to know is it necessary for me to uninstall the Evaluation
> Copy RS Client on my workstation before installing the new RS Client ?
> Your advice is sought.
>
Reinstall Reporting Services
Does anyone know of a way to completely reinstall reporting services?
I tried to do it through the SQL Server 2005 install and at somepoint
it told me the only way to modify/reinstall an existing installation
for this component was to do it through Control Panel > Add/Remove
Programs. I tried that, it ran through it's setup, but didn't really
reinstall anything or give me any installation config options. I've
messed up my reporting services pretty good and would like to
completely uninstall then reinstall if possible.
Thanks,
MattMark
Before uninstalling RS you should remove 2 RS components manually. Follow this
Launch Component Service MMC snap-in from Administrative Tools.
Navigate down to Components Services | Computers | <My Computer>| COM+
Applications, you fill find at least a pair of IIS application for RS &
Reports. You have to remove them, in order to do so you will ned to select
each applications properties dialog and Uncheck Diable deletion on the
Protection tab. This will delete them.
Thanks
Azhar
"Matt Karp" wrote:
> Does anyone know of a way to completely reinstall reporting services?
> I tried to do it through the SQL Server 2005 install and at somepoint
> it told me the only way to modify/reinstall an existing installation
> for this component was to do it through Control Panel > Add/Remove
> Programs. I tried that, it ran through it's setup, but didn't really
> reinstall anything or give me any installation config options. I've
> messed up my reporting services pretty good and would like to
> completely uninstall then reinstall if possible.
> Thanks,
> Matt
>
I tried to do it through the SQL Server 2005 install and at somepoint
it told me the only way to modify/reinstall an existing installation
for this component was to do it through Control Panel > Add/Remove
Programs. I tried that, it ran through it's setup, but didn't really
reinstall anything or give me any installation config options. I've
messed up my reporting services pretty good and would like to
completely uninstall then reinstall if possible.
Thanks,
MattMark
Before uninstalling RS you should remove 2 RS components manually. Follow this
Launch Component Service MMC snap-in from Administrative Tools.
Navigate down to Components Services | Computers | <My Computer>| COM+
Applications, you fill find at least a pair of IIS application for RS &
Reports. You have to remove them, in order to do so you will ned to select
each applications properties dialog and Uncheck Diable deletion on the
Protection tab. This will delete them.
Thanks
Azhar
"Matt Karp" wrote:
> Does anyone know of a way to completely reinstall reporting services?
> I tried to do it through the SQL Server 2005 install and at somepoint
> it told me the only way to modify/reinstall an existing installation
> for this component was to do it through Control Panel > Add/Remove
> Programs. I tried that, it ran through it's setup, but didn't really
> reinstall anything or give me any installation config options. I've
> messed up my reporting services pretty good and would like to
> completely uninstall then reinstall if possible.
> Thanks,
> Matt
>
Reinstall problem with Report Services
I have been playing with my Standard version of SQL Server with no problems. Now I wanted to start exploring Reporting Services, however whenever I tried to connect to the instance through the Management Studio, it would fail. I did notice that the folder in IIS was not present so I am thinking it was something I failed to do in the initial setup.
I have uninstalled everything, but when it gets to Reporting Services, I get an error message "The setup failed to read IISMiniMap table. Error Code -2147024893." I did a search on various newsgroups and forums and found a message about installing and running some Microsoft Cleanup utility. I did this, but I am still getting the error message and then the uninstall rolls everything back.
What do I need to do here, short of doing a total reformat of the harddrive and just reinstall everything?
Thanks for the information.
To add to this problem, I uninstalled all that I could with my original instance of SQL Server (minus Reporting Services). Now I have reinstalled a new instance that also created a new instance of Reporting Services. However when I go to IIS, it says that the Report Server is stopped and I cannot restart it. I get the error "The request is not supported".
What is up with this?
Reinstall operating system without loosing SQL data?
If I have SQL server installed on one partition(D:) and the OS installed on
another(C:), if I need to re-install the OS is it possible to re-install SQL
server without loosing my already created databases?
The drive with the OS got corrupted somehow over the weekend, but the SQL
server drive still seems to be working just fine.As long as the database data and log files are on a DIFFERENT physical
drive, you can re-install SQL Server, then use sp_attach_db to re-attach the
physical files to the new SQL Server..
Look for sp_attach_db in the SQL Books.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Russ" <russ@.acordiamn.com> wrote in message
news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
> If I have SQL server installed on one partition(D:) and the OS installed
on
> another(C:), if I need to re-install the OS is it possible to re-install
SQL
> server without loosing my already created databases?
> The drive with the OS got corrupted somehow over the weekend, but the SQL
> server drive still seems to be working just fine.
>|||You can use 'sp_change_users_login' to (find unconnected
users through 'report' option and ) link existing logins
with database permissions. Now, the logins are maintained
in master and will be lost upon new installation or master
rebuild. You have to re-enter all login/password
information. Alternatively, you can keep list of passwords
with you through this script generator
select 'EXEC sp_addlogin '''+name+''', ', CONVERT(VARBINARY
(32), password), ', @.encryptopt = ''skip_encryption'''
from syslogins
where dbname='test' -- database name
and name <> 'sa' -- exclusion list
order by name
(replace TABS with space on the resulting script and
execute it to create logins)
Happy computing,
Muhammad Zeeshan
>--Original Message--
>If I backup the Data files (mdf & ldf) before
reinstalling can I avoid
>having to redo all the permissions for the various
databases?
>I also have tape back-ups, but using them to restore
would lose the last
>weeks worth of data, so I would rather not have to do
that if it can be
>avoided.
>
>"Russ" <russ@.acordiamn.com> wrote in message
>news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
>> If I have SQL server installed on one partition(D:) and
the OS installed
>on
>> another(C:), if I need to re-install the OS is it
possible to re-install
>SQL
>> server without loosing my already created databases?
>> The drive with the OS got corrupted somehow over the
weekend, but the SQL
>> server drive still seems to be working just fine.
>>
>
>.
>sql
another(C:), if I need to re-install the OS is it possible to re-install SQL
server without loosing my already created databases?
The drive with the OS got corrupted somehow over the weekend, but the SQL
server drive still seems to be working just fine.As long as the database data and log files are on a DIFFERENT physical
drive, you can re-install SQL Server, then use sp_attach_db to re-attach the
physical files to the new SQL Server..
Look for sp_attach_db in the SQL Books.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Russ" <russ@.acordiamn.com> wrote in message
news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
> If I have SQL server installed on one partition(D:) and the OS installed
on
> another(C:), if I need to re-install the OS is it possible to re-install
SQL
> server without loosing my already created databases?
> The drive with the OS got corrupted somehow over the weekend, but the SQL
> server drive still seems to be working just fine.
>|||You can use 'sp_change_users_login' to (find unconnected
users through 'report' option and ) link existing logins
with database permissions. Now, the logins are maintained
in master and will be lost upon new installation or master
rebuild. You have to re-enter all login/password
information. Alternatively, you can keep list of passwords
with you through this script generator
select 'EXEC sp_addlogin '''+name+''', ', CONVERT(VARBINARY
(32), password), ', @.encryptopt = ''skip_encryption'''
from syslogins
where dbname='test' -- database name
and name <> 'sa' -- exclusion list
order by name
(replace TABS with space on the resulting script and
execute it to create logins)
Happy computing,
Muhammad Zeeshan
>--Original Message--
>If I backup the Data files (mdf & ldf) before
reinstalling can I avoid
>having to redo all the permissions for the various
databases?
>I also have tape back-ups, but using them to restore
would lose the last
>weeks worth of data, so I would rather not have to do
that if it can be
>avoided.
>
>"Russ" <russ@.acordiamn.com> wrote in message
>news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
>> If I have SQL server installed on one partition(D:) and
the OS installed
>on
>> another(C:), if I need to re-install the OS is it
possible to re-install
>SQL
>> server without loosing my already created databases?
>> The drive with the OS got corrupted somehow over the
weekend, but the SQL
>> server drive still seems to be working just fine.
>>
>
>.
>sql
Subscribe to:
Posts (Atom)