March 23, 2014 at 10:58 pm
Dear,
I have two servers. One is primary and other is backup. In primary server, I installed Windows 2008 R2 64 bit and SQL Server 2008 R2 64 bit. In backup server, I installed Windows 7 Ultimate 32 bit and SQL Server 2008 R2 32 bit.
When I try to connect database of backup server from primary server via SSMS, I become successful. But if I try to connect database of primary server from backup server via SSMS, I become failed.
I have enabled all the protocols. I can access primary server using remote desktop from backup server and vice versa.
Now I am not getting any clue. Please help me to sort out the problem.
Thanks
Akbar
March 23, 2014 at 11:53 pm
Check that the firewall is enabled on the Windows 7 machine (by default it is). It may be blocking port 1433. Also please check the Event viewer logs and the SQL Server Error logs to see if anything has been recorded there.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 24, 2014 at 5:53 am
Thanks to MyDoggieJessie. It really worked for me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply