This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject

→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

Community FAQ
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: 

Getting lansweeper (lswinap) to work.

Sayonara_SA
Engaged Sweeper

‎08-14-2007 02:37 PM

Hi
This might be a port problem. if i do a netstat -a i don't see port 9524. even if i use tcpview ... it still show no port
Ways i've tried to add ports.
1 Start, Control Panel, Windows Firewall,exeptions, add port
2 Start, Control Panel, Windows Firewall,Advanced,Select Local Area Connection, Settings, Add and fill ion the fields as follows:
Lansweeper,127.0.0.1, 9524,9524 and check TCP
.
I've open ports in different ways, but hell I can't see that port. All I want to do is get lswinap to run but it says"

"When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server down not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Then you click OK and it opens the white lansweeper box with no data.

Lsservice can log in and runs perfectly but as soon as you open the website it gives errors.
The top box under description:

<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
runat="Server"
id="DScomputers"
IsStoredProcedure="true"
CreateDataSet="true"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Lansweeper") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_Lansweeper") %>'
CommandText="dbo.WebComputers"
Debug="true"
><Parameters>
<Parameter Name="@RETURN_VALUE" Type="Int" Direction="ReturnValue" />
<Parameter Name="@computername" Value='<%# request("computername") %>' Type="VarChar" Direction="Input" />
<Parameter Name="@description" Value='<%# request("description") %>' Type="VarChar" Direction="Input" />
<Parameter Name="@addomaindns" Value='<%# request("addomaindns") %>' Type="VarChar" Direction="Input" />
</Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>New Page 3</title>
<link href="CSS/lansweeper.css" rel="stylesheet" type="text/css">
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" marginwidth="0" marginheight="0" bottommargin="0">
<table border="0" cellpadding="2" cellspacing="0" width="100%" id="table1">
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="1" cellspacing="1" id="Resulttable">
<tr>
<td width="18" class="columngrey">&nbsp;</td>
<td class="columngrey">Computer (<%= DScomputers.RecordCount %>)</td>
<td class="columngrey">Description</td>
<td class="columngrey">Domain</td>
<td class="columngrey">Last seen</td>
</tr>
<ASP:Repeater runat="server" DataSource='<%# DScomputers.DefaultView %>'>
<ItemTemplate>
<tr>
<td width="18"><font size="1"><img src="Icons/exe.gif" width="16" height="16"></font></td>
<td><font size="1"><a href="process.aspx?computername=<%# DScomputers.FieldValue("Computername", Container) %>&description=<%# DScomputers.FieldValue("theDescription", Container) %>" target="frmprocess" class="hotlink"><%# DScomputers.FieldValue("Computername", Container) %></a></font></td>
<td><font size="1"><%# DScomputers.FieldValue("thedescription", Container) %></font></td>
<td><font size="1"><%# DScomputers.FieldValue("ADdomainDNS", Container) %></font></td>
<td><font size="1"><%# DScomputers.FieldValue("Lastseen", Container) %></font></td>
</tr>
</ItemTemplate>
</ASP:Repeater>
</table></td>
</tr>
</table>
</body>
</html>

and the box underneath that shows:

<%@ page language="VBSCRIPT" ASPCompat="true"%>
<%
if request("link") <> "" then
session("bottomsubbar")= request("link")
else
'session("bottomsubbar")= "empty"
end if
if session("bottomsubbar")="" then
session("bottomsubbar")= "empty"
end if
%>
<Script runat="server">

function getclass(byval sessie as string) as string
if session("bottomsubbar") = sessie then
return "seltext"
else
return "normaltext"
end if
end function
</script>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>New Page 1</title>
<link href="CSS/lansweeper.css" rel="stylesheet" type="text/css">
<SCRIPT LANGUAGE=javascript>

function change() {
parent.parent.frames["frmbottom"].document.location = "<%=session("bottomsubbar")%>.aspx?computername=<%=session("computername")%>";
}

