How to Connecting to SQL Server 2008 from 2005 SSMS

Discussion about windows hosting plans offered by Hostriples. Issues and solutions on Plesk control panel, emails, MySQL and MS SQL Databases, asp.net, Coldfusion, phpmyadmin, MS Access, ODBC, GD library and much more.
hrdedicated
Site Admin
Posts: 50
Joined: Thu May 30, 2013 10:28 pm

How to Connecting to SQL Server 2008 from 2005 SSMS

Postby hrdedicated » Sat Jun 01, 2013 7:44 am

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,

Return to “Windows Shared Hosting Services Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest