Connection to SQL Server

[Dejan Lazic]

Why can't I connect to my SQL database using ASP.NET
(VB.NET) and ADO.NET?
I get the following error:

System.Data.SqlClient.SqlException: Login failed for
user 'DEJO\ASPNET'. at
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at
MyWebSite.WebForm2.Page_Load(Object sender,
EventArgs e) in C:\Documents and
Settings\Dejan\VSWebCache\DEJO\MyWebSite\WebForm2.aspx.vb:l
ine 29

My connection is:
Imports System.Data.SqlClient
--
Const DBString As String = "Integrated
Security=SSPI;Initial Catalog=Northwind;Data Source=
(local)"
Dim cnn As New SqlConnection(DBString)
cnn.Open()

I use VS.NET 2003, Windows XP SP1, computer's name is
DEJO, SQL Server 2000 is on local computer.
I tried with both permission settings, "Use same
permissions as the root Web server"
and "Use unique permissions for this Web application".

What (Where) do I have to set up?
Thanks in advance.

 

[Dejan Lazic]

Thank you Marc, I'll try.
Can I change the name of the account (ASPNET)?

 

[Dejan Lazic]

Yes, it works perfectly.
I was confused because the same connetion
worked well in VB.NET. I just learn ASP.NET.
Thank you.

 

[Marc Hoeppner]

Yes, you can change the machine.config which is in the
microsoft.net/framework/ under winnt or windows on your hard drive.

http://support.microsoft.com/default.aspx?scid=kb;en-us;315158

Thank you Marc, I'll try.
Can I change the name of the account (ASPNET)?