Friday, March 23, 2012

MSDE 2000 error

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/d...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/d...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 -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
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?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 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/d...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/d...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 -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

No comments:

Post a Comment