Any way to find out who's causing "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." error in SQL Server error logs?
View 7 RepliesHi, am having the error above in my Subject Line. I seem to have the problem on my host web service, they have IIS 6.0 on a 2003 Server, and SQL 2000 and SQL 2005 on another server that I connect to seperately. I am using asp.net 2.0 and SQL 2000 Desktop version. I am in the very basic beginning of this website development, all I am trying to accomplish here is to enter in a login and password and be redirected to another webpage. This works on my local laptop with XP Pro, but when I try it on the server that I host my website on, I am getting this error. Im not sure on what is going wrong here so I am at the mercy of asp gods of this site , below is some more info.
web.config
<?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings><add key="ConnectionString2" value="sqlXXX.XXXXXXXXXXX.com;uid=My_ID;pwd=My_Password;database=azwduser" /> </appSettings> <connectionStrings><remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=sqlXXX.XXXXXXXXXXX.com;Initial Catalog=AZWDUSER;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development.
Visual Basic options: Set strict="true" to disallow all data type conversions where data loss can occur. Set explicit="true" to force declaration of all variables. --> <authorization> <allow roles="Admin"/> </authorization> <roleManager enabled="true"/> <compilation debug="true" strict="false" explicit="true"/> <pages> <namespaces> <clear/> <add namespace="System"/> <add namespace="System.Collections"/> <add namespace="System.Collections.Specialized"/> <add namespace="System.Configuration"/> <add namespace="System.Text"/> <add namespace="System.Text.RegularExpressions"/> <add namespace="System.Web"/> <add namespace="System.Web.Caching"/> <add namespace="System.Web.SessionState"/> <add namespace="System.Web.Security"/> <add namespace="System.Web.Profile"/> <add namespace="System.Web.UI"/> <add namespace="System.Web.UI.WebControls"/> <add namespace="System.Web.UI.WebControls.WebParts"/> <add namespace="System.Web.UI.HtmlControls"/> </namespaces> </pages> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Forms"> <forms loginUrl="login.aspx" defaultUrl="rdp.aspx"/> </authentication> <membership> <providers> <remove name="AspNetSqlMembershipProvider"/> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/> </providers> </membership> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace.--> <customErrors mode="Off" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> </system.web></configuration>
Am I missing somthing here?
Chrissrbytes@yahoo.com
Hi I have am developing on xp machine with iis 5.1 and trying to connect to a seperate windows 2003 machine with mssql 2000 installed.I would like to use a trusted connection and I added an asp account on the sql server with permissions to the database and also edited the security tab on IIS to have this account. I unchecked allow IIS to control this password. When I look in the event viewer on my local machine I get an error:Process information: Process ID: 2388 Process name: aspnet_wp.exe Account name: MACHINENAMEASPNET Exception information: Exception type: SqlException Exception message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Any Ideas as to how I can fix this?
View 7 Replies View RelatedBasic setup
IIS 6 with ASP.Net 2.0, Integrated Windows Authentication turned on (anonymous turned off)
SQL Server 2000 with Windows Only Authentication on (SQL Server authentication turned off)
web.config file contains the following relevant entries:<identity impersonate="true" /><authentication mode=Windows" />
connection string:Data Source=[server name]; Integrated Security=SSPI; Initial Catalog=[database name];
When I run my query on my development server, it runs perfectly. When I run it on the production server (which is just an exact xcopy of the development web site), I get the "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" error. I have verified that the settings I listed above are the same on both sites. What else should I check for?
I placed some test code on the page that outputs the current logged on user and the current asp.net user, and everything seems fine (both usernames are the same - the expected domainusername of the impersonated user who logged in to the site), so I don't know why the database would say the user was null. My test code for outputting the user is below:
string authUserName = User.Identity.Name;string aspUserName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;Response.Write("You are: " + authUserName + "<br/>");Response.Write("This page runs as: " + aspUserName);
I dont believe that no one can help me in this damn error,Please, I'm gonne lose my job offer If I didnt fix this. I have spent 7 days searching with no use !!
I use ASP.NET 2.0 with C# to develop an intranet site, it was working perfectly when i was on Visual Studio, when i tried to publish the site it gave me that error.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
the web application on IIS server, windows 2003 - the database on a different server windows 2003, sql server 2000.
Regaeding that we have proxy server, one firewall.
I tried to do the following steps with no use :(
1. Create a Domain Account with priveleges similar NETWORKSERVICE (windows server 2003).2. Grant this Domain Account (DomainName/NETWORKSERVICE ) access in the SQL Server Database for the necessary databases (created a new login for this user and gave it the privillage creator, read, write)3. <identity impersonate="true" userName="DomainNameUserName" password="password" />The second method is to simply set identity impersonate to true and assign the username and password in the IIS.1. Type inetmgr from your command prompt and give enter.2. This would open the IIS Control Panel.3. Expand the appropriate nodes and select the Virtual Directory of your application.4. Right Click and select Properties.5. Switch to the Directory Security Tab.6. Under Anonymous access and authentication control click Edit7. Check the Enable Anonymous access in case you want people to access the application without logging in with Windows Logon Screen.8. Uncheck the Allow IIS to control password and enter the DomainName/UserName and Password in the respective boxes. Usually IIS uses IUSER_MACHINENAME credentials for Anonymous access.9. Uncheck if any other authentication mode is checkedI did the previous step exactly like that. and the error still come.I remind you again we have a proxy server with one firwallI dont running under https X
My connection string is: <add name="LocalSqlServer" connectionString="Data Source=database server IP; Initial Catalog=database name; Integrated Security=True"; UID="sa" ; pwd="password"; providerName="System.Data.SqlClient" />Please find me a solution
hi,
there are two win2003 servers in the same workgroup. one has mssql 2000 server and other one has asp.net 2.0 web application connecting that mssql server. mssql server Authentication is SQL Server and Windows but when i try to connect using sql authentication with uid and pwd, i get the error;
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
searched a lot about it but couldnt find any solutions. the win2003 server which hosts mssql server has active directory. is this could be the problem? thanks in advance.
ametedit :here is my connection string;"data source=192.168.16.1;initial catalog=SOLAR4;Trusted_Connection=yes;UID=Sql_user;PWD=123;"sql_user is dbowner of Solar4 database.
Hi i installed msde with follwoing attributes for a project DotnetNUke..C:sql2ksp3MSDE>Setup.exe SAPWD="password "INSTANCENAME="DNNV3" SECURITYMODE=SQLin my web.config file here is what i am using==><appSettings> <add key="SiteSqlServer" value="Server=(local);Database=DNNV3;uid=;pwd=password;" /> but i am getting below error...can anyone PLEASE help me on this.thanks a lotInstalling DotNetNukeUpgrade Error: ERROR: Could not connect to database specified in connectionString for SqlDataProvider
--------------------------------------------------------------------------------
Server Error in '/dotnetnuke' Application. --------------------------------------------------------------------------------
Login failed for user '(null)'. Reason: 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
This code is giving me this error
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Text;
namespace WebApplication1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection con;
string sql;
SqlDataAdapter adExisting;
//con = new SqlConnection("Data Source=slon12d11012";User ID=nnichol1;);
//con = new SqlConnection("Initial Catalog=DACari;Data Source=slon12d11012;User ID=nnichol1;Password=xxxxx");
//con = new SqlConnection("Data Source=slon12d11012;Initial Catalog=DACari;Integrated Security=SSPI;");
//con = new SqlConnection("Server=slon12d11012;Database=DACari;Trusted_Connection=yes;");
con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DACari;Data Source=slon12d11012;Packet Size=4096;Workstation ID=WLON110355965;");
sql = "select 'RCRF' as DacType, R.Id, R.AmendmentInstructions as Comments, 'Comment' as TypeOfComment, D.ExternalID as RiskId,D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from dbo.ITRR_RCRFDetailComments R, RCRFDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.AmendmentInstructions *=D.AmendmentInstructions";
sql+="union";
sql+="select 'RCRF' as DacType, R.Id, R.ApproverComments as Comments,'RejectedComment' as TypeOfComment,D.ExternalID as RiskId, D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from ITRR_RCRFApproverComments R, RCRFDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.ApproverComments *=D.ApproverComments";
sql+="union";
sql+="select 'DAC' as DacType, R.Id, R.Comments, 'Comment' as TypeOfComment,D.RiskId, D.AmendedByUserId as UserId, D.AmendedDateTime from ITRR_DacDetailComments R, DacDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.Comments *=D.Comments";
sql+="union";
sql+="select 'DAC' as DacType, R.Id, R.RejectedComments as Comments,'RejectedComment' as TypeOfComment,D.RiskId, D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from ITRR_DacDetailRejectedComments R, DacDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.RejectedComments *=D.RejectedComments";
sql+="union";
sql+="select 'CAP' as DacType, R.CapId, R.Comments, 'Comment' as TypeOfComment, D.CurrentRiskId,D.AmendedByUserId as UserId, D.AmendedDateTime from dbo.ITRR_CAPDetailComments R, CapDetail D";
sql+="where R.CapId *= D.CapId";
sql+="and R.Comments *=D.Comments";
sql+="union";
sql+="select 'CAP' as DacType, R.CapId, R.RejectedComments as Comments,'RejectedComment' as TypeOfComment,D.CurrentRiskId, D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from ITRR_CapDetailRejectedComments R, CapDetail D";
sql+="where R.CapId *= D.CapId";
sql+="and R.RejectedComments *=D.RejectedComments";
sql+="union";
sql+="select 'MODAC' as DacType, R.Id, R.MiddleOfficeComments as Comments, 'MiddleOfficeComment' as TypeOfComment, D.RiskId,D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from ITRR_MODacDetailComments R, MODacDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.MiddleOfficeComments *=D.MiddleOfficeComments";
sql+="union";
sql+="select 'MODAC' as DacType, R.Id, R.RequestorComments as Comments,'RequestorComment' as TypeOfComment,D.RiskId, D.AmendedByUserId as UserId, D.AmendedDateTime";
sql+="from ITRR_RequestorComments R, MODacDetail D";
sql+="where R.Id *= D.Id";
sql+="and R.RequestorComments *= D.RequestorComments";
adExisting = new SqlDataAdapter(sql,con);
con.Open();
DataSet ds = new DataSet();
try
{
adExisting.Fill(ds,"Existing");
}
catch
{
throw;
}
finally
{
con.Close();
}
/**
System.Data.SqlClient.SqlConnection conn =
new System.Data.SqlClient.SqlConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString =
"integrated security=SSPI;data source=slon12d11012;" +
"persist security info=False;initial catalog=DACari";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
Response.Write("Failed to connect to data source"+ex.ToString());
}
finally
{
conn.Close();
}
**/
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
Server Error in '/WebApplication1' Application.
Login failed for user '(null)'. Reason: 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 '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error:
Line 75:
Line 76: adExisting = new SqlCommand(sql,con);
Line 77: con.Open();
Line 78: DataSet ds = new DataSet();
Line 79: trySource File: c:inetpubwwwrootwebapplication1webform1.aspx.cs Line: 77 Stack Trace:
[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
WebApplication1.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootwebapplication1webform1.aspx.cs:77
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Anyone,I have a user "john" whose machine is part of the "job" domain. He istrying to establish an odbc connection to an MS SQL 2000 server on the"school" domain. He uses Windows authentication to establish the odbcconnection however it gives the error "Login failed for user '(null)'.Reason: Not associated with a trusted SQL Server connection."I am guessing that the odbc connection is trying to pass thecredentials of jobjohn to the sql server. And since the sql serveris on the school domain it expects the credentials of schooljohn. Isthere anyway to specify the username and password so that this willwork even though the servers are on different domains without havingto trust the domains? Thanks in advance forany help on this!!Tony
View 2 Replies View RelatedHi, I have been working on this for a few days now. Read enough searchs on line. Still not working.
I have a web IIS 6.0 server and sql server 2005 both on the same Windows 2003 server. I have an ASP.net 2.0 application try to access the database, getting the error message as describer above.
By the way, the app is an internet application, so can not using window integrated security.
The config for the ASP .net application is like this:
Enable anonymous access using the IWAM_machine local account.
None of the authentication method is checked.
The app pool is also set to use the identity of the IWAM_machine account.
In sql server, using the mixed mode acess.
Added the IWAM_machine account, granted the account access to the databases needed
The app web config is set as:
<identity impersonate="true"/>
<authentication mode="Forms">
<forms name="ApplicationAB.ASPXAUTH" loginUrl="/ApplicationAB/login.aspx" />
</authentication>
<appSettings>
<add key="conString" value="Data Source=XXX.XX.XX.XXX;Initial Catalog=MyDB;Integrated Security=SSPI"/>
</appSettings>
Could you please help?!! I am really frustrated with this.
Thanks a million.
My company is using classic asp pages for clients to sign in. A COM object is used in the page to do members and lists management job. The database server(SQL 2000) and web server(Windows server 2000) are on different machine.
Now I am laungching a project which wrap the COM into class so that we can upgrade our existing webforms to .net based. The folder which runs the .net website is set as anonymous access, and the username is set to a domian user as "POOHCORNERUM52API". I ran an asp page which is ok.
However if I runs an .aspx page even with very simply sentences It runs into error page like:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I googled on the internet, some pages suggest that .net pages are running under aspnet account, we need to impersonate to run that page with €œPOOHCORNERUM52API€? account, but the problem still exists even we do that impersonating like this:
<identity userName="poohcornerUM52API" impersonate="true" password="xxxxxxx" />
And on the SQL server I can see the user poohcornerUM52API is existed in the logins:
POOHCORNERUM52API Windoes User Permit master English
I ran the SQL profile to filter those with fail logins, and the event is captured however the field NTUserName and LoginName fields are empty.
Since I have done the impersonating, the page is running with the user "POOHCORNERUM52API", why those two fields are empty? I guess that is why the error come from.
If any one can help me out of this problem will be greatly appreciated.
I am receiving the following message when connecting via query analzyer to SQL server using windows authentication.(error 18452). I have a login created with the sys admin server role on the server. When I connect using SQL authentication it works.
I added myself to the local admin group on the server, this allows it to work. The same situation is seen with another user.
I am using windows 2000 sp4 server and SQL 2000 SP3, connecting from NT4. I get the same issue if I use TCP or named pipes. We have been using SQL security but are moving to windows authentication - but this issue is stopping us.
I have checked and upgraded my version of MDAC to match the server version 2.7 (sp1)
Any help would be much appreciated.
Thanks
Ian
I have a single user receiving this error msg on a web page of our Intranet web app after they change their password. The user can access the web app just fine until they interact with this particular page. This page accesses the database while data is entered via an ADO connection. (Classis ASP)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
The user has recently received a new desktop and the problem persists. The database login account created for the user has been deleted and recreated with no change.
We are running SQL Server 2000 with SQL Server and Windows Authentication enabled.
Connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ProductionDatabase Data Source=ProductionServer
Our solution has been to change the user's password back to their old password.
Any ideas?
Thanks.
Edit: I am not entirely sure this is a SQL Server issue but I am starting here.
HI,
Im have deployed a report to my RS2005 server and when i run it I get the error
An error has occurred during report processing.
Cannot create a connection to data source 'test'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
My datasources ''test'' is as follows ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=master"
It is not a shared datasource
For complete source code and explanation of the problem, I am trying to replicate this excercise posted on this hyperlink
http://www.sqlservercentral.com/articles/Reporting+Services/61339/#
I have modified the DBA_REP.RDS datasource to point to a server on my network and set up the , I have got the report rendering within Visual Studio but when i deploy I get the above error...can someone please advise?
to get the example working..make sure you
1. change the default server under the servername parameter
2. change dataset2 to be a storedprocedure and not text command
3. create the sql_server table
I am having problems with my app. I am developing an app on my local PC. I am using IIS locally to test it in Visual Studio.My application is hitting a SQL Server on a remote machine.I have a drop-down list that works find when testing from my local PC. But when I have remote users test this application I get the following error when it tries to run the code that gets the contents of the drop-down list from the SQL Server:System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Here is my connection string from web.config: </code>
<add key="dbconnect" value="Server=SQLSERVERWEB;Database=WebDB;Trusted_Connection=True" /></code>And my info about impersonation:<code>
<identity impersonate="true" />
<authentication mode="Windows" /> </code>And the VB code from my Application:
</code>
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Label1.Text = User.Identity.Name
ddlDepartments.DataSource = Dep()
ddlDepartments.DataTextField = "DepartmentName"
ddlDepartments.DataValueField = "DepartmentID"
ddlDepartments.DataBind()
End If
End SubPublic Function Dep() As SqlDataReader
Dim dbConnection As New SqlConnection(ConfigurationSettings.AppSettings("dbconnect"))
Dim dbCommand As New SqlCommand("sp_retrieve", dbConnection)
dbCommand.CommandType = CommandType.StoredProcedure
Try
dbConnection.Open()
Dim Results As SqlDataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection)
Return Results
Catch ex As Exception
Label1.Text = ex.ToString()
End Try
End Function</code>I have IIS running under an account that is on both the SQL Server and on the IIS server and have granted dbo, read, write rights to the account. I have tried disabling anonymous access, and the other authentication routines and it still does not seem to work. Why will this work fine on mylocal PC remote PCs can't retrieve data from the SQL Server?
can any one help
View 3 Replies View RelatedHello All,
Login failed for user '(null)'.
I know this issue is all over the forum, however i have not found any posts that help me resolve the issue.
Situation:
I have an ASP.NET 2.0 application hosted currently on XP pro(will be moving to 2003 Server) which connects to a SQL 2000 database that resides on a different server. I have taken the following step to implement my security.
Given my account permissions to the database
Put the following in my web.config
<add name="MyName" connectionString="Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
<authentication mode="Windows" />
<identity impersonate ="true" />
I have set IIS to use integrated authentication and removed anonymous. The application works when run from the web server but not when run from a remote machine.
Thank you for any asistance,
George
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Newbie here, so thanks in advance for any help. SQL Server 2000 on Windows 2000, Mixed Mode authentication IS enabled.
System DSN set on 8 workstations, a mix of 2000 - 98 and XP Pro
App uses DSN connection, specifies sa user and password. DSN's all set up the same, Client config is TCP/IP, SQL Server also set to only accept TCP/IP.
Trying to authenticate using SQL Server Authentication. XP Pro machines generate the above error. 98 and 2000 machines connect flawlessly.
I am stumped. Have read the MS knowledgebase articles, read threads here. Nothing seems to apply. It's an Internet app, so using Windows Authentication is not desired. I just don't understand why XP pukes while the other MS platforms connect just fine.
If anyone has any thoughts, I'd appreciate suggestions!
Thanks
Hi,
I have a copy of VS2005 and i have installed the Microsoft SQL Server Developer Edition
I am trying to do my first connection using ASP.net (yay for me...) and it has failed...with this error..Login failed for user 'testuser'. The user is not associated with a trusted SQL Server connection.
can someone please point out why? yes i know that the error seems pretty straight forward but how do i fix it? like how do i make the user a trusted server connection? where do i do it? and what are the steps? the user is an administrator and by rights should have all access to everything....
connection string
SqlConnection MySQLConnection; MySQLConnection = new SqlConnection("server=cmptrname\databsename;uid=testuser;password=password;database=mytest");
btw while your reading do you have any examples of opening a db with the connection string in the web.config file? because i get some error "connection string has not been initialised" using the
system.Configuration.ConfigurationManager.AppSettings.Get
i though i would stick to the top code first before i tackled the web config error first....
Thanks heaps
All the research I found dealing with this problem is that the solution is to set SQLserver to mix mode. I have SQL server already set to mix mode. I am not sure what else to do. Has anybody run into this problem?
my connection string: <connectionStrings>
<add name="ConnectionString" connectionString="Data Source= server name ;
Initial Catalog=FILESHAREDB.MDF;
Integrated Security=false;"providerName="System.Data.SqlClient"/>
</connectionStrings>
Server Error in '/SendItNow' Application.
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 ''. The user is not associated with a trusted SQL Server connection.Source Error:
Line 41:
Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()Source File: H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb Line: 43 Stack Trace:
[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
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) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ResourceDB.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message, Int32 ID) in H:MIS DepartmentIntranetSendItNowApp_CodeDalResourceDB.vb:43
Resource.SaveResource(String filename, String fromContactEmail, String toContactEmail, String message) in H:MIS DepartmentIntranetSendItNowApp_CodeBllResource.vb:31
ContentFiles_Default.ImageButton1_Click1(Object sender, ImageClickEventArgs e) in H:MIS DepartmentIntranetSendItNowContentFilesDefault.aspx.vb:33
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
Hi all,
I am new in asp.net. In my web.config file, I wrote the connection strings as below and then I got the above error. I already changed SQL server Authentication mode to "SQL server and Windows". Any idea? Thanks in advance.
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=xxx;Initial Catalog=mydb;User ID=test;Password=test;Persist Security Info=False;"
providerName="System.Data.SqlClient" />
</connectionStrings>
I cant find a reason why its doing this
Code Snippet
Login failed for user 'KOQuotes'. The user is not associated with a trusted SQL Server connection.
I cant find a reason why its doing this
Code Snippet
Login failed for user 'KOQuotes'. The user is not associated with a trusted SQL Server connection.
Hi All,
We have setup a SCOM 2007 Server and in this we have SQL 2005 SP2, We are using two accounts one for OPRATIONAL DATABASE and another one for REPORTING DATABASE after this setup everything was working fine but suddenly my SDK account which is for REPROTING DATABASE was locked by entering wrong password and afterwards I unlocked the password but SINCE this i'm not able to connect to my REPORTING DATABASE and i'm getting following ERROR:- Login Failed for user 'username'. The user is not associated with a trusted SQL Server connection.
Taken following action to rectify this problem:
1) Resetting the SDK password with the same password.
2) Restarted all the SQL and SCOM services.
3) Restarted the Server as well.
4) Converted from WINDOWS AUTHENTICATION mode to MIXED mode.
But the problem is still persisting, Please help ASAP.
Regards,
Akhilesh
I set up SQL Express and Visual Studio Team System for the first time yesterday. I created a web service (on my localhost IIS) and added an MDF file to my App_Data folder. I added a table with five fields. I'm trying to connect to the database in my web service, but when my web service gets to the connection line it returns the error
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
When I add in my domain name and password to the connection string I get the error
System.Data.SqlClient.SqlException: Login failed for user 'redmonddanmor'. The user is not associated with a trusted SQL Server connection.
I've queried these SQL forums, and the advice is usually "add the user to the trusted users" or "changed to mixed mode authentication", but none of the posts I found specified HOW exactly to do either. When I launch SQL Server Connection Manager all I can appear to do is stop and start the service. I'm not sure what needs to be set for SQLEXPRESS properties to log on as Network Service, Local System, or Local Service.
Hi,
i'm a newbie in SQL. I can't connect to SQL 6.5 server using ASP ADO. Below is the program code
<%
set conn=server.createobject("adodb.connection")
conn.open "dsn=Central;uid=sa;pwd="
%>
An error message appears
Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection.
I've already created a ODBC System DSN named Central
parameter Server Local and used Trusted connection checked.
Then under sql Manager there is a sa with a blank password.
Please help.
I received the above error yesterday and haven't been able to trace it to any job or process running. We haven't implemented any changes to the server in the past few months, and it doesn't look to be a user-established connection, since the Client IP Address of the SSPI handshake error is from the server itself.
I logged this set of messages in SQL AgentServer error log:
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[298] SQLServer Error: 18452, Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000]
Date 10.03.2008 6:15:19 PM
Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message
[382] Logon to server '<server>' failed (ConnAttemptCachableOp)
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 17806, Severity: 20, State: 2.
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <IP Address>]
Date 10.03.2008 6:15:19 PM
Log SQL Server (Current - 11.03.2008 2:32:00 PM)
Source Logon
Message
Error: 18452, Severity: 14, State: 1.
Any help in explaining this would be greatly appreciated.
Hi all,
Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?
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 ''. The user is not associated with a trusted SQL Server connection.Here is my code and i am using windows authentication:
<%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.SqlClient" %>
<%
Dim connAkaki As SqlConnection Dim cmdSelectAuthers As SqlCommand Dim dtrAuthers As SqlDataReader connAkaki = New SqlConnection("Server=.SQLEXPRESS;database=akaki") connAkaki.Open() cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki) dtrAuthers= cmdSelectAuthers.ExecuteReader() While dtrAuthers.Read() Response.Write("<li>") Response.Write(dtrAuthers("Firstname")) End While dtrAuthers.Close() connAkaki.Close() %>
I've seen many, many, many, many posts regarding this topic - but none have been able to fully explain nor fix my problem.I've developed a security solution according to Scott Gu's guide and it works great - but only on my local machine running VWD and SQLExp2005. Once I move this application it completely breaks in the productions environment. Today I managed to get it halfway there. I created a SQL login and changed my web.config to use these credentials - now the web application will come up, but none of my links (that are role based) are displayed - most likely because i'm authenticating as the SQL credentials instead of me. So I switch it back to windows authenticated, as it is on my laptop, and it breaks again. Please tell me theres a way to get this working in production and Scott's fantastic tutorial hasn't wasted me 2 weeks of work. Here's the exact error I get when using Integrated authentication:
Server Error in '/Contracts' Application.
Login failed for user ''. 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 ''. The user is
not associated with a trusted SQL Server connection.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 ''. The user is not associated with a trusted SQL Server connection.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +771 System.Web.Security.RolePrincipal.IsInRole(String role) +272 System.Web.SiteMapProvider.IsAccessibleToUser(HttpContext context, SiteMapNode node) +194 System.Web.SiteMapNode.IsAccessibleToUser(HttpContext context) +14 System.Web.StaticSiteMapProvider.GetChildNodes(SiteMapNode node) +348 System.Web.SiteMapNode.get_ChildNodes() +23 System.Web.SiteMapNode.get_HasChildNodes() +4 System.Web.SiteMapNode.System.Web.UI.IHierarchyData.get_HasChildren() +4 System.Web.UI.WebControls.Menu.DataBindRecursive(MenuItem node, IHierarchicalEnumerable enumerable) +4225 System.Web.UI.WebControls.Menu.DataBindItem(MenuItem item) +277 System.Web.UI.WebControls.Menu.PerformDataBinding() +117 System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect() +82 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.Menu.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.Menu.EnsureDataBound() +29 System.Web.UI.WebControls.Menu.OnPreRender(EventArgs e, Boolean registerScript) +21 System.Web.UI.WebControls.Menu.OnPreRender(EventArgs e) +22 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET Version:2.0.50727.42
Hello,
I just got a copy of a website I was supposed to be working on. I went to the web.config file changed the machine name to my machine's name and when I try to run the program I get the following error. Could someone give me some advice on how to fix this ?
Thanks!
Hi
I'm making a website and will upload it next via ftp but i need to access the local server for database retrieval from this website. i'm doing so first time so not sure about its working and isues. Through google search and from forums i collect some info to work on it. now i have made a connection string to access remotely that gives the following error when i make the connection open
"Login failed for user ''. The user is not associated with a trusted SQL Server connection."
the local server use the windows authentication mode or may be the mix mode.
Please any one can help me about this issue and further information related to it. and one more question, how much time a page takes to load while getting 600 records from a table in local server.
thanx in advance
Arrgh! I've check and to make sure SQL Server and Windows Authentication option is selected. The user has Grant access to connect to database engine and Login is enabled...and also has database read/write privs. I can login using the username/password from Mangement Studio Express, but I can't from my app. Here is my web.config:
<connectionStrings> <add name="CPT_ConnectionString" connectionString="Data Source=192.168.1.40ccsql1;Integrated Security=SSPI;" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <identity impersonate="true"></identity> </system.web>
The only thing I can think of is that my app is using a DSN to connect to the database. Any ideas?
Many thanks,
Mark
Hi to all......... In my project I am using windows authentication and if I am running through the IIS getting this error. Suppose if I am directly run the project or use server authentication then I wont get this error.My web.config file is <?xml version="1.0"?><configuration> <configSections> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/> <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere" /> <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication" /> <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication" /> </sectionGroup> </sectionGroup> </sectionGroup> </configSections> <appSettings> </appSettings> <connectionStrings> <add name="ConnectionString" connectionString="Server=Myserver;Database=MyDB;Trusted_Connection=Yes;"/> </connectionStrings> <system.web> <authentication mode="Windows" /> <identity impersonate="false"/> <pages> <controls> <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </controls> </pages> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <customErrors mode="Off"/> <compilation debug="false"> <assemblies> <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </assemblies> </compilation> <httpHandlers> <remove verb="*" path="*.asmx"/> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/> </httpHandlers> <httpModules> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </httpModules> </system.web> <system.web.extensions> <scripting> <webServices> <!-- Uncomment this line to customize maxJsonLength and add a custom converter --> <!-- <jsonSerialization maxJsonLength="500"> <converters> <add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/> </converters> </jsonSerialization> --> <!-- Uncomment this line to enable the authentication service. Include requireSSL="true" if appropriate. --> <!-- <authenticationService enabled="true" requireSSL = "true|false"/> --> <!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved and modified in ASP.NET AJAX applications, you need to add each property name to the readAccessProperties and writeAccessProperties attributes. --> <!-- <profileService enabled="true" readAccessProperties="propertyname1,propertyname2" writeAccessProperties="propertyname1,propertyname2" /> --> </webServices> <!-- <scriptResourceHandler enableCompression="true" enableCaching="true" /> --> </scripting> </system.web.extensions> <system.webServer> <validation validateIntegratedModeConfiguration="false"/> <modules> <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </modules> <handlers> <remove name="WebServiceHandlerFactory-Integrated" /> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </handlers> </system.webServer></configuration>Thanks Abins Muhammad
View 3 Replies View Related