sp debug isnt working - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sp debug isnt working

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-12-20 : 07:59:26

i have tried to debug a SP and got the message :

then i tried to change the mssqlserver like this :

but it didnt help!!
(i did the same for the sqlserver agent at first (by mistake) but nothing helped)
any idea?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2005-12-20 : 08:25:34

I'm suggesting u to stop-start the SQL Services (MS SQL Server & SQL Sever Agent) - in Services, after the change u did above.

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-12-20 : 09:24:20

of course i did the services tell it to u when u change the logon user and no luck

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2005-12-20 : 10:09:03

U may need to put the Machine’s admin user (use the browse button in the above screen u have given) & select that username & corresponding pswd.
Log in to the Query Analyzer with the windows authentication

Did u restarted the "SQL Server Agent" as well ???????

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-12-20 : 14:24:35

1)i putted the machine admin user and pass:)
2)i have restarted the sql server agent
3)when i open the qurey analayzer from the enterprise manager it openes it with sa userpass i think - do i still need to try it with the admin pass?

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2005-12-20 : 14:39:46

U Open the Query Analyzer direclty (ie. go to Start --> Programs --> Microsoft SQL Server --> Query Analyzer)
Select the Windows authentication option (ie. the one without the user / pwd)
Then continue & c

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2005-12-21 : 00:49:41

ok great now it work:)
thanks alot

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources