I installed client version of SQL 2000 to connect to my server
(I can connect to my server and access the database there).
I installed MSDE2000RelA on my Win ME PC. Installation all
went smooth,(no errors). How do I use MSDE now. In the
enterprise manager I dont see any reference to MSDE. Am
I missing something. pls help
Joy -
Here is what you need to do.
First thing first , the network libraries are not enabled in MSDE by default
if it is a NAMED INSTANCE. In order to enable the libraries -
- Go to the Server Network Utilities of SQL Server from the Start Menu.
- Select the MSDE Instance from drop down list
- enable Named Pipes, TCP-IP and Shared Memory
- highlight TCP-IP and go to its Properties.
- if MSDE is a default instance then set the port number to 1433, but if it
is not a default instance then set the Port Number to 0. This will enable
dynamic port allocation.
- apply the above changes.
- close all client tools including Enterprise Manager and Query Analyser
- restart MSDE
- after restarting , Open Enterprise Manager
- right click on the SQL Server Group Icon, and select NEW SQL SERVER
REGISTRATION.
- give the details of the MSDE Instance.
You should be able to see the MSDE Instance in the EM . try connecting to
MSDE from Query Analyser.
This should help.
Regards
Pragya
"Joy H" wrote:
> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help
|||Just to add to my previous posting, the MSDE by default does not get
registered in the Enterprise Manager. ...
"Joy H" wrote:
> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help
No comments:
Post a Comment