Very Computer

When I try to use ADO/OLEDB to connect to a Server running Win2kServer
and SQL2k I get the following error message...

    Run-time error '-2147467259 (80004005)':
    Login failed for user 'TESTER'. Reason: Not associated with a
    trusted SQL Server connection.

The code is below, it fails on the .Open.

    conn.Provider = "SQLOLEDB"
    conn.Open "server=TESTSERVER; database=DBTest;"

I have looked in the knowledgebase and could not find any applicable
articles.

Additional Information

    - TESTER is the name of the Win98SE machine I am using to test from
       (and the user name that I use to log into this machine with)
    - TESTSERVER is the name of the server
    - I have installed MDAC 2.6 on TESTER and am using VB6
    - SQL2k Security is set to "Windows Only"
    - A user TESTER has being defined on the server
    - This user belongs to a group called TESTERS
    - This group has been added to SQL2k using Enterprise Manager
       under Security/Logons
    - db_datareader and db_datawriter roles have been permitted
       for the database DBTest for this group

Any ideas?

Thanks.

RichardF

Richard:

Try adding UserID and PWD (password) to your connect string, or create
whatever the win2k equivelent of NT SQLServer user accounts is. Without the
user id, sqlserver assumes you are using NTLogin authentication.

conn.Open "server=TESTSERVER; database=DBTest;USER ID=sa;PWD=xxxx"

Quote:> When I try to use ADO/OLEDB to connect to a Server running Win2kServer
> and SQL2k I get the following error message...

>     Run-time error '-2147467259 (80004005)':
>     Login failed for user 'TESTER'. Reason: Not associated with a
>     trusted SQL Server connection.

> The code is below, it fails on the .Open.

>     conn.Provider = "SQLOLEDB"
>     conn.Open "server=TESTSERVER; database=DBTest;"

> I have looked in the knowledgebase and could not find any applicable
> articles.

> Additional Information

>     - TESTER is the name of the Win98SE machine I am using to test from
>        (and the user name that I use to log into this machine with)
>     - TESTSERVER is the name of the server
>     - I have installed MDAC 2.6 on TESTER and am using VB6
>     - SQL2k Security is set to "Windows Only"
>     - A user TESTER has being defined on the server
>     - This user belongs to a group called TESTERS
>     - This group has been added to SQL2k using Enterprise Manager
>        under Security/Logons
>     - db_datareader and db_datawriter roles have been permitted
>        for the database DBTest for this group

> Any ideas?

> Thanks.

> RichardF

You can't authenticate to SS on Win98 through Winidows authentication
only SS

Allan

On Wed, 28 Feb 2001 13:41:27 -0600, "RichardF"

Allan, that's not true.  I have several machines authenticating through
Win98 to SS.  I am getting the same error on two machines.  "Not
associated with a trusted SQL server connection."  But I've set up 20
others and gotten through fine.  I first had two machines that wouldn't
connected, but I updated the Host and lmhost files and they connected
fine.  It was just timming out on.  I'm still troubleshooting this error.  
Let me know if you find a solution, Richard.

Curtis

--
Posted via CNET Help.com
http://www.help.com/