|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Express on a small network
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 Show quoteHide quote "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). I'll give that a go. Thanks for the advice Paul. I'll let ya know how that
turns out. Show quoteHide quote "Paul Shapiro" <p***@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). > > 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. Show quoteHide quote "Paul Shapiro" <p***@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). > >  
Other interesting topics
query
Problem starting up databases Trace flags for deadlock detection on startup. Second Instance os SQL 2005? Deadlocks in the error log Backup log isn't overwritten in SQL Server 2005 Full Backup DB is too large of DB & TL Backup copy_only on 2000 Service account authentication cache How to setup SQL Mail on SQL 2005 express |
|||||||||||||||||||||||
