login failed to database [B][Resolved][B]

[d2005]

Resolved
Dim oSQLConn As SqlConnection = New SqlConnection
oSQLConn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=Con_Test;" & _
"Integrated Security=SSPI"
oSQLConn.Open()

this doesnt work as i get an error,

login failed for user 'computername'
Line 33: "Initial Catalog=Con_Test;" & _
Line 34: "Integrated Security=SSPI"
Line 35: oSQLConn.Open()
Line 36:
Line 37:

anybody any ideas of connecting to a databse for asp.net
i really want to get connected but cant

[techgnome]

Mmmmmm.... try looking here: ConnectionString.com it looks as though your connectionstring isn't quite right.

Also, make sure that the user you are loging in as has permissions to the server & database. You may think you are loging in as yourself, but ASP runs under it's own user context and logsin to database as that ASP user.

Tg

[d2005]

how do i go about changing the permissions????, i was trying to write to a text file as a test and access was denied this may be my stumbling block,

thanks keep the change

yeah it connects , thanks a million buddy

[techgnome]

SO, does it work now then? Or is there still a problem?

Tg

[d2005]

sorry i didnt edit the message too good.
aye she connects now for theres no errors coming up.
what now would be my next plan of action, after the connection.

i want to have like a registration page and want to write then from the textboxes to the database.