Notification

Icon
Error

Connecting to !P_ADD: Failed

Posted: Monday, December 11, 2006 6:31:50 PM(UTC)
Tom

Tom

Member Posts: 1
0
Like
Iv installed SQL 2005 SP2 on a Longhorn beta server. Created the LS database as per instructions. When i try to logon to th econsole i get:

Code:

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load file or assembly 'DreamweaverCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=836f606ede05d46a' or one of its dependencies. The system cannot find the file specified.

Source Error:


Line 1: <%@ Page Language="VB" ContentType="text/html" %>
Line 2: <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
Line 3: <MM:DataSet
Line 4: runat="Server"


Ive tried registering DreamweaverCtrls but dont think thats the problem.

Ive installed the service which is up and running with credentials of lsuser, lsscanner and administrator but have the following problem when this is executed from a client machine (that is the lsclient)

Quote:

-- LanSweeper Client --

Connecting to IP_ADD: failed



IP_ADD is the ip address of the longhorn server. SQL database is configured with Widnows and SWL authentication, database has full rights for lsuser.
LS config reads as:

Code:

<?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;localhost&quot;;persist security info=False;initial catalog=Lansweeper" />
        <add key="ConcurrentThreads" value="10" />
    </appSettings>
</configuration>


LSWinap config reads:

Code:

<?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>


Webconfig:

Code:

<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=Isuser;Password=NewPassword1" />
        <add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />
        <add key="MM_CONNECTION_SCHEMA_Lansweeper" value="" />
        <add key="MM_CONNECTION_CATALOG_Lansweeper" value="" />
    </appSettings>
</configuration>


The users are on the domain (lsuser/scanner)

I cant find any logs to why its failed but have tried running it as 3 different users all with the same error. Anyone got any ideas?

Thanks
Lansweeper
#-29Lansweeper Member Premium Users Administration  
posted: 12/11/2006 7:56:46 PM(UTC)
- Configure your firewall to allow inbound tcp connections to port 9524 (on the server running the service)
- the dreamweaver DLL should be in the webroot\bin folder (never tried longhorn since it's in beta)
jwalters
#-28jwalters Member  
posted: 12/12/2006 11:05:26 PM(UTC)
I've also tried installing Lansweeper on Windows Longhorn Server Build 5384. I had the same error as Tom who started this thread, but from what you said Smikkel I copied the Bin folder with its contents, DreamweaverCtrls.dll, into "C:\inetpub\wwwroot\". There was no Bin folder in wwwroot as my error was looking for DreamweaverCtrls there. This is on an isolated test domain, therefore it has no firewall installed and the default Windows one is disabled. The SQL Server is also on the same computer that the Lansweeper installation is on. The user, lsuser, has full access to SQL and can login when I connect to SQL via the Microsoft SQL Server Management Studio. The database is set for using SQL Server and Windows Authentication. The lsservice is running as a service and is started properly. Lsuser has been made a domain admin with local admin to ensure the user has no problems accessing anything. "Everybody" has been given full control over inetpub and lansweeper (folder on C:\ where the lansweeper files are located).

After doing the above I now get the following error:

Code:
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()


My LSservice.exe.config file looks like:
Code:
<?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=lansweeper;;persist security info=False;initial catalog=lansweeper" />
        <add key="ConcurrentThreads" value="10" />
    </appSettings>
</configuration>


My web.config file:
Code:
<configuration>
    <appSettings>
        <add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm" />
        <add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=localhost;Initial Catalog=Lansweeper;User ID=lsuser;Password=Password1" />
        <add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />
        <add key="MM_CONNECTION_SCHEMA_Lansweeper" value="" />
        <add key="MM_CONNECTION_CATALOG_Lansweeper" value="" />
    </appSettings>
</configuration>


I've looked around to try to figure out what kind of default settings that SQL Server has for remote connections to see if anything fits, but I've found nothing so far. Any help would be appreciated.

Tom, how far along have you gotten?
Lansweeper
#-27Lansweeper Member Premium Users Administration  
posted: 12/13/2006 10:40:49 AM(UTC)
So there are 3 problems

-lsclient cannot connect to server
(most likely cause server is firewalled, try telnetting to port 9524)
Tom do you also have this problem?

-Dreamweaver problem
Can't test it, since I don't have longhorn :)
Use filemon from sysinternals and check where the webserver tries to find the dreamweaver dll, copy the file there.
(or maybe it's a new feature in IIS7)

- Sql server problem.
Open SQL server configuration manager (from the start menu)
under network configuration, enable the protocols.
(this should solve the problem)

Doe you guys know if longhorn runs in vmware esx?
if so I will search a beta and test it myself.
insflavio
#-26insflavio Member  
posted: 1/10/2007 7:02:02 PM(UTC)
Hello !!

I have the same problem that Mr. JWalters, but i'm using SQL Server 2005 Express version with a Windows 2000 Advanced Server.

SMIKKEL, so i have 3 problems also ?

The worst is my SQL with all protocols enabled (TCP/IP and Named Pipes) and with SQL and Windows auth. I havn't restarted the server after these changes but the services (Lansweeper and sql services) were restarted more than once but the error message is the same.

Mr. JWalters, did you solve your problem ?

Thanks !
jwalters
#-25jwalters Member  
posted: 1/19/2007 11:43:45 PM(UTC)
No, I've not solved the problem I had. I've been too busy with other things to tackle this side project.

Top Rated

1 Lansweeper Post here about your lansweeper setup.
by  Lansweeper  
Go to last post Go to first unread
Last post: 6/13/2014 1:18:56 AM(UTC)
2 Lansweeper User-Inventory
by  jhache  
Go to last post Go to first unread
Last post: 11/14/2014 3:29:48 PM(UTC)
3 Lansweeper Unlock Password Customization
by  Hobbs13  
Go to last post Go to first unread
Last post: 7/26/2012 2:50:56 PM(UTC)
4 Lansweeper LS not pulling in corrected version of Visio/Project
by  ldellinger  
Go to last post Go to first unread
Last post: 12/4/2014 3:41:41 PM(UTC)
5 Lansweeper Lansweeper 5.2 (recent update)
by  MikeInLa  
Go to last post Go to first unread
Last post: 11/26/2014 9:57:29 AM(UTC)
6 Lansweeper Approve software only for certain PCs or Users
by  sarmo  
Go to last post Go to first unread
Last post: 11/13/2014 4:09:33 PM(UTC)

Active Discussions

Lansweeper Network Connection Speed
by  pharoz   Go to last post Go to first unread
Last post: Today at 1:40:25 AM(UTC)
Lansweeper Search using MAC Address
by  AdmJLovejoy  
Go to last post Go to first unread
Last post: Yesterday at 11:20:35 PM(UTC)
Lansweeper Hardware reporting
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 7:52:38 PM(UTC)
Lansweeper Password last set
by  dteague  
Go to last post Go to first unread
Last post: Yesterday at 6:54:03 PM(UTC)
Lansweeper Lansweeper detects the domain name incorrect
by  GMFDE   Go to last post Go to first unread
Last post: Yesterday at 6:08:05 PM(UTC)
Lansweeper QR Code variable
by  wimmy  
Go to last post Go to first unread
Last post: Yesterday at 1:07:01 PM(UTC)
Lansweeper IIS Express 8.0 64 Bit
by  daigls   Go to last post Go to first unread
Last post: Yesterday at 1:04:35 PM(UTC)
Lansweeper Forum itself: copy reports with IE9 bugged
by  Mitch.V  
Go to last post Go to first unread
Last post: Yesterday at 11:31:46 AM(UTC)