RE: old question about login, but no help from the existing threads

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 06/07/05


Date: Tue, 7 Jun 2005 09:46:02 -0700


> - Windows Authentication only

osql -d adventureworks2000 -E

AMB

"man-in-nature" wrote:

> osql -d adventureworks2000 -U admin -P admin
>
> Login failed for user 'admin'. Reason: Not associated with a trusted SQL
> Server connection.
>
> My system and configurations:
>
> - Winxp + sp2
> - mssql developer edition + sp3a
> - Windows Authentication only
> - Local System Account is used to start the sql instance
> - admin/admin is the administrator account to login to the xp box
> - admin/admin was added to "SQL Server Group/[Machine Name]/Security/Logins"
> with the database access and all database role assigned to the database in
> question.
> - admin/admin was added to "Databases/[database in question]/Users, with
> Permit in Database Role all checked.
>
> Am I missing anything?
>
> Thanks
>