Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : General : SQLServer

Connection open while running DB manager in Client system

Issue:
When performing the Connection test while running the DB manager in client system in RPOS7 returns connection test failure. In client machine DB was not created due to server DB unreachable(Sql).

Observation Made:
1. LAN connection was good.When tried to ping the server by machine name it was not connected but when tried to ping by IP it was replied.
2.In cliconfg the Tcp/Ip and named pipes are also enabled.

Cause:
Our DB manager always looks for server machine name.Here it can't able to fine the server machine name so it returned the connection failure. Issue is due to pinging not succeeded with server machine name.

Solution:
1. In client machine navigate to System32/drivers/etc/hosts file.

2. Rename hosts file as hosts.txt and add the server machine name with server IP here at last.

3. Rename as hostfile(remove.txt).

Now try to ping by server name it will get pinging and issue get solved.

Note:
1.If we use IP instead of server name in DB manager it will create.
2. In RPOS6 it will returns SQL connection open.

Thanks,
Ramprakash S





Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Article # 566

Created:
08-03-2010 10:09am

Last Updated:
08-03-2010 10:53am

Views:
1223

Rating:
NA

Rate This Article:


Attachments:
None

Powered By AutoKB