Re: New guitar parts website

"Woody" <usenet@xxxxxxxxxxxxxx> wrote in message
news:i9b1jwi3o824$.cumbglz4jqn0$.dlg@xxxxxxxxxxxxx
Handy collection of stuff, but amazing that in this day and age people
still come up with such badly functioning websites!

How true! This is what happened when I tried the link.

C# and SQL Server. Hmmm!

Rgds,
MikeB

Server Error in '/' Application.
--------------------------------------------------------------------------------

Login failed for user 'admin@myguitar'. The user is not associated with a
trusted SQL Server connection.
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
'admin@myguitar'. The user is not associated with a trusted SQL Server
connection.

Source Error:


Line 28: ProductBLL uTopBLL = new ProductBLL();
Line 29: int RecordCount = 0;
Line 30: IList uTopList = uTopBLL.GetListByClause(1, 1, out
RecordCount, " And FlagRecommend=1");
Line 31: if (uTopList.Count > 0)
Line 32: {


Source File:
e:\SiteData\Domains\diyguitars.net\root\inetpub\wwwroot\Index.aspx.cs
Line: 30

Stack Trace:


[SqlException (0x80131904): Login failed for user 'admin@myguitar'. The user
is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
+170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) +51
Eden.DAL.ProductDAL.GetListByClause(Int32 PageNo, Int32 PageSize, Int32&
RecordCount, String sSearchSQL) +431
Eden.BLL.ProductBLL.GetListByClause(Int32 PageNo, Int32 PageSize, Int32&
RecordCount, String sSearchSQL) +74
Index.ShowTop() in
e:\SiteData\Domains\diyguitars.net\root\inetpub\wwwroot\Index.aspx.cs:30
Index.Page_Load(Object sender, EventArgs e) in
e:\SiteData\Domains\diyguitars.net\root\inetpub\wwwroot\Index.aspx.cs:19
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061



.

Relevant Pages

  • .NET 2.0 Upgrade Connection Problem
    ... However, if I recompile the app in .NET 2.0, the app returns a connection ... Boolean& failoverDemandDone, String host, String failoverPartner, String ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Locate Server
    ... >> Boolean& failoverDemandDone, String host, String failoverPartner, String ... >> owningObject, SqlConnectionString connectionOptions, String newPassword, ... >>> trying to make a remote database connection while you think your ...
    (microsoft.public.sqlserver.setup)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot Generate SSPI Context - help
    ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
    (microsoft.public.inetserver.asp.db)
  • Re: New guitar parts website
    ... The user is not associated with a trusted SQL Server connection. ... System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170 ...
    (uk.music.guitar)