Can't connect to DB

From: Sandy (anonymous_at_discussions.microsoft.com)
Date: 10/21/03

  • Next message: Mary Chipman: "Re: .net security books" 
    Date: Tue, 21 Oct 2003 13:24:08 -0700

    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

  • Next message: Mary Chipman: "Re: .net security books"

    Relevant Pages

    • 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)
    • Re: Exception trying to import data from Excel .
      ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
      (microsoft.public.sqlserver.tools)