Need help in connecting to SQL database...

16 Mar 2006 9:47 PM

Satish Anand

I am creating my first web form with vb.net and having this error in line #
63:

----------------------------------------------------------
Login failed for user 'TSP_USER'.
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
'TSP_USER'.

Source Error:

Line 61: Private Sub FillGrid(ByVal currentSQLCommand As SqlClient.
SqlCommand)
Line 62: Dim dr As SqlClient.SqlDataReader
Line 63: SqlConnection1.Open()
Line 64: dr = currentSQLCommand.ExecuteReader
Line 65:
-----------------------------------------------
When I created the connection, on test it was successful.
What I am doing wrong here?

Any assistance is appreciated.
Thanks

19 Mar 2006 5:13 AM

Christopher Reed

Is the user TSP_USER actually configured to work with your production
database?

--
Christopher A. Reed
"The oxen are slow, but the earth is patient."

Show quoteHide quote

"Satish Anand" <san***@cox.net> wrote in message
news:bb37495952624b3f93694842ab937250@ureader.com...
>I am creating my first web form with vb.net and having this error in line #
> 63:
>
> ----------------------------------------------------------
> Login failed for user 'TSP_USER'.
> 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
> 'TSP_USER'.
>
> Source Error:
>
>
> Line 61: Private Sub FillGrid(ByVal currentSQLCommand As SqlClient.
> SqlCommand)
> Line 62: Dim dr As SqlClient.SqlDataReader
> Line 63: SqlConnection1.Open()
> Line 64: dr = currentSQLCommand.ExecuteReader
> Line 65:
> -----------------------------------------------
> When I created the connection, on test it was successful.
> What I am doing wrong here?
>
> Any assistance is appreciated.
> Thanks