Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query Analyzer login Expand / Collapse
Author
Message
Posted Monday, March 24, 2008 1:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2008 7:56 AM
Points: 33, Visits: 34
Greetings,

I log into SQL 2005 through SQL query analyzer successfully. When I run/execute each query, I am prompted to re-enter the sa password? What causes this?

Thanks in advance




"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec
Post #473682
Posted Monday, March 24, 2008 1:38 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
Right-click: "Query Options"...

under "Execution..Advanced" tab, uncheck "Disconnect after query executes"


--------------------

Is someone practicing April Fool's jokes early today?


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #473689
Posted Monday, March 24, 2008 3:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2008 7:56 AM
Points: 33, Visits: 34
RBarry,

Thank you for the info. I failed to mention that I am using the SQL Query tool from SQL 2000 which does not have the options you mentioned.




"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec
Post #473755
Posted Monday, March 24, 2008 3:47 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
OK, on QA for SQL 2000 it is under the "Tools" menu, click the "Options" item, then select the "Connections" tab on the dialog that comes up. You should see the "Disconnect after query executes" option on that page.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #473762
Posted Monday, March 24, 2008 4:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2008 7:56 AM
Points: 33, Visits: 34
Thank you sir. What if the "Disconnect after query executes" option is not checked?



"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec
Post #473785
Posted Monday, March 24, 2008 5:24 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
At the bottom of your query window is a status bar with your connection information. First connect you session, then check to see what it says.

Now execute something like "select suser_sname()", then look at the connection bar again. Did it change?

Finally, execute the same command again. Did the connection bar change? Tell us what the connection bar said in each case, and what errors/etc. occurred at each step.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #473795
Posted Wednesday, March 26, 2008 12:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2008 7:56 AM
Points: 33, Visits: 34
I followed the steps you indicated with the following results:
1. log in; status says sa(115)
2. run query by clicking the run query button; status says sa(115)
3. run query again pressing the F5 key: login screen pops open
3a. I enter the password and press enter
3b. New window opens the status says sa(120)
3c. close the window and return to original window: status says sa(115) press F5 and query runs.

Here is what I determined;
Any query run using the F5 key, I get the login prompt.
Any query run using the run query button runs w/o the login prompt.

Very strange considering the button and the F5 key have always functioned identically in my experience.

Thank you for your assistance. Please let me know if you have a solution for the issue.




"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec
Post #474984
Posted Thursday, March 27, 2008 10:29 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
Maybe someone has setup one of those function key macros? I don't really know how that's done, so maybe someone who does can jump in?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #475876
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse