Strange Sql Server behavior

  • Thread starter Thread starter Joe Handelsman
  • Start date Start date
J

Joe Handelsman

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe
 
Joe, what version of SQL Server is this?
What OS are you running on?

What happens if you attempt to connect to the server via the IP address
using TCPIP_sockets as your communication protocol?

You might want to post this question to microsoft.public.sqlserver.connect.




Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
Subject: Strange Sql Server behavior
Date: Thu, 25 Sep 2003 12:44:53 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: host-200-56-115-62.block.alestra.net.mx 200.56.115.62
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34453
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe
 
I'm using the latest version of MSDE and Windows XP. I haven't tried
specifying the IP Address yet because sometimes this computer is on a router
so specifying the servername is easier for setting them up with IP adresses.
And this only seems to happen on handhelds, not so much other computers
connecting to it.

Thanks,
Joe

"Kevin Boske - [MS]" said:
Joe, what version of SQL Server is this?
What OS are you running on?

What happens if you attempt to connect to the server via the IP address
using TCPIP_sockets as your communication protocol?

You might want to post this question to microsoft.public.sqlserver.connect.




Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
-------------------------------------------------------------------------- --
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
-------------------------------------------------------------------------- --
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
-------------------------------------------------------------------------- --
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
Subject: Strange Sql Server behavior
Date: Thu, 25 Sep 2003 12:44:53 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: host-200-56-115-62.block.alestra.net.mx 200.56.115.62
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34453
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe

--
Joe Handelsman
Technical Manager
CSI
773.732.5309
Click to expand...
 
Joe, did you get it to work?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
References: <#[email protected]>
<Dsc0#[email protected]>
Subject: Re: Strange Sql Server behavior
Date: Fri, 26 Sep 2003 18:28:43 -0500
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: adsl-68-77-152-30.dsl.emhril.ameritech.net 68.77.152.30
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34559
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework


I'm using the latest version of MSDE and Windows XP. I haven't tried
specifying the IP Address yet because sometimes this computer is on a router
so specifying the servername is easier for setting them up with IP adresses.
And this only seems to happen on handhelds, not so much other computers
connecting to it.

Thanks,
Joe

"Kevin Boske - [MS]" said:
Joe, what version of SQL Server is this?
What OS are you running on?

What happens if you attempt to connect to the server via the IP address
using TCPIP_sockets as your communication protocol?

You might want to post this question to microsoft.public.sqlserver.connect.




Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
-------------------------------------------------------------------------- --
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
-------------------------------------------------------------------------- --
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
-------------------------------------------------------------------------- --
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
Subject: Strange Sql Server behavior
Date: Thu, 25 Sep 2003 12:44:53 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: host-200-56-115-62.block.alestra.net.mx 200.56.115.62
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34453
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe

--
Joe Handelsman
Technical Manager
CSI
773.732.5309
Click to expand...
 
Not really, I just have to use a static IP address and things work pretty
well. But from time to time I still have some problems.

Joe

"Kevin Boske - [MS]" said:
Joe, did you get it to work?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
-------------------------------------------------------------------------- --
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
-------------------------------------------------------------------------- --
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
-------------------------------------------------------------------------- --
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
References: <#[email protected]>
<Dsc0#[email protected]>
Subject: Re: Strange Sql Server behavior
Date: Fri, 26 Sep 2003 18:28:43 -0500
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: adsl-68-77-152-30.dsl.emhril.ameritech.net 68.77.152.30
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34559
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework


I'm using the latest version of MSDE and Windows XP. I haven't tried
specifying the IP Address yet because sometimes this computer is on a router
so specifying the servername is easier for setting them up with IP adresses.
And this only seems to happen on handhelds, not so much other computers
connecting to it.

Thanks,
Joe

"Kevin Boske - [MS]" said:
Joe, what version of SQL Server is this?
What OS are you running on?

What happens if you attempt to connect to the server via the IP address
using TCPIP_sockets as your communication protocol?

You might want to post this question to microsoft.public.sqlserver.connect.




Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
--------------------------------------------------------------------------
--
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
--------------------------------------------------------------------------
--
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
--------------------------------------------------------------------------
--
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
Subject: Strange Sql Server behavior
Date: Thu, 25 Sep 2003 12:44:53 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: host-200-56-115-62.block.alestra.net.mx 200.56.115.62
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34453
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe

--
Joe Handelsman
Technical Manager
CSI
773.732.5309
Click to expand...
Click to expand...
 
You should post this question to the microsoft.public.sqlserver.msde
newsgroup.

Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
References: <#[email protected]>
<Dsc0#[email protected]>
<[email protected]>
<[email protected]>
Subject: Re: Strange Sql Server behavior
Date: Sat, 4 Oct 2003 09:10:03 -0500
Lines: 148
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: dialup-67.73.136.222.dial1.chicago1.level3.net
67.73.136.222
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:35156
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Not really, I just have to use a static IP address and things work pretty
well. But from time to time I still have some problems.

Joe

"Kevin Boske - [MS]" said:
Joe, did you get it to work?


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
-------------------------------------------------------------------------- --
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
-------------------------------------------------------------------------- --
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
-------------------------------------------------------------------------- --
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
References: <#[email protected]>
<Dsc0#[email protected]>
Subject: Re: Strange Sql Server behavior
Date: Fri, 26 Sep 2003 18:28:43 -0500
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: adsl-68-77-152-30.dsl.emhril.ameritech.net 68.77.152.30
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34559
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework


I'm using the latest version of MSDE and Windows XP. I haven't tried
specifying the IP Address yet because sometimes this computer is on a router
so specifying the servername is easier for setting them up with IP adresses.
And this only seems to happen on handhelds, not so much other computers
connecting to it.

Thanks,
Joe

"Kevin Boske - [MS]" said:
Joe, what version of SQL Server is this?
What OS are you running on?

What happens if you attempt to connect to the server via the IP address
using TCPIP_sockets as your communication protocol?

You might want to post this question to microsoft.public.sqlserver.connect.




Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
--------------------------------------------------------------------------
--
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
--------------------------------------------------------------------------
--
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
--------------------------------------------------------------------------
--
----------------------------------------
--------------------
From: "Joe Handelsman" <[email protected]>
Subject: Strange Sql Server behavior
Date: Thu, 25 Sep 2003 12:44:53 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: host-200-56-115-62.block.alestra.net.mx 200.56.115.62
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:34453
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Has anybody noticed that sometimes if you change the server IP, or hibernate
and restart the machine containing the server, that you are able to ping the
sql server computer from your handheld, but applications cannot find the
database unless you stop and start the sql server using the sql server
service manager. Any fixes for this, my most common tech support answer
seems to be "stop and restart the sql server". It doesn't seem to make
sense since I can ping the machine but cannot find the server. My
connection string isn't in IP address format, I use the computer
name/database- but this shouldn't matter I think.

Thanks,
Joe

--
Joe Handelsman
Technical Manager
CSI
773.732.5309
Click to expand...
Click to expand...
 
Back
Top