StrataFrame Forum

I just installed StrataFrame on my new Windows 7 ultimate machine and I cannot connect to the StrataFrame Database

http://forum.strataframe.net/Topic29889.aspx

By Marcia G Akins - 4/16/2011

When I click on the Business Object mapper, I get this message:

SQL Connection Failed

Event ID: 2121

The connection to the SQl Server that houses the StrataFrame databases could not be established. See the error message below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (providere: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)

Do you want to configure the connection now?

When I click on the configure button, I immediately get this error message:

SqlException
  A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source     : .Net SqlClient Data Provider

Stack Trace:
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   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 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
   at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.ᜀ(ᜒ A_0)


Can anyone tell me what I need to do so that StrataFrame can find its database? I am new to Windows 7 and hate it more every day Crazy

TIA.

Marcia
By Charles R Hankey - 4/16/2011

It's a permission thing.  Just go into the Microfour folder in program files and right click on each EXE, and check the thing that says always run as administrator.

If you search here for Windows 7 I have a couple messages explaining it in more detail, but that's the basics.

If you get hung up shoot me an email or call my cell.
By Marcia G Akins - 4/17/2011

Charles R Hankey (4/16/2011)
It's a permission thing.  Just go into the Microfour folder in program files and right click on each EXE, and check the thing that says always run as administrator.

If you search here for Windows 7 I have a couple messages explaining it in more detail, but that's the basics.

If you get hung up shoot me an email or call my cell.


Hi Charles.

Thanks for the quick reply.

I HATE Wondows 7. Whose machine is it anyway?
By Ivan George Borges - 4/17/2011

Yours and all the crackers' around the world. Hehe
By Marcia G Akins - 4/19/2011

Ivan George Borges (4/17/2011)
Yours and all the crackers' around the world. Hehe


I think that Microsoft thinks it belongs to them Pinch
By Charles R Hankey - 4/20/2011

No wonder MS and the Federal Govt are always locking horns - they're too much alike BigGrin