can't add current login as user (more)

That's SQL Server 2000 (sorry!) and Windows (Server)
2000... it's almost like SQL isn't reading from or
synchronizing with Active Directory properly, but we can
find no other indicator that there is a problem.
Again, any help is greatly appreciated!

>--Original Message--
>Hi all. I'm having problems trying to add a current
login
>as a user to any databases. The logins are there, but
>when I try to give one access to another db, or even if I
>try to add user from within the db itself, I get error
>15401 (Windows NT user or group not found). I looked in
>KB but could only find this error in reference to adding
a
>new login. As stated, the logins are already setup and
>have been for about two years now, the system just won't
>let me add them as users.
>What really gets me is how SQL Server will let me use the
>necessary tool to pick the login from the list, but then
>it says it's not found. (?)
>Thanks in advance for any help!
>Sandy Mach
>.
>Check the article I just posted for you in the first message
on this (you can keep all these in the same thread...just
reply to the original to follow up and add additional info).
The only time I've run into something similar was with
accounts that were renamed.
-Sue
On Thu, 25 Mar 2004 11:32:05 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>That's SQL Server 2000 (sorry!) and Windows (Server)
>2000... it's almost like SQL isn't reading from or
>synchronizing with Active Directory properly, but we can
>find no other indicator that there is a problem.
>Again, any help is greatly appreciated!
>
>login
>a|||Right, and that's happened here before too, but we
reconciled those long ago. This is something new because
these accounts haven't been renamed since then, and I've
added them as users since then.

>--Original Message--
>Check the article I just posted for you in the first
message
>on this (you can keep all these in the same thread...just
>reply to the original to follow up and add additional
info).
>The only time I've run into something similar was with
>accounts that were renamed.
>-Sue
>On Thu, 25 Mar 2004 11:32:05 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
I
in
adding
won't
the
then
>.
>sql

can't add current login as user

Hi all. I'm having problems trying to add a current login
as a user to any databases. The logins are there, but
when I try to give one access to another db, or even if I
try to add user from within the db itself, I get error
15401 (Windows NT user or group not found). I looked in
KB but could only find this error in reference to adding a
new login. As stated, the logins are already setup and
have been for about two years now, the system just won't
let me add them as users.
What really gets me is how SQL Server will let me use the
necessary tool to pick the login from the list, but then
it says it's not found. (?)
Thanks in advance for any help!
Sandy MachCheck the following KB article:
HOW TO: Troubleshoot Error 15401
http://support.microsoft.com/?id=324321
-Sue
On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:

>Hi all. I'm having problems trying to add a current login
>as a user to any databases. The logins are there, but
>when I try to give one access to another db, or even if I
>try to add user from within the db itself, I get error
>15401 (Windows NT user or group not found). I looked in
>KB but could only find this error in reference to adding a
>new login. As stated, the logins are already setup and
>have been for about two years now, the system just won't
>let me add them as users.
>What really gets me is how SQL Server will let me use the
>necessary tool to pick the login from the list, but then
>it says it's not found. (?)
>Thanks in advance for any help!
>Sandy Mach|||As previously stated, I read that article before posting
here, and it refers only to adding new logins... these
LOGINs are already existing within SQL Server Security
Logins. SQL Server will not let me grant any of the
current logins access to any additional databases (will
NOT let me add current LOGIN as NEW USER), and the only
error I get is that 15401 which doesn't make sense in this
situation.
SQL Server lets me use the drop-down box showing current
logins to choose as new user, so it's finding them fine
there. It lets me go thru all the motions until it comes
time to save, then it says it can't find the user or group
(when IT let me find them thru its own nav tools!!).
Any other suggestions?

>--Original Message--
>Check the following KB article:
>HOW TO: Troubleshoot Error 15401
>http://support.microsoft.com/?id=324321
>-Sue
>On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
login
I
a
the
>.
>|||Hi, I'd the same error when I tried to add an user group (domain user group)
to new login (sql server).
What I did was instead of clicking on be "..." button (browse no Name), I ty
ped in manually "BUILTIN\Users" (assuming I want to add "Users" user group)
and click "OK". and guess what? It works for me.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.

Cant add ASPNET login to SQL Server

Here's the situation:

SQL Server is on one machine.
ASP.net is running on a different machine named THALES, which has the ASPNET account on it.
Both machines are on the same domain.

I am trying to add the THALES\ASPNET as a SQL Server login so that I can connect using Windows Authentication. When I try to add THALES\ASPNET, I get this message:
Error 15401: Windows NT user or group 'THALES\ASPNET' not found. Check the name again.

