HI

I can't get it to work any ideas?

/ Jonas

[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
   InstantASP.InstantKB.Logic.GetPopularArticles()
   InstantKB.panel.BindQuestionData()
   InstantKB.panel.Page_Load(Object Sender, EventArgs E)
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Page.ProcessRequestMain() +731

Hi Jonas,

Are you running Windows 2003 or XP, 2000 ?

It looks like the database connection associated with a trusted connection on your SQL Server has not been provided access to the database.

I've provided below a link to our knowledge base article which should assist with this problem

http://kb.instantasp.co.uk/article.aspx?id=10221

Explore our products...
http://demos.instantasp.co.uk/

Hi

I have got it to work now.

I changed the connection string to include login and password and then it works.

Great

Explore our products...
http://demos.instantasp.co.uk/