SQL Server & Terminal Services Questions

kdcui

Lifetime Supporting Member
Join Date
Dec 2007
Location
USA
Posts
386
So we have a SQL Server 2008 running on a Windows Server machine that our iFix SCADA is writing to periodically.

If we want to connect to the SQL server, we are doing it remotely via MSTSC.

My question is, when the server is powered off and rebooted, does the SQL Server service start up if no one logs in? This is running as a console service, right?

If I remote in to the server, I usually log in as the Administrator. Should I be using the /console command to remote in? In either case (with or without /console) I am logged in the Administrator, but with the /console switch I can see the SQL Server service running in the background.

When it is time for me to log out, if I am running as a console session, with "Log Out" completely kill anything running as a console service or is it ok to simply close the console session without logging out?
 
SQL Server defaults to running as a system service; available at all times, unless you explicitly change it.

As long as it is running as a system service, then logging in or out will make no difference to it.
 

Similar Topics

Hi all, I'm having difficulties trying to connect FactoryTalk View SE Local Station (V13.00) to MS SQL Server Express. I state that they are...
Replies
2
Views
132
Hi, All: I have a project to replace 3 old window 7 PCs with new window 10 PCs. the 3 old PCs: one is FTV SE server, other 2 are SE clients...
Replies
2
Views
575
Hi everyone, I have a small project where I need to use plc to get sensor data and log them to an sql server locally or remote. I have found...
Replies
7
Views
2,808
Hello, I have a FT view version 12 application running and receiving alarms from my PLC. I have verified I have active alarms and when I...
Replies
3
Views
3,143
Hi, Can someone guide me through how to use FactoryTalk SE VB script to open communication with SQL Server? which command I can use? Are there...
Replies
2
Views
2,295
Back
Top Bottom