DevForce Community Forum : n-tier deployment http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : n-tier deployment Thu, 11 Jun 2026 02:56:45 -700 Wed, 02 Jul 2008 18:00:02 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=857 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ n-tier deployment : Is it possible that your SQL Server... http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3161#3161 Author: kimj
Subject: 857
Posted: 02-Jul-2008 at 6:00pm

Is it possible that your SQL Server allows only Windows authentication?  I notice that your client-side rdbKey connection string (which is not actually used when using a BOS) contains the attribute for integrated security, while your server-side rdbKey connection string does not. 

To use integrated security from IIS you need to ensure that the account running the IIS service on machine A has privileges to the SQL Server on machine B.  The account is probably either ASPNET or "Network Service", or you can set up a domain account.
 
Also double check the debug log on the server to see where it loaded the IdeaBladeConfig info from - it's possible it is not using the configuration information that you think it is.
]]> Wed, 02 Jul 2008 18:00:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3161#3161 n-tier deployment : <?xml version="1.0"... http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3140#3140 Author: orcities
Subject: 857
Posted: 26-Jun-2008 at 3:33pm

<?xml version="1.0" encoding="utf-8"?>

<ideaBlade xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="1.07">

  <useDTC>false</useDTC>

  <copyLocal>false</copyLocal>

  <loginManagerRequired>false</loginManagerRequired>

  <enforceDynamicTypeSecurityOnServer>false</enforceDynamicTypeSecurityOnServer>

  <logging>

    <archiveLogs>false</archiveLogs>

    <logFile>DebugLog.xml</logFile>

    <usesSeparateAppDomain>false</usesSeparateAppDomain>

    <port>0</port>

  </logging>

  <rdbKey name="Default" databaseProduct="Unknown">

    <connection>Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=sa;Initial Catalog=IdeaBladeTutorial;Data Source=LOC-DEVDB\Sql2005</connection>

    <probeAssemblyName>FirstApp.Business</probeAssemblyName>

  </rdbKey>

  <remoting>

    <remotePersistenceEnabled>true</remotePersistenceEnabled>

    <communicationsTechnology>Remoting</communicationsTechnology>

    <remoteBaseURL>http://localhost</remoteBaseURL>

    <serverPort>80</serverPort>

    <serviceName>QuickAppCS/PersistenceServer.rem</serviceName>

    <serverDetectTimeoutMilliseconds>-1</serverDetectTimeoutMilliseconds>

    <proxyPort>0</proxyPort>

  </remoting>

  <notificationService>

    <enabled>false</enabled>

    <serverPort>0</serverPort>

    <clientPort>0</clientPort>

  </notificationService>

  <webService>

    <remoteBaseURL />

    <serverPort>0</serverPort>

    <serviceName />

    <authentication>None</authentication>

  </webService>

  <appUpdater>

    <updateURL />

    <versionFileName>FirstAppVersion.xml</versionFileName>

    <appLauncher>AppLauncher.exe</appLauncher>

  </appUpdater>

</ideaBlade>

]]> Thu, 26 Jun 2008 15:33:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3140#3140 n-tier deployment : Client: &lt;?xml version=&#034;1.0&#034;... http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3139#3139 Author: orcities
Subject: 857
Posted: 26-Jun-2008 at 3:32pm

Client:

<?xml version="1.0" encoding="utf-8"?>

<ideaBlade xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="1.07">

  <useDTC>false</useDTC>

  <copyLocal>false</copyLocal>

  <loginManagerRequired>false</loginManagerRequired>

  <enforceDynamicTypeSecurityOnServer>false</enforceDynamicTypeSecurityOnServer>

  <logging>

    <archiveLogs>false</archiveLogs>

    <logFile>DebugLog.xml</logFile>

    <usesSeparateAppDomain>false</usesSeparateAppDomain>

    <port>0</port>

  </logging>

  <rdbKey name="default" databaseProduct="Unknown">

    <connection>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IdeaBladeTutorial;Data Source=localhost</connection>

    <probeAssemblyName>Entities</probeAssemblyName>

    <probeAssemblyName>AppHelper</probeAssemblyName>

  </rdbKey>

  <remoting>

    <remotePersistenceEnabled>true</remotePersistenceEnabled>

    <communicationsTechnology>Remoting</communicationsTechnology>

    <remoteBaseURL>http://localhost</remoteBaseURL>

    <serverPort>80</serverPort>

    <serviceName>QuickAppCS/PersistenceServer.rem</serviceName>

    <serverDetectTimeoutMilliseconds>-1</serverDetectTimeoutMilliseconds>

    <proxyPort>0</proxyPort>

  </remoting>

  <notificationService>

    <enabled>false</enabled>

    <serverPort>0</serverPort>

    <clientPort>0</clientPort>

  </notificationService>

  <webService>

    <remoteBaseURL />

    <serverPort>0</serverPort>

    <serviceName />

    <authentication>None</authentication>

  </webService>

  <appUpdater />

</ideaBlade>

]]> Thu, 26 Jun 2008 15:32:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3139#3139 n-tier deployment : I have built the IIS Deploy Example.... http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3138#3138 Author: orcities
Subject: 857
Posted: 26-Jun-2008 at 3:26pm

I have built the IIS Deploy Example. I am still having a problem with the connection. Its gives an error "Unable to Login".  Looking at the Debug.xml file it gives the below error (IIS Server version):
 
Note: I am using my dev machine. The database is on a seperate machine. When I run any other IdeaBladeTutorial I am doing the same thing with the same connection string and they work fine, just not going through IISServer. I am also using the sa account to connect. But it doesn't seem to be going thru.
 
The client uses the embedded AppHelper ibconfig file. It is remoting to the IIS Server which then has the correct connection string.
 
System.Data.OleDb.OleDbException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at IdeaBlade.Rdb.AdoHelper.CreateDbCommand(IDbConnection pConnection) at IdeaBlade.Persistence.Rdb.RdbQuerySqlFormatter.Fetch(Type pEntityType, DataSet pDataSet, IDbSelectCommandBuilder pDbCommandBuilder) at IdeaBlade.Persistence.Rdb.RdbQuerySqlFormatter.Fetch(Type pEntityType, DataSet pDataSet, ParameterizedSql pParamSql, Int32 pCommandTimeout) at IdeaBlade.Persistence.Rdb.RdbQuery.Fetch(DataSet pDataSet, IDataSourceKey pDataSourceKey) at IdeaBlade.Persistence.Server.PersistenceServer.Fetch(IEntityQuery pQuery, DataSet pDataSet, IDataSourceKey pDsKey) at IdeaBlade.Persistence.Server.PersistenceServer.Fetch(SessionBundle pSessionBundle, IEntityQuery pEntityQuery)
]]> Thu, 26 Jun 2008 15:26:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3138#3138 n-tier deployment : I have been trying to find how... http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3127#3127 Author: orcities
Subject: 857
Posted: 25-Jun-2008 at 8:55am

I have been trying to find how to do n-tier deployment. I have looked through all of the instructional units. I have created the Server portion, I believe correctly. I am having a problem with the client portion.
 
I know they each need a ibconfig. I have one compiled into the shared apphelper project. But I have also added one loosely to each project. The server ibconfig would have the connection string to the database.
 
What does the client ibconfig have. I have left the connection string in the rdbKey elements. I have change the remoting address to that of the server.
 
When I run the application it fails. I am also running the CABANA framework. Publish hasn't worked successfully. I am trying a setup project next.
]]> Wed, 25 Jun 2008 08:55:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=857&PID=3127#3127