New answers tagged security
As mentioned by Aaron, you're login 'say' X would be pointing to a different database rather than NordenWeb, when it throws error with state 38: You need to check the login for any other mapped databases. To find correct error you need to enable the trace when above error is created: To dig in deep do nslookup 184.108.40.206 from windows to find the host ...
As long as you change the service account within SQL Server Configuration Manager (SSCM) it will apply all the permissions required (registry, files, etc.). Only thing to be aware of are those rare occasions where SSCM process does not apply all permissions as expected, generally from some WMI issue. I so far have not come across this in new versions of ...
My blind guess would be to look in %APPDATA%\MySQL on your system as follows: cd %APPDATA% cd MySQL dir .my_secret For those who use the MySQL no-install Zip File (such as myself), you will not see one. If .my_secret is not on your Windows servers, I have an alternative. You could start up mysqld manually with skip-grant-tables, set the password net ...
Can you check your my.ini file? (inside MySQL folder) There you should find something like: [mysqladmin] user=root password=pwpwpw port=3306
Put NT AUTHORITY\SYSTEM user in sysadmin server role Add this user into linked server login mappings with remote user name and pwd
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 ...
Top 50 recent answers are included