Query Analyster Issue

Question

Post reply

Query Analyster Issue

binu.m a

Ten Centuries

Points: 1002
More actions
December 4, 2009 at 6:20 am

#228388

In my sql server 2005 I am able to connect to server trhouh management studio,i am able to view all dbs.But when I clicke on new query I am getting the error
Acced is denied,. (Exception from HRESULT : 0*80070005(E_ACCESSDEINED))(mscorlib).
Kindly assist me Urgent

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

joeroshan SSChampion Points: 10377 More actions · Answer 1

binu

May be your account does not have appropriate permission.

Also can be a corrupt installation.

Create a .sql file using notepad and try double click it to open. Are you able to connect?

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

binu.m a Ten Centuries Points: 1002 More actions · Answer 2

Hi

I am having sysadmin rights in sql level.I created a sql script in notepad and tried to open , it is working.But when I tried to open new query it is showing the same error

joeroshan SSChampion Points: 10377 More actions · Answer 3

Does it open in management studio? are being able to execute the script?

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

binu.m a Ten Centuries Points: 1002 More actions · Answer 4

It is opening

But if i tried to execute the script it showing Access to the path is denied.

I tried -use master. it is working.But if i put sp_helpdb -error

Access to the path is denied.

satpathy.sonali325 Grasshopper Points: 16 More actions · Answer 5

[font="Comic Sans MS"][/font]

It might b that the DB owner in some of the databases is NULL. Change it sa. May be it would work.

satpathy.sonali325 Grasshopper Points: 16 More actions · Answer 6

Run it from MASTER

SELECT name, suser_sname(sid), convert(nvarchar(11), crdate),dbid, cmptlevel

FROM master.dbo.sysdatabases

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

You either have a corrupted install or insufficient rights. The error is NOT from SQL server it is a .NET error..

CEWII

binu.m a Ten Centuries Points: 1002 More actions · Answer 8

I tried to execute select * from sys.databases

it is also showing the same error -Access denied.

sql service is running under windows functional id.I given registry privilages to that id.still it is showing the same error.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 9

Elliott Whitlow

SSC Guru

Points: 102402

December 8, 2009 at 6:55 am

#1089179

Does this work from another machine?

CEWII

binu.m a Ten Centuries Points: 1002 More actions · Answer 10

yes

If i connect from other machine all r working fine.Problem with local server only

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 11

You could try re-applying the service pack..

Hold on.. Are you using Query Analyzer to connect to SQL 2005 or SSMS? It just occurred to me that the title was QA..

CEWII

binu.m a Ten Centuries Points: 1002 More actions · Answer 12

HI

SSMS is connecting to server correctily

I am using the windows login. I added the id to Administrators group and then it is working fine. I am able to connect to query analyser.

Seems some permission issue.

Kindly let me know if i use ssms and query analyser where the temp file will bel created????.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 13

Kindly let me know if i use ssms and query analyser where the temp file will bel created????.

Uh, what temp file?

CEWII