Viewing 15 posts - 601 through 615 (of 2,857 total)
I've noticed this too. For me, I usually get that error if I wait too long to click on "Submit" after loading the page. Like if I load the page,...
February 4, 2022 at 3:33 pm
Just to confirm something - what does the network traffic look like on the AG instances?
My thought here is that your non-AG instances seem to be working fine, but the...
February 4, 2022 at 3:32 pm
If you configured the publisher and subscriber on the local system, then nothing should be going to Azure.
My understanding of replication is that you need to have a publisher which...
February 4, 2022 at 3:21 pm
My opinion - Profiles (and all other database mail configuration stuff) should be handled by the DBA, not by "corporate people". Heck, the SQL Server install should be done by...
February 4, 2022 at 2:26 pm
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...
February 4, 2022 at 2:17 pm
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...
February 3, 2022 at 10:32 pm
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...
February 3, 2022 at 10:24 pm
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...
February 3, 2022 at 10:18 pm
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...
February 3, 2022 at 2:21 pm
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...
February 1, 2022 at 7:39 pm
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...
January 31, 2022 at 8:04 pm
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...
January 31, 2022 at 3:01 pm
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...
January 31, 2022 at 2:49 pm
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...
January 28, 2022 at 10:17 pm
Viewing 15 posts - 601 through 615 (of 2,857 total)