SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Problems with running MSDE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nemaria
Starting Member

7 Posts

Posted - 04/21/2004 :  06:12:49  Show Profile  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 04/21/2004 :  06:24:14  Show Profile  Reply with Quote
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 - 04/21/2004 :  07:52:47  Show Profile  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 04/21/2004 :  08:06:05  Show Profile  Reply with Quote
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 - 04/21/2004 :  08:13:34  Show Profile  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 04/21/2004 :  08:34:17  Show Profile  Reply with Quote
You will also need to check you have sql security rather than windows security switched on by the looks of it...

Edited by - RickD on 04/21/2004 08:37:07
Go to Top of Page

nemaria
Starting Member

7 Posts

Posted - 04/21/2004 :  08:39:26  Show Profile  Reply with Quote
How do I do that?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/21/2004 :  08:43:07  Show Profile  Reply with Quote
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 - 04/21/2004 :  08:48:11  Show Profile  Reply with Quote
Sorry, where is Enterprise Manager?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/21/2004 :  08:52:36  Show Profile  Reply with Quote
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 - 04/21/2004 :  08:59:29  Show Profile  Reply with Quote
I have files dowloaded unpacked into
C:\sql2ksp3\MSDE
Is it it?
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/21/2004 :  09:05:46  Show Profile  Reply with Quote
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 - 04/21/2004 :  09:07:45  Show Profile  Reply with Quote
Thank you, I'll read it. Hope it will help.
Go to Top of Page

manuela
Starting Member

1 Posts

Posted - 05/02/2004 :  16:36:19  Show Profile  Reply with Quote
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

USA
1 Posts

Posted - 06/08/2004 :  09:58:59  Show Profile  Reply with Quote
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

India
3 Posts

Posted - 06/16/2004 :  01:31:46  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000