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).

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 (AT) newsgroups (DOT) nospam> wrote

I'll give that a go. Thanks for the advice Paul. I'll let ya know how that
turns out.

"Paul Shapiro" <paul (AT) hideme (DOT) broadwayData.com> wrote

Paul,

This indeed was a good first step. Alas, there were many more steps that I
had to take in order to get connectivity. I'm going to begin a new post
asking for inquiries as to whether I took the correct approach and whether I
did anything needlessly. Thanks for the advice about the workgroups.


"Paul Shapiro" <paul (AT) hideme (DOT) broadwayData.com> wrote