Jump to content
JohnnyJoker

SQL Server 2014 Dependencies?

Recommended Posts

Hello dear friends of monitoring ;)

We're using SQL 2014 Enterprise Edition in production and it seems I can't setup the SQL Server Module.

It's a named Instance and Connection Tests succeed.

I've tried with Windows Authentication (Service runs as Local System) and a dedicated SQL Login with serveradmin role (not using a Domain Account there) but it shows the same behaviour.

Also I have installed "Microsoft SQL Server 2008 R2 Management Objects (x64)" (Version 10.50.1600.1) and "Microsoft SQL Server System CLR Types (x64)" (Version 10.50.1600.1) but there are also the x86 Versions (without (x64) in their name - Version 10.51.2500.0) installed or rather were installed with the SQL Server 2014 itself. When I try to install them from a fresh download (https://www.microsoft.com/en-US/download/details.aspx?id=16978) the setup tells me that there is already a newer version installed.

On the Client (Android App) it can't load any information from the SQL Server. I can see The Databases but can't do anything else.

See attached trace.log and Screenshot of Programs and Features of said Server.

 

Thank you and kind regards, Jonathan

SQL2014_SMO-CLR.jpg

trace.log

Share this post


Link to post
Share on other sites

Hi Jonathan,

Thank you for your logs. You need to add the 'securityadmin' role to the SQL user you've configured in Pulseway Manager.

Chris

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...