A critical SQL Server problem

Hi,

Once, I wanted to attach a database to SQL Server by means of "CREATE DATABASE ... FOR ATTACH" command, in Query Analizer.

I encountered an error and attaching database failed.
(The error was something like this : "the phisical file 'FILENAME' maybe is incorrect")

But after going to Enterprice Manager, I realised that a database whitout a name was created.

Since then, I wasn't able to do any process in SQL Server whitout either not recieving an error or failing the process.

I decided to uninstall and reinstall SQL Server again.
But after uninstalling, whenever I want to reinstall SQL Server I get this error :

"A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

Which restarting does not help.

Now :

1- What was the reason of creation a null-named database, and how can I prevent it next time?

2- What should I do to Install SQL Server again?

Ooh, that doesn't sound healthy at all. I think your best bet would've been to have dropped the database using something really similar to the script you used to create it.

Now that you've tried to uninstall SQL Server, I think things have got worse. You may need us to find registry entries for you to play with, and things like that (but I don't know them off the top of my head). If this doesn't help, you may find yourself needing to rebuild your system. :(

Rob|||

I tried to drop database in diferent ways but they didn't work. That was the reason of why

I unistalled the SQL Server. And I don't know how to deal with registry for this problem.

|||Very carefully, go through this article. I hope it helps:

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

A critical SQL Server problem

Hi,

Once, I wanted to attach a database to SQL Server by means of "CREATE DATABASE ... FOR ATTACH" command, in Query Analizer.

I encountered an error and attaching database failed.
(The error was something like this : "the phisical file 'FILENAME' maybe is incorrect")

But after going to Enterprice Manager, I realised that a database whitout a name was created.

Since then, I wasn't able to do any process in SQL Server whitout either not recieving an error or failing the process.

I decided to uninstall and reinstall SQL Server again.
But after uninstalling, whenever I want to reinstall SQL Server I get this error :

"A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

Which restarting does not help.

Now :

1- What was the reason of creation a null-named database, and how can I prevent it next time?

2- What should I do to Install SQL Server again?

Ooh, that doesn't sound healthy at all. I think your best bet would've been to have dropped the database using something really similar to the script you used to create it.

Now that you've tried to uninstall SQL Server, I think things have got worse. You may need us to find registry entries for you to play with, and things like that (but I don't know them off the top of my head). If this doesn't help, you may find yourself needing to rebuild your system. :(

Rob|||

I tried to drop database in diferent ways but they didn't work. That was the reason of why

I unistalled the SQL Server. And I don't know how to deal with registry for this problem.

|||Very carefully, go through this article. I hope it helps:

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

5 User License

Hi,
What exactly does the 5 user(s) license of MSDE means?
"sa" is a user and i can have only 4 more users, does that means total 5
users license?
Or its the number of users connected to MSDE at any given point of time?
Reetesh.
hi Reetesh,
"Reetesh B. Chhatpar" <reetesh@.widesystems.com> ha scritto nel
messaggio news:OZsTAvI1EHA.1408@.TK2MSFTNGP10.phx.gbl
> Hi,
> What exactly does the 5 user(s) license of MSDE means?
> "sa" is a user and i can have only 4 more users, does that means
> total 5 users license?
> Or its the number of users connected to MSDE at any given point of
> time?
> Reetesh.
MSDE does not have a "5 users license" limitation... MSDE includes a
Governor Workloads that kicks in when 8 of more concurrent workloads
activities (batches that include the operations as described in
http://msdn.microsoft.com/library/?u...asp?frame=true)
are executed and slows all of them down, but more workloads are supported
and only slowed down...
AFAIK, no such a limitation exists, nor technical or legal..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
The article was really worth reading. Thanks for clearing up my doubt for
MSDE. Could you also please share with me the licensing logic for SQL
Server. How do i cut-cost my product installation when I choose backend as
SQL?
Reetesh B. Chhatpar
ShawMan Software Enterprises
www.shawmansoftware.com
Diamond is just another piece of coal that did well under pressure.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:30rjstF346j3iU1@.uni-berlin.de...
> hi Reetesh,
> "Reetesh B. Chhatpar" <reetesh@.widesystems.com> ha scritto nel
> messaggio news:OZsTAvI1EHA.1408@.TK2MSFTNGP10.phx.gbl
> MSDE does not have a "5 users license" limitation... MSDE includes a
> Governor Workloads that kicks in when 8 of more concurrent workloads
> activities (batches that include the operations as described in
>
http://msdn.microsoft.com/library/?u...asp?frame=true)
> are executed and slows all of them down, but more workloads are supported
> and only slowed down...
> AFAIK, no such a limitation exists, nor technical or legal..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Reetesh,
"Reetesh B. Chhatpar" <reetesh@.widesystems.com> ha scritto nel
messaggio news:%230kNRzQ1EHA.2540@.TK2MSFTNGP09.phx.gbl
> Hi Andrea,
> The article was really worth reading. Thanks for clearing up my doubt
> for MSDE. Could you also please share with me the licensing logic for
> SQL Server. How do i cut-cost my product installation when I choose
> backend as SQL?
in order to optimze your license fees, perhaps you've better have a call
with a Microsoft representative, as this really is a big deal and i'm not a
lawyer :D
if you choose MSDE (as per MSDE Release A package), your only need is to
register for distribution
(http://www.microsoft.com/sql/msde/ho...stregister.asp) , no other
requirement is necessary, for you nor for your customers... theoretical max
number of simultaneos connections stays at 32767 but, at 8 concurrent
workloads the Governor will kick in...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply