"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:uv76DiZZHHA.588@TK2MSFTNGP06.phx.gbl...
>I have an app that is on a small network. The backend is SQL Express 2005.
>The network is connected through a router without a server. Each of the
>computers on the network appear in the Explorer browser of the other
>computers -- they can share files and printers.
>
> However, when I try to add a login to the SQL Express (Security ->
> Logins -> Search), none of the other computers on the network are
> available when I click on the Locations button. Any advice on how to "see"
> the other Locations?
>
> The server is a named instance ("ComputerXXX\SQLExpress").
> Windows Authentication.
> Maximum concurrent connections (0).

"Paul Shapiro" <paul@hideme.broadwayData.com> wrote in message
news:%23hftbOaZHHA.3968@TK2MSFTNGP06.phx.gbl...
> If this is a workgroup and not a domain, then the only accounts SQL
> Express can use are the accounts on the computer where it's running. The
> easiest solution is creating the same accounts, with the same passwords,
> on all computers. Or at least put all the accounts on the SQL computer.
> Windows automatically tries to use the current username/password when
> connecting to another computer in a workgroup.
> Paul Shapiro
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:uv76DiZZHHA.588@TK2MSFTNGP06.phx.gbl...
>>I have an app that is on a small network. The backend is SQL Express 2005.
>>The network is connected through a router without a server. Each of the
>>computers on the network appear in the Explorer browser of the other
>>computers -- they can share files and printers.
>>
>> However, when I try to add a login to the SQL Express (Security ->
>> Logins -> Search), none of the other computers on the network are
>> available when I click on the Locations button. Any advice on how to
>> "see" the other Locations?
>>
>> The server is a named instance ("ComputerXXX\SQLExpress").
>> Windows Authentication.
>> Maximum concurrent connections (0).
>
>