Post reply

MSDE Release A: Setup-The instance name specified is invalid.

  • July 3, 2005 at 2:07 pm

    #88062

    Hi all,

    I downloaded the Microsoft SQL Server Desktop Engine (MSDE) 2000 Release A from MSDN to my C://drive.  I tried to install it by clicking on the setup file. The following showed up first:

    Please wait while Windows configure Micrsoft SQL Server Desktop Engine.

    Few seconds later, I got the following response:

        Micrsoft SQL Server Desktop Engine

        The instance name specified is invalid 

    What is wrong with the way I tried to install the MSDE?  Please help and advise me how to get the MSDE installed in my Windows XP Pro.

    Thanks,

    Scott  Chang 

        

  • July 4, 2005 at 2:12 am

    #570596

    Please open the ReadMe.htm file, and run the setup.exe in the commmand line parameter.... It will work fine....

    Thanks,

    Ganesh

     

     

     

  • July 4, 2005 at 1:12 pm

    #570737

    Hi Ganesh, Thanks for your response.

    I have the setup of MSDE 2000 Release A done and saved in my C:\MSDERelA\ folder.

    I tried to install a default instance configures to use Windows Authentcation Mode by executing:

    setup SAPWD="AStrongSAPwd"

    in the Command Prompt.

    My PC responded: Windows XP Setup

    Please go to the Control Panel to install and configure system components.

    I do not know what to do to get the system components of "MSDE 2000 Release A" configurated and have the MSDE 2000 Release A working in my PC!!!  Please help and advise me again.

    Let me tell you two more things: 

    (1) I tried to get Microsoft SQL Server 2000 Developer Edition installed in my PC before I did this MSDE 2000 Release A installation.  Now both "Microsoft SQL Server 2000 Developer Edition" and "MSDE 2000 Release A" are not successfully installed and configured in my PC.  Can these two SQL Servers co-exist and operate in my Windows XP Pro PC?  

    (2) I used the following to test SQL Server in my PC:  http://localhost/NorthDB/ch13_ex01.asp

    The latest result of this testing is listed below:

    The page cannot be displayed

    There is a problem with the page you are trying to reach and it cannot be displayed.

    Please try the following:

    • Click the Refresh button, or try again later.
    • Open the<script> </script> localhost home page, and then look for links to the information you want.

    HTTP 500.100 - Internal Server Error - ASP error

    Internet Information Services

    Technical Information (for support personnel)

    • Error Type:

      Microsoft OLE DB Provider for SQL Server (0x80004005)

      Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

      /NorthDB/ch13_ex01.asp, line 21

    • Browser Type:

      Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; AT&T CSM7.0; AT&T CSM8.0; SV1; .NET CLR 1.1.4322; .NET CLR 1.0.3705)

    • Page:

      GET /NorthDB/ch13_ex01.asp

    • Time:

      Monday, July 04, 2005, 2:06:34 PM

    • More information:

      Microsoft Support

      ////////////////////////////////////////

    Please help and respond/advise again.

    Thanks,

    Scott  Chang

  • July 4, 2005 at 1:34 pm

    #570740

    Theoritically, you can't have two instances with the same name.

    Step 1: Uninstall all the SQL Server instances, if got installed.

    Step 2: Install Developer Edition as the default instance.

    Step 3: Install the MSDERelA as the Named instance

    Use this command to install.

    setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

    Step 4: After installation, please check the services there are two SQLServer instances running.

    Step 5:Check the connection string of your asp page, to which instance it is pointing.

    Step 6: If you get the same error, Open the Enterprise Manager and register your SQL Server. Go to the Security Tab and make sure, the server accepts the mixed mode authentication. Attached the gif file for your consideration.

    Thanks,

    Ganesh

     

     

     

     

     

     

  • July 4, 2005 at 2:46 pm

    #570747

    Hi Ganesh,

    Thank you very very much for your valuable instructions.

    I am very new in the Microsoft SQL Server 2000 Developer Edition and MSDE 2000 Release A and I do not know what you mean by "the SQL Server instances" and whether the instances are got installed or not.  So I really do not know how to do the Step 1 of your instructions. 

    First of all, I do not know whether both the Microsoft SQL Server 2000 Developer Edition and MSDE 2000 Release A are correctly installed in my PC.  I went to my Control Panel => Add/Remove Programs, and I saw "Microsoft SQL Server 2000" and "Microsoft SQL Server 2000 Reporting Services Developer Edition". So I think that "Microsoft SQL Server 2000 Developer Edition" was installed but not correctly configurated in my PC yet and that "MSDE 2000 Release A" was not installed in my PC. Should I try to install the MSDERelA as the Named instance as you instructed in the Step 3 of your instructions?

    Please define the "instance" for me first and then tell me whether I should install the MSDERelA as the Named instance.  Furthermore, please guide me how to configure the Developer Edition as the default instance in my "upgraded" Windows XP Pro.

    Thanks again,

    Scott  Chang 

    P. S.  I can not read your attached .gif file.  Please reveal it in a different format if you can, after you help me the above-mentioned key things. 

     

  • July 4, 2005 at 3:12 pm

    #570752

    I should add the following to my last posted message:

    Services (Local)/Adminstrative Tools/Control Panel in my PC, I see the following:

    Name:       MSSQLSERVER      

    Description:   (Null-noting!)    

    Status:       started   

    Startup Type:  Automatic  

    LogOn As:   Local system

    ------------------------------

    Name:      MSSQLServerADHelp

    Descritipn:   (Null-noting!)    

    Status:     started

    Startup Type:   Manual

    LogOn As:   Local system.

    -----------------------------

    Ganesh,  hope this information is helpful to you.

    Thanks,

    Scott  Chang

  • July 4, 2005 at 10:11 pm

    #570776

    Scott,

    From your message I got to understand, you basically require a SQL Server Database connectivity for your ASP Pages. If Iam correct, proceed with the existing Developer Edition SQL Server itself.

    SQL Server Instance:

    The following link would be the best place for you to understand the concept.

    http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=29&rl=1

    All other questions can be clarified and fixed by the following link.

    http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp

    Note: Me writing a big story about all this technical things, may not make you to understand because of my english. Please do spend time to read those articles and you will understand and be able to fix the problem easily.

    The attached gif, I really meant the image getting displayed in my posting.

    I hope I tried my level best to solve your issue.

    Thanks,

    Ganesh

     

     

     

     

  • July 14, 2005 at 9:03 am

    #574438

    Hi Ganesh,

    I gained a little bits of understanding on the "named" instance of SQL Server.  But I have a question to ask you: Does the "Strong" in SECURITYMODE=SQL SAPWD="AStrongSAPwd" has any special meaning or rules to pich the name of SQL SAPWD?  Please respond. 

    Thanks,

    Scott  Chang

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply