Is there a way to install SmartConnector standalone without the need for a separate database to connect to?

[jritchey_jaxcon]

For one of our potential deployments, the customer absolutely does not want another SQL database on their system. Our current use of SmartConnector only uses an endpoint to retrieve data from EcoStruxure.

Would it be possible to deploy SmartConnector without the use of a database? Outside of configuration data, it doesn’t appear that the database is holding that much information in other similar deployments we have.

[sesa180908_brid · Accepted solution]

The short answer is "no". 

SmartConnector requires a database.  That said, v2.3 introduced support for LocalDb which is intended to run on the same machine as SmartConnector. 

[jritchey_jaxcon]

I've started setting up a proof-of-concept for this localDB, and I'm running into a problem where I can't reach the server on port 8082.

The last thing in the logs is:

2018-08-03 12:16:14.0093,Status,Service,<no principal>,PortalAddress disabled because there is no defined endpoint.,

I believe I'm having the same problem as before in this question:

Trouble connecting to SmartConnect config page after fresh install

Has there been any update on this?

[JeffBowman]

Hi Josh,

By the error message, it seems as though the database itself was created, but no tables were created.

Can you verify that your Windows user and potentially the SYSTEM user has at least Database creator permissions in your Local DB setup?

Regards,

-Jeff

[jritchey_jaxcon]

Your diagnosis was correct.  I used SQL Management Studio and logged in as the Windows user, and they did not have dbcreator permission.  Funny enough, I was able to add that permission 'to myself' while logged in as that user.  So I had enough permission to change my permission to dbcreator.  I had to uninstall/reinstall to get it to work.