SQL Query designer add table window is blank - ASP DB

I have an ASP.NET website using the ASP database running on SQL Server 2008 R2.
I'm trying to write a query against this database with the queryu designer, but when select 'add table' theres no tables available.  Any ideas?

See image attached... View of designer
jamie77777Asked:
Who is Participating?
 
jamie77777Connect With a Mentor Author Commented:
SQL restart fixed it... last resort.
0
 
Kevin CrossChief Technology OfficerCommented:
That may be an indication that the user id you are connecting with has permissions to SELECT, but not REFERENCES. Try adding that privilege or using another more privileged account and see what happens.
0
 
jamie77777Author Commented:
Thanks for responding, but I'm logged in as domain administrator, who is DBO.
0
 
jamie77777Author Commented:
SQL restart fixed it... last resort.
0
 
Kevin CrossChief Technology OfficerCommented:
Glad you found that. Very odd.
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.