Mestre wrote:
> Hi,
>
> I have 2 PCs that aren't in any domain.
>
> One of PCs, have installed on MSDE. I change the authentication
> mode from windows to mixed mode.
> Created users inside MSDE.
>
> In the PC with MSDE I can enter with all users, but in the other PC I
> could not connect to the server.
>
> I tried to register in Enterprise Manager that MSDE instalation and I
> get the following error
>
> ---------------------------
> SQL Server Enterprise Manager
> ---------------------------
> SQL Server registration failed because of the connection failure
> displayed below. Do you wish to Register anyway?
>
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> ---------------------------
> Yes No
> ---------------------------
>
>
> I already add the TCP 1433 and UDP 1434 ports to windows firewal, I
> tried to with the firewall disconected and i get always the same
> error.
> So I think the problem could be in permissions, but how can I set
> permisons in one computer to a user from another computer. Don't
> forget that the pcs aren't in any domain.
>
> Or how can I put on PC connecting to the MSDE in the other PC?

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:4271egF1hrbv5U1@individual.net...
> hi Mestre,
> Mestre wrote:
>> Hi,
>>
>> I have 2 PCs that aren't in any domain.
>>
>> One of PCs, have installed on MSDE. I change the authentication
>> mode from windows to mixed mode.
>> Created users inside MSDE.
>>
>> In the PC with MSDE I can enter with all users, but in the other PC I
>> could not connect to the server.
>>
>> I tried to register in Enterprise Manager that MSDE instalation and I
>> get the following error
>>
>> ---------------------------
>> SQL Server Enterprise Manager
>> ---------------------------
>> SQL Server registration failed because of the connection failure
>> displayed below. Do you wish to Register anyway?
>>
>> SQL Server does not exist or access denied.
>> ConnectionOpen (Connect())
>> ---------------------------
>> Yes No
>> ---------------------------
>>
>>
>> I already add the TCP 1433 and UDP 1434 ports to windows firewal, I
>> tried to with the firewall disconected and i get always the same
>> error.
>> So I think the problem could be in permissions, but how can I set
>> permisons in one computer to a user from another computer. Don't
>> forget that the pcs aren't in any domain.
>>
>> Or how can I put on PC connecting to the MSDE in the other PC?
>
> please have a look at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql
> for the most common causes of this exception.. and of course please verify
> that remote access to the instance is enabled with the Server Network
> Utility (svrnetcn.exe) as MSDE installs by default disabling all network
> protocols...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>