Any suggestions?You need to create an ASPNET user on the SQL Server machine, and give it the same password as the ASPNET user on the Web Server. By default, the password for the ASPNET user is autogenerated. You will need to change this in the Machin.Config so that it is a known password that you can then use for the ASPNET user on the SQL Server machine.|||Thank you, Douglas, that helped.

Cant add "ComputerName\ASPNET user

I see a lot of people have this same problem, but I still can't find a solution. I keep getting a "SqlException: Login failed for user 'domain\user name'Error when I try and access my SQL db from my web app. I've tried adding the ASPNET user to my db, but am unable to. Here are the steps I took:

SQL 2000 ent manager
-Windows NT
-Logins (right Click)
-New login
-Name <click>
but once I'm here, I can't find the ASPNET user name, and I am unable to create it here, or under the database users. Any help? It works fine on my local machine.

Do I need to install the .NET framework on my SQL server?

You don't need--exactly speaking you can not create a Windows account in SQL, what you can do is just adding existing Windows account to SQL logins. So just input myserver\ASPNETas login name while choosing Windows Authenticaiton. If you can't add myserver\ASPNET and get an error saying "Windows user or group can not be found...", then check the login failure error message from .NET. What's the login name in the error message? Is it myserver\ASPNET?If you're using IIS 6.0, the login name should be 'NT AUTHROITY\NETWORK SERVICE'

Can't access properties on Stored Procedures

Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.

I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.

Can anyone please tell me what I need to do so I can access the properties of the stored procedures?

Thanks

Your procedure was created with encryption option. Because this you can′t see the contents.

|||Its either an encryption problem (like already mentioned by the other poster) or you don′t have the appropiate permissions viewing the properties. Which access level does the account you are using have ? Is there a pas lock on the stored procedure symbol ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Cannot start up SQL 2000

I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?In EM, right-click on the server and then Edit Registration Properties.
Have it use Windows authentication.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eet8EBKhGHA.1612@.TK2MSFTNGP04.phx.gbl...
I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?

cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgs
Your post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs
|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:

> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>
>
|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...[vbcol=seagreen]
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:

> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
>
>

cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:

> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A
?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere T
O
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...[vbcol=seagreen]
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:

> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
>
>

cannot see the view

Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:
> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> > Hi ,
> >
> > I have created a login id on 2 different databases DB_A & DB_B as the
> > owner
> >
> > from crystal report i can see the view of DB_A but not DB_B using the
> > same
> > login id
> >
> > Could anyone kindly advise ?
> >
> > tks & rdgs
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>> Your post is not clear.
>> What is the default database for the login? Is Crystal connecting to
>> DB_A?
>> If so it will be able to see the view in that database. Unless you
>> "tell"
>> Crystal to look within DB_B for the view it will not be found.
>> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
>> TO
>> UserNameGoesHere
>> --
>> Keith
>>
>> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
>> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>> > Hi ,
>> >
>> > I have created a login id on 2 different databases DB_A & DB_B as the
>> > owner
>> >
>> > from crystal report i can see the view of DB_A but not DB_B using the
>> > same
>> > login id
>> >
>> > Could anyone kindly advise ?
>> >
>> > tks & rdgs
>>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:
> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> > Hi Keith ,
> >
> > the default db for the login is master. and i have set up 2 odbc
> > datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> > from crystal when connecting using DS_A it can show me the view but not
> > when
> > using DS_B
> >
> > i hope this time i am clearer in my explanation
> >
> > i'll try to use the grant select on the view for that login in DB_B
> >
> > tks & rdgs
> > "Keith Kratochvil" wrote:
> >
> >> Your post is not clear.
> >>
> >> What is the default database for the login? Is Crystal connecting to
> >> DB_A?
> >> If so it will be able to see the view in that database. Unless you
> >> "tell"
> >> Crystal to look within DB_B for the view it will not be found.
> >>
> >> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
> >> TO
> >> UserNameGoesHere
> >>
> >> --
> >> Keith
> >>
> >>
> >> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> >> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I have created a login id on 2 different databases DB_A & DB_B as the
> >> > owner
> >> >
> >> > from crystal report i can see the view of DB_A but not DB_B using the
> >> > same
> >> > login id
> >> >
> >> > Could anyone kindly advise ?
> >> >
> >> > tks & rdgs
> >>
> >>
> >>
>
>

Cannot see Login account properties

Hi everybody !!!

I have SQLServer 2005 installed and I think a login account is corrupted because Im not able to connect to a database. I get an Timeout expiration error after I clicked on Login Properties or when I try to make a connection to SQLServer 2005 using that login account. Also I cannot review the script needed to create the login, but I do can review the database user properties mapped to this login account.

