User Profile
Ben_Miller_DBADuck
MVP
Joined Sep 18, 2018
User Widgets
Recent Discussions
Re: Error msg: Login failed for user... Reason: Failed to open the explicitly specified database 'JetSer
Because the CLIENT indicates in the error message that it is from ::1 it means that it is from the local machine. NETWORK SERVICE could be a service that is logging in as that. You can see quickly if it is related to SQL Server services by going into the SQL Configuration Manager on the server and go to Services and see if NETWORK SERVICE is a login that uses this account.2.4KViews0likes0CommentsRe: Error msg: Login failed for user... Reason: Failed to open the explicitly specified database 'JetSer
In Management Studio Object Explorer, do you see this database? Is it Online or does it have a message to the right of the database? Things like (In Recovery) (Suspect) or is it normal? If it is normal then maybe that login does not have access to that database by login. Is the NT AUTHORITY\NETWORK SERVICE a login in the Logins? Is it mapped to that database? The bigger question is what is using the NETWORK SERVICE login? Is it authorized to be used? This is normally not a login that you grant access to databases.2.6KViews0likes2CommentsRe: Backing up using Differential in Microsoft SQL server management studio 2016, but see error.
The job failed, maybe not the backup. You need to expand the job failure with the + sign and see what the messages are in that entry. There could have been more in the Maintenance Plan that failed but the backup succeeded.1.2KViews1like1CommentRe: Encrypted backups using Asymmetric key
bake13 is correct, when using Asymmetric keys you must use an EKM like Azure Key Vault or another one that supports SQL Server. You can create an Asymmetric key in SQL Server, but if it is not managed in an EKM, it cannot be used to do Encrypted Backups.2.3KViews0likes0CommentsRe: ODBC Linked Server in Managed Instance
What is the target of the Linked Server in managed Instance? ODBC should be able to connect to managed instance, so I am not sure the question is very clear as to what you are trying to do. ODBC --> ManagedInstance TSQL --> SELECT * From LINKEDSERVER.Database.dbo.Table Not ODBC --> LinkedServer3.5KViews0likes0Comments
Recent Blog Articles
No content to show