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

Table of Contents

Hello,

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.

Regards,


How to Connecting to SQL Server 2008 from 2005 SSMS .., Hostripples Web Hosting
HR-ADMIN