Re: Can't connect to DB

From: Andrea D'Onofrio (andreado_at_microsoft.com)
Date: 10/22/03 

Date: Wed, 22 Oct 2003 15:50:21 +0200

Hi,
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".

Andrea

"Sandy" <anonymous@discussions.microsoft.com> wrote in message
news:0a5001c39811$47c00b60$a001280a@phx.gbl...
> Hi!
>
> 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
> Security=SSPI;")
> ConPubs.Open()
>
> 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!
>
> Sandy
>

Relevant Pages

  • Re: network error
    ... the back-end properly connected with ODBC to the back-end. ... sure that you have enough record locks and that your connection is good. ... front end, and a Microsoft SQL Server database holding the tables, as the ... back end (SQL Server 2000, ...
    (microsoft.public.access.formscoding)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)