+ Reply to Thread
Results 1 to 4 of 4

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

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

    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,



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

    hi Eddie,
    Eddie Walker wrote:
    > 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?


    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..
    --
    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



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

    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
    "Andrea Montanari" wrote in message
    news:6eh1fqF6qf8iU1@mid.individual.net...
    > hi Eddie,
    > Eddie Walker wrote:
    >> 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?

    >
    > 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..
    > --
    > 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
    >



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

    h iEddie,
    Eddie Walker wrote:
    > 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=...+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...b;en-us;285097 ..
    --
    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 Thread