The user is not associated with a trusted SQL Server connection.

jun jun

Hi Forumers! I been working on this for an hour right now.. Where did I go wrong The first I error I got is to allow my SQLExpress connected remotely, and I did and after running my work the error message say something like this:

Login failed for user 'asmt_admin'. The user is not associated with a trusted SQL Server connection.

Tnx in advance..

Barbi

is "asmt_admin" local or domain user

jun jun

Hi Barbi, yes asmt_admin is domain user.. and one thing, i had 3 databases that asmt_admin uses: asmt_admin, asmt_porta and asmt_users. is there any things that i need to configure pls tell me.

tnx!

Paul P Clement IV

Is this a Windows Forms or a Web application

jun jun

a web application...

and whenever i create a user, i noticed that the user's password changed. and when i login, it prompts a message 'the user is not associated with a trusted SQL Server connection.'

William Vaughn

Let's see your ConnectionString.

Note that you can connect to a SQL Server using Windows authentication (Integrated Security=SSPI) or SQL Server authentication (where you provide a hard-coded UID and PWD). In an ASP application if you use SSPI authentication, you need to setup rights for the IIS account (which vary based on the version of IIS). IIS 7 uses IUSR_<machinename> so you need to grant rights to the target database using SQL Server Management Studio (Express). If you've configured SQLEXPRESS to permit SQL Server (mixed mode) authenication, you need to create a user account and (again) grant rights to the target database.

See Chapter 9 of my book or get started with the whitepaper on connecting on my blog. www.betav.com/blog/billva

hth

jun jun

tnx!.. i got it now.