Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

Service not starting after fresh install of SQL2012 and SmartConnector

SmartConnector Forum

Schneider Electric support forum about SmartConnector applications for integration of other building management systems (BMS) into EcoStruxure Building Operation.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • EcoStruxure Building
  • SmartConnector
  • SmartConnector Forum
  • Service not starting after fresh install of SQL2012 and SmartConnector
Options
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
JeffBowman
Sisko JeffBowman Sisko
164
ardak
ardak Schneider Alumni (Retired)
34
sesa180908_brid
Commander sesa180908_brid Commander
34
mike_meirovitz
Commander mike_meirovitz
21
View All

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to SmartConnector Forum
LucasHawk
Lieutenant JG LucasHawk Lieutenant JG
Lieutenant JG

Posted: ‎2018-02-28 02:09 PM

0 Likes
1
685
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-02-28 02:09 PM

Service not starting after fresh install of SQL2012 and SmartConnector

I just installed SQL2012 Express and SmartConnector. SmartConnector service is not starting, and provides the following error:

I found the following post, and checked the logs:

SmartConnectorService  can not start

The .log file attached contains the info. It appears there was some user/password snafu, and I am unsure how that gets established.

For some background, I have attempted this several times, working on this for the past 8 hours. I have Installed and uninstalled this 4 times, using SQL2017 (which I then realized was not supported), SQL2016 (which had this same problem of not starting the service), and now SQL2012. I just clicked through the basic, default SQL installation (including adding a check to 'LocalDB'), then followed the 'Installation and Configuration Guide'. I did the 'Complete Install', and set this exactly as seen, making the password 'admin':

I am ridiculously unsure how the DB should be configured, and the install guide is unclear. Would it be possible to get a set of queries to configure SQL as it should be? Is there some better guide for the SQL part of this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

EDIT:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I got this working. I did a few things; I am not sure which one actually worked.

First off, I used the SqlExpress Server Type in the SmartConnector install, instead of LocalDB. (I had both installed, but I guess LocalDB wasnt wanting to work...) I used 'Windows Implicit' Authentication (just trying to develop things ATM), and it started throwing a new error in the logs, and actually installed the DB, but it still seemed to be a permissions problem.

I found this post - iis - SQL Server Login error: Login failed for user 'NT AUTHORITY\SYSTEM' - Stack Overflow  - (ALL HAIL StackOverflow!!), and made the 'NT AUTHORITY\SYSTEM' user the sysadmin of the DB. This FINALLY got the service running when I then reinstalled SmartConnector. However, when I browsed to 'localhost:8082', it was no dice.

So, I thne remembered seeing this post at some point during the day - Enable remote connections for SQL Server Express 2012 - Stack Overflow  - (Seriously. HAIL. THEM.) I started the SQL browser service, and I am now about to attempt a login.

Now that step 1 is done, maybe I will not have to come back. Maybe. Only 60 pages of install and config to go. (One can hope...)

Attachments
Install and Attempted Service Restart.log.zip
Tags (3)
  • Tags:
  • failed install
  • sql management
  • sql server configuration
Reply
  • All forum topics
  • Previous Topic
  • Next Topic
Reply 1
JeffBowman
Sisko JeffBowman Sisko
Sisko

Posted: ‎2018-03-01 06:26 AM

0 Likes
0
628
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2018-03-01 06:26 AM

Hi Lucas,

I am glad you were able to work through your install issues on your own!

Let me see if I can shed some light onto what you were experiencing.

  • SQL 2017 isn't official supported, but I can say that I have used it with no problems, and am currently doing on on my personal computer, so I don't believe that was your problem.
  • If you are just setting this up for yourself, I would recommend enabling the 'sa' user in your SQL installation, and setting a password. Then using 'SQL Server' authentication type in the installer and using the 'sa' username and password configured above.
  • When using the Windows login authentication types (both implicit and explicit), the logged in user (in the case of implicit), and the specified user (in the case of explict) must have at least 'public' and 'dbcreator' roles in the SQL server installation. This is mentioned in the install guide.

The next part of it, where after using 'Windows implicit' credentials and then receiving the permissions error for NT AUTHORITY\SYSTEM, after looking into it, I actually think that this part of it is a bug in the installer. When using the Windows implicit login types, the installer should be setting up the System user permissions in the database, and making sure the SYSTEM user doesn't need elevated SQL permissions besides 'db_owner' on the SmartConnector database. In inspecting the installer code, although the code that does this exists, it is not being executed when the installer runs.

Overall though! I think you may have gotten over the hardest part (harder than it should have been for sure, the installer will be fixed going forward.) Once the service is installed, running, and licensed, I hope understanding the configuration will be more straight forward for you!

Thank you for reaching out!


Regards,

-Jeff

Reply
Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of