The path specified by "c:\Data\imoltp_mod1" is not in a valid directory

Question

I am using Sql Server InMemory OLTP for Asp.Net application to store session data in Sql Server using this link

After that i found one error like need to create file group for the database which i used for InMemory OLTP. I was able to create the file group for my existing database. After that need to add file, For that i have tried below Query:

ALTER DATABASE imoltp ADD FILE (
    name='imoltp_mod1', filename='c:\data\imoltp_mod1')
    TO FILEGROUP imoltp_mod;

But when i run above query i am getting below error:

Msg 5121, Level 16, State 2, Line 1
The path specified by "c:\Data\imoltp_mod1" is not in a valid directory.
Msg 5009, Level 16, State 14, Line 1
One or more files listed in the statement could not be found or could not be initialized.

in this path i created "Data" folder, Or even tried to change the drive from C to D but still getting the same error. I have also created new database as per this link provided solution. But stil stuck in same query.

I have here few question related to session store in DB.

When i provided DB name in session membership provider related connnectionstring, Will it create table dynamically, If yes then what could be the name of table?

Please suggest.

Answer 1

I also had this error. Then I realized that the c:\data\ folder has to be created on the server and not my own developer machine.