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
 General SQL Server Forums
 New to SQL Server Programming
 connection issue

Author  Topic 

pksarada
Starting Member

1 Post

Posted - 2010-01-09 : 17:52:16
SQL Error

Source Logon

Message
Login failed for user 'sa1'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]
Message
Error: 18452, Severity: 14, State: 1.


Informatica connection issue
Starting Repository [REPOSITORY1]
(4652|5148) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.
(4652|5148) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.
(4652|5148) Informatica Repository Agent starting up.
(4652|5148) Security audit trail has been turned off.
(4652|5148) REPOSITORY1: Repository runtime manager initialized.
(4652|5148) REPOSITORY1: Initialized configuration information.
(4652|5148) REPOSITORY1: Initialized request dispatcher.
(4652|5148) Database Connection Error : Failed to logon to Database server
SQL State: 08001 Native Error: 17
State: 1 Severity: 16
SQL Server Message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [<Database_User>] and connection string [<connect_string>].
(4652|5148) Service stopped.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-09 : 18:09:06
Sounds like you are trying to connect with SQL authentication but you are only configured for Windows authentication. Switch to mixed-mode security by right clicking on the server in SSMS, properties, and then to security.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2010-01-10 : 10:09:29
After that you will have to restart the SQL Services.
Go to Top of Page
   

- Advertisement -