According to
Create a Sitefinity Project for Your Portal Site, it throws an error on step 4 "Site Setup" when I want to connect to Azure SQL Server Database(It works fine if I connect to local SQL Server Database).
Message: Telerik.OpenAccess.OpenAccessException:
System.InvalidOperationException:
Wrong database backend configuration
detected: Connecting to 'SQL Azure' but configured for 'mssql'.
at OpenAccessRuntime.Relational.sql.MsSqlDriver.customizeForServer(Connection
con)
at
OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString
connectionString, Boolean noConnect, PropertySet props, DBDriver& driver,
Connection& conn, ConnectionPoolType poolType)
at
OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder
b)
at
OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
---> System.InvalidOperationException: Wrong database backend configuration
detected: Connecting to 'SQL Azure' but configured for 'mssql'.
at
OpenAccessRuntime.Relational.sql.MsSqlDriver.customizeForServer(Connection con)
at
OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString,
Boolean noConnect, PropertySet props, DBDriver& driver, Connection&
conn, ConnectionPoolType poolType)
at
OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder
b)
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
--- End of inner exception stack trace ---
at OpenAccessRuntime.ExceptionWrapper.Throw()
at
OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
at
OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
at
OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
at
OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet
props)
at
OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props)
at
OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String usr,
String password, Boolean open)
at
OpenAccessRuntime.DatabaseAdapter.Telerik.OpenAccess.SPI.IDatabaseAdapter.GetMetaData()
at Telerik.OpenAccess.Database.get_MetaData()
at
Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.TestConnection(IConnectionStringSettings
connStrSettings, Exception& err, Int32 retryCount)
Not sure we can create a local portal and link to Azure SQL Server Database, can anyone help?
Last modified on 24 Feb 2022 02:02 by Jun Hua