NETSDK - where'd it go? - SQL Server Forums

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

SQL Server Administration (2000)

NETSDK - where'd it go?

Author

Topic

Shogun
Starting Member

9 Posts

Posted - 2003-11-30 : 18:11:21

Hi guys,

I feel kinda stupid about this question, and I'm a little confused, but here goes.

I'm running XP pro with SQL Server 2k Personal Edition with the default instance - <computername>.

I purchased the Visual Studio, Standard Visual Basic.NET development package, and found the standard edition wouldn't connect to SQL Server 2k PE, but would connect to the <computername>\NETSDK instance.

Anyhow, somehow the <computername>\NETSDK instance was available for registration in Enterprise Manager and I registered it successfully. Since then I've been creating all my DBs in the <computername>\NETSDK instance and everything has been running smoothly.

Until... two days ago when my system crashed and I had to reinstall the O/S.

Good news is I have backups of all my databases.

Bad news is that I can't remember how I installed the <computername>\NETSDK instance. I know I didn't simply add an instance. I thought it was added automatically with the installation of another program. I thought it happened when I installed Visual Studio, but it's not there.

I need to be able to get this back so I can restore my dbs, particularly the msdb so I can get my DTS packages running again, and so my VB app can connect to my database.

Any suggestions please?!!

Thank you.

Shogun

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-11-30 : 18:25:47

Hiya

Have a look in : C:\Program Files\Microsoft.NET\FrameworkSDK\Samples\Setup\msde

You should find the installer there.

Damian

Shogun
Starting Member

9 Posts

Posted - 2003-11-30 : 18:33:40

Hi Damian,

Thanks for the quick reply.

The FrameworkSDK folder is missing. I guess I didn't install the samples this time? Visual Studio takes so long to install. Is there an easy way that you know of please?

Thanks,

Shogun

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-11-30 : 18:38:52

Go back into VS.NET setup, find the option to add or remove components. I'm sure you will find an option in there to install the SDK.

Damian

Shogun
Starting Member

9 Posts

Posted - 2003-11-30 : 19:29:20

Hi again,

I went back to the setup like you suggested and found that all samples are in fact installed at the following dir.

C:\Program Files\Microsoft Visual Studio .NET 2003\Setup\MSDE

However, the MSDE is not. In the MSDE folder, there is an HTML file with the following link that says the MSDE must be downloaded.

(http://go.microsoft.com/fwlink/?linkid=13962)

I downloaded the file "sql2kdesksp3.exe" as instructed, followed the instructions on the Microsoft page and I get a dialog box when it's run from the command prompt that says...

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

Under Administration Tools in Control Panel, there are new Icons.

1) Microsoft .NET Framework 1.1 Configuration

AND

2) Microsoft .NET Framework 1.1 Wizards

The first launches the Snap-In for the .NET 1.1 Framework with the following tree-list.
- Assembly Cache
- Configured Assemblies
- Remoting Services
+ Runtime Security Policy
- Applications

And the wizards just point me back to this stuff in a wizard format. This doesn't seem to be ringing any bells to me. Am I way off here?

Any suggestions? Thanks.

Shogun

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-11-30 : 19:40:05

Fun fun

I don't think the framework wizards are what you want.

Did you try my suggestion ?
Go to control panel - > Add / Remove Programs ->VS.NET 2003 ->Change / Remove

That should run the setup program. In there you should find an option to add or change components.

Failing that, on your VS.NET disk you should have the Framework SDK installer. Just try running that and reinstalling the framework SDK. If you don't have the installer, you can download it from MSDN.

Damian

Shogun
Starting Member

9 Posts

Posted - 2003-11-30 : 20:01:55

Uh oh.

Yep, did what you said. It completely removed the .Net Framework.

So I reinstalled it, but it gives no options to install components. It just says it's gonna install Microsoft .NET Framework 1.1, which it did. But still no MSDE.

Hmmmm....

Shogun
Starting Member

9 Posts

Posted - 2003-11-30 : 20:38:39

Ok, I've gone back to the downloaded sql2kdesksp3.exe. I've stopped the SQL Server services, and run it again from the command line.

setup.exe/qb+INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD="MyPwd"

The installer starts and then I get a dialog that says...

"The instance name specified is invalid."

And the installer terminates and says

"Microsoft SqlServer Desktop Engine Setup Failed."

I'm not sure if I should be including quotation marks when specifying passwords, instances, etc. I've tried a number of ways but no luck...

I'm guessing my command line is not correct?

Shogun
Starting Member

9 Posts

Posted - 2003-12-01 : 01:22:17

Hi guys,

Damian - Thanks so much for your help so far.

Here is where I'm at. Sorry to be a pain in neck...

I've successfully installed MSDE. I rebooted and tried again from the command prompt and it is installed as an instance, and running as a service - MSSQL$VSDOTNET

However, I still cannot register it with Enterprise Manager. It doesn't appear in the list of available servers. All that is shown is the default (local) which installed with SQL Server 2k.

Of course it doesn't appear in the Service Manager either. When I manually type in the name of the instance in the Service Manager it gives me the "server doesn't exist or access is denied" message. Both SQL server and MSDE are running as services under my login account name and password.

I'm not sure where to go from here. Any suggestions please?

Thank you.

Shogun

Shogun
Starting Member

9 Posts

Posted - 2003-12-01 : 02:32:38

Finally!

Someone please tell me why the Server Network Utility recognizes the name/path of the server (which you need to register your MSDE instance) and the server registration dialog box does not?!

Of course I had made a simple mistake in typing the path to register the instance of MSDE with the SQL Server, hence the registration errors.

All fixed now.

Sorry for all the posts!

Shogun

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources