• jghali (6/4/2010)


    ...

    Create Database Mytestdb

    on

    ( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB

    )log on(

    name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)

    ...

    CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\MyTEST.mp3'.

    ...

    Can someone explain if this behavior is normal?? I'm suspecting that it's some type of setting on my account... :doze:

    The permissions required are for the account that SQL Server is running under, not your account.

    To see what account that is, open the services panel (services.msc) for example, and find the MSSQL Service.

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.