Changing SQL Server Connection String Based On User.

Mar 1, 2007

I’m working with a team of programmers who are in the process of upgrading an older ASP application to ASP.NET 2.0 (VB).  The existing application connects to the SQL Server Database using different Logins, depending on the User logged into the ASP Application.
 
We are hoping to do the same using ASP.NET 2.0, although we haven’t been able to find a simple solution.  The most feasible solution we have found includes programmatically trapping all the Selecting etc events and changing the SqlConnection at run time.  This allow for ease during Designing of the Web Pages, but implementation requires adding code to each web page (>100 pages).
 
We are hoping there may be a simple solution which can be implemented once for the application where the event can be trapped at the application level, and the SqlConnection set at this point.  Or possibly another type of solution such as creating a new class etc that can be used?
 
Does anyone have a simple solution where the username / password for the Database Connection can be set at run time?

View 2 Replies


ADVERTISEMENT

Connection String Based On Current User

Oct 23, 2007

Hi All,
His there any way to build a connection string to sql server based on the current user credential?
I mean, intead of using
user id=Adminpassword=adminPass
Is it possible to do something like
user id= Context.User.IDpass=???
I'm asking cause, iI don't want to use impersonisation in my code.So that I can be sure logged user only sees what they can
(I'm a newbie, so this whole thing may makes no point(thanks for clarifying

View 4 Replies View Related

MS Sql Server User ID, Password And Connection String

Nov 25, 2007

Hi;I am making a software (.Net) which is going to connect a ms sql server but I cant conect yet :(.1- I dont know what I have to type for user id (name)2- What is my password, it has been long time that I hvae installed it but I dont need any password with Microsoft SQL Server Management Studio Express which has windows authentication option. My software can work via internet or network. So I need to know my user name and password. I am using oledbconnection. Do I need any password?3- I visited www.connectionstrings.com already so I have the format of it.Thanks very much for any help...

View 1 Replies View Related

Changing The Connection String On The Fly....

Nov 21, 2006

Now that I have figured out how to connect to a foxpro database...

Could anyone tell me how to change the connection string on the fly?

I would like to make it possible, from the command line (using dtexec) to specify a portion of the connection string.... incorportate this portion into the connection string and then instruct the connection manager to use this connection...

For example I have a number of foxpro databases to import, they will be place in a directory structure like this:


TopLevel
TopLevelNewYork ransactions.dbf
TopLevelLondon ransactions.dbf
TopLevelSydney ransactions.dbf

I'd like the user to be able to specify which city's files to load each time the package is run..

dtexec /f MyPackage /set Package.Variables[User::THECITY].Properties[Value];"London"

And when the package starts the THECITY variable would take the value "London"

But I'm not sure how to then affect the connection string property of the connection manager... there seems to be no way to specify that it take its connection string property from an expression...

So I'm lookin for some way which would cause the Connection String property of the coneection manager to become:
Driver={Microsoft Visual FoxPro Driver};sourcedb=d:TopLevelLondon;sourcetype=DBF;exclusive=No;backgroundfetch=Yes;collate=Machine;


Jsut to recap, the provider for this connection manager
is a ".Net ProvidersOdbc Data Provider" which I've been forced to use becasue the OLEDb provider for Foxpro has been rendered useless by service pack 1

Thanks in advance
PJ

View 3 Replies View Related

Changing The Connection String At Runtime? C# 2.0

Oct 24, 2007

How can i change the connection string at runtime?

Scenario is, I want my customer to enter server name, database name, and some parameters at the installation time then i will use these entries to build the connection string and persist it into the app.config.

also not only at installation time but also at runtime while the program is running. i wanna make these entries as options which can be modified at any time

so, How can i do that ?

Thanks in advance

View 5 Replies View Related

Changing Connection String To Data Source

Sep 4, 2007

Can I change databases for a SqlDataSource in code behind and still use the edit,inset,delete capabilities of the SQLDataSource control?

View 1 Replies View Related

Changing Connection String In SSIS Package ???

Feb 5, 2007

Hi!

I create a SSIS Package for ETL on my own machine. During development database was also on my machine. For access to this database an OLE DB connection was defined within a package in BI Development Studio. Everything worked well both in debug mode and testing package itself.

Finally I need to load data to a database on a different machine using this package.

I used several scenaries:

1) simply copied the package-file to estination machine, open it for execution, in section "Connection Managers" I edited connection string manually - changed server name and Initial Catalog. And try to execute.

2) on the destination machine I manually created an OLE DB connection (using Microsoft Data Link) to a different database (test succeded), Changed the extention of the connection file 'udl' for ' txt ' and copied its connection string to the field connection string in section "Connection Managers" (pointed in variant 1) ).

