Hi ...
I have been reading throuhg the internet to solve a problem that happens to
me when i try to access a databse in SQL mode...
when i access the database through (visual web developer 2005) ie testing
it, then everything runs perfect! but then i simply connected the database
to the page by draging the table to the ASP.NET page and the web developer
creates the necessary code... it seems that the page access the Database
using windows authintication...
but when i run the same page through the IIS (http://locahost/default.aspx)
i get the message at the end of this page
I am guessing that the page tries to access the database through SQL
authintication...
I have many questions please:
1- when i install MSDE i can specify SA password, but what is the user
name???
2- is it that user name and the sa password that is used when accessing
database through SQL:
conAB = New SqlConnection( "Server=localhost;uid=?;pwd=?;database=dbname" )
3- what is this "mixed SQL mode " that i have to enable to allow connecting
to DB by sql and not only windows authintication???
I would appreciate it if i could get answers to those question.
and i thank you all for your time
Ammar
error message:
Login failed for user 'AMMAR\ASPNET'.
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.SqlClient.SqlException: Login failed for user
'AMMAR\ASPNET'.
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): Login failed for user 'AMMAR\ASPNET'.]
System.Data.ProviderBase.DbConnectionPool.GetConne ction(Object
owningObject) +317
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnectionBase
owningConnection) +90
System.Data.ProviderBase.DbConnectionClosed.Open(D bConnectionBase
outerConnection) +189
System.Data.ProviderBase.DbConnectionBase.Open() +62
System.Data.SqlClient.SqlConnection.Open() +168
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +144
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+86
System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectAr
guments arguments) +1167
System.Web.UI.DataSourceView.Select(DataSourceSele ctArguments arguments,
DataSourceViewSelectCallback callback) +18
System.Web.UI.WebControls.DataBoundControl.Perform Select() +112
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +68
System.Web.UI.WebControls.GridView.DataBind() +5
System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound() +1721719
System.Web.UI.WebControls.CompositeDataBoundContro l.CreateChildControls()
+64
System.Web.UI.Control.EnsureChildControls() +108
System.Web.UI.Control.PreRenderRecursiveInternal() +37
System.Web.UI.Control.PreRenderRecursiveInternal() +156
System.Web.UI.Control.PreRenderRecursiveInternal() +156
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5448
