Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.
> From: "Jj" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
Showing posts with label strange. Show all posts
Showing posts with label strange. Show all posts
Friday, March 9, 2012
Regular Disconnection occurs in query analyzer??
Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jj" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jj" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
Wednesday, March 7, 2012
Regular Disconnection occurs in query analyzer??
Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jéjé" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jéjé" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional
Registration of SQL Servers missing in Enterprise manager
Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situatio
n
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are usin
g?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situat
ion
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situati
on
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situatio
n
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are usin
g?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situat
ion
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situati
on
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>
Registration of SQL Servers missing in Enterprise manager
Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situation
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are using?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situation
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situation
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
>> Sounds like this may be the issue you are running into:
>> FIX: Registered remote servers disappear from SQL Enterprise
>> Manager in Windows XP when user password is changed
>> http://support.microsoft.com/?id=323280
>> -Sue
>> On Thu, 17 Aug 2006 13:39:02 -0700, VM
>> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Recently a strange behaviour was seen with Enterprise manager. When we
> >change the Windows login password all the registrations of SQL Servers are
> >missing from SQL Server Enterprise Manager. Did anyone faced this situation
> >before? Its really painful to register 20 servers each time when login
> >password is changed. Some of the registered servers are windows
> >authentication and rest of them are SQL Server authentication.
> >
> >Thanks a lot in advance!
> >
> >Vinod Meesala
>
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situation
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are using?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situation
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situation
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
>> Sounds like this may be the issue you are running into:
>> FIX: Registered remote servers disappear from SQL Enterprise
>> Manager in Windows XP when user password is changed
>> http://support.microsoft.com/?id=323280
>> -Sue
>> On Thu, 17 Aug 2006 13:39:02 -0700, VM
>> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Recently a strange behaviour was seen with Enterprise manager. When we
> >change the Windows login password all the registrations of SQL Servers are
> >missing from SQL Server Enterprise Manager. Did anyone faced this situation
> >before? Its really painful to register 20 servers each time when login
> >password is changed. Some of the registered servers are windows
> >authentication and rest of them are SQL Server authentication.
> >
> >Thanks a lot in advance!
> >
> >Vinod Meesala
>
Subscribe to:
Posts (Atom)