ODBC error - Network interface card

[KSiva]

Hi all,

I just installed a new network card (has static internet ip address) to sql-server 2000 which already had another network card set intranet ip address.

From the client end (locally) we can connect to the server using old ip address (intranet) but we cant connect using other network card. But we can ping that network card. Not sure if I have to change setup in sql-server?

Please help me here!

Siva Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.

 

[sguslan]

Where can you ping the new card from, internet or locally?
More, you can connect from the internet or what? Is there a firewall that prevents access to the SQL port? ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[tlbroadbent]

Check out the following.

http://support.microsoft.com/default.aspx?kbid=294453

FYI: There is a new SQL Server Setup and Administration forum on Tek-Tips. Please post future questions about Setup and Admininstration in forum962. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[KSiva]

Thanks every one,

It's just matter of restarting the sql-server. I installed network card and enabled it after sql-server starts. sqlserver did not detect that card when it was loading up. I needed to restart the service to detect the card.

Thanks everyone!

Siva Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.