ODBC Trusted_Connection Call To SQLGetInfo Returns DBO As User Name, Not NT User
Hello, all:
I am connecting to SQL Server 2000 with a trusted connection, and that is working fine. I then am issuing a SQLGetInfo call to find out the SQL_USER_NAME, which is always returning dbo instead of (my) Windows NT login name, which I expect to see. THe authentication is (apparently) confirmed by the SQL Server session monitor where it shows the right Windows NT user name logged in, over ODBC. With a standard SQL Login, untrusted, I definitely get the right user name back, not dbo.
So:
Login Type / user id /returned value from SQLGetInfo
Windows Authentication / Windows login / dbo
SQL Authentication / Windows login (UID) / UID
The problem is that I am trying to confirm that the userid entered in a dialog or passed on the command line to my application matches the actual connected user name inside SQL Server....
My questions:
Is there some pathology in Trusted_Connections that masks the Windows/NT login name and always returns UID 'dbo' from a call to SQLGetInfo? Is there a MSS (public) stored procedure that can robustly give back the logged in user name so I can bypass the SQLGetInfo call?
View Complete Forum Thread with Replies
Related Forum Messages:
Login Failed For User '[USER]'. The User Is Not Associated With A Trusted SQL Server Connection.
Server Error in '/Forums' Application. can u help me how to find a solution to this:Server Error in '/Forums' 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 '"[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.
View Replies !
ASP.NET 2.0 Call Of MS SQL DTS Package Fails With Unknown User Name/Password
I am writing an ASP.NET intranet application on a Windows XP machine running IIS 5.1 which executes a MS SQL Server 2000 DTS package as part of the process. The application allows the user to select a UNC path of an input source (.txt) file to be procesed by the DTS pacakge and the UNC file path property is then set in the source object name of the DTS package tasks before executing the DTS package. Whenever I run the application using a file path that is on my development machine (the same machine that the web server is on) it works fine. When I select a source file path that is on a network share folder, the DTS package fails with the following error:Event Type: ErrorEvent Source: DataTransformationServicesEvent Category: NoneEvent ID: 81Date: 2/14/2007Time: 12:58:06 PMUser: N/AComputer: PHILSDELL2Description:The execution of the following DTS Package failed: Error Source: Microsoft Data Transformation Services (DTS) PackageError Description:Package failed because Step 'DTSStep_DTSDataPumpTask_2' failed.Error code: 80040428Error Help File:sqldts80.hlpError Help Context ID:700Package Name: ATMRecon_ImportElanACHTxtPackage Description: (null)Package ID: {3A8CC31D-A81F-40B7-BE57-AEB3AA238088}Package Version: {B01420A7-ED22-49A7-B4C7-9FA1732394E3}Package Execution Lineage: {2A9D45E8-35F8-4F0A-8339-7E5E29DA08B7}Executed On: PHILSDELL2Executed By: webaccess23Execution Started: 2/14/2007 12:58:05 PMExecution Completed: 2/14/2007 12:58:06 PMTotal Execution Time: 1.047 secondsPackage Steps execution information:Step 'DTSStep_DTSExecuteSQLTask_1' succeededStep Execution Started: 2/14/2007 12:58:05 PMStep Execution Completed: 2/14/2007 12:58:05 PMTotal Step Execution Time: 0.047 secondsProgress count in Step: 0Step 'DTSStep_DTSExecuteSQLTask_2' succeededStep Execution Started: 2/14/2007 12:58:05 PMStep Execution Completed: 2/14/2007 12:58:05 PMTotal Step Execution Time: 0.047 secondsProgress count in Step: 0Step 'DTSStep_DTSDataPumpTask_1' failedStep Error Source: Microsoft Data Transformation Services Flat File Rowset ProviderStep Error Description:Error opening datafile: Logon failure: unknown user name or bad password.Step Error code: 80004005Step Error Help File:DTSFFile.hlpStep Error Help Context ID:0Step Execution Started: 2/14/2007 12:58:05 PMStep Execution Completed: 2/14/2007 12:58:06 PMTotal Step Execution Time: 1 secondsProgress count in Step: 0Step 'DTSStep_DTSDataPumpTask_2' failedStep Error Source: Microsoft Data Transformation Services Flat File Rowset ProviderStep Error Description:Error opening datafile: Logon failure: unknown user name or bad password.Step Error code: 80004005Step Error Help File:DTSFFile.hlpStep Error Help Context ID:0Step Execution Started: 2/14/2007 12:58:05 PMStep Execution Completed: 2/14/2007 12:58:05 PMTotal Step Execution Time: 0.031 secondsProgress count in Step: 0 When I check the Security Event Log on the server on which the network share is located, I find the following set of messages repeated multiple times:Event Type: Failure AuditEvent Source: SecurityEvent Category: Account Logon Event ID: 680Date: 2/14/2007Time: 1:02:48 PMUser: NT AUTHORITYSYSTEMComputer: FS1ADescription:Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 Logon account: ASPNET Source Workstation: PHILSDELL2 Error Code: 0xC000006AEvent Type: Failure AuditEvent Source: SecurityEvent Category: Logon/Logoff Event ID: 529Date: 2/14/2007Time: 1:02:48 PMUser: NT AUTHORITYSYSTEMComputer: FS1ADescription:Logon Failure: Reason: Unknown user name or bad password User Name: ASPNET Domain: PHILSDELL2 Logon Type: 3 Logon Process: NtLmSsp Authentication Package: NTLM Workstation Name: PHILSDELL2 Caller User Name: - Caller Domain: - Caller Logon ID: - Caller Process ID: - Transited Services: - Source Network Address: 10.120.4.61 Source Port: 0The problem appears to be that the DTS package is trying to access the input source file using the local ASPNET Id from PHILSDELL2 which does not have authority to the network share. The ASP.NET application is using impersonation, set up through the web.config file: <identity impersonate="True" userName="registry:HKLMSOFTWARESkylightATMReconidentityASPNET_SETREG,userName" password="registry:HKLMSOFTWARESkylightATMReconidentityASPNET_SETREG,password" />The application can sucessfully access the network share under the impersonated id (the application first verifies the existience of the source files before executing the DTS package). I have wracked my brain trying to determine where the ASPNET security context is coming from to no avail. Can someone shed some light on what security credentials the DTS package is using to access the source files and how to change them?
View Replies !
Find Phonecall Records Based On User At The Time Of Call
i have a table of phonecall records detailing amongst other things the time and duration of the call. there is a relationship linking this table to a table of handsets and from there to a table of users. this users table lists the start date the user had the phone. as ever sample data might make this easier to show: PhoneUsers table PhoneUserID Name StartDate PhoneID 1 john 1/08/2006 1 2 bob 20/08/2006 1 3 fred 2/08/2006 2 etc Phones table: PhoneID 1 2 etc PhoneCalls table: PhoneCallID PhoneID CallDate Duration 1 1 10/08/2006 25 2 1 23/082006 20 3 2 23/08/2006 20 i want the following result set: user calldate duration john 10/08/2006 25 bob 23/08/2006 20 fred 23/08/2006 20 essentially i am trying to link the phonecalls to the user of the phone at the time of the call. i make the following assumptions regarding the data: the user is responsible for all calls for a given handset from the 'startdate' until the next 'startdate' for a different user, if such a record exists, if not then for all calls after that date thanks
View Replies !
Prevent ODBC By USER/APP
Is there a way to monitor all ODBC connections to a MSSQL server and prevent a username/ODBC combination. My problem is that we have many frontends for viewing reports, but we managed them all and users are not allow to make their own connections. Some users now uses MSAccess over ODBC to draw their own reports - they have all the permissions as neededd by the other apps. thanx
View Replies !
Odbc Error - Record Has Been Changed By Another User
The following error is recieved when updating a record using access 97 and odbc driver to an oracle database. This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Any help is greatly appriciated. Thanks in Advance
View Replies !
Odbc Errors After Joining New Domain With New User
Hi I am new to this forum so I hope I have got the right one. The problem I am having is I installed a new server into an office with 25 users. I joined the users to the new domain with new logins. The server process then installed outlook 2003 onto each machine. Most machines are windows 2000 Problems arose in sage I have tied this down to the report designer and odbc. On every machine bar 1 the report designer crashed when running a report. The problem like I said was that you cannot now connect to the odbc driver for sage and when you go into odbcad and try to look at the driver you get an error saying The setup routines for the sage line 50 odbc driver could not be loaded due to system error 127 Then after that comes Could not load the setup or translator library I have looked on the net for this error and it tells you to look in the registry to make sure that the odbcinst is pointing to the correct location, I have checked this and it is. I ahve also checked the security and this seems ok aswell. The next step was I loaded a fresh copy of windows 2000 into a new folder and tried to load the odbc driver again. This failed with the same as above. This points to the software settings but I cannot find out where. Iwas wondering if anyone has had the same problem and they could point me in the right direction.
View Replies !
HIDE System Tables From ODBC Connection / User
I had a question about some of the tables that show up when you link through a ODBC datasource using Access to link to SQL tables on SQL Server. Would it affect anything like merge replication, select statements etc, if the administrator were to hide tables with the following naming: conflict_TABLENAME (merge replication participant tables). ctsv_######### dtproperties MSmerge_contents through MSmergesubscription_properties syncobj_0x000000 sysalternates through syssegments tsvw_####### INFORMATION_SCHEMA.CHECK_CONSTRAINTS through INFORMATION_SCHEMA.VIEWS
View Replies !
DataReader With ODBC As Source Using A User Variable In The Sqlcommand
Does anyone know how I can use a user variable in a sqlcommand in a Datareader source with an ODBC connection as the source? I am storing a date value in a user variable(Date) I fill with a SQL Task and then want to use the value in the sqlcommand I use in the Datareader Source. It won't let me use the @variablename in the sql command. Can anyone help with some advice on how I can make this work? Appreciate any help I can get. Thank you
View Replies !
Error : &&"cannot Open User Default Database. Login Failed. Login Failed For User 'server/user'
i'm using the Enterpirse library logger to write logs into a database. When choosing connection string i choose the database i want in the "connection properties" dialog box and push 'Test connection' button. everything goes well. then i open the SQL Server Management studio express and connect to the databse to check some things, from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error: "cannot open user default database. Login failed. login failed for user My'server/MyuserName'" even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore.... it only work when i restart the computer. why ?
View Replies !
OLE DB Or ODBC Error: Login Failed For User 'NT AUTHORITYLOCAL SERVICE'
Hi, I need help with a problem: When trying to process a analysis services project, I receive the following error message - OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITYLOCAL SERVICE'.; 28000; Cannot open database "DocumentDB" requested by the login. The login failed.; 42000. I am using the service account for impersonation for the datasource. One suggestion I received from the data-access forum was to grant privileges to the local service for the database. I am not clear about the procedure to do that. Can someone please guide me through this? I am posting this question in this forum since this is a authentication/privilege issue. - Sanchet
View Replies !
SQL Call To Count The Total Rows In Table B For Each User In Table A
I have 2 tables: TableA: Name UserA UserB UserC Table B: Name Data UserA xxx UserB asdasd UserB ewrsad UserC dsafasc UserA sdf UserB dfvr4 I want to count the total entries in Table B for every user in Table A. The output would be: Name Count UserA 2 UserB 3 UserC 1 I can use a Select Count statement, but I will have to make a SQL call for every user in Table A. Also, Table A is dynamic, so the users are always changing. Can this be incorporated into one SQL call to count the total rows in Table B for each user in Table A?
View Replies !
Cannot Open User Default Database. Login Failed For User 'NT AUTHORITYNETWORK SERVICE'
Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. 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: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. I have This Error When i try to log into My online web site, i have no idea how to fix it,one day it was working and the next it wasnt, is there any way to find out what database the default is and if it's either incorrect or not present change the web.config in a way that will make my system work. i have the NT Authority/Network Service in my Server Properties Permissions, its given the type login and is granted Connect SQL by sa i have 3 colder copies of the web site on my server my question is, how would i use of of these to restore the original site configuration is there a way to restore the original configuration to undo whatever it is i've done to break the system ChrisStressed
View Replies !
[JavaScript Error] Cannot Delete User Or User's Authority In Specific Report After Install SQL SP2
Hi, I have several reports for users to view on our Intranet. After installation of SQL 2005 SP2 patch, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates / hotfix. Thanks a lot! Regards, Kenneth Lai Programmer Error Pic Message Box
View Replies !
Second User Trying To Connect Generates: Cannot Open User Default Database. Login Failed.
Hi, I'm new to SQL Express 2005. I found information regarding : "Cannot open user default database. Login failed."on this forum but I think that in my case it's a bit different issue. I have a website (ASP.NET 2.0) accessing DB, in the mean time Windows Service tries to update some data in the same DB (Service runs as NT AUTHORITYLOCAL SYSTEM). The second connection is rejected: "Cannot open user default database. Login failed.Login failed for user ....". Problem occurs only when both: service and website are running at the same time. So service and website are running without problems when they are connecting DB exclusively. My connection string is: "Data Source=.SQLEXPRESS;AttachDbFilename="|DataDirectory|spider-lab.mdf";Integrated Security=True;User Instance=True" I would be grateful if you can help me
View Replies !
How To Call A Sproc From Within A UDF That Returns A Table?
Hi. This is a SQL question. I am trying to wrap a stored procedure with a UDF so I can do selects against the result. The following doesn't work, but is it possible to do something like: Create Function test()returns @tmp table ( myfield int)asbegin insert into @tmp (field1) Exec dbo.MySprocWhichRequires3ParmsAndReturnsATable 5, 6, 10 output returnend Thanks
View Replies !
SQL Call INNER JOIN Returns Too Many Records
I have my SQL call: SELECT CallLog.CallID, Journal.HEATSeqFROM CallLog INNER JOIN Journal ON CallLog.CallID = Journal.CallID There are multiple enteries in the Journal table for every entry in the CallLog table, so I receive multiple records: CallID HEATSeq00000164 983290904 00000164 983291548 00000164 983295209 00000231 984818271 00000231 985194317 00000231 985280248 I only want to return the LAST record in the Journal table, so the output will be: CallID HEATSeq00000164 983295209 00000231 985280248 Can this be done directly in the SQL call?
View Replies !
Login Failed For User 'test'. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed For User 'NT AUTHORITYANONYMOUS LOGON' (but User.identity.name Is Correct)
I need help. The security principal is the correct DomainUser, but the error message says I am not authenticated. So here is my error Message: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomainRyan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomainRyan; HttpContext.Current.User.Identity.Name=CompanyRyan Generated by: Dim secPrinc As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrent Me.lblError.Text = ex.Message & vbCrLf & vbCrLf & "Me.User.Identity.Name=" & Me.User.Identity.Name & "; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name & "; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name Here is the Connection String: Private ConnString As String = "Server=10.144.162.111;Database=DNS;Trusted_Connection=True" IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest. In IIS, is there a problem with having the parent level anonymous and website level windows auth?
View Replies !
Login Failed For User 'testuser'. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed: Reason: User '_' Not Defined As A Valid User Of Trusted
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 Replies !
Login Failed For User &&". The User Is Not Associated With Trusted Sql Server Connection
We are wanting to use SQLEXPRESS in a workgroup called REALITY, no servers just PCs. I have four PCs in this workgroup and need them all to share the same database from one of the PCs. I can share folders and map a network drive but can not connect to the SQLEXPRESS database remotely. I have set server authentication mode to Windows and SQL and have enable local and remote connections (TCP/IP only) in the surface area. After making these modifications I was able to connect to the database through the SQL Server Management Studio Express after I enable the guest account. When I first started I had numerous connection errors and have worked through them all by performing the above and was only finally able to connect after enabling the guest account and adding said account to the SecurityLogins. However, today I am unable to connect I have double and triple checked the settings and still continue to receive the same error.
View Replies !
Is There A Way To Show A User-friendly Error When User Did Not Select A Required Parameter ?
Hi all, I was wondering whether there is a way to show the user an error when the user did not select a specific parameter. In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ? Thanks Bernard
View Replies !
Login Failed For User 'username'. 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
View Replies !
Migration Problems From SQL 2000 To SQL 2005: User Cannot Find The User 'RSExecRole'
Hello, I am trying to migrate reporting services from SQL server 2000 to SQL 2005. I followed the migration steps listed in one of the TechNet documents. Installed SQL 2005 and SP2. Backed up existing SQL 2000 databases and restored on SQL 2005. Went to Configuration tool and then to the Database setup. Connected to SQL 2005. Clicked on the Upgrade button. The upgrade fails and I always get the following errors: "The database version (C.0.6.54) does not match your reporting services installation. You must upgrade your Reporting services database" Then I get this exception: System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) I do not understand why it is looking for user 'RSExecRole', which is a role. Appreciate your help
View Replies !
Help:SQLExpress User Instance Fails For Normal User; Works For Administrator
I'm using the RTM version of Visual Studion 2008 and SQLServer Express. Logged in as an administrator, I can create a connection to an mdf file and all is well. As a normal user, attempting to create a connection gives the message "sqlservr.exe has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." I have tried this with UAC turned on and turned off. The result is the same. In Services I can see that SQLEXPRESS is running, but each time I try to connect, I get the "stopped working" message. For existing database programs that have the .mdf file stored in the project folder, I can run the program in the VS IDE on my XP machine and on my Vista machine as administrator, but not as a normal user. I'm not looking for a workaround to make this work once, but the cause and solution to the problem. This is for an introductory VB textbook and we must be able to move a database program from one machine to another and make it work. Everything I have read says that SQLExpress should be able to do that. Can anyone help me with this? Judy Fraser
View Replies !
Login Failed- User: Reason: Not Defined As A Valid User Of A Trusted SQL Server Connection.
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 Replies !
Script Failed For User / User.UserType: NoLogin Is Not A Valid Option For SQL Server 2005
I posted this on USENET (microsoft.public.sqlserver.dts) but no response so far. Hopefully someone here can help? I have converted a SQL Server 2000 DTS package to an SSIS one for SQL Server 2005. When I execute the package that has CopyDatabaseUsers set to true, I get the following errors that cause the package to stop: [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Script failed for User 'xyzUser'. ". [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "User.UserType: NoLogin is not a valid option for SQL Server 2005." The SSIS package is copying from a 2005 database to a 2000 one. The user that is failing appears to have been created with the WITHOUT LOGIN clause. Looking up User.UserType I see that NoLogin is an enumerator of the type. How come it isn't valid for 2005? How do I work around this? Many thanks.
View Replies !
[298] SQLServer Error: 18452, Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Windows Authentication - Cannot Generate SSPI Context - Login Failed For User ''. The User Is Not Associated With A Trusted SQL
We are looking at developing an SQL Server 2005 Database and I would like to use Windows Authentication rather than SQL Server Authentication to connect our client app. In our development environment, we have two Servers, one being used as a file server and the other as an SQL Server. We have now set up a domain using the file server as the domain controller. (We had previously been set up to use a workgroup). I have set up an active directory group called SqlDevelopers and added an active directory user called Jonathan to it. On the SQL Sever, in management studio, I have set up a new server login which uses windows authentication called DomainSqlDevelopers. I used the GUI to verify I could see the domain and the group. The default database is set to a test database on the server. A user in the test database is mapped to the DomainSqlDevelopers and given the Roles dbo, db_datareader, db_datawriter. To test the log in, on the server, I logged out as administrator and in as Jonathan. I could successfully access the server through management studio using windows authentication. However, if I log in as Jonathan on my client PC and try to access the SQL Server using management studio and windows authentication, I have problems. The first time I try I will get a timeout error. If I try again will get either: Login failed for user ''. The user is not associated with a trusted SQL Server connection Or Cannot generate SSPI context I can€™t determine any pattern to which of the above errors I get. However, if I log in as administrator on my client PC, I can connect to the server using management studio and windows authentication. Sounds like Active Directory/Domain or other Network issue (Not really my area). I would be grateful for any help. Thanks, Jon
View Replies !
System.Data.SqlClient.SqlException: Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection
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 Replies !
Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Login Failed For User ''. The User Is Not Associated With A Trusted SQL Server Connection.
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 Replies !
Problem In SQL Developing As Restricted User (member Of User Group)
Greetings,VWD EE and other Tools do not have problems working O.K. on my machine, when I am logged-on as restricted(limited) user, both environment and local web server are functioning, and it was MS effort to do it right.BUT the Problem is, when I try to connect to database->new DB connection(either through vwd or management studio etc). I get an Error - which should be written to event log (according to msg) but it isn't - that I can't connect. I am sure that it is because NO SQL SERVER2005EXPRESS instance is running, which I think is the only prerequisite to have it work (I do not need sqlbrowser service I am doint local development).SQL2005express service is configured on MANUAL start. I can start it as administrator through SQL config manager, but it is not convienient and what I want. I need to start it ONLY as a developer user, I do not want it to be running all-the-time for everyuser using computer. It was congigured as Network Service logon, I tried Local Service logon, and I even tried configuring it to logon as -my developer user- account, e.g. with limited user name and his password.In every case I can't start the service as member of users group and this developer. Then I added limited user to SQL2005EXPRESS group. Still NO help, won't start either.My question is, If I want to start developing ADO2.NET application and I need to have running SQL2005Express instance as a develper, how can I start it? I think I do not have some rights to masterDB or something. Do it allways need to be running when computer starts? Isn't there any other way, to start it JUST when I think I start developing?I know of user-mode of accessing SQL2005express DBs, but it also assumes that SQL2005Express service is already running, what I am trying to prevent. I do not want to have it running for everyone who uses computer, just for someone who neeeds it.Any help explaining me the right way HOW TO SETUP WORKING ENVIRONMENT when developing as limited user welcome, I read the the documentations and haven't found the answers.THANK YOU !
View Replies !
|
TRACKER
