Posted by Erland Sommarskog on 08/21/06 21:49

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.

> 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?

> 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?

Can you reach the machine for other operations, for instance to mount
network drives?

What about any firewall?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]