March 24, 2008 at 1:31 pm
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
March 24, 2008 at 1:38 pm
Right-click: "Query Options"...
under "Execution..Advanced" tab, uncheck "Disconnect after query executes"
--------------------
Is someone practicing April Fool's jokes early today?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2008 at 3:34 pm
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
March 24, 2008 at 3:47 pm
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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2008 at 4:59 pm
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
March 24, 2008 at 5:24 pm
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 "[font="Courier New"]select suser_sname()[/font]", 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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2008 at 12:05 pm
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
March 27, 2008 at 10:29 pm
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?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply