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 2005 Forums
 Transact-SQL (2005)
 odbc connection

Author  Topic 

rjhe22
Constraint Violating Yak Guru

283 Posts

Posted - 2010-02-25 : 06:06:41
hi
im tring to creat an odbc connection on a pc but keep getting this error

connection failed
sql 28000
sql server error 18452
user is not associated with a trustedconnection.
anyone any ideas why this is happening

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-02-25 : 07:49:14
Hi,

You get this error when you select the option "With windows NT authentication using the network login id" while creating odbc connection and your login don't have privelage to access the SQL Server.

Make sure that your windows login id has permission to access the SQL server (against which you want to create odbc connection) or use the other mode "Use SQL Server Authn......".

Regards,
Bohra
Go to Top of Page
   

- Advertisement -