Can't open Northwind
I remembered doing walkthrough using Northwind. However it wasn't an http
project but a file project using the development server. Northwind allowed
me to add, edit and insert, and the web page looked fine.
I opened a simple project just to see whether I could get my sqlserver on
the internet. (vs studio 2005, sqlserver 2005)
I created the project in http location http://localhost/Northwind . I
dragged a sqldatasource to the page, configuring it to display ID and
ProductName. I clicked advanced, but noticed the generate insert, edit and
delete were grayed out. That told me something was wrong with my
authetification .
I configured my sqlserver 2005 to have integrated security.
I built the solution and website, then pressed cntl-F5. I got a login
error. Nowhere did the page ask me for username and password. First
questions - how do I get this to open up a web page, and how to I get it to
allow me to generate insert, edit and delete statements?
dennist685
Server Error in '/Northwind' Application.
--------------------------------------------------------------------------------
Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPN ET'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: Cannot open database
"Northwind" requested by the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPN ET'.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Cannot open database "Northwind" requested by
the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPN ET'.]
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +735123
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +188
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet
bulkCopyHandler , TdsParserStateO bject stateObj) +1838
System.Data.Sql Client.SqlInter nalConnectionTd s.CompleteLogin (Boolean
enlistOK) +33
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) +628
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance) +170
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n) +359
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options) +28
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject) +424
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject) +66
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject) +496
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +82
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Sql Client.SqlConne ction.Open() +111
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteSelect(Da taSourceSelectA rguments arguments) +1770
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s arguments,
DataSourceViewS electCallback callback) +17
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +149
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +70
System.Web.UI.W ebControls.Deta ilsView.DataBin d() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +82
System.Web.UI.W ebControls.Deta ilsView.EnsureD ataBound() +181
System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls()
+69
System.Web.UI.C ontrol.EnsureCh ildControls() +87
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +41
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +161
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +161
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +1360