I have a Windows Home Server connected to my home network on which I have just installed SQL Server 2008 R2, I am aiming to connect to the SQL Server installation from my laptop using SQL Management Studio using my Windows Credentials (I selected mixed mode authentication during installation).
I have a few questions about both the installation and connection:
- What is the default instance and how is it used within SQL Server?
- In the connection screen on my laptop I can select my server itself as a database engine, is this correct?
- When I try to connect via step three I receive a timeout error, (Error number -2), how would I go about fixing this?
I hope I have provided enough information, feel free to let me know if you need anything else.
Thanks for your time.
Solution (Expanded from Ganesh R.):
After following some of the guidance by Ganesh it led me to this article:
The problem was my Home Server was blocking any attempt to connect to the database due to Windows firewall, one exception rule later and it works great!