General information
Forum:
Microsoft SQL Server
You need to enable the network protocols of the msde they are disabled by default when you install it.
Have you got EM on the SQL box? If so right click on the instance of the MSDE Instance and click properties then Network Configuration. Ensure TCP\IP and or Named Pipes are selected as enabled protocols.
This should do it.
Jon
>Hi,
>
>I installed SQL Server 2000 in a box (machine name 'SQL') on the network and I can connect to it no problem from my laptop. I created a registration 'SQL' to it in Enterprise Manager in my laptop. Then I installed MSDE in that box 'SQL\MSDEDB' but I can't connect to it from enterprise manager in my laptop. I try to register with 'SQL\MSDEDB' but no success.
>
>I happen to have Enterprise manager in the box where I installed MSDE (b/c of the SQL 2000 installation) also so I registered there with 'SQL\MSDEDB' and it registered successfully.
>
>Any ideas why I can't connect to the MSDE database but I can to the SQL 2000 Database on the same box?
>
>Thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only