Troubleshoot connecting client to SQL Server instance on a server

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am in the process of testing a SQL Server Express 2005-Access 2007
ADP initially created on a single-user desktop in a multiuser
environment, but cannot connect a test client.

This is the specific problem:
When I open the ADP file on the client, select "Server" from the menu
then "Connection," under "Select or enter a server name," the instance
I wish to connect to appears, as "SERVER\SQLEXPRESS"

After selecting this, leaving the default "Use Windows NT Integrated
security" option, when I go to "Select the database on the server,"
the following error occurs:

Title: Microsoft Data Link Error
Message: "Login failed for user ". The user is not associated with a
trusted SQL Server connection."

The server is simply a PC with an evaluation copy of Windows SBS R2
installed on a partition. The client (running XP SP2) is
successfully connected to the server itself. I believe I have
configured SQL Server Express on the server to accept client
connections. Specifically, via Surface Area Configuration, under
"Database Engine," the "Remote Connections" options are "Local and
remote connections" and "Using TCP/ICP only." The "SQL Server
Browser" the startup type is "Automatic" and the service status is
"Running"

In SQL Server Management Studio Express, the database is properly
attached. One problem I suspect may be causing or contributing to the
overall connection problem, however, is that I cannot seem to
specifically add a client user. Under the database in question, when
I select "Security" then "Users" and right-click on Users to select
"New User," I have not seemed to be able to enter a recognized "Login
name." If I click on the ellipsis (3 dots) and try "Browse" to look
for a matching logon, I only see entries relating to the server, but
none of the two test clients.

I have not been able to figure out the problem from previous posts,
Books On Line, or the books I have on hand.

Any insight would be so appreciated.

.

Relevant Pages

  • Re: .Net Scalability problem
    ... LoadRunner will peak out a server with a few virtual users. ... To get an idea of load, ... Fire off the test client and watch the number of ... > So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection lost at same time every hour (sometimes)
    ... After making the two following alterations on the server the problem seems ... After analyze your ipconfig on SBS and client, ... Then, other connection is good, ...
    (microsoft.public.windows.server.sbs)
  • Re: server disconnection - very often
    ... Reason of permanent popups is VMware server aplication on clients. ... Run CEICW to configure the network of SBS: ... Two network adapters - manual router connection to broadband ... Uninstall VMware on client. ...
    (microsoft.public.windows.server.sbs)
  • Re: Lan setup 2 nic
    ... The external nic only has TCP/IP enabled. ... Ipconfig of the server is looking good, but the client is still missing the ... > connection so we have a 2 nic with router setup now. ...
    (microsoft.public.windows.server.sbs)
  • Re: Regular disconnections from remote web workplace
    ... I can connect to office server and all office clients from home at all times ... be physically working right up until the connection is lost. ... If I enter http://companyip from a client I receive the login screen for the ... Click Services tab and select Hide All Microsoft Services and Disable ...
    (microsoft.public.windows.server.sbs)