Notification

Icon
Error

Connecting to !P_ADD: Failed

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

Tom

Member Posts: 1
0
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

Edited: by user Monday, December 11, 2006 6:38:56 PM(UTC) | Reason: Not specified

Lansweeper
#1Lansweeper 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
#2jwalters 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
#3Lansweeper 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
#4insflavio 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
#5jwalters 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 List of Devices matching list of MAC addresses
by  atkinsjd  
Go to last post Go to first unread
Last post: 9/10/2013 11:36:51 PM(UTC)
2 Lansweeper Looking for customers in the US using LanSweeper
by  WbstDev  
Go to last post Go to first unread
Last post: 12/4/2013 10:30:34 PM(UTC)
4 Lansweeper Seperate logins
by  akosters  
Go to last post Go to first unread
Last post: 1/10/2014 6:20:40 AM(UTC)
5 Lansweeper 5.1 Lansweeper Error- Adding New Assets
by  Mlacombe  
Go to last post Go to first unread
Last post: 1/13/2014 5:41:35 PM(UTC)
6 Lansweeper Number of CPU cores and one result per server
by  jaekob  
Go to last post Go to first unread
Last post: 10/20/2014 3:31:46 PM(UTC)
8 Lansweeper Lansweeper Report
by  dlaporte  
Go to last post Go to first unread
Last post: 10/30/2013 8:16:40 PM(UTC)

Active Discussions

Lansweeper Default Package Share username permissions
by  Susan.A   Go to last post Go to first unread
Last post: Yesterday at 1:30:01 AM(UTC)
Lansweeper Is it possible to link a web page to an asset?
by  Susan.A  
Go to last post Go to first unread
Last post: Yesterday at 1:24:10 AM(UTC)
Lansweeper LS v5.2 silentupgrade
by  MDGraves   Go to last post Go to first unread
Last post: 11/21/2014 2:45:43 PM(UTC)
Lansweeper Query Assets in Multiple Groups
by  Susan.A   Go to last post Go to first unread
Last post: 11/21/2014 2:18:06 PM(UTC)
Lansweeper Scanner Model Report
by  Susan.A  
Go to last post Go to first unread
Last post: 11/21/2014 2:00:09 PM(UTC)
Lansweeper relations between assets and users
by  Susan.A   Go to last post Go to first unread
Last post: 11/21/2014 1:04:13 PM(UTC)