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=.;truste d_connection=Tr ue;database=pub s")

[Jeff Dillon]

Re: SQL Server does not exist or access denied Problem

Do you get an error?


"Sal" <Sal@discussion s.microsoft.com > wrote in message
news:6310C2D6-A656-4897-B83D-D5C2BFD02790@mi crosoft.com...[color=blue]
> 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=.;truste d_connection=Tr ue;database=pub s")
>[/color]

[Sal]

Re: SQL Server does not exist or access denied Problem

Yes the error is as follows:
[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +484

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
before.WebForm1 .Page_Load(Obje ct sender, EventArgs e) in
C:\AspDotNet\la bs\AspDotNetInt roLab3\before\d efault.aspx.vb: 26
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +731


"Jeff Dillon" wrote:
[color=blue]
> Do you get an error?
>
>
> "Sal" <Sal@discussion s.microsoft.com > wrote in message
> news:6310C2D6-A656-4897-B83D-D5C2BFD02790@mi crosoft.com...[color=green]
> > 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=.;truste d_connection=Tr ue;database=pub s")
> >[/color]
>
>
>[/color]

[Jeff Dillon]

Re: SQL Server does not exist or access denied Problem

Try server=(local)

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

Jeff

"Sal" <Sal@discussion s.microsoft.com > wrote in message
news:714E64A3-AFB3-45E6-A113-87954824D6FB@mi crosoft.com...[color=blue]
> Yes the error is as follows:
> [SqlException: SQL Server does not exist or access denied.]
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) +484
>
>[/color]
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction ) +372[color=blue]
> System.Data.Sql Client.SqlConne ction.Open() +384
> before.WebForm1 .Page_Load(Obje ct sender, EventArgs e) in
> C:\AspDotNet\la bs\AspDotNetInt roLab3\before\d efault.aspx.vb: 26
> System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
> System.Web.UI.C ontrol.LoadRecu rsive() +35
> System.Web.UI.P age.ProcessRequ estMain() +731
>
>
> "Jeff Dillon" wrote:
>[color=green]
> > Do you get an error?
> >
> >
> > "Sal" <Sal@discussion s.microsoft.com > wrote in message
> > news:6310C2D6-A656-4897-B83D-D5C2BFD02790@mi crosoft.com...[color=darkred]
> > > I am new to ASP.Net and I am trying to to make simple SQLConnection to[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > pubs database that comes with SQLServer2000.
> > > I have attempted many things to try and resolve it. I tried adding[/color][/color][/color]
ASPNET[color=blue][color=green][color=darkred]
> > > user in the security section of SQLServer2000, and I also removed the[/color][/color][/color]
XP[color=blue][color=green][color=darkred]
> > > firewall on the machine.
> > > My SQLServer2000 and ASP.Net development are on the same server and I[/color][/color][/color]
can[color=blue][color=green][color=darkred]
> > > even make a connection to the database through VS environment.
> > > The following is my VB.net connection string:
> > > Dim conn As New
> > > SqlConnection(" server=.;truste d_connection=Tr ue;database=pub s")
> > >[/color]
> >
> >
> >[/color][/color]