"Test Connection" fails for all Telerik DBs.

[Lee]

I have read some threads about this regarding folder/file authorities but still cannot connect to any DBs.

Environment is..
SQL Express running under Network Service.
I have admin priviledges.
Connection string is "Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Temp\Delete Anytime\ExpressionWebTests\Telerik\Rotator\App_Data\Northwind.mdf";Integrated Security=True;User Instance=True"

I am using 'Windows Authentication' in the 'Log on to the server' dialogue box.
Message I get is...

"Failure to generate a user instance of SQL server due to a failure in starting the process for the user instance....."

Exception Stack
[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064474
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +5078123
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +123
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1618
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +143
   Telerik.Web.UI.RadListView.PerformSelect() +24
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74
   Telerik.Web.UI.RadListView.DataBind() +17
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66
   Telerik.Web.UI.RadListView.CreateChildControls() +53
   System.Web.UI.Control.EnsureChildControls() +102
   System.Web.UI.WebControls.CompositeDataBoundControl.get_Controls() +15
   Telerik.Web.UI.RadAjaxControl.PopulatePlainPanels(Control parent, List`1 list, Control root) +68
   Telerik.Web.UI.RadAjaxControl.OnPagePreRender(Object sender, EventArgs e) +1160
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnPreRender(EventArgs e) +8997922
   System.Web.UI.Control.PreRenderRecursiveInternal() +103
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496

[Kate]

Hi Lee,

As I answered in your ticket:

One reason I can think of is that you need to change your connection string in the web.config file. So if your current string reads as:

... <connectionStrings>
        <add name="ActiveSkillConnectionString" connectionString="Data Source=localhost;Initial Catalog=ActiveSkill;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings> ...

You can try changing the source to:

<connectionStrings>
        <add name="ActiveSkillConnectionString" connectionString="Data Source=.\SQLEXPRESS; Initial Catalog=ActiveSkill;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>

So depending on th SQL that you installed on your machine you need to change the source.

Greetings,
Kate
the Telerik team

[Tom]

I have provided the connection string in my question and it already is what you recommend.
That is *not* the problem.

It turns out running SQL EXPRESS as user = NETWORK SERVICE causes authority problems.

I simply ran SQL EXPRESS as me and all the errors went away.

This article may explain what is going on behind the scenes (or not as I am not an expert in this area)
http://support.microsoft.com/kb/2002980

[Kate]

Hello Tom,

Thank you for sharing this article as it might be helpful for others that encounter the same issue.

Greetings,
Kate
the Telerik team