Access Remote SQL server Database from local machine

Sheraz Khan · May 18th, 2010, 04:29 PM

Hi,
How can i connect my local project with the SQL server 2008 Database that is running on other server (This server is not on my network and i connect to it via remote desktop connection).

Cheers
S

melvik · May 27th, 2010, 03:01 AM

well I guess u have to assign ur server in Configuration manager
go to

Code:

Start\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager

SQL Native Client Configuration node & Aliases
add ur Server IP or any topology u r going to connect & then smile lile

HTH