Monday, March 26, 2012

How to connect to my MSDE 2000 Rel A

Hi,

I only have Framework installed on my machine, and I also installed MSDE 2000 Rel. A, using the following command:
C:\MSDERelA\setup.exe SAPWD="myPass" INSTANCENAME="myXP"

I can see that the service for this app is running. Though, I could not connect to it using oSql command like the following:
osql -S(local)\myXP -E
or
osql -S(local)\myXP -Usa, and supply the password "myPass".

The message was:
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).

Any response would be appreciated.



Subi_IHave you tried
osql -L
to verify the instance name?

If that doesn't help you may also want to check out this link|||Hi McMurdo,

Thanks. The command did help to find my database (my initial post was wrong in specifying the instance name).
And the link really helps for managing MSDE without UI tools.

Thanks,



Subi_I

No comments:

Post a Comment