SQL CLR Function and .NET Framework return different results

• sektor81

  Say Hey Kid

  Points: 679

  More actions

  November 1, 2014 at 11:01 am

  #397594

  Hello, everyone.

  I have rather simple CLR function:

  [SqlFunction(IsDeterministic = true, DataAccess = DataAccessKind.None)]

  public static SqlString GetUserName()

  {

  return (SqlString)WindowsIdentity.GetCurrent().Name;

  }

  When I get result from .NET console app, I get correct answer "Jungle\Sektor". However, when SQL Server executes this code, it gives me "NT Service\MSSQL$SQL2014". How to get correct result? Thanks.

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  November 1, 2014 at 5:45 pm

  #1756188

  When you execute it from ssms it gives you the account under which the sql service is running.

  SELECT SUSER_SNAME() run from ssms should give you the same result as from your console .net app.

  Igor Micev,My blog: www.igormicev.com