SQL Server does not exist or access denied Problem

[Sal]

I am new to ASP.Net and I am trying to to make simple SQLConnection to the
pubs database that comes with SQLServer2000.
I have attempted many things to try and resolve it. I tried adding ASPNET
user in the security section of SQLServer2000, and I also removed the XP
firewall on the machine.
My SQLServer2000 and ASP.Net development are on the same server and I can
even make a connection to the database through VS environment.
The following is my VB.net connection string:
Dim conn As New
SqlConnection("server=.;trusted_connection=True;da tabase=pubs")

[Jeff Dillon]

Do you get an error?
"Sal" <Sa*@discussions.microsoft.com> wrote in message
news:63**********************************@microsof t.com...

I am new to ASP.Net and I am trying to to make simple SQLConnection to the
pubs database that comes with SQLServer2000.
I have attempted many things to try and resolve it. I tried adding ASPNET
user in the security section of SQLServer2000, and I also removed the XP
firewall on the machine.
My SQLServer2000 and ASP.Net development are on the same server and I can
even make a connection to the database through VS environment.
The following is my VB.net connection string:
Dim conn As New
SqlConnection("server=.;trusted_connection=True;da tabase=pubs")

[Sal]

Yes the error is as follows:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
before.WebForm1.Page_Load(Object sender, EventArgs e) in
C:\AspDotNet\labs\AspDotNetIntroLab3\before\defaul t.aspx.vb:26
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
"Jeff Dillon" wrote:

Do you get an error?
"Sal" <Sa*@discussions.microsoft.com> wrote in message
news:63**********************************@microsof t.com...

I am new to ASP.Net and I am trying to to make simple SQLConnection to the
pubs database that comes with SQLServer2000.
I have attempted many things to try and resolve it. I tried adding ASPNET
user in the security section of SQLServer2000, and I also removed the XP
firewall on the machine.
My SQLServer2000 and ASP.Net development are on the same server and I can
even make a connection to the database through VS environment.
The following is my VB.net connection string:
Dim conn As New
SqlConnection("server=.;trusted_connection=True;da tabase=pubs")

[Jeff Dillon]

Try server=(local)

And using Query Analyzer, you can check Windows Authentication and get in
ok?

Jeff

"Sal" <Sa*@discussions.microsoft.com> wrote in message
news:71**********************************@microsof t.com...

Yes the error is as follows:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384
before.WebForm1.Page_Load(Object sender, EventArgs e) in
C:\AspDotNet\labs\AspDotNetIntroLab3\before\defaul t.aspx.vb:26
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
"Jeff Dillon" wrote:

Do you get an error?
"Sal" <Sa*@discussions.microsoft.com> wrote in message
news:63**********************************@microsof t.com...

I am new to ASP.Net and I am trying to to make simple SQLConnection to the pubs database that comes with SQLServer2000.
I have attempted many things to try and resolve it. I tried adding ASPNET user in the security section of SQLServer2000, and I also removed the XP firewall on the machine.
My SQLServer2000 and ASP.Net development are on the same server and I can even make a connection to the database through VS environment.
The following is my VB.net connection string:
Dim conn As New
SqlConnection("server=.;trusted_connection=True;da tabase=pubs")