Author message:

SQL Server session store for Connect/Express based on node-mssql.

npm install connect-mssql

Before you can use session store, you must create a table. Recomended table name is sessions but you can change it via options.

CREATE TABLE [dbo].[sessions](
    [sid] [varchar](255) NOT NULL PRIMARY KEY,
    [session] [varchar](max) NOT NULL,
    [expires] [datetime] NOT NULL
)

var session = require('express-session');
var MSSQLStore = require('connect-mssql')(session);
 
var config = {
    user: '...',
    password: '...',
    server: 'localhost', 
    database: '...',
    
    options: {
        encrypt: true 
    }
}
 
app.use(session({
    store: new MSSQLStore(config, options), 
    secret: 'supersecret'
}));

• options.table - Table to use as session store. Default: [sessions]
• options.ttl - (Time To Live) Determines the expiration date. Default: 1000 * 60 * 60 * 24 (24 hours)
• options.autoRemove - Determines if expired sessions should be autoremoved or not. If value is interval then a new function, destroyExpired(), will autodelete expired sessions on a set interval. Default: never
• options.autoRemoveInterval - Sets the timer interval for each call to destroyExpired(). Default: 1000 * 60 * 10 (10 min)
• options.autoRemoveCallback - Is the callback function for destroyExpired(). Default: undefined

var store = new MSSQLStore(config, options);
 
store.on('connect', function() {
    
});
 
store.on('error', function() {
    
});
 
app.use(session({
    store: store
    secret: 'supersecret'
}));

To see all options please visit node-mssql docs.