Connecting to a Microsoft SQL Database via Redhat 5
Dear friends I wish you a lovely day. I am getting an error on redhat 5 not connecting to microsoft sql via isql. The error is that could not resolve destination host. I have even tried using the ip address of the instance. Kindly help. Thanks in advance Athar
Conceptually (because I have no knowledge of how MS SQL works): 1. Does the MS SQL server listen on TCP port? 2. Is that port open on the host's firewall (if any)? That's as far as my uneducated guess can get, otherwise you always need to include some logging level in your programs and read the logs outputted. On Sat, Aug 13, 2011 at 09:38, Athar Ahmad Bhatti <atharab@gmail.com> wrote:
Dear friends
I wish you a lovely day.
I am getting an error on redhat 5 not connecting to microsoft sql via isql. The error is that could not resolve destination host. I have even tried using the ip address of the instance.
Kindly help.
Thanks in advance
Athar
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ I can't hear you -- I'm using the scrambler. Please consider the environment before printing this email.
Make sure 1. The SQL Server is configured to allow remote connections (this is off by default) 2. Port 1433 is open and not being blocked by firewall On Sat, Aug 13, 2011 at 9:38 AM, Athar Ahmad Bhatti <atharab@gmail.com>wrote:
Dear friends
I wish you a lovely day.
I am getting an error on redhat 5 not connecting to microsoft sql via isql. The error is that could not resolve destination host. I have even tried using the ip address of the instance.
Kindly help.
Thanks in advance
Athar
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Typically, Sql will use port 1433. You need to define that in the connection string and pass username and password to the right db(if you are not using sa) Also, ran profiler on the database instance and trace for failed or attempted logins You will be able to see what's going wrong Thanks On 8/13/11, Athar Ahmad Bhatti <atharab@gmail.com> wrote:
Dear friends
I wish you a lovely day.
I am getting an error on redhat 5 not connecting to microsoft sql via isql. The error is that could not resolve destination host. I have even tried using the ip address of the instance.
Kindly help.
Thanks in advance
Athar
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Sent from my mobile device
Thanks guys. Will try it out. Sent from my iPad On Aug 13, 2011, at 11:25 AM, Agosta Liko <agostal@gmail.com> wrote:
Typically,
Sql will use port 1433. You need to define that in the connection string and pass username and password to the right db(if you are not using sa)
Also, ran profiler on the database instance and trace for failed or attempted logins
You will be able to see what's going wrong
Thanks
On 8/13/11, Athar Ahmad Bhatti <atharab@gmail.com> wrote:
Dear friends
I wish you a lovely day.
I am getting an error on redhat 5 not connecting to microsoft sql via isql. The error is that could not resolve destination host. I have even tried using the ip address of the instance.
Kindly help.
Thanks in advance
Athar
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Sent from my mobile device _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
participants (4)
-
Agosta Liko -
Athar Ahmad Bhatti -
Odhiambo Washington -
Rad!