Developer forum

Forum » Development » Local development, external sql

Local development, external sql

E-mail notifications

Reply
Posted on 29/10/2007 14:03:19

Hi all,




I get the following error message


Please wait!



The SQL-Server database could not be opened ('Dynamic.mdb') - the error is:

 System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

   ved System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   ved System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   ved System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   ved System.Data.SqlClient.SqlConnection.Open()

   ved Dynamicweb.Database.GetConn(String strDatabase)




on the following configuration

client: vista with iis, virtual dirs setup ok.

server: sql 2005, test.sql.kpjung.dk (ip locked for all except me, but i can connect with the sa user i Sql Server Management Studio on my client)

Files\GlobalSettings.aspx content is as follows (the relevant part)

***
 
ms_sqlserver
sa
 
Dw
 
81.7.132.27
 
 
 What could be the problem
 
Thanks in advance
Stig


Replies

 
Nicolai Høeg Pedersen
Posted on 29/10/2007 14:48:11
Reply

Since the error message states it can not login the user '' (that is a blank) - it seems like dynamicweb is unable to read the username from GlobalSettings.aspx.


 


This is either because the /files virtual folder is setup the wrong way (as application maybe)


or because permissions are not as they should be. See appendix A in the installation guide.

 
Nicolai Høeg Pedersen
Posted on 29/10/2007 14:51:00
Reply
NP wrote:


Since the error message states it can not login the user '' (that is a blank) - it seems like dynamicweb is unable to read the username from GlobalSettings.aspx.




 




This is either because the /files virtual folder is setup the wrong way (as application maybe)




or because permissions are not as they should be. See appendix A in the installation guide.





Just noticed the message regarding Trusted Connection - check if


/Globalsettings/System/Database/IntegratedSecurity is set to an empty string or false.

 

You must be logged in to post in the forum