08-12-2016 04:35 PM
Every time I boot up my machine, SQL SERVER (ACT7) is showing as "Running" and is set to "AUTO" but when I load Act and open my database, it says its unable to connect.
I've tried the RESETSQL.BAT file but that just temporarily resolves the issue, presumably because it's restarting SQL SERVER. For example, even without executing this .bat file, if I simply restart the SQL server, then my database opens fine.
I checked event viewer and saw the following:
"Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'DBNAME'. [CLIENT: IP Address]"
08-12-2016 08:32 PM
08-14-2016 10:24 PM