Greetings. I am brand new to SRS, so please bear with me. I'm trying to
create a Report Model in SRS 2005 against an Analysis Services 2005 cube. I
am an admin on the AS box. I am using this tutorial:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/8e5d2bd3-48ec-45f3-afee-6d86797c8f28.htm
I set up the data source, then I hit "generate model". I type in my model
name, hit "OK", and get the "Logon failed (rsLogonFailed)" message. I am
using "credentials supplied by the user running the report" dialog box with
the "Use as Windows..." checkbox checked. For good measure I have even added
myself to a cube Role with admin privelages. Alos, I can in fact browse and
manipulate the cube.
Any ideas?
TIA, ChrisRHi
I think the issue here is not the users priviliges in SSAS , rather
the priviliges in SSRS. Try using report manager to configure
permissions for the user in question .
Cheers
Shai
On Nov 20, 12:34 am, ChrisR <Chr...@.discussions.microsoft.com> wrote:
> Greetings. I am brand new to SRS, so please bear with me. I'm trying to
> create a Report Model in SRS 2005 against an Analysis Services 2005 cube. I
> am an admin on the AS box. I am using this tutorial:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/8e5d2bd3-48ec-45f3-afee--6d86797c8f28.htm
> I set up the data source, then I hit "generate model". I type in my model
> name, hit "OK", and get the "Logon failed (rsLogonFailed)" message. I am
> using "credentials supplied by the user running the report" dialog box with
> the "Use as Windows..." checkbox checked. For good measure I have even added
> myself to a cube Role with admin privelages. Alos, I can in fact browse and
> manipulate the cube.
> Any ideas?
> TIA, ChrisR
Showing posts with label brand. Show all posts
Showing posts with label brand. Show all posts
Saturday, February 25, 2012
Sunday, February 19, 2012
"inner SELECT"
Hi everybody!
I'm brand new to MS SQL Server,
Can you give me some examples of "Inner SELECT"?
Regards,
alias 939Nope.
Select
or
Inner join
No such thing as inner select.
It's covered well with examples in bol.
select a.col1, b.col2
from tbl1 a
inner join tbl2 b
on a.pk = b.fk|||SELECT will retireve your data from the DB. The effective format is "SELECT <What - Field Name or Names separated by comma> FROM <Which DB/Table> WHERE <Conditions for filtering results, such as particular field = something> ORDER BY <How you want it sorted when it;s output>"
On the other hand, JOIN is used when you need to work with data across two or more tables. The effective format is "SELECT <What> FROM <First DB/Table Name> JOIN <Second DB/Table Name> ON <Condition that links the first and second table together> WHERE <Condition for filtering the results> ORDER BY <Sorting order>
For example, I have one table called EMPLOYEES that holds ID, NAME, POSITION_ID and another table called POSITIONS that holds ID, POSITION_NAME. Now, the POSITION_ID in the EMPLOYEES table refers to the ID in the POSITIONS table. So, to get the list of all employee names and their positions, I would write:
SELECT NAME, POSITION_NAME
FROM EMPLOYEES
JOIN POSITIONS ON EMPLOYEES.POSITIONID = POSITIONS.ID
ORDER BY NAME, POSITION_NAME
Notice I have skipped WHERE altogether (WHERE and ORDER BY are optional. Ther are plenty more options, see help)
Also notice my SELECT statement contains field names from both tables - possible thanks to JOIN-ing them in the third row.
Note also that if field names repeat in the joined tables you need to clarify your reference. For example, I could have written the above as:
SELECT EMPLOYEES.NAME, POSITIONS.POSITION_NAME
FROM ...
Of course, this could be tedious, right? So what you can do is to assign alias to the tables / databases you deal with. In the above example:
SELECT E.NAME, P.POSITION_NAME
FROM EMPLOYEES E
JOIN POSITIONS P ON E.POSITIONID = P.ID
ORDER BY NAME, POSITION_NAME
Notice how I put EMPLOYEES E and POSITIONS P in the above command. Effectively I assigned "E" to be alias for EMPLOYEES and "P" to be alias for POSITIONS, and so in the futre I only need to refer to these tables via this alias.
Finally, to make the thing complete, you can have more than one type of JOIN - INNER JOIN, LEFT JOIN, RIGHT JOIN and OUTER JOIN. I'll let you browse through help for these.
Hope this helps.
Cheers,
V
Originally posted by thebitwriter
Hi everybody!
I'm brand new to MS SQL Server,
Can you give me some examples of "Inner SELECT"?
Regards,
alias 939
I'm brand new to MS SQL Server,
Can you give me some examples of "Inner SELECT"?
Regards,
alias 939Nope.
Select
or
Inner join
No such thing as inner select.
It's covered well with examples in bol.
select a.col1, b.col2
from tbl1 a
inner join tbl2 b
on a.pk = b.fk|||SELECT will retireve your data from the DB. The effective format is "SELECT <What - Field Name or Names separated by comma> FROM <Which DB/Table> WHERE <Conditions for filtering results, such as particular field = something> ORDER BY <How you want it sorted when it;s output>"
On the other hand, JOIN is used when you need to work with data across two or more tables. The effective format is "SELECT <What> FROM <First DB/Table Name> JOIN <Second DB/Table Name> ON <Condition that links the first and second table together> WHERE <Condition for filtering the results> ORDER BY <Sorting order>
For example, I have one table called EMPLOYEES that holds ID, NAME, POSITION_ID and another table called POSITIONS that holds ID, POSITION_NAME. Now, the POSITION_ID in the EMPLOYEES table refers to the ID in the POSITIONS table. So, to get the list of all employee names and their positions, I would write:
SELECT NAME, POSITION_NAME
FROM EMPLOYEES
JOIN POSITIONS ON EMPLOYEES.POSITIONID = POSITIONS.ID
ORDER BY NAME, POSITION_NAME
Notice I have skipped WHERE altogether (WHERE and ORDER BY are optional. Ther are plenty more options, see help)
Also notice my SELECT statement contains field names from both tables - possible thanks to JOIN-ing them in the third row.
Note also that if field names repeat in the joined tables you need to clarify your reference. For example, I could have written the above as:
SELECT EMPLOYEES.NAME, POSITIONS.POSITION_NAME
FROM ...
Of course, this could be tedious, right? So what you can do is to assign alias to the tables / databases you deal with. In the above example:
SELECT E.NAME, P.POSITION_NAME
FROM EMPLOYEES E
JOIN POSITIONS P ON E.POSITIONID = P.ID
ORDER BY NAME, POSITION_NAME
Notice how I put EMPLOYEES E and POSITIONS P in the above command. Effectively I assigned "E" to be alias for EMPLOYEES and "P" to be alias for POSITIONS, and so in the futre I only need to refer to these tables via this alias.
Finally, to make the thing complete, you can have more than one type of JOIN - INNER JOIN, LEFT JOIN, RIGHT JOIN and OUTER JOIN. I'll let you browse through help for these.
Hope this helps.
Cheers,
V
Originally posted by thebitwriter
Hi everybody!
I'm brand new to MS SQL Server,
Can you give me some examples of "Inner SELECT"?
Regards,
alias 939
"GUID should contain 32 digits" when saving brand new Maintenance
Someone help me please. I'm confused.
I've got a brand new Maintenance Plan which reorganizes indexes, clears out
the MP history and updates DB stats. It refused to save with a schedule of
once a week on Sunday at 1:00 a.m., but did save without a schedule (on
demand).
I have reopened the Maintenance Plan and tried to create a schedule. Every
time I try to close out and save (X on the upper right), it gives me the
Error: "GUID should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
information.
What is going on? Does anyone know? Help would be appreciatedd since we're
right on top of our official 2000-to-2005 server switch over.
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Check this link out, hopefully it should resolve your issue.
http://www.kbalertz.com/Feedback_922651.aspx
Bob
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||Just an FYI. I tried creating a new job that contained the above 3 steps and
the Notify Operator (set with a fail precendence from the other three tasks)
for another user db. I hit save, then the X up in the right hand corner and
got the following error message:
"Apply to target server failed for job 'MyJobName' "
I did get this error message on the other job and wonder if maybe there's a
connection between this and the GUID message?
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||No these issues are not related. The second issue you are seeing is probably
because you are using SQL Server Management studio to connect to a server
which is not local. If you terminal service to the machine itself and use sa
account to connect to it from there then you shouldn't see this issue. This
issue is somehow related to security but haven't found a solution yet.
Bob
"Catadmin" wrote:
> Just an FYI. I tried creating a new job that contained the above 3 steps and
> the Notify Operator (set with a fail precendence from the other three tasks)
> for another user db. I hit save, then the X up in the right hand corner and
> got the following error message:
> "Apply to target server failed for job 'MyJobName' "
> I did get this error message on the other job and wonder if maybe there's a
> connection between this and the GUID message?
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
I appreciate the link, but this has nothing to do with SSIS or an
importanted maintenance plan. I'm actually creating this plan from scratch
in the GUI of SSMS and getting this error.
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> Check this link out, hopefully it should resolve your issue.
> http://www.kbalertz.com/Feedback_922651.aspx
> Bob
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
You are correct. I am connected on my desktop with SSMS to a remote server.
So, you're saying I actually have to use a remote connection like VPN/Remote
Desktop to get onto the actual server and create the maintenance plan there?
That stinks. I hope they fix this soon as we only allow one TS connection
to the machine at a time and there are several of us doing different parts of
our upgrade project.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> No these issues are not related. The second issue you are seeing is probably
> because you are using SQL Server Management studio to connect to a server
> which is not local. If you terminal service to the machine itself and use sa
> account to connect to it from there then you shouldn't see this issue. This
> issue is somehow related to security but haven't found a solution yet.
> Bob
> "Catadmin" wrote:
> > Just an FYI. I tried creating a new job that contained the above 3 steps and
> > the Notify Operator (set with a fail precendence from the other three tasks)
> > for another user db. I hit save, then the X up in the right hand corner and
> > got the following error message:
> >
> > "Apply to target server failed for job 'MyJobName' "
> >
> > I did get this error message on the other job and wonder if maybe there's a
> > connection between this and the GUID message?
> >
> > Thanks,
> > Catadmin
> >
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "Catadmin" wrote:
> >
> > > Someone help me please. I'm confused.
> > >
> > > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > > the MP history and updates DB stats. It refused to save with a schedule of
> > > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > > demand).
> > >
> > > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > > time I try to close out and save (X on the upper right), it gives me the
> > > Error: "GUID should contain 32 digits with 4 dashes
> > > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > > information.
> > >
> > > What is going on? Does anyone know? Help would be appreciatedd since we're
> > > right on top of our official 2000-to-2005 server switch over.
> > >
> > > Thanks,
> > >
> > > Catadmin
> > > --
> > > MCDBA, MCSA
> > > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > > Microsoft pays the bills for the funny white jackets that tie in the back?
> > > @.=)
I've got a brand new Maintenance Plan which reorganizes indexes, clears out
the MP history and updates DB stats. It refused to save with a schedule of
once a week on Sunday at 1:00 a.m., but did save without a schedule (on
demand).
I have reopened the Maintenance Plan and tried to create a schedule. Every
time I try to close out and save (X on the upper right), it gives me the
Error: "GUID should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
information.
What is going on? Does anyone know? Help would be appreciatedd since we're
right on top of our official 2000-to-2005 server switch over.
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Check this link out, hopefully it should resolve your issue.
http://www.kbalertz.com/Feedback_922651.aspx
Bob
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||Just an FYI. I tried creating a new job that contained the above 3 steps and
the Notify Operator (set with a fail precendence from the other three tasks)
for another user db. I hit save, then the X up in the right hand corner and
got the following error message:
"Apply to target server failed for job 'MyJobName' "
I did get this error message on the other job and wonder if maybe there's a
connection between this and the GUID message?
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||No these issues are not related. The second issue you are seeing is probably
because you are using SQL Server Management studio to connect to a server
which is not local. If you terminal service to the machine itself and use sa
account to connect to it from there then you shouldn't see this issue. This
issue is somehow related to security but haven't found a solution yet.
Bob
"Catadmin" wrote:
> Just an FYI. I tried creating a new job that contained the above 3 steps and
> the Notify Operator (set with a fail precendence from the other three tasks)
> for another user db. I hit save, then the X up in the right hand corner and
> got the following error message:
> "Apply to target server failed for job 'MyJobName' "
> I did get this error message on the other job and wonder if maybe there's a
> connection between this and the GUID message?
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
I appreciate the link, but this has nothing to do with SSIS or an
importanted maintenance plan. I'm actually creating this plan from scratch
in the GUI of SSMS and getting this error.
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> Check this link out, hopefully it should resolve your issue.
> http://www.kbalertz.com/Feedback_922651.aspx
> Bob
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
You are correct. I am connected on my desktop with SSMS to a remote server.
So, you're saying I actually have to use a remote connection like VPN/Remote
Desktop to get onto the actual server and create the maintenance plan there?
That stinks. I hope they fix this soon as we only allow one TS connection
to the machine at a time and there are several of us doing different parts of
our upgrade project.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> No these issues are not related. The second issue you are seeing is probably
> because you are using SQL Server Management studio to connect to a server
> which is not local. If you terminal service to the machine itself and use sa
> account to connect to it from there then you shouldn't see this issue. This
> issue is somehow related to security but haven't found a solution yet.
> Bob
> "Catadmin" wrote:
> > Just an FYI. I tried creating a new job that contained the above 3 steps and
> > the Notify Operator (set with a fail precendence from the other three tasks)
> > for another user db. I hit save, then the X up in the right hand corner and
> > got the following error message:
> >
> > "Apply to target server failed for job 'MyJobName' "
> >
> > I did get this error message on the other job and wonder if maybe there's a
> > connection between this and the GUID message?
> >
> > Thanks,
> > Catadmin
> >
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "Catadmin" wrote:
> >
> > > Someone help me please. I'm confused.
> > >
> > > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > > the MP history and updates DB stats. It refused to save with a schedule of
> > > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > > demand).
> > >
> > > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > > time I try to close out and save (X on the upper right), it gives me the
> > > Error: "GUID should contain 32 digits with 4 dashes
> > > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > > information.
> > >
> > > What is going on? Does anyone know? Help would be appreciatedd since we're
> > > right on top of our official 2000-to-2005 server switch over.
> > >
> > > Thanks,
> > >
> > > Catadmin
> > > --
> > > MCDBA, MCSA
> > > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > > Microsoft pays the bills for the funny white jackets that tie in the back?
> > > @.=)
"GUID should contain 32 digits" when saving brand new Maintenance
Someone help me please. I'm confused.
I've got a brand new Maintenance Plan which reorganizes indexes, clears out
the MP history and updates DB stats. It refused to save with a schedule of
once a week on Sunday at 1:00 a.m., but did save without a schedule (on
demand).
I have reopened the Maintenance Plan and tried to create a schedule. Every
time I try to close out and save (X on the upper right), it gives me the
Error: "GUID should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
information.
What is going on? Does anyone know? Help would be appreciatedd since we're
right on top of our official 2000-to-2005 server switch over.
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Check this link out, hopefully it should resolve your issue.
http://www.kbalertz.com/Feedback_922651.aspx
Bob
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears ou
t
> the MP history and updates DB stats. It refused to save with a schedule o
f
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Ever
y
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we'
re
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
'
> @.=)|||Just an FYI. I tried creating a new job that contained the above 3 steps an
d
the Notify Operator (set with a fail precendence from the other three tasks)
for another user db. I hit save, then the X up in the right hand corner and
got the following error message:
"Apply to target server failed for job 'MyJobName' "
I did get this error message on the other job and wonder if maybe there's a
connection between this and the GUID message?
Thanks,
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears ou
t
> the MP history and updates DB stats. It refused to save with a schedule o
f
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Ever
y
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we'
re
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
'
> @.=)
I've got a brand new Maintenance Plan which reorganizes indexes, clears out
the MP history and updates DB stats. It refused to save with a schedule of
once a week on Sunday at 1:00 a.m., but did save without a schedule (on
demand).
I have reopened the Maintenance Plan and tried to create a schedule. Every
time I try to close out and save (X on the upper right), it gives me the
Error: "GUID should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
information.
What is going on? Does anyone know? Help would be appreciatedd since we're
right on top of our official 2000-to-2005 server switch over.
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Check this link out, hopefully it should resolve your issue.
http://www.kbalertz.com/Feedback_922651.aspx
Bob
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears ou
t
> the MP history and updates DB stats. It refused to save with a schedule o
f
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Ever
y
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we'
re
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
'
> @.=)|||Just an FYI. I tried creating a new job that contained the above 3 steps an
d
the Notify Operator (set with a fail precendence from the other three tasks)
for another user db. I hit save, then the X up in the right hand corner and
got the following error message:
"Apply to target server failed for job 'MyJobName' "
I did get this error message on the other job and wonder if maybe there's a
connection between this and the GUID message?
Thanks,
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears ou
t
> the MP history and updates DB stats. It refused to save with a schedule o
f
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Ever
y
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we'
re
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
'
> @.=)
Subscribe to:
Posts (Atom)
