Skip navigation
2852 Views 7 Replies Latest reply: Dec 9, 2011 2:35 AM by ahe RSS
pmoreno Employee 174 posts since
Feb 24, 2008

Has received 1 of 9 achievements.
Currently Being Moderated

Oct 19, 2011 2:47 PM

Console in Windows 7 does not connect to the SQL server

Hello,

 

Some of my colleagues are now installing LANdesk console LDMS 9 SP2 in Windows 7 machines and all of them have the same issue. After console installation login into console is rejected with the message "[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exists or access denied.". We have disabled Windows 7 firewall and we can ping perfectly the MSSQL server and we can even telnet into SQL server port 1433, but we can not log into LANDesk console.

When using a WXP LANDesk console we don't have any problems, so we think this must be a specific Windows 7 issue. Does anybody have experienced this issue?

 

Thanks

  • mrspike SSMMVPGroup 1,313 posts since
    Dec 19, 2007

    Has received 9 of 9 achievements.

    Make sure they are going to the LANDesk Console Icon and right clicking on it, and choosing "Run as different user" and that they LAUNCH it with the same credentials that they use to LOG into the console

  • ahe Expert 862 posts since
    Dec 21, 2007

    Has received 4 of 9 achievements.

    Hello,

     

    additionally to the good tips of billyc and James, we solved a lot of performance problems with a local LANDesk Console after we add the core(s) and their database server(s) in our local hosts file with shortname (NOT FQDN!)!

     

    I hope LANDesk will change the need to open the local Console with a administrative account...

     

    Regards

    Axel

  • dbozic Rookie 21 posts since
    Apr 2, 2008

    Has received 1 of 9 achievements.

    Capture.bmp

     

    This king of error ? A way to get arround this, is to check for the following registry entries (here 64bit):

     

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo]
    "yourcoreserver"="DBMSSOCN,yourcoreserver,port"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\DB-Lib]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SuperSocketNetLib]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect]
    "yourcoreserver\\LDMSDATA"="-1022427127:tcp:yourcoreserver,port"

     

    Hope it works....

     

     

    Damir

  • ahe Expert 862 posts since
    Dec 21, 2007

    Has received 4 of 9 achievements.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software