Login Problem for SQL

When i run my project in my computer all is OK, but when i upload files to the server i got this error:

Login failed for user 'NS1\IWAM_plesk(default)'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NS1\IWAM_plesk(default)'.
Source Error:

Line 51: body.value=iBody
Line 52: pdate.value=#2/2/2003#
Line 53: conn.Open()
Line 54: comm.ExecuteNonQuery()
Line 55: conn.Close()

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

i tryed both of these connection strings, but the same error!

1)

Code Snippet

<connectionStrings>
<add name="MaysamDB" connectionString="data source=(local);database=databasename;uid=username;pwd=password;trusted_connection=yes"
providerName="System.Data.SqlClient" />
</connectionStrings>

2)

Code Snippet

<connectionStrings>
<add name="MaysamDB" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|databasename.mdf;User Instance=true;user id=username;password=password;"
providerName="System.Data.SqlClient" />
</connectionStrings>

Web Data Adminstrator, Microsoft SQL Server 2005 - 9.00.3042.00. installed on the server, CPanel is Plesk 8.1.

trusted_connection=false not trusted_connection=yes

1)

Code Snippet

<connectionStrings>
<add name="MaysamDB" connectionString="data source=(local);database=databasename;uid=username;pwd=password;trusted_connection=false"
providerName="System.Data.SqlClient" />
</connectionStrings>

||| i did it, but the same error!!!
|||

Your login looks like a server not a logon name unless you have something other than a default instance.

just use "IWAM_plesk" as the logon

Is your login correct?

Adamus

|||hey guys, thanks all, i was maked a mistake! i thought my page read coonction string from web.config, but when i saw its source, i was declared concetion string in the page_load with wrong username and password!!!!
sorrrrrry for this f**king question!
all is ok now!