SQL ACCESS Vias Web Form

Hello, I'm having a problem connection to an Eval version of SQL Server 2000. I'm pretty sure the problem is not due to Eval version since...well, I need to evaluate the server if I intended to purchase it right? anyhow. I've loaded a copy of SQL server 2000 on my local machine. I only have one machine which I use for development and housing SQL Server.





I tried to set SQL up real "vanilla" and elected to use only Windows Authentication, this bypassing any userdefined passwords for the sa login.





Now...I've written a real basic Stored Procedure to test the connection and verify proper data transfer from the .aspx page. here's the SP SQL code and the .vb code behind page as well as the error I get. Note. I also tried Query Analyzer and was getting an error there as well indicating the SP could not be found...hmmm..





stored procedure:





CREATE PROCEDURE [dbo].[NewMemberInsert]





@UserNamevarchar(100),


@UserPassvarchar(10)





AS





INSERT INTO EEMemberList ( UserName, UserPass )


VALUES ( @UserName, @UserPass)


GO





.vb code behind





Imports System


Imports System.Data


Imports System.Data.SqlClient








Public Class WebForm1


Inherits System.Web.UI.Page


Protected WithEvents lblUserName As System.Web.UI.WebControls.Label


Protected WithEvents lblUserPass As System.Web.UI.WebControls.Label


Protected WithEvents txtUserName As System.Web.UI.WebControls.TextBox


Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button


Protected WithEvents frmMyForm As System.Web.UI.HtmlControls.HtmlForm


Protected WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection


Protected WithEvents sqlCmd As System.Data.SqlClient.SqlCommand


Protected WithEvents txtUserPass As System.Web.UI.WebControls.TextBox





#Region " Web Form Designer Generated Code "





'This call is required by the Web Form Designer.


<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()


Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection()


Me.sqlCmd = New System.Data.SqlClient.SqlCommand()


'


'SqlConnection1


'


Me.SqlConnection1.ConnectionString = "data source=THIRDEYE;initial catalog=SQCTEST;integrated security=SSPI;persist sec" & _


"urity info=False;workstation id=THIRDEYE;packet size=4096"


'


'sqlCmd


'


End Sub





Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init


'CODEGEN: This method call is required by the Web Form Designer


'Do not modify it using the code editor.


InitializeComponent()


End Sub





#End Region





Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


'Put user code to initialize the page here


End Sub





Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click





sqlCmd.CommandText = "dbo.[NewMemberInsert]"


sqlCmd.CommandType = System.Data.CommandType.StoredProcedure


sqlCmd.Connection = SqlConnection1


sqlCmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(10, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))


sqlCmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 100))


sqlCmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UserPass", System.Data.SqlDbType.VarChar, 10))


sqlCmd.Parameters("@UserName").Value = txtUserName.Text


sqlCmd.Parameters("@UserPass").Value = txtUserPass.Text





sqlCmd.Connection.Open()








End Sub


End Class





Now...the error





Server Error in '/EEscape' Application.


--------------------------------------------------------------------------------





Login failed for user 'THIRDEYEASPNET'.


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 'THIRDEYEASPNET'.





Source Error:








Line 54: sqlCmd.Parameters("@UserPass").Value = txtUserPass.Text


Line 55:


Line 56: sqlCmd.Connection.Open()


Line 57:


Line 58:








Source File: C:InetpubwwwrootEEscapelogin.aspx.vb Line: 56





Stack Trace:








[SqlException: Login failed for user 'THIRDEYEASPNET'.]


System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)


System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)


System.Data.SqlClient.SqlConnection.Open()


EEscape.WebForm1.btnSubmit_Click(Object sender, EventArgs e) in C:InetpubwwwrootEEscapelogin.aspx.vb:56


System.Web.UI.WebControls.Button.OnClick(EventArgs e)


System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)


System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)


System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)


System.Web.UI.Page.ProcessRequestMain()














--------------------------------------------------------------------------------


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