help with SQL 2005 Express!!!! cant remove instance (add/remove no longer lists it but the instance still lists in services)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddie Walker - 19 Jul 2008 17:14 GMT

Hello Everyone -

I'm trying to install this application that needs sql 2000 or sql 2005
express.

I have a box that already hasthe sql desktop engine running for blackberry
enterprise software and another application.

The third application at the suggestion of the vendor was installed with sql
2005 express.

After installing the program once successfully, i realized I needd to move
it to another location. I removed the program and the sql 2005 options via
add/remove.

I go back to install the program check off the items to include the sql 2005
express.Now it doesnt launch the sql install.
it tries to added the database and it says its unavailable. I looked further
and found that under services it has a listing for sql server
2005(database$) the one that im supposed to create. I dont see any way to
remove those and I suspect that being in the services list is keeping the
install from reinstalling sql 2005 express properly.

can anyone help me out with this?

Thanks,

Reply to this Message

Andrea Montanari - 20 Jul 2008 15:47 GMT

hi Eddie,

> Hello Everyone -
>
[quoted text clipped - 20 lines]
>
> can anyone help me out with this?

if you do not have access to a "customer support" program, you can try
manually uninstalling the SQLExpress instance you are involved with as
described in http://support.microsoft.com/kb/909967/en-us..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message

Eddie Walker - 21 Jul 2008 02:06 GMT

I have SQL express completely uninstalled,but in services i still have it
showing once instance. If i try to start it it says the file not found, and
the aritlce i read below im not sure if that is what i need to be able to
get that out of thee service list.

I cant reinstall this application because the sql express install fails out
(it doesnt give it a chance to create the database im guessing because there
is one of the same name listed in the services under control panel )..

I also hae MDSE installed for blackberry and another program. I tried to
create another instance there, the databsae was created and when i specify
it in the setup it says the SA account is not trusted or someting like that?

this is very frustrating.

ed

the program im trying to apply

> hi Eddie,
>> Hello Everyone -
[quoted text clipped - 25 lines]
> manually uninstalling the SQLExpress instance you are involved with as
> described in http://support.microsoft.com/kb/909967/en-us..

Reply to this Message

Andrea Montanari - 21 Jul 2008 11:35 GMT

h iEddie,

> I have SQL express completely uninstalled,but in services i still
> have it showing once instance. If i try to start it it says the file
> not found, and the aritlce i read below im not sure if that is what i
> need to be able to get that out of thee service list.

if you only have the service registered, but no binaries are present (really
a mess), you can try manually "deleting" the registry entry..
http://www.google.it/search?hl=it&q=manually+remove+service&meta=

> I cant reinstall this application because the sql express install
> fails out (it doesnt give it a chance to create the database im
> guessing because there is one of the same name listed in the services
> under control panel )..

you can eventually assign a different instance name for the one you want to
install..

> I also hae MDSE installed for blackberry and another program. I tried
> to create another instance there, the databsae was created and when i
> specify it in the setup it says the SA account is not trusted or
> someting like that?

please notice that a SQL Server instance and a SQL Server database are very
different things..
an instance [you can install up to 16 of them on the same machine, but each
of them will consume resources, so you should be cautios :) ] is made of
"binaries", thus is represented by executable files and a set of related
databases, both system databases and user's databases... different instances
can be at different version and service pack levels..
on the other side, a database is "just data" (loosely speaking), and it has
to be registered (via sp_attach_db) to a specific instance in order to be
used...
this should mean you tried to install an additional instance of MSDE or
what? this has nothing to do with "the database was created" statement and
with "when I specify IT in the setup.." as you can not specify a database
name at MSDE/SQL Server install time... at install time you can specify an
instance name via the INSTANCENAME=whatever parameter.. so the "SA account
is not trusted or something like that" exception should be related at
connection time and not at install time.. by default MSDE installs allowing
only trusted connections, and you have to manually enable mixed mode
connections at install time, providing the SECURITYMODE=SQL additional
parameter, or later, modifying that setting "hacking" the windows registry
as indicated in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 ..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply to this Message