3) use Package Configurations, copied the deployment to destination machine, installed the package the way like written here - http://msdn2.microsoft.com/en-us/library/ms365338.aspx. Changed exported properties - Server name, Initial Catalog and also the whole Connection String. Also try to execute.

In all cases I recieved the same error execution message :

"Errors in the metadata manager. Either the database with ID of " OLD_DATABASE_NAME " does not exist in the server with ID of " NEW_SERVER_NAME " or the user does not have permissions to access the object."

As for access (username/pass) settings they are the same for both of them, I have the same administrative rights on both machines. And more with the same rights the ole db connection made was made manually in variant 2 - succeded!!! So I don't think the problem is here.

As for Error message - I think somewhere the OLD name of database (Initial Catalog) is saved, though I tried to change it. Though the NEW value for the server name is substituted.

Please, help me. I don't know what else can I try. And it is not a single case for my practice. So I think - something wrong in my actions.

View 9 Replies View Related

Changing Connection String In Multiple Packages.

Mar 29, 2006

Scenario:

130 dtsx packages using 4 matching connections.
3 of those connections are stored in an SSIS Configuration table in an Operational database.
The last connection is in a shared data source and points to the Operational database so the packages can grab the others.

Problem:

It's time for deployment and all of those connections must change to production servers.
The 3 are no issue, just change the ConfiguredValue in the SSIS Configuration table on the production box to point to the other production servers.
However, the fourth one... I had made an assumption that when you changed a shared data source it filtered down throughout all the packages. We all know what assumptions do to you.... So. I need a way to change all 130 connections (and be able to change ALL packages quickly and simply for other projects in the future)

Solution:

It has been suggested that we use another package to run though all of the packages and change the connection with a script task. I can live with this (and more importantly so can our DBS's who have to deploy).

I have one snippet of code to ADD a connection using a variable holding the connection string, but we dont' want to add one, just change an existing one.

Has anyone else done this? Or had a similar problem and way to fix?

We are likely to have many projects in which the connections MUST change at deployment, and the idea of going into every package to make the change is sad at best... We would be more likely to move back to a competitor's product that has a connection repository, than continue with SSIS.

Ches Weldishofer
ETL Developer
Clear Channel Communications

View 23 Replies View Related

Web.config Connection String Being Used Based Off Enviroment Or Domain?

Feb 20, 2007

I used 3 seperate web.config files - one for Development seerver, one for Certification server, and one for Production server.  The only difference between these three is the within the <connectionStrings> tags. 
For Example:
<connectionStrings><add name="strConn" connectionString="server=xxx;uid=xxxx;pwd=xxxxx;database=yyy;"/></connectionStrings>
Within Development the connectionString points to the Development SQL server, Cert to cert SQL, and Prod to Prod SQL.  I do not have permissions to copy new Web.Config files into Cert or Prod, so when I have a change within my web.config I have to have another group manually add these files.
Is there a way to identify the domain I am curernt within and use a specific set of connections string within the web.config based off this information.  If so, can anyone post an example of how to do this...
 

View 3 Replies View Related

User Id And Password In My Connection String

Aug 15, 2006

Is there a way to find out my user id and password that should be used in my connection string? If I can not find this information out for myself, do I need to go to some type of system administrator.
Here is the connection string in my web.config file.
<connectionStrings>
<add name="SPK" connectionString="Server=localhost; User ID=AppUser;Password=meander;Database=atstdb01;
Persist Security Info=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
 
When I access this connection string via my code, A little dialog box pops up with the following error message:
Login failed for user AppUser. Reason: Not associated with a trusted SQL Server connection.
 

View 2 Replies View Related

Connection String With Authenticated User Info

Jul 6, 2006

Hi.  New to ASP.NET and first time posting.
My web app connects to a SQL database - SQL authentication. 
Users login to the web app through the login server control.  Once authenticated, it is my understanding that the user name and password are stored on the client as a cookie. 
How do you programmatically get this user info and use it for the userid and password parameters of the connection string?
Is there a better way to use the authenticated user info to access a SQL database?
Thanks

View 2 Replies View Related

Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed

Dec 7, 2006

This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View 3 Replies View Related

User Instance=True Causes Invalid Connection String

Feb 14, 2006

Whenever I use "User Instance=True" as in the connection string below, I get an invalid connection string error. If I take it out, the connection string generates other errors.

"Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;User Instance=True;AttachDBFileName=|DataDirectory|DbName.mdf;Data Source=.\sqlexpress;"

Removing User Instance=True always eliminates the invalid connection string message.

BTW, I tried both Data Source=.\sqlexpress and Data Source=.sqlexpress.

View 9 Replies View Related

Dynamic OLE DB Connection String With Static User ID And Password

Apr 30, 2008

I'm trying to setup a dynamic ole db connection using the SA user ID, it has to be dynamic because the server name will change and it has to be SA because we're pulling information from system databases that some users don't have access to.

If I setup a regular static connection using SA credentials it works like a charm of course. When I create an expression to use the User:erver variable it doesn't work, it throws an error message saying that "The login failed for user sa" among other things, I'm thiking that the sa's password is not being saved.

Where exactly do I place a password for dynamic connections using sql server users? On the connection string? On the password property of the source? Any ideas?

View 1 Replies View Related

Login Failed For User , The User Is Not Associated With A Trusted Sql Server Connection. (microsoft SQL Server,Error:18452)

Aug 21, 2007

Login Failed for user , the user is not associated with a trusted sql server connection. (microsoft SQL Server,Error:18452)


hi ,
i am getting the above error message once in a while maybe two or 3 times a week , and then it goes away in 10 to 15 minutes or 5 minutes ,

our mode is set to mixed and we are able to connect and use both sql and windows , but once in a while , it will give us the above message when we try connecting throught sql server management studio client (using sql 05) using windows login , although it lets us connect using sql login while the windows login is denied, and after a while it lets us connect with both.

occurs randomly on some days , we run our servers on VM ware virtual machines using windows 2003 r2 enterprise 64 bit with sp2 with esx 301 virtual machine.

would appericate any feedback on this thanks

View 5 Replies View Related

Login Failed For User '' ..... Sql Server, Error: 18452 (The User Is Not Associated With A Trusted SQL Server Connection)

Nov 7, 2007

Hi

Last week I was receiving an error when trying to connect to two of our seven sql servers from my laptop via my domain admin account. The only fix was to have my laptop rebuilt and everything re-installed.

Today however another administrator is starting to have the same problem but to only one of the seven servers!
When that administrator uses my laptop with her domain admin account it works!?

What could possibly be going wrong with our laptops? We have not installed or changed anything.

The full error message we see:

Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft Sql Server, Error: 18452)

