Win 2003 Small business server with IIS being used as a web server.
Our client app can log in and run queries, but our web app when trying to log in gets the message,
'SQL server does not exsist or access denied'
The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group.
Any suggestions on what it might be? :confused:instead of dsn, try dsn-less:
http://www.connectionstrings.com/
Showing posts with label tcp. Show all posts
Showing posts with label tcp. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
Cannot connect using TCP/IP protocol
Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?
What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?
What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?
Cannot connect using TCP/IP protocol
Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem.
>any advice?
Cannot connect using TCP/IP protocol
Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem
.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without proble
m.
>any advice?
TCP/IP protocol. NamePipe is OK. Other XP client can connect without problem
.
any advice?What is the error number and error message?
There are some TCP/IP issues with older MDAC versions - did
you check/try updating the MDAC version on the 98 client?
-Sue
On Mon, 24 Oct 2005 01:50:02 -0700, "alex"
<alex@.discussions.microsoft.com> wrote:
>Win98 client cannot connect to SQL 2K (sp3) on WIN SERVER 2003 (sp1) using
>TCP/IP protocol. NamePipe is OK. Other XP client can connect without proble
m.
>any advice?
cannot connect using tcp/ip
Hi,
I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?
Leo-Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
> Hi,
> I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I tes
t
> it using telnet in port 1433, nothing happends.
> I need to connect to this server via Internet.
> How can I do?
> Leo-
Have you enabled TCP on the Server? There should be a program "SQL Server
Client Configuration" on the server. If not, search for SVRNETCN.EXE on the
server. With this program you can check if TCP is enabled.
Second problem could be a firewall.
bye,
helmut|||I have enabled TCP port (1433). I can access to that port from any computer
in my intranet. But I cannot do this using my internet IP.
There's no router issue. I think it's due to Windows XP SP2 Firewall, but I
have open those ports to.
Leo-
"helmut woess" <hw@.iis.at> escribi en el mensaje
news:1nee56bcb93ir$.rpvg777x77c0.dlg@.40tude.net...
> Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
>
> Have you enabled TCP on the Server? There should be a program "SQL Server
> Client Configuration" on the server. If not, search for SVRNETCN.EXE on
> the
> server. With this program you can check if TCP is enabled.
> Second problem could be a firewall.
> bye,
> helmut
I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?
Leo-Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
> Hi,
> I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I tes
t
> it using telnet in port 1433, nothing happends.
> I need to connect to this server via Internet.
> How can I do?
> Leo-
Have you enabled TCP on the Server? There should be a program "SQL Server
Client Configuration" on the server. If not, search for SVRNETCN.EXE on the
server. With this program you can check if TCP is enabled.
Second problem could be a firewall.
bye,
helmut|||I have enabled TCP port (1433). I can access to that port from any computer
in my intranet. But I cannot do this using my internet IP.
There's no router issue. I think it's due to Windows XP SP2 Firewall, but I
have open those ports to.
Leo-
"helmut woess" <hw@.iis.at> escribi en el mensaje
news:1nee56bcb93ir$.rpvg777x77c0.dlg@.40tude.net...
> Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
>
> Have you enabled TCP on the Server? There should be a program "SQL Server
> Client Configuration" on the server. If not, search for SVRNETCN.EXE on
> the
> server. With this program you can check if TCP is enabled.
> Second problem could be a firewall.
> bye,
> helmut
cannot connect using tcp/ip
Hi,
I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?
Leo-
Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
> Hi,
> I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
> it using telnet in port 1433, nothing happends.
> I need to connect to this server via Internet.
> How can I do?
> Leo-
Have you enabled TCP on the Server? There should be a program "SQL Server
Client Configuration" on the server. If not, search for SVRNETCN.EXE on the
server. With this program you can check if TCP is enabled.
Second problem could be a firewall.
bye,
helmut
|||I have enabled TCP port (1433). I can access to that port from any computer
in my intranet. But I cannot do this using my internet IP.
There's no router issue. I think it's due to Windows XP SP2 Firewall, but I
have open those ports to.
Leo-
"helmut woess" <hw@.iis.at> escribi en el mensaje
news:1nee56bcb93ir$.rpvg777x77c0.dlg@.40tude.net...
> Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
>
> Have you enabled TCP on the Server? There should be a program "SQL Server
> Client Configuration" on the server. If not, search for SVRNETCN.EXE on
> the
> server. With this program you can check if TCP is enabled.
> Second problem could be a firewall.
> bye,
> helmut
I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?
Leo-
Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
> Hi,
> I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
> it using telnet in port 1433, nothing happends.
> I need to connect to this server via Internet.
> How can I do?
> Leo-
Have you enabled TCP on the Server? There should be a program "SQL Server
Client Configuration" on the server. If not, search for SVRNETCN.EXE on the
server. With this program you can check if TCP is enabled.
Second problem could be a firewall.
bye,
helmut
|||I have enabled TCP port (1433). I can access to that port from any computer
in my intranet. But I cannot do this using my internet IP.
There's no router issue. I think it's due to Windows XP SP2 Firewall, but I
have open those ports to.
Leo-
"helmut woess" <hw@.iis.at> escribi en el mensaje
news:1nee56bcb93ir$.rpvg777x77c0.dlg@.40tude.net...
> Am Tue, 15 Nov 2005 13:17:12 -0300 schrieb Leo Deserio:
>
> Have you enabled TCP on the Server? There should be a program "SQL Server
> Client Configuration" on the server. If not, search for SVRNETCN.EXE on
> the
> server. With this program you can check if TCP is enabled.
> Second problem could be a firewall.
> bye,
> helmut
Friday, February 10, 2012
cannot connect to a named instance via TCP/IP
Hi all,
I have a SQL server running on a WIN2k server at my office
I have an application running on a named instance of the sql server, say SQL_instance1
Due to some reason, I have to connect to the SQL server named instance from my home workstation. Therefore, I have already set a portmapping (1433) on my company firewall and use the IP address, say 61.88.17.3, to connect the sql server at my home
However, I find that I cannot register the sql server at the EM and the error message is "SQL server not found or access denied". I am sure the login name and password is correct and the firewall setting is correct also (Since I can use telnet to connect the server, the command is : telnet 61.88.17.3 1433)
Anyone know how to solve this problem '
I use the following connection string to register the remote sql server in my workstation EM
61.88.17.3\SQL_instance
Thank in advanc
Regards
ongAre you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
>--Original Message--
>Hi all,
>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
>Anyone know how to solve this problem '
>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>Thank in advance
>Regards,
>ong
>.
>|||thx for your reply.
I use 1433 for my named instance and the I have configured the firewall to allow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
>--Original Message--
>Hi all,
>>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
>Anyone know how to solve this problem '
>>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>>Thank in advance
>>Regards,
>ong
>.
>
I have a SQL server running on a WIN2k server at my office
I have an application running on a named instance of the sql server, say SQL_instance1
Due to some reason, I have to connect to the SQL server named instance from my home workstation. Therefore, I have already set a portmapping (1433) on my company firewall and use the IP address, say 61.88.17.3, to connect the sql server at my home
However, I find that I cannot register the sql server at the EM and the error message is "SQL server not found or access denied". I am sure the login name and password is correct and the firewall setting is correct also (Since I can use telnet to connect the server, the command is : telnet 61.88.17.3 1433)
Anyone know how to solve this problem '
I use the following connection string to register the remote sql server in my workstation EM
61.88.17.3\SQL_instance
Thank in advanc
Regards
ongAre you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
>--Original Message--
>Hi all,
>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
>Anyone know how to solve this problem '
>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>Thank in advance
>Regards,
>ong
>.
>|||thx for your reply.
I use 1433 for my named instance and the I have configured the firewall to allow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
>--Original Message--
>Hi all,
>>I have a SQL server running on a WIN2k server at my
office.
>I have an application running on a named instance of the
sql server, say SQL_instance1.
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
>Anyone know how to solve this problem '
>>I use the following connection string to register the
remote sql server in my workstation EM.
>61.88.17.3\SQL_instance1
>>Thank in advance
>>Regards,
>ong
>.
>
cannot connect to a named instance via TCP/IP
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
office.
sql server, say SQL_instance1.
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
remote sql server in my workstation EM.
I use 1433 for my named instance and the I have configured the firewall to a
llow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot
connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
sql server, say SQL_instance1.
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
quote:
>--Original Message--
>Hi all,
>I have a SQL server running on a WIN2k server at my
office.
quote:
>I have an application running on a named instance of the
sql server, say SQL_instance1.
quote:
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
quote:
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
quote:
>Anyone know how to solve this problem '
>I use the following connection string to register the
remote sql server in my workstation EM.
quote:thx for your reply.
>61.88.17.3\SQL_instance1
>Thank in advance
>Regards,
>ong
>.
>
I use 1433 for my named instance and the I have configured the firewall to a
llow 1433.
I even try to configure the firewall to allow all TCP/IP, but I still cannot
connect to my SQL server.
-- Tim Richardson wrote: --
Are you connecting to your office through VPN or is your
firewall just configured to allow you to access port 1433?
If it is the latter, you must configure your firewall to
allow you access on the port that the named instance is
listening on (each instance has its own port and only the
default instance will be listening on 1433). You can
find the port the named instance is using by looking at
the TCP/IP properties for the instance in the server
network utility.
Hope this helps.
Tim
quote:
>--Original Message--
>Hi all,
office.[QUOTE]
>I have an application running on a named instance of the
sql server, say SQL_instance1.
quote:
>Due to some reason, I have to connect to the SQL server
named instance from my home workstation. Therefore, I
have already set a portmapping (1433) on my company
firewall and use the IP address, say 61.88.17.3, to
connect the sql server at my home.
quote:
>However, I find that I cannot register the sql server at
the EM and the error message is "SQL server not found or
access denied". I am sure the login name and password is
correct and the firewall setting is correct also (Since I
can use telnet to connect the server, the command is :
telnet 61.88.17.3 1433).
quote:
>Anyone know how to solve this problem '
remote sql server in my workstation EM.[QUOTE]
>61.88.17.3\SQL_instance1
>ong
>.
>
Subscribe to:
Posts (Atom)