Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Problems with running MSDE

Author  Topic 

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 06:12:49
Hello!

I've downloaded msde. While trying to run the following file: setup.exe, I get the following message: "The instance name specified is invalid". Please help. I want to run MSDE.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 06:24:14
Sounds like you've downloaded the service pack rather than msde itself...

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

The .exe to download is at the bottom of the page.
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 07:52:47
Message Preview
Thanks a lot! I made a mistake, running the setup.exe file without the parameters: instance name(in my case, it's "localhost", right? Or something else? How can I know what instance name to set?) and password. The setup runs ok. Now I have another problem. I try to install Buy Spy portal. To do that I'm asked to run aIBuySpySetup.exe file, in order to "configure the web virtual root and install the database for the sample". I'm asked to "choose a database server instance on the local machine, then click configure". The default Database server instance I can choose is "localhost".
But when I try to "configure", I get the following log file:
"14:33:38 éåí øáéòé 21 àôøéì 2004: [Checking system requirements]
14:33:38 éåí øáéòé 21 àôøéì 2004: [Pass] Detected the NetSDK version of MSDE.
14:33:38 éåí øáéòé 21 àôøéì 2004: [Pass] Determined SQL Server version (8.00.194).
14:33:38 éåí øáéòé 21 àôøéì 2004: [Pass] Detected .NET Framework.
14:33:38 éåí øáéòé 21 àôøéì 2004: [Pass] Detected Internet Information Server (IIS).
14:33:39 éåí øáéòé 21 àôøéì 2004: [Begin Sample Configuration]
14:33:39 éåí øáéòé 21 àôøéì 2004: [Pass] Created IIS virtual directory.: PortalCSVS
14:33:39 éåí øáéòé 21 àôøéì 2004: [Pass] Determined SQL Server version (8.00.194).
14:33:54 éåí øáéòé 21 àôøéì 2004: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
14:33:54 éåí øáéòé 21 àôøéì 2004: [Done]"

What can I do? Please help.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 08:06:05
I think you need the developers edition of SQL Server to create the DB's and any security you require on the server, then you can deploy using msde...


http://www.microsoft.com/sql/msde/default.asp
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 08:13:34
I've got it or maybe the earlier version of MSDE. DB server is running. But there is still the problem.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 08:34:17
You will also need to check you have sql security rather than windows security switched on by the looks of it...
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 08:39:26
How do I do that?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 08:43:07
Open Enterprise Manager, right click your server registration, go to the security tab and change the authentication mode...
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 08:48:11
Sorry, where is Enterprise Manager?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 08:52:36
You do have the developers edition of SQL Server don't you???

If not, as I said before, you need to get it...
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 08:59:29
I have files dowloaded unpacked into
C:\sql2ksp3\MSDE
Is it it?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-04-21 : 09:05:46
This article will tell you what you need to do...

http://support.microsoft.com/default.aspx?scid=kb;en-us;325022
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 2004-04-21 : 09:07:45
Thank you, I'll read it. Hope it will help.
Go to Top of Page

manuela
Starting Member

1 Post

Posted - 2004-05-02 : 16:36:19
quote:
Originally posted by nemaria

Hello!

I've downloaded msde. While trying to run the following file: setup.exe, I get the following message: "The instance name specified is invalid". Please help. I want to run MSDE.



Hello Nemaria,

I have exactly the same problem. Have you solved it yet?
It would be nice, if you will write me what you've done.

Thanks,
manuela
Go to Top of Page

pelikan
Starting Member

1 Post

Posted - 2004-06-08 : 09:58:59
check out this help file for correct usage of setup.exe

http://msdn.microsoft.com/library/?url=/library/en-us/distsql/distsql_84xl.asp?frame=true

In parvum multum
Go to Top of Page

mangeshtambde
Starting Member

3 Posts

Posted - 2004-06-16 : 01:31:46
I want to know how create new database in MSDE and
Steps in details to transfer sql server 7 database to msde2000
Go to Top of Page
   

- Advertisement -