DB Connection

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm posting here hopeing some here has delt with a similar problem and
has a suggestion for a fix.

If anyone knows the answer to this I?d me greatly appreciative.

I am not on a domain.

I have SQL Server sitting on computer A

Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X

I am writing an ASP.NET app on Computer B. IIS and Dev on B) I am
trying to make a connection to SQL on computer A but get the
error ?SQL Server does not exist or access denied?

Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.

So, I?m guessing the problems lies in the security of ASP.NET, but I?m
not sure what to change to make this work.

BTW, I can also connect just fine with the same user/pw with Enterprise
Manger, and Query Analyzer as well as add the connection to Visual
Studio

Anyone with any ideas?

TIA
B
.

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)