</SCRIPT>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="return change()">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<%select case session("bottombar")%>
<%case "extra"%>
<tr>
<td align="left" valign="top" >&nbsp;<span class="small"><img src="Icons/scan.gif" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=lastscan" class="<%=getclass("lastscan")%>">Last Scan</a> </span> <span class="small"> &nbsp;|</span><span class="small">&nbsp;</span><span class="small"><img src="Icons/error.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=errors" class="<%=getclass("errors")%>">Errors</a> </span> <span class="small"> &nbsp;|</span><img src="Icons/linkicon_external.gif" width="26" height="12"><a href="http://www.lansweeper.com" target="_blank">Lansweeper.com</a></td>
</tr>
<%case "userinfo"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/logoninfo.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=logoninfo" class="<%=getclass("logoninfo")%>">Logon</a> <span class="small">|</span><span class="small">&nbsp;<img src="Icons/user.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=users" class="<%=getclass("users")%>">Users</a> <span class="small">|&nbsp;<img src="Icons/groups.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=groups" class="<%=getclass("groups")%>">Groups</a> <span class="small">|&nbsp;<img src="Icons/usersgroups.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=usergroups" class="<%=getclass("usergroups")%>">Users in Groups</a></td>
</tr>
<%case "hardware"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/printer.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Printers" class="<%=getclass("Printers")%>">Printer</a><span class="small">&nbsp;|&nbsp;<img src="Icons/netw.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=Network" class="<%=getclass("Network")%>">Network</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span><img src="Icons/floppy.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Floppy" class="<%=getclass("Floppy")%>">Floppy</a><span class="small">&nbsp;|</span><img src="Icons/cpu.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Baseboard" class="<%=getclass("Baseboard")%>">Baseboard</a><span class="small">&nbsp;|</span><img src="Icons/battery.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Battery" class="<%=getclass("Battery")%>">Battery</a><span class="small">&nbsp;|</span><img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Bus" class="<%=getclass("Bus")%>">Bus</a><span class="small">&nbsp;|</span> <img src="Icons/cd.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Cdrom" class="<%=getclass("Cdrom")%>">CDrom</a><span class="small">&nbsp;|</span><img src="Icons/system2.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Systemproduct" class="<%=getclass("Systemproduct")%>">SystemProduct</a><span class="small">&nbsp;| </span><img src="Icons/ide.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=IDE" class="<%=getclass("IDE")%>">IDE</a><span class="small">&nbsp;|</span><img src="Icons/infrared.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Infrared" class="<%=getclass("Infrared")%>">Infared</a><span class="small">&nbsp;|</span>&nbsp;<img src="Icons/keyboard.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Keyboard" class="<%=getclass("Keyboard")%>">Keyboard</a><span class="small">&nbsp;|</span><br>
&nbsp;<img src="Icons/device.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Onboard" class="<%=getclass("Onboard")%>">Onboard</a><span class="small">&nbsp;|<img src="Icons/port.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Parallelport" class="<%=getclass("Parallelport")%>">Parallelport</a>&nbsp;|</span><img src="Icons/pcmcia.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=pcmcia" class="<%=getclass("pcmcia")%>">PCMCIA</a><span class="small">&nbsp;|</span><img src="Icons/mice.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=pointing" class="<%=getclass("pointing")%>">Pointing</a><span class="small">&nbsp;|</span><img src="Icons/battery.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=portablebattery" class="<%=getclass("portablebattery")%>">PortableBattery</a><span class="small">&nbsp;|<img src="Icons/device.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=portconnector" class="<%=getclass("portconnector")%>">Portconnector</a>&nbsp;|</span><img src="Icons/modem.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=modem" class="<%=getclass("modem")%>">Modem</a><span class="small">&nbsp;|</span><img src="Icons/processor.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=processor" class="<%=getclass("processor")%>">Processor</a><span class="small">&nbsp;|</span><img src="Icons/ide.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=scsi" class="<%=getclass("scsi")%>">SCSI</a><span class="small">&nbsp;|<img src="Icons/port.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=serialport" class="<%=getclass("serialport")%>">Serialport</a>&nbsp;|</span><img src="Icons/sound.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=sound" class="<%=getclass("sound")%>">Sound</a><span class="small">&nbsp;|<br>
&nbsp;&nbsp;<img src="Icons/tape.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=tape" class="<%=getclass("tape")%>">Tape</a>&nbsp;|<img src="Icons/rdp.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Terminal" class="<%=getclass("Terminal")%>">Terminal</a>&nbsp;|</span><img src="Icons/usb.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Usb" class="<%=getclass("Usb")%>">USB</a><span class="small">&nbsp;|</span><img src="Icons/device.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Video" class="<%=getclass("Video")%>">Video</a><span class="small">&nbsp;</span></td>
</tr>
<%case "installation"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/arp.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=Software" class="<%=getclass("Software")%>">Software</a><span class="small">&nbsp;|&nbsp;<img src="Icons/dcom.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=Com" class="<%=getclass("Com")%>">COM</a><span class="small">&nbsp;|</span><img src="Icons/dcom.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=dcom" class="<%=getclass("dcom")%>">DCOM</a><span class="small">&nbsp;|</span><img src="Icons/dcom.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=componentcategory" class="<%=getclass("componentcategory")%>">ComponentCategory</a><span class="small">&nbsp;|</span><img src="Icons/codec.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=codecs" class="<%=getclass("codecs")%>">Codecs</a></td>
</tr>
<%case "configuration"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=boot" class="<%=getclass("boot")%>">Boot</a><span class="small">&nbsp;|&nbsp;<img src="Icons/desktop.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=desktop" class="<%=getclass("desktop")%>">Desktop</a><span class="small">&nbsp;|</span><img src="Icons/monitor.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=desktopmonitor" class="<%=getclass("desktopmonitor")%>">Desktopmonitor</a><span class="small">&nbsp;|</span><img src="Icons/disk.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=diskpartition" class="<%=getclass("diskpartition")%>">Diskpartition</a><span class="small">&nbsp;|</span><img src="Icons/vid.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=display" class="<%=getclass("display")%>">Display</a><span class="small">&nbsp;|</span><img src="Icons/device.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=displaycontroller" class="<%=getclass("displaycontroller")%>">Displaycontroller</a><span class="small">&nbsp;|</span><img src="Icons/driver.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=drivers" class="<%=getclass("drivers")%>">Drivers</a><span class="small">&nbsp;|</span><img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=environment" class="<%=getclass("environment")%>">Environment</a><span class="small">&nbsp;|</span><img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=extensionaction" class="<%=getclass("extensionaction")%>">ExtensionAction</a><span class="small">&nbsp;|</span><br>
&nbsp;<img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=logicalprogramgroup" class="<%=getclass("logicalprogramgroup")%>">LogicalProgramGroup</a><span class="small">&nbsp;|</span><img src="Icons/empty.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=recovery" class="<%=getclass("recovery")%>">Recovery</a><span class="small">&nbsp;|&nbsp;</span> </td>
</tr>
<%case "windows"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/shares.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=shares" class="<%=getclass("shares")%>">Shares</a><span class="small">&nbsp;|&nbsp;<img src="Icons/disk.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=harddisk" class="<%=getclass("harddisk")%>">Harddisk</a><span class="small">&nbsp;|</span><img src="Icons/service.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=services" class="<%=getclass("services")%>">Services</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span><img src="Icons/netw.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=networkclient" class="<%=getclass("networkclient")%>">Networkclient</a><span class="small">&nbsp;|&nbsp;</span><img src="Icons/pagefile.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=pagefile" class="<%=getclass("pagefile")%>">Pagefile</a><span class="small">&nbsp;|&nbsp;</span><img src="Icons/fix.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=quickfix" class="<%=getclass("quickfix")%>">Quickfix</a><span class="small">&nbsp;|&nbsp;</span></td>
</tr>
<%case "running"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/run.gif" width="16" height="16" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=autorun" class="<%=getclass("autorun")%>">Autorun</a><span class="small">&nbsp;|&nbsp;<img src="Icons/process.gif" width="16" height="16" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=processes" class="<%=getclass("processes")%>">Processes</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span>
</td>
</tr>
<%case "ie"%>
<tr>
<td align="left" valign="top" >&nbsp;<img src="Icons/activex.png" width="16" height="15" align="absbottom">&nbsp;<a href="bottomsubbar.aspx?link=activex" class="<%=getclass("activex")%>">ActiveX</a> <span class="small">|&nbsp;<img src="Icons/activex.png" width="16" height="15" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=bars" class="<%=getclass("bars")%>">Browser Bars</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span><span class="small"><img src="Icons/activex.png" width="16" height="15" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=bho" class="<%=getclass("bho")%>">Browser Helper Objects</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span><span class="small"><img src="Icons/activex.png" width="16" height="15" align="absbottom">&nbsp;</span><a href="bottomsubbar.aspx?link=extensions" class="<%=getclass("extensions")%>">Browser Extensions</a><span class="small">&nbsp;|</span><span class="small">&nbsp;</span> </td>
</tr>
<%case else%>
<%end select%>
</table>
</body>

