Tag Info

Hot answers tagged


To get the information for a single instance you would use DaysUntilExpiration value for the LOGINPROPERTY function. This will give you the days until the password expires. You can then cast that as an integer and use the DATEADD function to get the actual date. SELECT name AS LoginName, DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS ...


Machine accounts such as LocalService cannot be trusted over the network. There is essentially no way to authenticate the remote machine without domain authentication of some kind. Use SQL Server authentication; that's what it is meant for. Alternately, you could provide a setup procedure that allows your clients to provide a domain account for each ...

Only top voted, non community-wiki answers of a minimum length are eligible