Do a "winver" or "msinfo32" from run for exact information on OS version. Nope, this hardware is not going to play well with latest versions of OS and SQL. Intel...

I don't think you can open a report created in Data tools(VS) 2017 using VS 2010,2012 or 2013 (As far as I know).

Sounds like you are running on Windows 2008 OS based on the information provided. If you are looking for SQL 2016/2017, you might want to consider spinning up a machine...

Login with sid = 0x01 from sys.logins is the original 'sa' account that gets created during install and this cannot be dropped. In your case, They might have just renamed...

Glanced over your log and it is clearly stating that WSFC was unhealthy - lost Quorum. AGs are heavily dependent on health of your cluster. Below are the events which...

Are you aware of sp_help_revlogin?? If not, check this

https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

Should be fine if it's just for learning/POC/Experimental purposes. As far as I know, you should not run into any issues with installs.

You should get that information in detail in your cluster logs.

BTW, SQL tiger team released an outstanding utility which can be used to analyze (including the Cluster Logs, SQL Error...

How about this?

DECLARE @qry NVARCHAR(max);

SET @qry = 'SELECT * into ContactLog_' + cast(year(getdate()) AS VARCHAR(4)) + cast(month(getdate()) AS VARCHAR(2)) + cast(day(getdate()) AS VARCHAR(2)) + ' FROM ContactLog'...

As Sue mentioned, you need to use [   ]. In your case that would be  " Alter database [ENR Access DB] "

Absolutely agree with Luis.

Good write up Deepak. Never knew it's that simple to implement. Any pitfalls/limitations and GOTCHAs to be aware of based on your experience?

You can't use SSMS to connect and manage IIS, You need something called IIS Manager for that. If you are referring to SSIS, I would not use SSMS 17.9.1 to...

End to End (E2E) migration experience.