have you tried with this connection string?
"Data Source=local;Initial Catalog=PUBS;Integrated Security=SSPI;"
I changed the "Data Source=localhost" with "Data Source=local".
"Sandy" <anonymousdiscussions.microsoft.com> wrote in message
> I am trying to open a connection to a SQL Server database
> using just the Framework, Notepad and the browser. I keep
> getting the error message "SQL Server does not exist or
> access is denied."
> I am using the following for the connection:
> Dim conPubs As SqlConnection
> ConPubs = New SqlConnection ("Data
> Source=localhost;Initial Catalog=PUBS;Integrated
> In Page_Load of the script. I can take the same notepad
> aspx page and put it into Visual Studio .NET and it
> connects without a problem.
> I'm using Windows Server 2003 and my SQL Server 2000 is
> set up with windows authentication. I am not on a
> network - just studying this stuff on my home computer.
> THIS IS DRIVING ME CRAZY! I have read many many pages on
> security and nothing seems to be giving me what I need. I
> would guess on some level there is probably some stupid
> little box that has to be checked or unchecked . . . Where
> ever that could be . . .
> Any help anyone can give me will be immensely appreciated!