Perplexed: Login Failed For User '(null)'. Reason: Not Associated With A Trusted SQL Server Connection.
Jul 21, 2005
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?
View 3 Replies
ADVERTISEMENT
Nov 25, 2006
Hi, 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
View 7 Replies
View Related
Jan 18, 2007
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 Related
Mar 26, 2007
Basic 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);
View 3 Replies
View Related
Mar 23, 2008
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
View 4 Replies
View Related
Apr 3, 2008
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.
View 1 Replies
View Related
Jul 20, 2005
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
View 13 Replies
View Related
Aug 26, 2005
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
View 1 Replies
View Related
Jul 20, 2005
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 Related
Mar 28, 2008
Hi, 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.
View 3 Replies
View Related
Dec 11, 2007
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.
View 3 Replies
View Related
Oct 24, 2006
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
View 21 Replies
View Related
Mar 26, 2007
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.
View 6 Replies
View Related
Oct 23, 2007
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
View 2 Replies
View Related
Aug 11, 2005
can any one help
View 3 Replies
View Related
May 7, 2004
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
View 6 Replies
View Related
Jul 11, 2006
Hello,
I have some problem here. I have a sql server installed on one machine and I have another development machine for my asp application. How could I actually access the asp application and sql server at the same time from another machine within the network. I kept on getting the error message above.
Thank you for your help :)
View 22 Replies
View Related
Jun 20, 2006
Hi,
I have 2 windows 2003 server, i instllaed sql server 2005 enterprise edition on the first one (Mixed Mode), and i am trying to install sql server reporting 2000 on the second one,
I installed the sql 2000 connectivity only on the second one , and i installed the sql server sp4 also, while installing reporting services i used the sql login account (sa,pwd)
i got the following error :
Cannot connect to sql server instance ...
Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.
NB1: Allow Remote connection is enabled on sql server 2005.
NB2: I tried to connect from server 2 to server 1 from odbc and it worked properly with (sa,pwd) i have only a problem from reporting server.
Please any help?
Tarek Ghazali
SQL Server MVP
View 6 Replies
View Related
Mar 3, 2006
Hello, here we have 2 developers, one developer has sql 2005 in his machine, the connection string has Integrated Security=SSPI, that developer can connect to the application, the other user gets that error when he tries to execute the application froms its own IIS.
The sql server has windows authentication, I want that the application uses one account, I tried to create one account, and give db_owner to it on the database, then I changed the connection string and it happens the same thing.
TKS
View 3 Replies
View Related
Dec 19, 2003
This is the error I get below. What did I do wrong?
Login failed for user 'useranme' 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 'dnn'. Reason: 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: Login failed for user 'dnn'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
DotNetNuke.AdminDB.ExecuteSQLScript(String strScript)
DotNetNuke.Global.Application_Start(Object Sender, EventArgs E)
View 1 Replies
View Related
Jul 26, 2006
I am very new to SQL Server Express, so I watched the video on how to create permissions in SQLSE. I did what I seen, and I still cannot connect to the specifed database.
I did create a login account in the main part using SQL Auth., then I create a login account in the database, and set its role as dbowner.
After all that I disconnected the object explorer and tried to use the account that I just made and it didnt work, I also went to VBE and tried to connect from within the database explorer and I got the same error above.
I can go to a different pc and try to connect with the same result.
I did watch the video again to make sure that I didnt miss up and what I did was right by the video.
I did try to set another name and user account with no prevail.
Where did I miss up?
Davids Learning
View 7 Replies
View Related
Apr 5, 1999
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.
View 1 Replies
View Related
Jun 19, 2015
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 Replies
View Related
May 24, 2006
Hello 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
View 1 Replies
View Related
Jan 26, 2000
Our server has integrated security setup, upon startup of the server,
we have a continuous flow of error msg:
Login Failed: Reason: User '_' not defined as a valid user of trusted
connection.
The timing of these messages only around 30 seconds apart
The only incident from Technet I can find is Q186314, but we don't have replication setup, anyone knows where I can look into ?
I recycle the server but didn't help.
I appreciate any help I can get ..
Thanks.
View 1 Replies
View Related
Aug 19, 2006
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
View 10 Replies
View Related
Feb 18, 2008
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
View 2 Replies
View Related
Mar 18, 2008
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>
View 1 Replies
View Related
Apr 28, 2008
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.
View 4 Replies
View Related
Apr 28, 2008
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.
View 11 Replies
View Related
May 9, 2008
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
View 1 Replies
View Related
Oct 24, 2006
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.
View 7 Replies
View Related
