RE: We stepped in SQL

[David L Herrick]

Great will try it --- as soon as my internet connection is repaired L

 

From: Andrew Levicki [mailto:and...@levicki.me.uk] 
Sent: Sunday, April 04, 2010 4:12 AM
To: NT System Admin Issues
Subject: Re: We stepped in SQL

 

I've seen this before a few times. There's a Microsoft work-around here:

http://support.microsoft.com/kb/929665

 

On 4 April 2010 19:59, Ken Schaefer  wrote:

What do you mean by "promoting the server"? (dcpromo? Or some other kind of 
promotion?)
What do you mean by "cannot access the database"?
What do you mean by "cannot start it"?
What do you mean by "cannot uninstall SQL"?

What have you tried? What errors are you getting? Etc.

Cheers
Ken


-Original Message-
From: David Herrick [mailto:davidherr...@nincal.com]
Sent: Friday, 2 April 2010 4:46 AM
To: NT System Admin Issues
Subject: We stepped in SQL

OK we messed up rebuilding a server (lost a raid array)  In hindsight it looks 
like in our haste we installed Vipre Enterprise and its SQL database before 
promoting the server. Now we cannot access the database, cannot start it, 
cannot uninstall SQL.  Any clues on getting SQL off this box so we can 
reinstall Vipre and the other apps needing SQL

Thanks
David

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~




-- 
Kind regards,

Andrew Levicki
ルビッキー アンドルュー
MCITP Enterprise Administrator on Windows Server 2008
MCITP Enterprise Messaging Administrator on Exchange Server 2007
Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003
Cisco Certified Network Associate (CCNA)
ITILv3

 

 



This email and any attached files are confidential and intended solely
for the intended recipient(s). If you are not the named recipient you 
should not read, distribute, copy or alter this email. Any views or
opinions expressed in this email are those of the author and do not
represent those of Names in the News. Warning: Although precautions have been
taken to make sure no viruses are present in this email, the company 
cannot accept responsibility for any loss or damage that arise from the 
use of this email or attachments. 
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

RE: We stepped in SQL

[David L Herrick]

Tx see in line

-Original Message-
From: Ken Schaefer [mailto:k...@adopenstatic.com] 
Sent: Sunday, April 04, 2010 3:59 AM
To: NT System Admin Issues
Subject: RE: We stepped in SQL

What do you mean by "promoting the server"? (dcpromo? Or some other kind of 
promotion?)yes dcpromo
What do you mean by "cannot access the database"? application cannot login to 
the database
What do you mean by "cannot start it"? go to services the sql instance is not 
not running start - fails
What do you mean by "cannot uninstall SQL"? add remove programs select SQL 2005 
it shows the instance select it, ok uninstall starts, gets to the database 
portion and errors out

What have you tried? What errors are you getting? Etc.

Cheers
Ken

-Original Message-
From: David Herrick [mailto:davidherr...@nincal.com] 
Sent: Friday, 2 April 2010 4:46 AM
To: NT System Admin Issues
Subject: We stepped in SQL

OK we messed up rebuilding a server (lost a raid array)  In hindsight it looks 
like in our haste we installed Vipre Enterprise and its SQL database before 
promoting the server. Now we cannot access the database, cannot start it, 
cannot uninstall SQL.  Any clues on getting SQL off this box so we can 
reinstall Vipre and the other apps needing SQL

Thanks
David

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~



This email and any attached files are confidential and intended solely
for the intended recipient(s). If you are not the named recipient you 
should not read, distribute, copy or alter this email. Any views or
opinions expressed in this email are those of the author and do not
represent those of Names in the News. Warning: Although precautions have been
taken to make sure no viruses are present in this email, the company 
cannot accept responsibility for any loss or damage that arise from the 
use of this email or attachments. 
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

Re: We stepped in SQL

[Andrew Levicki]

I've seen this before a few times. There's a Microsoft work-around here:
http://support.microsoft.com/kb/929665

On 4 April 2010 19:59, Ken Schaefer  wrote:

> What do you mean by "promoting the server"? (dcpromo? Or some other kind of
> promotion?)
> What do you mean by "cannot access the database"?
> What do you mean by "cannot start it"?
> What do you mean by "cannot uninstall SQL"?
>
> What have you tried? What errors are you getting? Etc.
>
> Cheers
> Ken
>
> -Original Message-
> From: David Herrick [mailto:davidherr...@nincal.com]
> Sent: Friday, 2 April 2010 4:46 AM
> To: NT System Admin Issues
> Subject: We stepped in SQL
>
> OK we messed up rebuilding a server (lost a raid array)  In hindsight it
> looks like in our haste we installed Vipre Enterprise and its SQL database
> before promoting the server. Now we cannot access the database, cannot start
> it, cannot uninstall SQL.  Any clues on getting SQL off this box so we can
> reinstall Vipre and the other apps needing SQL
>
> Thanks
> David
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>



-- 
Kind regards,

Andrew Levicki
ルビッキー アンドルュー
MCITP Enterprise Administrator on Windows Server 2008
MCITP Enterprise Messaging Administrator on Exchange Server 2007
Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003
Cisco Certified Network Associate (CCNA)
ITILv3

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

RE: We stepped in SQL

[Ken Schaefer]

What do you mean by "promoting the server"? (dcpromo? Or some other kind of 
promotion?)
What do you mean by "cannot access the database"?
What do you mean by "cannot start it"?
What do you mean by "cannot uninstall SQL"?

What have you tried? What errors are you getting? Etc.

Cheers
Ken

-Original Message-
From: David Herrick [mailto:davidherr...@nincal.com] 
Sent: Friday, 2 April 2010 4:46 AM
To: NT System Admin Issues
Subject: We stepped in SQL

OK we messed up rebuilding a server (lost a raid array)  In hindsight it looks 
like in our haste we installed Vipre Enterprise and its SQL database before 
promoting the server. Now we cannot access the database, cannot start it, 
cannot uninstall SQL.  Any clues on getting SQL off this box so we can 
reinstall Vipre and the other apps needing SQL

Thanks
David

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~