Posted by Erland Sommarskog on 08/22/06 07:55

Ted (r.ted.byers@rogers.com) writes:
> 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.

That means that the server is not configured for SQL authentication.

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

Windows authentication is a difficult thing to get working in a workgroup.
I have not been successful with my machines at home.


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

• Next in forum: Re: SQL Server 2005 Opening Script File Problem
• Prev in forum: Re: Problem with SELECT
• Thread view: Re: User authentication

[Reply to this message]