Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. Error applying server configuration with MS SQL 2012

Error applying server configuration with MS SQL 2012

Scheduled Pinned Locked Moved Support
2 Posts 1 Posters 28.1k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C
    C
    cjmcgee
    wrote on last edited by
    #1

    I am getting an error connecting to the database on the "applying server configuration" step.

    Windows Server 2012 Standard
    Microsoft SQL Server Express 2012 x64

    • SQL Server is installed as the default instance (MSSQLSERVER).
    • I checked that Named Pipes and TCP/IP are both enabled protocols for SQL.
    • I verified that MyDomain\MyAccount is server admin on this SQL instance.  Also to verify, I connected as this user (using SQL server management studio) and created a test database.
    • The NetXMS core service is setup to run as MyDomain\MyAccount
    • I verified that SQL is allowed on the firewall

    On the select database page I have this selected:

    • Microsoft SQL Server
    • mssql.ddr
    • localhost
    • create new database
    • DBA login name = *
    • DBA password =
    • Database name = netxms_db
    • DB login name = *
    • DB password =

    The error message I get is "Unable to connect to database [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MyDomain\MyAccount'."

    If I change the database server from "localhost" to "MyServerNetBIOSName" I get the same message.
    If I change the database server from "localhost" to "MyServerNetBIOSName\MSSQLSERVER" I get "Unable to connect to database [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Connection string is not valid [87].", but I get a similar message if I try to connect to this instance in SQL management studio. 

    Any suggestions about what I am doing wrong?

    Thanks

    1 Reply Last reply
    0
    • C
      C
      cjmcgee
      wrote on last edited by
      #2

      I was able to get around this by creating a blank database using SQL Server Management Studio and then choosing "Use existing database" along with checking the "Initialize database" checkbox.  It seems like the DBA User = * option is not working with my setup.

      1 Reply Last reply
      0

      Hello! It looks like you're interested in this conversation, but you don't have an account yet.

      Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

      With your input, this post could be even better 💗

      Register Login
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      Powered by NodeBB Contributors
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups