|
|
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
Navigation:
[Reply to this message]
|