Error 18452

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I keep getting this error when trying to log in to a SQL 7 db from a client application written in VB6.

The text reads:

Login failed for user 'rmuser'. Reason: Not associated with a trusted SQL Server connection.

I have the account setup in SQL security and I have the account listed in the database and I'm using named pipes on a common domain. I'm running out of options. The network is a mix of Novell and NT. Please help

-- Anonymous, February 17, 2000

Answers

Mike,

I have a couple of suggestions. First, make sure that the server is using mixed mode security. You can do this using Enterprise Manager.

To set up Mixed Mode Security

Expand a server group.

Right-click a server; then click Properties.

Click the Security tab.

Select SQL Server and Windows NT.

Second, you may find that you need to use TCP/IP instead of named pipes.

Hope this helps,

Eric

-- Anonymous, February 23, 2000


Another resolution for this is check the server of the Enterprice Manager. The user login maybe locked out on this side. Unlock your login here and try to access the client application again.

-- Anonymous, April 02, 2004

Moderation questions? read the FAQ