Trouble Connecting To SQL DB

Greetings,





I am having difficulty connecting to a SQL DB in my ASP page. Each time I run my application I receive the following error, "Login failed for user 'CX259ASPNET'". This is obviously something to do with permissions. I am all out of ideas but I will list the things I have already attempted to see if I either missed something or somebody can add to what I have already done.





1. In SQL Server I right-clicked the db -> properties -> security tab -> selected the option button to "SQL Server and Windows" instead of "Windows Only".


2. I installed SP3 and changed the sa password.


3. I created a new user under my db using the ASPNET account listed. I then changed the permissions to allow selecting, update, insert and delete access.


4. I also created a new user under my db using the IUSR account listed. I changed the permissions to the same settings as above.





I did a search on google which provided with all of the information above, but I am still stuck and hoping that this is a common problem and will be easy to fix.





Below is the code which I am attempting to use.








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


If Not Page.IsPostBack Then


Dim strConnString As String = _


"Data Source=(local);" & _


"Initial Catalog=Names;" & _


"Integrated Security=SSPI;"


Dim objConn As New SqlConnection(strConnString)


Dim strSQL As String = "SELECT * FROM [Names]"


Dim objCmd As New SqlCommand(strSQL, objConn)





objConn.Open()


MyDataGrid.DataSource = objCmd.ExecuteReader


MyDataGrid.DataBind()


objConn.Close()


End If


End Sub








Regards,


Corey