sqlprov.exe

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  January 21, 2009 at 11:33 pm

  #200321

  Dear All,

  What is sqlprov.exe?

  I have found at last when I was deploying sp3 on sql server 2005.

  Thx,

  Ajay

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 22, 2009 at 12:25 am

  #930904

  It's used on Vista (and I think Server 2008) to add in an administrative user as, by default, the builtin\admins are no longer automatically sysadmin on those OSs. It's only used with SQL 2005 SP2 and SP3

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Sandeep.Lad

  Old Hand

  Points: 319

  More actions

  May 25, 2009 at 6:53 am

  #999646

  Hi All,

  It is for permitting user access by Windows Vista and Windows 2008 .

  Regards,

  Sandeep Lad