</html>

i've tried everything and i still can't get this thing running. Please assit


Labels:
0 Kudos
19 REPLIES 19
Sayonara_SA
Engaged Sweeper

‎08-16-2007 12:42 PM

I'm using SQL express 2005

Trying to follow instructions on this document http://support.microsoft.com/kb/265808 to figure out this instance thing
0 Kudos
Hemoco
Lansweeper Alumni

‎08-16-2007 12:25 PM

See this post : http://forum.lansweeper.com/Default.aspx?g=posts&t=128

Which version of sqlserver are you using?
0 Kudos
Sayonara_SA
Engaged Sweeper

‎08-16-2007 12:07 PM

I dont have a clue what you're talking about

but here's my netstat -a


C:\lsservice>netstat -a

Active Connections

Proto Local Address Foreign Address State
TCP SNJHBUTILS:smtp SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:http SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:epmap SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:https SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:microsoft-ds SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:1043 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:1217 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:3389 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:netbios-ssn SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:2508 snctndc01.snvsp.local:epmap TIME_WAIT
TCP SNJHBUTILS:2509 snctndc01.snvsp.local:1025 TIME_WAIT
TCP SNJHBUTILS:2516 snjhbdc02.snvsp.local:netbios-ssn TIME_WAIT
TCP SNJHBUTILS:2519 snjhbdc02.snvsp.local:epmap TIME_WAIT
TCP SNJHBUTILS:2520 snjhbdc02.snvsp.local:1025 TIME_WAIT
TCP SNJHBUTILS:2521 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:2522 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:2523 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:2524 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:2525 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:2526 snjhbdc02.snvsp.local:ldap TIME_WAIT
TCP SNJHBUTILS:3389 snjhblprieckush.snvsp.local:1570 ESTABLISHED
TCP SNJHBUTILS:1096 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:12025 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:12080 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:12110 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:12119 SNJHBUTILS.snvsp.local:0 LISTENING
TCP SNJHBUTILS:12143 SNJHBUTILS.snvsp.local:0 LISTENING
UDP SNJHBUTILS:microsoft-ds *:*
UDP SNJHBUTILS:isakmp *:*
UDP SNJHBUTILS:1025 *:*
UDP SNJHBUTILS:1026 *:*
UDP SNJHBUTILS:ms-sql-m *:*
UDP SNJHBUTILS:2029 *:*
UDP SNJHBUTILS:3456 *:*
UDP SNJHBUTILS:4500 *:*
UDP SNJHBUTILS:ntp *:*
UDP SNJHBUTILS:netbios-ns *:*
UDP SNJHBUTILS:netbios-dgm *:*
UDP SNJHBUTILS:1900 *:*
UDP SNJHBUTILS:ntp *:*
UDP SNJHBUTILS:1027 *:*
UDP SNJHBUTILS:1083 *:*
UDP SNJHBUTILS:1151 *:*
UDP SNJHBUTILS:1366 *:*
UDP SNJHBUTILS:1900 *:*

