Could not obtain information about Windows NT group/user

You should receive this error when you use “Execute as ower” in your script or in your jobs. I received this error when I want to create a natively compiled stored procedure for my memory optimized table. You may want to read the below article about memory optimized tables and natively compiled stored procedures.

In Memory OLTP in SQL Server“,

What is Natively Compiled Stored Procedure in SQL Server

The reason I receive the error is that I used the expression “Execute as Owner” in the create script and the database owner was not “sa”.

The script and the error is below:

To solve the error, change the owner of the database or job to sa. You should read the below article to change the owner of the database.

How To Change Owner of Database in SQL Server(ALTER AUTHORIZATION)

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *