Re: Failed to start monitoring changes

From: Praveena Adabala (anonymous_at_discussions.microsoft.com)
Date: 01/22/04


Date: Thu, 22 Jan 2004 07:26:09 -0800

I connect to a remote SQL Server using SQL authentication, regarding permissions its the owner of the database.
     
     ----- Hernan de Lahitte wrote: -----
     
     Can you be more specific about the scenario of the SQL connection (SQL auth
     or SSPI, remote SQL Server, worker process account if SSPI, permissions on
     tables, SPs, logins, etc.)
     
     
     --
     Hernan de Lahitte - MSDE
     Lagash Systems S.A. - Buenos Aires, Argentina
     http://www.lagash.com
     
     
     
     "Praveena Adabala" <anonymous@discussions.microsoft.com> wrote in message
     news:6098E9F6-E2E1-442D-B87F-0BA6CB0B915F@microsoft.com...
> Thank you for all the support, I appreciate it.
> I have a another problem with SQL Connection.
> It displays the following error, when i try to open the page,
>> System.Data.SqlClient.SqlException: Invalid connection. at
     System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
     at
     System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
     tionString options, Boolean& isInTransaction) at
     System.Data.SqlClient.SqlConnection.Open() at
     OnlineExam.WebForm1.Page_Load(Object sender, EventArgs e)
>> Can you help me fix this.
> Thank you very much
> Praveena.
>>> ----- Hernan de Lahitte wrote: -----
>> This article states exactly what I was referring to.
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;317955
>>> --
> Hernan de Lahitte - MSDE
> Lagash Systems S.A. - Buenos Aires, Argentina
> http://www.lagash.com
>>>> "Praveena adabala" <anonymous@discussions.microsoft.com> wrote in
     message
> news:3BFFDCBB-8043-43CF-9FF3-80FF5F53C3B3@microsoft.com...
>> I am sorry , I didnt get what you are saying, Where should i check
     ? I
> have a ASPNET user on the webserver, I went and checked the
     permissions.
> what specifically should i check??
>> Please can you be more detail.
>>> Thank you
>> Praveena.
>>> ----- Hernan de Lahitte wrote: -----
>>> Check the ACL on the remote share for the accessing account
     (ASP.NET
> worker
>> process account). This are typically ASPNET or "Network
     Service"
> accounts.
>>> --
>> Hernan de Lahitte - MSDE
>> Lagash Systems S.A. - Buenos Aires, Argentina
>> http://www.lagash.com
>>>>> "Praveena Adabala" <anonymous@discussions.microsoft.com>
     wrote in
> message
>> news:0b1b01c3db79$2e1b9070$a401280a@phx.gbl...
>>> I am running an ASP.NET application on the remote share.
>>> So in IIS i specify the share name and in .NET
>>> configuration tool i make the remote share a "Fully
>>> Trusted" one.
>>>> I get this error
>>> Failed to start monitoring changes to
>>>> [HttpException (0x80070038): Failed to start monitoring
>>> changes to ]
>>>> Please can anyone Help me.
>>> Thank you
>>> Praveena.
>>>



Relevant Pages

  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)