Say i have two login accounts in sql server 2005,I want to do context switch operation for two accounts.
I want to know to get impersonate permission....
any suggestions?
thanks
I don't want to use "network service" account for app poll identity for asp.net applications because of security reason. But I try to use sqlexpress I receive following error message.
"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."
But when I try to connect master db with same account (test) there is no problem. Then I create to user profile for "test" account but same error occurred.
Does anyone know how I can resolve this? Thanks!
I am currently logged in as local admin on my laptop, and I want to connect to clients SQL Server 2005.
I can't use my local admin and have to use company network login.
How can I impersonate my network login when connecting to the SQL Server when using local admin account?
Peter Larsson
Helsingborg, Sweden
Hello,
On my SQL Server 2000, I have successfully created a linked server to my Exchange 2000 server (located on the same physical computer). I can't send request and everything is fine.
But now, I would like to apply the "Impersonate" setting. The big problem I've got is that Exchange doesn't use a login and password for the authentification but use the Windows credentials.
I have try things like :
login : <domain name><username> with the real password
login : <username>@<internet domain name> with the real password
but that doesn't work.
I would like to know if there is a way to "impersonate" user log on the SQL Server when they try to use the linked server to Exchange Server.
Thank a lot
Felix Pageau
fpageau@NOSPAM.str.ca
Print | Copy URL of this post
Expand All Collapse All
I am calling SqlContext.WindowsIdentity.Impersonate() within a CLR Stored Procedure and getting the following error:
System.InvalidOperationException: Data access is not allowed in this context. Either the context is a function or method not marked with DataAccessKind.Read or SystemDataAccessKind.Read, is a callback to obtain data from FillRow method of a Table Valued Function, or is a UDT validation method.
The CLR Routine does not do any kind of data accees (as far as SQL is concerned).
Here is the routine:
[SqlFunction(
DataAccess = DataAccessKind.Read,
SystemDataAccess = SystemDataAccessKind.None )] public static int CallService( string sServer, int iPort, string sPath, SqlXml cSqlXmlRequest, out SqlXml cSqlXmlResponse ) { string sXmlResponse = string.Empty; WindowsImpersonationContext cImpersonationContext = null; try {
cImpersonationContext = SqlContext.WindowsIdentity.Impersonate(); sXmlResponse = SoapTransport.CallService( sServer, iPort, sPath, cSqlXmlRequest.Value );
...
} catch (...) { throw; } finally { if ( cImpersonationContext != null ) cImpersonationContext.Undo(); } return SQL_SUCCESS; }
The only SQLContext method/properties that are called is the WindowsIdentity. Further, if I "push" the SqlContext.WindowsIdentity.Impersonate(); call inside CallService, everything work. (It also works correctly if I leave the call of and change the execution identity of SQLServer).
Any ideas as to why this error is occurring and how to resolve it?
Thanks.
Hello all,
I have a quick question. The sql reporting server is on server A, and the actual data for the report is on a sql server 2005 called server B. When I am actually developing my report and click preview, everything works perfectly using windows authentication. However, whenever I publish and try to view the report, i get this error:
An error has occurred during report processing.Cannot create a connection to data source 'serverB'.Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.How do I change the login for this datasource while still using windows authentication and not mixed mode?
Thanks
Hi all,
I encountered a problem when I tried to generate .rdl report in my PWA website integrated with report server. In the "Manage Data Source", when I set the credential type to "Windows authentication (integrated)", it works.
However, when I changed it to "Stored credentials" with the windows account as the Login, the following error occurs:
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'CustomizedDB'. (rsErrorImpersonatingUser)
Logon failed. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
Does anyone know the reason behind? Thanks in advance.
The problem also happens when "Prompt for credentials (use as Windows Credential)" is used.