On one of our servers is a copy of SQL Server express, it plays "some" role within one of major IT applications. We wanted to check the configuration of the SQL express server, but there doesn't appear to be any sort of management studio installed on the server on which to check settings, i.e. patches, backups, location of DB's, who has access etc.
As I am not a DBA do you need some sort of SQL management studio installed on that server, or can you still connect to that system remotely from a PC with management studio installed.
are there any risks/concerns you as DBA's would have if you found a SQL express version without a management studio installed on the server, if so could you list which.