Viewing 15 posts - 14,161 through 14,175 (of 19,560 total)
Paul White NZ (5/7/2010)
CirquedeSQLeil (5/6/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 7, 2010 at 9:50 am
newbie2sql (5/7/2010)
As per your current scenario you will be able to login to the box if you are administrator on the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 7, 2010 at 8:31 am
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Time for the tentIt is there for whoever needs it, just be sure the hippo knows you are coming. 😛
Skipping the tent and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 7, 2010 at 12:02 am
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Time for the tentIt is there for whoever needs it, just be sure the hippo knows you are coming. 😛
Skipping the tent and just going straight...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:49 pm
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
"Oh, please, tell me exactly what I need to do. I can't think for myself" said the OP.
Glad you saw his response before I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:45 pm
Time for the tent
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:44 pm
Is your windows auth account a member of the builtin administrators group?
Have you verified what permissions you have for your windows auth account?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:43 pm
Lynn Pettis (5/6/2010)
"Oh, please, tell me exactly what I need to do. I can't think for myself" said the OP.
Glad you saw his response before I did.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:41 pm
Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped based on the source document provided in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:38 pm
I would just verify it via the GUI.
Login under your sa account and check the logins. Lynn has given some good resources for finding that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:35 pm
woot - got it correct.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:33 pm
While providing the information already requested, you may also want to lookup linked servers in BOL.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:26 pm
Sounds like your windows auth hasn't been granted permissions to that database. Verify that you have the correct default database set and that your windows login has permissions to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 11:17 pm
I can't find the document, but I have been told that when purchasing volume license agreement and MSDN.
If in doubt ask the licensing partner.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 9:12 pm
You need to know what servers are "Production"
Non production development servers don't need to be licensed. Thus knowing what servers are serving up production data and apps will help...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2010 at 8:11 pm
Viewing 15 posts - 14,161 through 14,175 (of 19,560 total)