DOTNETNUKE: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.

I am trying to install DOTNETNUKE on Windows XP and SQL Server 5.0. I keep getting an error when trying to build the database: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.

I know that I must be missing a access permission somewhere but I can't find it.
jackjack347473Asked:
Who is Participating?
 
hongjunConnect With a Mentor Commented:
The above link points that VIEW SERVER STATE is not added.
0
 
hongjunCommented:
0
 
jackjack347473Author Commented:
How to add VIEW SERVER STATE permissions
Found out how to do it.

1. Right mouse click the SQL Server and go to Properties
2. Go to Permissions in select a page
3. Find the login you want to assign the permission to in the top box
4. In the bottom box go all the way to the bottom you will find "View
Server State" and put a check mark in the Grant box and click OK.
0
 
hongjunCommented:
The above link points that VIEW SERVER STATE is not added.
Credit should be awarded.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.