Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / Setup / January 2004

Tip: Looking for answers? Try searching our database.

Invalid Instance Name Error Installing MSDE Dot Net Framework 1.1 Samples

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian Morris - 28 Jan 2004 03:30 GMT
Background: Upgrading Visual Studio Enterprise Architect from 2002 to 2003;
SQL Server 2000 Developer Edition Installed; Previous Framework Install for
1.0 created MSDE instance \NetSDK.  Visual Studio Enterprise Architect 2003
is now installed and working.

To run the framework 1.1 samples requires a named instance of Microsoft SQL
Server 2000 Desktop Engine (MSDE).  I downloaded SQL2kDeskSP3.exe from
Microsoft.  When I ran the install it gave an error message about an invalid
instance name; I assume for the default install name of \NetSDK

I uninstalled both the SQLSERVER and the FRAMEWORK and then reinstalled
them.  Then I re-ran the SQL2KDeskSP3 install.  Again I got the same invalid
instance name.  In the program files for SQL Server there are directories
for each of the instances I have tried but the SQL Server Services Manager
doesn't recognize any of them.

My goal is to get the Framework 1.1 Samples working with a SQL SERVER
database.  I see four options:

1) install the new data load scripts into my base SQL Server and somehow
point the .NET Framework samples to use this instead of the \NetSDK
instance.  I think I have seen documentation for installing the files but I
don't know how to point the .Net framework samples to look for something
other than \NetSDK.

2) sucessfully create the \NetSDK instance by eliminating the cause of the
invalid instance name error; perhaps there are registry entries and
directories that need to be deleted

3) install a different instance name and rename it to the invalid instance
name \NetSDK; I don't know how to do this.

4) completely remove every reference to SQL Server and the .Net Framework
and start over; when all traces of SQL SERVER are gone from my machine,
should I install the MSDE first, and then SQL SERVER, or the SQL SERVER
first followed by the MSDE?

I also wonder if there is some kind of security catch-22 involved.  I know
Microsoft has increased security over the last few years.  I'm installing
the MSDE as the administrator of the machine but maybe the administrator is
not as powerful as he used to be without increasing his power.  I don't
know.

I also see a reference to the NetSDK on my other machine from the SQLSERVER
Services Manager but I no longer seem to be able to get rid of the
reference. I thought having a DIFFERENTMACHINE/NetSDK might be confusing the
install. I thought if I registered the SQL Server \NetSDK on the other
machine in Enterprise Manager  that when I unregistered it, it might remove
all references to it. But I don't seem to be able to do this anymore because
the SQL SERVER is not a "Trusted Connection" or something like that.

I have installed the MSDE several times over the past two years and it was
always a straight forward process. I don't know what is different now.

Thank you for your help.

Brian
Brian Morris - 28 Jan 2004 05:53 GMT
I solved the problem! I found a reference in some documentation to a net
start mssql$netsdk command (or something close to this). I ran it and I was
able to access the NetSDK instance from SQL Enterprise Manager.

Then I was able to run the scripts to load the data and I used Enterprise
Manager to add ASPNET as login and user for each of the sample databases.

I then was able to run the normal sample configuration program successfully
and my .Net Framework samples now access the database.

> Background: Upgrading Visual Studio Enterprise Architect from 2002 to 2003;
> SQL Server 2000 Developer Edition Installed; Previous Framework Install for
[quoted text clipped - 53 lines]
>
> Brian

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.