accessing sql server instance from another forest

Question

Hello,

I have two forests each has moss 2007 and ocs 2007 that are need to be installed but I can install sql server 2008 only on of the forests and I tried to access from the second forest to the forest that has the sql server but I failed to make use of the sql server in the second forest.

I was searching the net for a wile and couldnt find a solution and was wondering if you could help me.

thanks alot,

Dima Sh.

---

Dima Sh.

Answer 1

Hello,

1. Are you able to ping the database server from one forest to another? Ping bay computer name and by IP.

2. Are you able to connect to the database server using telnet? Telnet computername 1433. This is for a default instance.

3. Try getting connected using a SQL login.

4. Provide any error message you are receiving.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 2

Hey thanks for your replay,

I can ping and connect to the db server using sql login but I cant telnet ethier of the instances both in the forest who has the db server and from the other forest.

To be more clear im trying to achive this

http://serverfault.com/questions/357355/two-sql-server-instances-two-different-domains

but from two different forests instead of domains.

maybe I need to give some permissions but its not really clear to me

thanks alot,

Dima Sh.

---

Dima Sh.

Answer 3

Hello,

Telnet is not enable by default on Windows Server 2008 and later. You have to enable it using Control Panel -> Programs and Features.

Are you able to ping using the server name and using the IP Address?  From the same forest where the database server resides and from the other forest? Verify name resolution (DNS) using nslookup.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com