Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL SERVER 2000 login

Author  Topic 

tedew
Starting Member

22 Posts

Posted - 2005-10-30 : 09:03:10
hello,
I created user , I gave to him name and password .
But I Can't login to the server.

and this is the error from the Query Analyzer:
Not associated with a trusted SQL Server Connection

????

bye,
sorry for my english

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-10-30 : 14:24:27
How are you trying to connect to the SQL Server? If it's through an application, post the connection string. You might want to check out www.connectionstrings.com.



MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

tedew
Starting Member

22 Posts

Posted - 2005-10-31 : 03:36:07
hello:)
I'm traying to connect by SQL SERVER AUTHENTICATION for example to the Query Analyzer.

I'd love to connect by Windows Authentcation to the SQL SERVER but this is impossible in this communication:

A -> b -> c

I am login on the Compueter A ( to domain ) and run the Internet Expolrer , then I connect to the Computer B (in doamin too) and Computer B try connect to the Computer C (in domain too) .
Is it possible that in all this communication will be use windows authentication ??? all the computers are in the same domain - but computer B and C are always log off
When I move the webapp on the Computer A and I'm Logged to the domain and I have on the Computer A IIS then webapp works fine ( it's access to the SQL SEVER by the Windows Authentication ) , when I move webapp on the Computer B and I run the webapp from Computer A then I have no access to the SQL SERVER - there's no access to the SQL Server there's no windows authentication - only when I'm logged to the domain on the Computer B a run webapp on this Computer B

Go to Top of Page
   

- Advertisement -