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.

don think its possible

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

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.