The error being logged on the server: (two errors are logged each time)


SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 53.35.165.148]


Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 53.35.165.148]

View 16 Replies View Related

Entreprise Manager Error Message: [Microsoft][ODBC SQL ServerDriver][SQL Server]Login Failed For User '#####'. The User Is Not Associatedwith A Trusted SQL Server Connection.(28000,18452)

Dec 12, 2007

Can anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!

View 1 Replies View Related

Login Failed For User 'testuser'. The User Is Not Associated With A Trusted SQL Server Connection.

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

Error Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

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

Login Failed For User 'test'. The User Is Not Associated With A Trusted SQL Server Connection.

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

Login Failed For User 'KOQuotes'. The User Is Not Associated With A Trusted SQL Server Connection.

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

Login Failed For User 'KOQuotes'. The User Is Not Associated With A Trusted SQL Server Connection.

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

Login Failed For User 'username'. The User Is Not Associated With A Trusted SQL Server Connection.

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

Login Failed- User: Reason: Not Defined As A Valid User Of A Trusted SQL Server Connection.

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

[298] SQLServer Error: 18452, Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

Mar 11, 2008

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.

View 8 Replies View Related

System.Data.SqlClient.SqlException: Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

May 17, 2006

 
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()    %>
 

View 2 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

Oct 23, 2006

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   

View 2 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.?

Dec 28, 2007

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!

View 1 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

Jan 5, 2008

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

View 2 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

Jan 29, 2008

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

View 12 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection

Apr 29, 2008

 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

Login Failed For User 'sa'. The User Is Not Associated With A Trusted SQL Server Connection.

May 15, 2008

Hi,

How to handle "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
when i was access to web page. I want to on sql server authecation mode.

View 5 Replies View Related

Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.

May 26, 2008

hello
i am working on a web application where the application and data base are not on the same serverso when trying to connect to the data base from the web application using windows authentication i got that errorLogin failed for user ''. The user is not associated with a trusted SQL Server connection. when i used user id and password the problem solvedcan any one tell me how to make my application run using  windows authenticationone thing else ;this problem raised  after another issuse came from the network that the server is not able to resolve the address or ip of the serverbut that problem solved suddenly and left the above issue  

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved