Member Avatar for santoo

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.

  • 3 Contributors
  • 3 Replies
  • 118 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by JerryShaw
Member Avatar for lazybugger

don think its possible

Member Avatar for JerryShaw

SQL is a service. Therefore using the NET START syntax for a remote machine might get it done.

Member Avatar for JerryShaw

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.