Hello,
I need to install a new instance of SQL Server 2000 on a cluster.
Currently, we have three instances. Each instances stores program files on
the E:\ Drive. Each instance has its own drive for data and another for
logs. However, there is no more unallocated space on the array to create
another partitioned drive.
My question is: If I create the new instance, can I store the data and log
files on an existing drive? Are there any performance or overhead costs that
should be considered?
Thank you,
Caroline
Each instance must have separate disk resources from any other instances.
You will need new disks to create another instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Caroline" <Caroline@.community.nospam> wrote in message
news:4E870F35-33B9-4E92-91E6-1993FD8FE4C4@.microsoft.com...
> Hello,
> I need to install a new instance of SQL Server 2000 on a cluster.
> Currently, we have three instances. Each instances stores program files
> on
> the E:\ Drive. Each instance has its own drive for data and another for
> logs. However, there is no more unallocated space on the array to create
> another partitioned drive.
> My question is: If I create the new instance, can I store the data and
> log
> files on an existing drive? Are there any performance or overhead costs
> that
> should be considered?
> Thank you,
> Caroline
sql
Showing posts with label program. Show all posts
Showing posts with label program. Show all posts
Monday, March 26, 2012
Install new instance
Hi,
I just wanted to install a new instance of SQL Server. I came to the point
where I had to decide, where to install the program and datafiles. Am I
right in assuming, that these have to be different from my default
instance?
TIA
ThomasThomas
BOL says:
"
Each named instance of Microsoft SQL Server 2000 has a specific location
for its program files and another for its data files that is different from
that of the default instance of SQL Server.
"
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94B5963B2301Btwrobelwaslosde@.207
.46.248.16...
> Hi,
> I just wanted to install a new instance of SQL Server. I came to the point
> where I had to decide, where to install the program and datafiles. Am I
> right in assuming, that these have to be different from my default
> instance?
> TIA
> Thomas
I just wanted to install a new instance of SQL Server. I came to the point
where I had to decide, where to install the program and datafiles. Am I
right in assuming, that these have to be different from my default
instance?
TIA
ThomasThomas
BOL says:
"
Each named instance of Microsoft SQL Server 2000 has a specific location
for its program files and another for its data files that is different from
that of the default instance of SQL Server.
"
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94B5963B2301Btwrobelwaslosde@.207
.46.248.16...
> Hi,
> I just wanted to install a new instance of SQL Server. I came to the point
> where I had to decide, where to install the program and datafiles. Am I
> right in assuming, that these have to be different from my default
> instance?
> TIA
> Thomas
Friday, March 23, 2012
Install Error: Previous Program ... Pending File Operations
Here's an interesting one ...
I'm trying to install SQL Server 2000 Developers client tools on XP Pro Svc
Pk2. When I get to the "Computer Name Window" I get the following error
message:
"A previous program installation created pending file operations on the
installation machine. You must restart the computer before running setup."
Obviously I've restarted the machine, run Windows Update, etc. No luck.
I've also tried to look for any other "update operations" from other
products, but no luck there either.
Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machine,
but under a guest OS. No problems. I've run the same Windows Updates here
too.
Any suggestions? Tons of fun!
Thanks so much!
--
DougGoogle is your friend :-)
http://www.google.se/search?hl=sv& ...3%B6kning&meta=
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Doug" <Doug@.discussions.microsoft.com> wrote in message
news:AF5AB8C4-FCE5-4FEB-AED2-B7DBEDAAFB1D@.microsoft.com...
> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug|||Google is my friend, and you are too. Thank you very much, that did the tri
ck!
--
Doug
"Doug" wrote:
> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug
I'm trying to install SQL Server 2000 Developers client tools on XP Pro Svc
Pk2. When I get to the "Computer Name Window" I get the following error
message:
"A previous program installation created pending file operations on the
installation machine. You must restart the computer before running setup."
Obviously I've restarted the machine, run Windows Update, etc. No luck.
I've also tried to look for any other "update operations" from other
products, but no luck there either.
Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machine,
but under a guest OS. No problems. I've run the same Windows Updates here
too.
Any suggestions? Tons of fun!
Thanks so much!
--
DougGoogle is your friend :-)
http://www.google.se/search?hl=sv& ...3%B6kning&meta=
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Doug" <Doug@.discussions.microsoft.com> wrote in message
news:AF5AB8C4-FCE5-4FEB-AED2-B7DBEDAAFB1D@.microsoft.com...
> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug|||Google is my friend, and you are too. Thank you very much, that did the tri
ck!
--
Doug
"Doug" wrote:
> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug
Wednesday, March 21, 2012
Install Error - SQL 2000 Std/ NT4SP6a
I get an error, saying a previous instance of setup did not complete, select
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete'
Thought I knew SQL !!!
--
Thanks for any help!
Neil MillingtonCan you post the exact error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete'
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> >>
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete'
Thought I knew SQL !!!
--
Thanks for any help!
Neil MillingtonCan you post the exact error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete'
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> >>
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>
Install Error - SQL 2000 Std/ NT4SP6a
I get an error, saying a previous instance of setup did not complete, select
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete?
Thought I knew SQL !!!
Thanks for any help!
Neil Millington
Can you post the exact error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete?
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington
|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...[vbcol=seagreen]
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup[vbcol=seagreen]
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...[vbcol=seagreen]
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote:
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete?
Thought I knew SQL !!!
Thanks for any help!
Neil Millington
Can you post the exact error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete?
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington
|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...[vbcol=seagreen]
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup[vbcol=seagreen]
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...[vbcol=seagreen]
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote:
install error
mlissaw
Can you try this?
1. Run command regedit.
2. Check whether the the key
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Pendingfilerenameoperations
exists. If yes, please remove it and reboot the machine. Then you can retart installing.
|||Also please review the following before you modify registry...
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry
|||I tried this process with backing up the registry and it did not work. any other suggestions?
install error
mlissaw
Can you try this?
1. Run command regedit.
2. Check whether the the key
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Pendingfilerenameoperations
exists. If yes, please remove it and reboot the machine. Then you can retart installing.
|||Also please review the following before you modify registry...
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry
|||I tried this process with backing up the registry and it did not work. any other suggestions?
Monday, March 12, 2012
Install
I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu.
Any suggestions would be appreciated.
Thanks!
I'd suggest that you start using SQL Express! 
(Sorry, had to do it.)
SQL Express only includes the database engine and the configuration tools, so you're seeing exactly what you should. You can work with the engine using a number of different tools, here are a few:
SQLCmd - Command line tool included with SQL Express to run T-SQL Commands.|||Thanks, this helps.
I actually wanted to initially load the free msde but got an error that said:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer tp the readme for more details. Setup will now exit"
I downloaded msde 2000 release A. Is that the correct version for the old msde?
Can you give me any advice on this. Thanks!
David
|||Hi David,
SQL Express is newer than MSDE 2000 and offers some improved functionality, but if you want to use the older version...
I would go for MSDE 2000 SP4 since that is newer than Release A. The behavior you describe is by design since you must supply a strong password for the SA account when installing MSDE. The readme file that is available on the download page for MSDE explains how to install it and the correct usage of the SAPWD switch.
Mike
Friday, March 9, 2012
Inserts to tables as one or two users.
SQL 7.0 SP4
Background: C++ program accesses SQL via ODBC doing
massive inserts to two different tables. The data goes
either to one table or the other, but not both.
Problem: Is it more efficient to have the program access
the database as one or two SQL users?
1. user DOG inserts to table XXX "and" table YYY.
or
2. user DOG inserts to table XXX,
user CAT inserts to table YYY?
Thanks for your help,
DonUnless you need to load them in parallel there isn't any reason to use two
users. Adding connections has a slight overhead that you probably don't
need for this type operation.
--
Andrew J. Kelly
SQL Server MVP
"Don" <ddachner@.yahoo.com> wrote in message
news:0bf401c38126$d4174120$a001280a@.phx.gbl...
> SQL 7.0 SP4
> Background: C++ program accesses SQL via ODBC doing
> massive inserts to two different tables. The data goes
> either to one table or the other, but not both.
> Problem: Is it more efficient to have the program access
> the database as one or two SQL users?
> 1. user DOG inserts to table XXX "and" table YYY.
> or
> 2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
> Thanks for your help,
> Don|||no, it wouldn't make any difference in performance, it
will only increase work for you to manage permissions to
two users.
Also, consider using stored procedures rather than direct
insert statements. this will give slight performance gain,
and better management of sql code.
>--Original Message--
>SQL 7.0 SP4
>Background: C++ program accesses SQL via ODBC doing
>massive inserts to two different tables. The data goes
>either to one table or the other, but not both.
>Problem: Is it more efficient to have the program access
>the database as one or two SQL users?
>1. user DOG inserts to table XXX "and" table YYY.
>or
>2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
>Thanks for your help,
>Don
>.
>
Background: C++ program accesses SQL via ODBC doing
massive inserts to two different tables. The data goes
either to one table or the other, but not both.
Problem: Is it more efficient to have the program access
the database as one or two SQL users?
1. user DOG inserts to table XXX "and" table YYY.
or
2. user DOG inserts to table XXX,
user CAT inserts to table YYY?
Thanks for your help,
DonUnless you need to load them in parallel there isn't any reason to use two
users. Adding connections has a slight overhead that you probably don't
need for this type operation.
--
Andrew J. Kelly
SQL Server MVP
"Don" <ddachner@.yahoo.com> wrote in message
news:0bf401c38126$d4174120$a001280a@.phx.gbl...
> SQL 7.0 SP4
> Background: C++ program accesses SQL via ODBC doing
> massive inserts to two different tables. The data goes
> either to one table or the other, but not both.
> Problem: Is it more efficient to have the program access
> the database as one or two SQL users?
> 1. user DOG inserts to table XXX "and" table YYY.
> or
> 2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
> Thanks for your help,
> Don|||no, it wouldn't make any difference in performance, it
will only increase work for you to manage permissions to
two users.
Also, consider using stored procedures rather than direct
insert statements. this will give slight performance gain,
and better management of sql code.
>--Original Message--
>SQL 7.0 SP4
>Background: C++ program accesses SQL via ODBC doing
>massive inserts to two different tables. The data goes
>either to one table or the other, but not both.
>Problem: Is it more efficient to have the program access
>the database as one or two SQL users?
>1. user DOG inserts to table XXX "and" table YYY.
>or
>2. user DOG inserts to table XXX,
> user CAT inserts to table YYY?
>Thanks for your help,
>Don
>.
>
Subscribe to:
Posts (Atom)