Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

Connecting to a remove SQL server that is stopped

In query analyzer there is an option to start sql server if stopped. I want to emulate this login screen for my applicatin.  If I wanted to connect to a remote server using sql server authentication how would I do this.

Does anyone have any code to check and if necessary start the sql server service on the remove server, using sql server authentication not windows authentication.


thanks

Ian
0
alchemy9
Asked:
alchemy9
1 Solution
 
lmcmilliCommented:
I use the SDAC product ftom crlab.  It costs but it is good.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now