Viewing 2 posts - 1 through 2 (of 2 total)
Could possibly be Kerberos SPNs needing to be created for the new server.
The SQL Server service account often needs SPNs created to make a conneciton, or you get anonymous NTLM...
September 10, 2024 at 5:35 pm
#4456234
USE <dbname>
GO
GRANT EXECUTE TO <username>
This grants execute to all stored procedures and functions at database level. No database role is created.
September 10, 2024 at 4:53 pm
#4456207