How to Connecting to SQL Server 2008 from 2005 SSMS ..


To configure MS SQL service you need to connect the server via RDP and then open SQL configuration manager >>> expand the option ” SQL server network configuration” >>> select protocol TCP/IP >> right click on it >>> enable.

You need to enable only TCP/IP, Named pipes, Shared memory.
Once you enable TCP/IP protocol and open it >>click on IP address >>> assign default MsSQL port and enable IPv4.


Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.