Problem with database (Login failed for user 'X')

[Ramtin]

Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've been
granted ASPNET user in sql.

[Jacek Stawicki]

U¿ytkownik "Ramtin" <Ra****@discuss ions.microsoft. comnapisa³ w wiadomo¶ci
news:EF******** *************** ***********@mic rosoft.com...

Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've
been
granted ASPNET user in sql.

Give us more data. Some line with error description, line with code etc.
There are many possible reasons.
--
JS
BRE Bank Dev Team, Poland

[Ramtin]

Hi;
Thanks for your attention.I have not any problem with windows
application.the exact message that I recieve in web application is this:
(some description is below)
Server Error in '/Temp' Application.
--------------------------------------------------------------------------------

Login failed for user 'sa'.
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.Sql Client.SqlExcep tion: Login failed for user
'sa'.

Source Error:
Line 30: if(!IsPostBack)
Line 31: {
Line 32: sqlConnection1. Open();
Line 33: sqlDataAdapter1 .Fill(dataSet11 );
Line 34: DataGrid1.DataB ind();
Source File: c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs Line: 32

Stack Trace:
[SqlException: Login failed for user 'sa'.]
System.Data.Sql Client.Connecti onPool.CreateCo nnection()
System.Data.Sql Client.Connecti onPool.UserCrea teRequest()
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Temp.WebForm1.P age_Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs:32
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

This occurs when I use local sql server.when I use other sql server on the
network I give "server is not exist" message.I follow this steps:
1) I create a sqlconnection 2)I set a sql statement in a data adapter
3)generate a data set 3)in page load event I add above codes.
"Jacek Stawicki" wrote:

>
U¿ytkownik "Ramtin" <Ra****@discuss ions.microsoft. comnapisa³ w wiadomo¶ci
news:EF******** *************** ***********@mic rosoft.com...

Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've
been
granted ASPNET user in sql.

Give us more data. Some line with error description, line with code etc.
There are many possible reasons.
--
JS
BRE Bank Dev Team, Poland

[cannontrodder]

You are trying to connect using SA as the user. Try to connect using
sql management studio or query analyser using sql authentication.

Note: it's not a good idea AT ALL to connect using the sa account.
ASP.NET applications run under a particular username (in my case
ASPNET). It's best to use windows authentication and grant access to
the unprivileged account that asp.net applications run under.
Ramtin wrote:

Hi;
Thanks for your attention.I have not any problem with windows
application.the exact message that I recieve in web application is this:
(some description is below)
Server Error in '/Temp' Application.
--------------------------------------------------------------------------------

Login failed for user 'sa'.
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.Sql Client.SqlExcep tion: Login failed for user
'sa'.

Source Error:
Line 30: if(!IsPostBack)
Line 31: {
Line 32: sqlConnection1. Open();
Line 33: sqlDataAdapter1 .Fill(dataSet11 );
Line 34: DataGrid1.DataB ind();
Source File: c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs Line: 32

Stack Trace:
[SqlException: Login failed for user 'sa'.]
System.Data.Sql Client.Connecti onPool.CreateCo nnection()
System.Data.Sql Client.Connecti onPool.UserCrea teRequest()
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Temp.WebForm1.P age_Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs:32
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

This occurs when I use local sql server.when I use other sql server on the
network I give "server is not exist" message.I follow this steps:
1) I create a sqlconnection 2)I set a sql statement in a data adapter
3)generate a data set 3)in page load event I add above codes.
"Jacek Stawicki" wrote:

U¿ytkownik "Ramtin" <Ra****@discuss ions.microsoft. comnapisa³ w wiadomo¶ci
news:EF******** *************** ***********@mic rosoft.com...

Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've
been
granted ASPNET user in sql.

Give us more data. Some line with error description, line with code etc.
There are many possible reasons.


--
JS
BRE Bank Dev Team, Poland

[Ramtin]

Hi; The sa user is for example I'd been using so many different users.But
finally I use the other post and solve my problem.I must add UID and PWD in
connection string

Thanks for your attention
"cannontrod der" wrote:

You are trying to connect using SA as the user. Try to connect using
sql management studio or query analyser using sql authentication.

Note: it's not a good idea AT ALL to connect using the sa account.
ASP.NET applications run under a particular username (in my case
ASPNET). It's best to use windows authentication and grant access to
the unprivileged account that asp.net applications run under.
Ramtin wrote:

Hi;
Thanks for your attention.I have not any problem with windows
application.the exact message that I recieve in web application is this:
(some description is below)
Server Error in '/Temp' Application.
--------------------------------------------------------------------------------

Login failed for user 'sa'.
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.Sql Client.SqlExcep tion: Login failed for user
'sa'.

Source Error:
Line 30: if(!IsPostBack)
Line 31: {
Line 32: sqlConnection1. Open();
Line 33: sqlDataAdapter1 .Fill(dataSet11 );
Line 34: DataGrid1.DataB ind();
Source File: c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs Line: 32

Stack Trace:
[SqlException: Login failed for user 'sa'.]
System.Data.Sql Client.Connecti onPool.CreateCo nnection()
System.Data.Sql Client.Connecti onPool.UserCrea teRequest()
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Temp.WebForm1.P age_Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\temp\webfor m1.aspx.cs:32
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

This occurs when I use local sql server.when I use other sql server on the
network I give "server is not exist" message.I follow this steps:
1) I create a sqlconnection 2)I set a sql statement in a data adapter
3)generate a data set 3)in page load event I add above codes.
"Jacek Stawicki" wrote:

>
U¿ytkownik "Ramtin" <Ra****@discuss ions.microsoft. comnapisa³ w wiadomo¶ci
news:EF******** *************** ***********@mic rosoft.com...
Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've
been
granted ASPNET user in sql.
>
Give us more data. Some line with error description, line with code etc.
There are many possible reasons.
>
>
--
JS
BRE Bank Dev Team, Poland
>
>
>

[Jacek Stawicki]

U¿ytkownik "Ramtin" <Ra****@discuss ions.microsoft. comnapisa³ w wiadomo¶ci
news:96******** *************** ***********@mic rosoft.com...

Hi; The sa user is for example I'd been using so many different users.But
finally I use the other post and solve my problem.I must add UID and PWD
in
connection string

What is the connection string?
--
JS
BRE Bank Dev Team, Poland