C:\lsservice>
0 Kudos
Hemoco
Lansweeper Alumni

‎08-16-2007 10:50 AM

Do you have a named instance of sql server?

then you need to connect to "127.0.0.1\name_of_instance"
0 Kudos
Sayonara_SA
Engaged Sweeper

‎08-15-2007 02:15 PM

Configs
LSService
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Example: <add key="settingName" value="settingValue"/> -->
<add key="ConnectionString" value="integrated security=SSPI;data source=&quot;127.0.0.1&quot;;persist security info=False;initial catalog=Lansweeper" />
<add key="ConcurrentThreads" value="10" />
</appSettings>
</configuration>

LSwinap
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Example: <add key="settingName" value="settingValue"/> -->
<add key="ConnectionString" value="integrated security=SSPI;data source=&quot;127.0.0.1&quot;;persist security info=False;initial catalog=Lansweeper" />
<add key="ConcurrentThreads" value="10" />
</appSettings>
</configuration>

Web
<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm" />
<add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=127.0.0.1;Initial Catalog=Lansweeper;User ID=lsuser;Password=lsuser1" />
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />
<add key="MM_CONNECTION_SCHEMA_Lansweeper" value="" />
<add key="MM_CONNECTION_CATALOG_Lansweeper" value="" />
</appSettings>
</configuration>
0 Kudos
Hemoco
Lansweeper Alumni

