If replication from on-prem to the cloud works without firewall changes, I would be suspect of your firewall.  I would double and triple check your firewall configuration to make sure...

As far as I know, every time I set up a new instance, I re-setup the mail profile.  I currently use the GUI for it as I lost my mail...

Pretty sure SQL doesn't log that information.  In general, I have found that I don't care who created an index, I just care that the correct indexes are created.  Only...

I think it is one of those "it depends" scenarios.  If the column is named $$SomeName, then yes, the $'s are part of the column name.

If it is not a...

I can't speak to replication from on-prem to cloud as I've not done that, but you ask what other options do you have and there are options.  You could use...

Sounds like you are missing the Visual C redistributable package (VC_red.msi is the Visual C REDistributable package).

I would look for a copy of KB3045321 from Microsoft and HOPE they still...

As far as I am aware, and if I am understanding what you are saying, you can't do that.  I am PRETTY sure that SSDT would push across all of...

I am 99.999% sure that an INSERT failure is going to be different than a failed login error.  The INSERT failure sounds like you are modifying a maintenance plan with...

Something to note - installing an unsupported application (SQL 2000) on an unsupported OS (any that would support SQL 2000) will result in an unsupported scenario.

That being said, a quick...

My opinion - check the logs.  The message "the login failed" makes me think that the account was locked out or otherwise disabled.  If it is an AD account, if...

Is it always failing on the same file?  If so, then it is likely something with that file and the restore.  If it is sometimes failing on that file and...

My approach is to design the database with restrictions in place to begin with.  Use roles to restrict what data a user is allowed to access.  I expect (ie hope)...

Might not hurt to check out the Exchange error logs and see what those say.  Could be something that is easily corrected by reviewing the logs on the other side...

SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.

I believe you would need to upgrade to Enterprise to...

You could use ISNUMERIC.

Personally, if I COULD I would be changing the application that puts the data into the system to validate it and refuse to store invalid data.

Failing that,...