Re: Odd connection issue - (yes I'm running in mixed mode authentication)

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 02/03/04 

Date: Tue, 03 Feb 2004 13:42:30 GMT

Hi Thomas,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you have two servers running similar
SQL servers, your ASP.NET application can connect to one server, but was
unable to connection to the other. And you're connecting both servers with
SQL server authentication. If there is any misunderstanding, please feel
free to let me know.

Marina has provided us with a good suggestion. We can use SQL profiler to
check with which credential, the ASP.NET app is connecting to SQL server.
Here are the steps:
1. Click Start -> Programs -> Microsoft SQL Server -> Profiler to open SQL
profiler.
2. Select File -> New -> Trace to create a new trace.
3. Enter the server name, user name and password. Click OK.
4. Click Run to start the trace.
5. Start your ASP.NET app and repro the error.

When you can see the credential used to access SQL server, please verify if
this user name and password is a valid one. Please also try the following
connection string to see if it works.

Provider=SQLOLEDB.1;Password=development;Persist Security Info=True;User
ID=sa;Initial Catalog=V2Staging;Data Source=Staging

If the problem still persists, please feel free to let me know. I am
standing by to be of assistance.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... See what that gives you in the trace. ...
    (microsoft.public.sqlserver.security)
  • 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)
Loading