Forum Discussion

Shahid2000's avatar
Shahid2000
Copper Contributor
Dec 28, 2023
Solved

Have issues connecting my .bak file to SQL Server (using SSMS)

Hi there, I am very new to this SQL and SSMS.  I have downloaded the SQL Express and SSMS 19.2.  I have downloaded the "KCC Sample Database.bak" as a database file to practice on SQL Server.   I ...
  • olafhelper's avatar
    olafhelper
    Dec 29, 2023

     

    Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists

    Shahid2000 , where have you placed the backup file?

    Keep in mind, not "you" accesses the backup file, it's the SQL Server service account and if you stored the BAK file somewhere in your profile folder, the account can't access it.

    Move the BAK to the backup folder of SQL Server.

olafhelper's avatar
olafhelper
Bronze Contributor
Dec 29, 2023

 

Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists

Shahid2000 , where have you placed the backup file?

Keep in mind, not "you" accesses the backup file, it's the SQL Server service account and if you stored the BAK file somewhere in your profile folder, the account can't access it.

Move the BAK to the backup folder of SQL Server.

  • Shahid2000's avatar
    Shahid2000
    Copper Contributor
    Jan 02, 2024

    olafhelper 

    Hi there,

    Thanks for your help.  I appreciate it.,

    Yes, I was able to access and see the backup after going into specifically SQL Server Configuration and Refreshing that.

     

    Thanks for your help anyways.  I do appreciate this a lot.

     

    Take care.

     

    Shahid.

Resources