"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:52c5o2F1o3mquU1@mid.individual.net...
> hi Marcel,
> Marcel Kränzle wrote:
>> Hi there,
>>
>> I hope that I've an easy question. I've 2 pc's, one with MSDE and one
>> without. Now I want to use the msde from the pc without msde. But I
>> can't connect to database. In the configuration I found no option to
>> enable an external access. How can I enable an external access? Both
>> pcs are in the same workgroup.
>
> MSDE installs by default disabling network protocols and thus supporting
> local connections only..
> you can modify that behaviour at install time, specifying the
> DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrap installer,
> or later, at "run time" executing the Server Network Utilities
> (svrnetcn.exe) and enabling the required network protocol(s)..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> --------- remove DMO to reply
>

Marcel Kränzle wrote:
> Hi there,
>
> I hope that I've an easy question. I've 2 pc's, one with MSDE and one
> without. Now I want to use the msde from the pc without msde. But I
> can't connect to database. In the configuration I found no option to
> enable an external access. How can I enable an external access? Both
> pcs are in the same workgroup.

> How did you try to connect ? Did you install a named instance or a
> default one ? Which port did you have assigned to the service (Default
> is 1433). Using a workgroup you should use SQL Server authentication,
> did you specify a user name and a password upon connection time / in
> the connection string ? did you configure MSDE for Mixed
> authentication (See the screencast on my site for getting more
> information of switching the authentication mode)
>
> HTH, Jens K. Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>