Problem In Sql Server Connection

Hi There,

We have installed DynamicWeb, but it is working only through MS_Access DataBase.

To make it work through Sql Server DataBase, we have made following changes in the file

Files\GlobalSettings.aspx, we changed the settings ( Settings at 5 places ) to as below:

Here, Name_Of_Our_DataBase is the database which we had got after ReStoring the BackUp File ( DefaultEmptyData.bak ) present in your DefaultEmptyDataSQL Folder.

The above change is not working and giving the error:

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

System.Data.SqlClient.SqlException: Login failed for user 'sa'.

   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 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.PoolCreateRequest(Object state)

-------------------------------

Please wait!

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

System.Data.SqlClient.SqlException: Login failed for user 'cms'.

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   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 Dynamicweb.Database.GetConn(String strDatabase)

setTimeout("location = location;", 15000);

----------------------------------------

Please help. Thanks in advance ..

Hi,

Thanks for your reply, But it is not working that way either.

I have made a new User in DataBase specially for the DynamicWeb Restored DartaBase, and given to it the folllowing rights:

ddladmin, dbreader and dbwriter on the above database.

But the connection is not working even for this user. I am getting the following error:

-----------------------------------------------------------

Please wait!

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

System.Data.SqlClient.SqlException: Login failed for user 'cms'.

   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 Dynamicweb.Database.GetConn(String strDatabase)

------------------------------------------------------------

Looking forward to your reply ..

Developer forum

Problem In Sql Server Connection

Replies