943,920 Members | Top Members by Rank

Ad:
  • C# Discussion Thread
  • Unsolved
  • Views: 741
  • C# RSS
Apr 18th, 2008
0

accessing sqlserver on remote system

Expand Post »
Hi,

How to connect to sql server...on a remote system using the IP address of the machine.
I actually want to start the MSSQLSERVER on a remote machine using the sql service manager.
how can this be done.

thanks.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
santoo is offline Offline
17 posts
since Nov 2006
Apr 18th, 2008
0

Re: accessing sqlserver on remote system

don think its possible
Reputation Points: 10
Solved Threads: 0
Newbie Poster
lazybugger is offline Offline
7 posts
since Feb 2008
Apr 18th, 2008
0

Re: accessing sqlserver on remote system

SQL is a service. Therefore using the NET START syntax for a remote machine might get it done.
Reputation Points: 69
Solved Threads: 75
Posting Pro in Training
JerryShaw is offline Offline
465 posts
since Nov 2006
Apr 19th, 2008
0

Re: accessing sqlserver on remote system

Found a way of doing this using SMO.
The MSDN website has some almost useless (as usual) examples, but it should point you in the right direction.
Reputation Points: 69
Solved Threads: 75
Posting Pro in Training
JerryShaw is offline Offline
465 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in C# Forum Timeline: make executed project
Next Thread in C# Forum Timeline: help me please





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC