Re: Bizzare SQL Network Error

Try making sure the SQL account (sa) that you put into the connection string
is actually being used. If you are using the default network library(named
pipes) then it will ignore the name and pw in the connection string. You may
have to force the Network Library=dbmsoccn in the connection string. I used
to do this in ADO but haven't tried it with .NET.

The reason the Windows app worked was because it used the account of the
person running the Windows app.

"Andy Furnival" wrote:

> I though that, but I'm not using Integrated Security, I'm implicitly passing
> the sa username and password.
>
> The bizzare thing is that, the same connection string, the same code to
> connect to the database. In a windows APP it works fine, in a Web APP I get
> the error that I posted earlier.
>
> The SQL Database is not on the same machine as the applications. The SQL is
> set to use Windows and SQL Authentication. The SQL Server does reside on a
> Windows XP machine SP2 (no firewall, on domain).
>
> Last resort I tried using ODBC configuring TCP/IP and Named Pipes, still
> doesn't work. So I'm unsure if it's a .net issue or a connectivity issue.
> The ODBC drivers work with testing the connection, but just not through
> ado.net
>
> This problem is a serious head scratcher!!!
>
> "Robbe Morris [C# MVP]" wrote:
>
> > Your ASP.NET request is not being run under the same windows
> > account as your windows form app is. I suspect that you'll
> > need to grant windows authentication to whatever windows
> > account your ASP.NET requests are being run under. Hint,
> > it isn't the account you are personally signed in as.
> >
> > On Windows 2003 Server, I believe the "Network Service"
> > windows account is the default one. But, this can be altered.
> >
> > --
> > Robbe Morris - 2004/2005 Microsoft MVP C#
> >
> > Earn money answering .NET Framework
> > messageboard posts at EggHeadCafe.com.
> > http://www.eggheadcafe.com/forums/merit.asp
> >
> >
> >
> > "Andy Furnival" <AndyFurnival@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:1EF7201A-01C0-43CC-AF47-F8165BBC56DC@xxxxxxxxxxxxxxxx
> > >I am trying to connect to a default instance of SQL Server 2000 Enterprise
> > >on
> > > a remote network server using ADO.NET objects through ASP.NET Web
> > > Application.
> > >
> > > The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> > > TCP/IP
> > > and Named Pipes enabled
> > >
> > > For the test purposes, I created a new Web Form, created a new
> > > SqlConnection
> > > in the Server Explorer to the remote database. I test the connection is VS
> > > IDE and everything is fine. I create a SqlDataAdapter on the web form,
> > > generate a dataset, test the dataset and the results are valid. I bind the
> > > SqlDataAdapter to a datagrid and run the webform. I now get the following
> > > error.
> > >
> > > System.Data.SqlClient.SqlException: SQL Server does not exist or access
> > > denied.
> > > at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> > > isInTransaction)
> > > at
> > > System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> > > options, Boolean& isInTransaction)
> > > at System.Data.SqlClient.SqlConnection.Open()
> > > at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> > > c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
> > >
> > > Hmph! I take the same connection string from the web app, create a win
> > > app.
> > > Place a datagrid on the form, do the binding and load the app. Hey Presto!
> > > it
> > > works.
> > >
> > > I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> > > create a connection, but its at though SQL Server is rejecting the
> > > connection, although I see no failures in SQL Server.
> > >
> > > Any thoughts would be much appreciated.
> > >
> > > Andy
> >
> >
> >
.

Relevant Pages

  • Re: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)
  • RE: Integrated Authentication (Kerberos) Problem
    ... Verify the SPN for the SQL service account is registered such as the ... >Thread-Topic: Integrated Authentication Problem ... A Windows XP SP1 with IE6 client machine ...
    (microsoft.public.inetserver.iis.security)
  • Re: User authentication
    ... I was able to change the owner of a backup to the backup operator (Windows ... account) on a backup job configured on SQL Agent, ... If I set a backup job on SQL Server Maintenance Plan on SQL Server 2005, ... I am not able to assign the job to a different Windows account. ...
    (microsoft.public.sqlserver.clients)
  • Re: User authentication
    ... I was able to change the owner of a backup to the backup operator (Windows ... account) on a backup job configured on SQL Agent, ... If I set a backup job on SQL Server Maintenance Plan on SQL Server 2005, ... I am not able to assign the job to a different Windows account. ...
    (microsoft.public.sqlserver.clients)
  • Re: User authentication
    ... The windows accounts need to be added as logins in SQL ... Server prior to having them own jobs. ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)