Search code examples
.netsql-server.net-framework-version

Aspnet_regsql.exe - Which folder to use?

I need to enable SQL cache notification on my SQL Server via the command :

aspnet_regsql.exe -S .. -U sa -P ..

SQL server version:

enter image description here

Windows server version :

enter image description here

However - When I'm looking for the aspnet_regsql.exe file, I found many versions :

enter image description here

Question

How can I be sure which version to use? The computer has a 64-bit operating system, but this doesn't mean that SQL Server uses the 64-bit .NET framework.

Solution

  • About your SQL Server installation, if you want to know if that is a 32 or 64 bit installation, use the following T-SQL:

    SELECT SERVERPROPERTY('Edition')

    that will give an output like Developer Edition or Developer Edition (64-bit).

    About your question, I think you have to use the executable aspnet_regsql.exe in the directory %windir%\Microsoft.NET\Framework64\v4.0.30319 (if you're using the .NET Framework 4), since yours is a 64-bit OS, as explained in the MSDN documentation about aspnet_regsql.