Is there a way to recreate or repair a login account?

The only solution I have right now is create another login accout, but this involves to modify database connection properties within my code.

Any help, comment or suggestion is really appreciated.

Thans a lot.

I am guessing you are using Microsoft SQL Management Studio object browser to look at the properties, correct? It may be a problem in the tool, I would recommend asking about this one in the tools forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1).

To quickly verify if there is indeed something wrong with this particular login, you can try the following statement:

SELECT * FROM sys.server_principals WHERE name = 'login_name'

Go

You can also try the following statement to make sure the system is able to use this login as a valid principal:

EXECUTE AS LOGIN = 'login_name'

Let us know if you encountered any problem while running these statements.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

Cannot see Login account properties

Hi everybody !!!

I have SQLServer 2005 installed and I think a login account is corrupted because Im not able to connect to a database. I get an Timeout expiration error after I clicked on Login Properties or when I try to make a connection to SQLServer 2005 using that login account. Also I cannot review the script needed to create the login, but I do can review the database user properties mapped to this login account.

Is there a way to recreate or repair a login account?

The only solution I have right now is create another login accout, but this involves to modify database connection properties within my code.

Any help, comment or suggestion is really appreciated.

Thans a lot.

I forgot to say that I get the same Timeout expiration error when I try to drop the login account.

Thanks in advance.

Cannot save my Maintenance plan

I use sa to login to sql 2005. I can save Maintenance plan using wizard, however, when I try to save maintenance plan using the maintenance plan design screen. I received error message "Apply to target server failed for job ...". When I check the job, there is no step in the job.

In the Maintenance wizard, there is no maintenance clean up task. I want to create a task to delete my backup file if it is older than certain days.

Any suggestions are welcome. Thanks in advance.

Hi

Dont use the wizard.

You can use the cleanup maintenacne task to cleanup backups files older than x days.

Cheers

|||

Only the wizard let me save my maintenance plan. I cannot save my maintenance plan if I use the design screen.

There is no Maintenance clean up task in the wizard.

|||

What error do you get when you save from designer ?

Gops Dwarak

|||

Oh I missed to see the error message in your mail.

This is the difference in behavior i noticed when created though wizard and through Designer

When you create maintenance plan with a name of job that is already existing through wizard , maintenance plan gets created successfully with a step added to the existing job. Expected behavior should have been to throw valid error saying "Job with this name already exists". When similar scenario is tried from Designer then error is thrown mentioning "Create failed for job 'job name' ". I have opened a bug to be fixed for next release.

Can you check whether job with plan name exists before creating the plan through designer ?

Also, this issue looks like more of SQL Server Agent issue. Can you look at the agent log file(through log viewer) when you try to perform this operation and see what message is logged in there. That may help to narrow down the issue

|||

I checked my sql server log and agent log. Both had no error message recorded.

I noticed if there is job name existed, the Designer thrown error 'Create failed for job...'. I manually deleted the job and maintenance and created from fresh. I got error message 'Apply to target server failed for job 'job name''. Acturally the maintenance plan is saved and job is saved. However, there is no job steps in the job.

I don't think it is SQL agent issue since I have run the job yet. The error occurred at the save process. I guess maybe a security issue. I am using sa to login and sa is dbo of msdb. I can use the wizard to save with no problem.

Thanks for any suggestions.

|||Any suggestions? Thanks.|||

Hi renching

I am afraid i canoot help you much more.

My experience with the new maintenance plans are that they suck.

When i try upgrade 2000 plans to 2005 they just give me errors, i hate the wizard it is nowhere near as user friendly as easy as in 2000.

Basically all i can advise is to do what i did, redo all plans from scratch in 2005.

But you say you have to use the wizard so i cannot help you there cos the wizard cant do what i want it to do, so i avoid it.

As far as exisitng jobs are concerned , i know i had to use sp_delete_maintenance_plan and sp_delete_maintenance_plan_job to properly clear out exisitng jobs and plans.\

Good luck.

Thanx

|||

Thanks. I wish the error message gave more information. Our application is built on SQL 2005. We have no conversions. All jobs are new. I got a lot problem with SQL 2005.

Thanks anyway. I hope someone will help me out here.

|||My SSIS is installed, however, it is disabled. Will this cause the problem?|||Try logging to SQL Server Management Studio on the local server as 'sa' with a server name of '.', then create, schedule, and save the new maintenence plan.|||

renching wrote:

My SSIS is installed, however, it is disabled. Will this cause the problem?

We shouldn't have a dependency on the SSIS service. Try installing SQL Server 2005 Service Pack 2.

http://www.microsoft.com/sql/sp2.mspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Cannot save my Maintenance plan

