Posted by Ted on 08/21/06 23:11

Erland Sommarskog wrote:
> Ted (r.ted.byers@rogers.com) writes:
> > I have figured out how to use MS SQL Server Management Studio for SQL
> > Server 2005, including how to create users.
> >
> > At my client's offices, on my own LAN (a one man office with two
> > computers in a peer to peer LAN - machines running the professional
> > edition of WXP), and on my colleagues computers (stand alone
> > notebooks), SQL Server was installed allowing both local and remote
> > connections, and support for both Windows and SQL Server
> > authentication.
> >
> > At my client's offices, both local and remote connections work. On our
> > respective notebook computer/workstations only local connections work,
> > unless we're connecting to our client's network, in which case remote
> > connections work.
>
> I take it that at your client there is a domain controller, while your
> and your colleague's LAN is only a workgroup? Things are usually much
> easier with a domain. Myself, I can connect to SQL Server on my
> machines, but I yet to figure out how to mount discs.
>
That's right. The MIS there has set up three domains, and created
credentials for each of us in one of them.

> > 1) With regard to local connections on our notebooks, I can connect to
> > the default server using SQLCMD without specifying any command line
> > arguments, while my colleages have to specify at least the machine and
> > server name. I don't understand why.
>
> Is he running SQL Server on port 1433? And does really have a default
> instance?
>
This I don't know, but can check tomorrow.

> > 2) On my peer to peer LAN, MS SQL Server Management Studio can not find
> > the other machine that is running SQL Server, and using SQLCMD, I can't
> > connect to the other server when I provide the proper credentials for a
> > user I set up on it to use SQL Server authentication. What should I
> > look at in order to find out why this is and how to fix it?
>
> What happens when you connect? Do you get a message that login failed,
> or a message that indicates that the server was not found at all?
>
Specifying my UID/pwd along with the workstation's name (parameters -U,
-P, and -H) as arguments for SQLCMD, I get the following error message:

Msg 18452, Level 14, State 1, Server TEDSNEWACER, Line 1
Login failed for user 'TByers'. The user is not associated with a
trusted SQL Server connection.

I can not connect at all using SQL Server Management Studio. It does
not see the other workstation at all, and so I can't add a user,
defined on the other workstation, using it and configure it to use
Windows authentication.

> Can you reach the machine for other operations, for instance to mount
> network drives?
>
Yes. It appears in 'My Network Places', and I can easily move files
between the machines.

> What about any firewall?
>
There are software firewalls on both machines, as well as a hardware
firewall on the router.

Thanks

Ted

[Back to original message]