Groups | Blog | Home
all groups > sql server connect > october 2004 >

sql server connect : MSDE 2000 error


SqlJunkies User
10/29/2004 2:27:13 PM


1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Release A are the same.

2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe

3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a0dac778-60a6-4b11-8aa8-bf12261a303a&displaylang=en

3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server


3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?


4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?

5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as

[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).



---
Posted using Wimdows.net NntpNews Component -

Michael C
11/1/2004 11:23:04 AM
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?


[quoted text, click to view]
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
[quoted text, click to view]
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
[quoted text, click to view]
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
[quoted text, click to view]
supports Post Alerts, Ratings, and Searching.

AddThis Social Bookmark Button