Problem with connectionstring

[trg_550]

Hi,

i´m new in .net and i have a problem with a connectionstring for a SQL Server 2000 database.

In WebMatrix (for those who know it) it´s possible to generate a datapage with this connectionstring:

Dim myConnectionString As String = "server= (local);database=pubs;trusted_connection=true"

When i run the application inside WebMatrix everything is ok, I see my database.

If i try to run the apllication in visual studio.net or by http://localhost/........ .aspx with this same connection string i get the following error

System.Data.SqlClient.SqlException: Login failed for user 'RUICOMPU\ASPNET'

RUICOMPU is the name of my computer.

What modifications should i do in the connectionstring ??

I think the problem is in server=(local) . Sometimes i see localhost instead of local. What is the diference ? In SQL Server 2000 i have (LOCAL)(Windows NT)

Please help me, Thanks