‎08-15-2007 01:44 PM

Could you post your config files please (lswinap & web.config)
0 Kudos
Sayonara_SA
Engaged Sweeper

‎08-15-2007 01:14 PM

and i still have this problen on the http site

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()



I take it i still cant logon.
Please help
Pretty please
0 Kudos
Sayonara_SA
Engaged Sweeper

‎08-15-2007 10:53 AM

Regarding this
Configure your sql server to make sure it allows remote connections. (or your login/password is wrong)
i've done this http://support.microsoft.com/kb/914277/en-us
the login for lsuser is working ... if i go to SQL server management studio express i can login with lsuser on SQl server authentication.

This i did
2e problem:
your IIS isn't registered for asp.net
locate asp_netregiis.exe in your windows folder and run
asp_netregiis.exe -i
just with a change aspnet_netregiis.exe -i

If i run LSclient serverIP on another computer on the network it fails.
Still the port problem i take it ....
0 Kudos
innuendo
Engaged Sweeper
In response to Sayonara_SA

‎09-13-2007 03:17 PM

Sayonara_SA wrote:
Regarding this
Configure your sql server to make sure it allows remote connections. (or your login/password is wrong)
i've done this http://support.microsoft.com/kb/914277/en-us
the login for lsuser is working ... if i go to SQL server management studio express i can login with lsuser on SQl server authentication.


i m using lswinap.exe from the same machine of sql server and i have only one unnamed instance of sql server, but i received the same error:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server down not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

any help?

tnx

Inn
0 Kudos
Hemoco
Lansweeper Alumni

‎08-14-2007 02:42 PM

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server down not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

Configure your sql server to make sure it allows remote connections. (or your login/password is wrong)

2e problem:
your IIS isn't registered for asp.net
locate asp_netregiis.exe in your windows folder and run
asp_netregiis.exe -i

0 Kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now