SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Scott H. Chang
Scott  H.  Chang
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1612 Visits: 65

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


babuganesh2000
babuganesh2000
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2540 Visits: 825

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

Thanks,
Ganesh





Scott H. Chang
Scott  H.  Chang
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1612 Visits: 65

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


babuganesh2000
babuganesh2000
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2540 Visits: 825

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







Scott H. Chang
Scott  H.  Chang
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1612 Visits: 65

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.


Scott H. Chang
Scott  H.  Chang
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1612 Visits: 65

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


babuganesh2000
babuganesh2000
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2540 Visits: 825

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





Scott H. Chang
Scott  H.  Chang
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1612 Visits: 65

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search