I use sa to login to sql 2005. I can save Maintenance plan using wizard, however, when I try to save maintenance plan using the maintenance plan design screen. I received error message "Apply to target server failed for job ...". When I check the job, there is no step in the job.

In the Maintenance wizard, there is no maintenance clean up task. I want to create a task to delete my backup file if it is older than certain days.

Any suggestions are welcome. Thanks in advance.

Hi

Dont use the wizard.

You can use the cleanup maintenacne task to cleanup backups files older than x days.

Cheers

|||

Only the wizard let me save my maintenance plan. I cannot save my maintenance plan if I use the design screen.

There is no Maintenance clean up task in the wizard.

|||

What error do you get when you save from designer ?

Gops Dwarak

|||

Oh I missed to see the error message in your mail.

This is the difference in behavior i noticed when created though wizard and through Designer

When you create maintenance plan with a name of job that is already existing through wizard , maintenance plan gets created successfully with a step added to the existing job. Expected behavior should have been to throw valid error saying "Job with this name already exists". When similar scenario is tried from Designer then error is thrown mentioning "Create failed for job 'job name' ". I have opened a bug to be fixed for next release.

Can you check whether job with plan name exists before creating the plan through designer ?

Also, this issue looks like more of SQL Server Agent issue. Can you look at the agent log file(through log viewer) when you try to perform this operation and see what message is logged in there. That may help to narrow down the issue

|||

I checked my sql server log and agent log. Both had no error message recorded.

I noticed if there is job name existed, the Designer thrown error 'Create failed for job...'. I manually deleted the job and maintenance and created from fresh. I got error message 'Apply to target server failed for job 'job name''. Acturally the maintenance plan is saved and job is saved. However, there is no job steps in the job.

I don't think it is SQL agent issue since I have run the job yet. The error occurred at the save process. I guess maybe a security issue. I am using sa to login and sa is dbo of msdb. I can use the wizard to save with no problem.

Thanks for any suggestions.

|||Any suggestions? Thanks.|||

Hi renching

I am afraid i canoot help you much more.

My experience with the new maintenance plans are that they suck.

When i try upgrade 2000 plans to 2005 they just give me errors, i hate the wizard it is nowhere near as user friendly as easy as in 2000.

Basically all i can advise is to do what i did, redo all plans from scratch in 2005.

But you say you have to use the wizard so i cannot help you there cos the wizard cant do what i want it to do, so i avoid it.

As far as exisitng jobs are concerned , i know i had to use sp_delete_maintenance_plan and sp_delete_maintenance_plan_job to properly clear out exisitng jobs and plans.\

Good luck.

Thanx

|||

Thanks. I wish the error message gave more information. Our application is built on SQL 2005. We have no conversions. All jobs are new. I got a lot problem with SQL 2005.

Thanks anyway. I hope someone will help me out here.

|||My SSIS is installed, however, it is disabled. Will this cause the problem?|||Try logging to SQL Server Management Studio on the local server as 'sa' with a server name of '.', then create, schedule, and save the new maintenence plan.|||

renching wrote:

My SSIS is installed, however, it is disabled. Will this cause the problem?

We shouldn't have a dependency on the SSIS service. Try installing SQL Server 2005 Service Pack 2.

http://www.microsoft.com/sql/sp2.mspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Cannot save Maintenance plan

I use sa to login to sql 2005. I can save Maintenance plan using wizard. However, when I try to save maintenance plan using the maintenance plan design screen, I received error message "Apply to target server failed for job ...". When I check the job, there is no step in the job.

In the Maintenance wizard, there is no maintenance clean up task. I want to create a task to delete my backup file if it is older than certain days.

Any suggestions are welcome. Thanks in advance.

have you considered using the script task?|||

Although Maintenance Plans are built on the SSIS infrastrcucture, they do have some aspects that we do not cover. Best to start in the SQL Server Tools forum. I'll move this thread for now.

Thanks

Donald

Cannot run SQLServerAgent jobs after changing SA password

I am new to SQL Server 2000. When I set a password for SA all the SQLServerAgent jobs fail with a login error and will not start. I have tried to change the SQLAgent service login via the Control Panel/Services, but it will not accept SA as a valid login, when I browse logins, only the NT logins seem to appear. The jobs are owned by my normal login and not by SA.

This is probably a simple change, but I am going round in circles trying to locate the 'how to' documentation.SQLServerAgent service needs to run under a Windows account...|||Check your SQL Server connection settings in SQL Server Agent properties (Windows Auth. or SQL server Auth.).|||Thanks. I did not see the SQL agent connection properties with a login and password. All is now well.