error: use trust connect failure -urgent

i use visual studio.net 2003 version and when a progamme run , it told me

do not have trust connect .what is wrong ?how can I do to solute it?

We usually define trusted connection in web.congif like

<appSettings>

<addkey="connectionstring"value="server=localhost;Trusted_Connection=true;database=databaseNamw"/>

</appSettings>

In database users --> Add ServerName\ASPNET account.

That will create trusted connection for the application.

|||

i did as you told me.but it occurs new error as follows:

" database" server of application error.

abnormity particular information: system.data.sqlclient.sqlexception"BUSA_QFDKDIEDKDJ" landing fail.

BUSA_QFDKDIEDKDJ is my server name.

|||

Hi,

I have made little web application to show you how to add user in DB with trusted connection. The DB backup is in the TestDB folder called DB backup. Make Virtual directory and browse it to TestDB folder and Restore backup in MyDB (Create it). Here is link

http://www.riseofkingdoms.com/TestDB.rar

Hope it will work. Change the server name in the string like

<appSettings>

<addkey="connectionstring"value="server=BUSA_QFDKDIEDKDJ;Trusted_Connection=true;database=MyDB"/>

</appSettings>

|||

Hi:

I change the server name ,but it doesn't work. and i am a new proqrammer,and dosen't know much, can you say easily.

|||

i use Query Decomposition to land with trusted connection,and it success.but why

it can't work in the asp.net

|||it occurs the same error.|||

Hi,

You might try checking your SQL Server - make sure you select 'Mixed' security which allows SQL Server login & password to substitute for a trusted connection.

Good luck!

|||

I change the security for 'mixed' security ,but it

occurs error: trusted connection failed.and mayby

sql server's error,because when i use Query Decomposition to land with sa and no password

,bbut it failed .what is wrong?could anyone help?

|||what's wrong ?could anyone help?|||

This problem may be due to the way you have defined your Shared Datasource. Have you stored the login Credentials or used the prompt for login option?

If you used the latter you might want to change to the store credentials option. Hope this helps

|||That's all right.Aftar I select 'Mixed' security ,I didn't restart the computer.