General discussion


Problem in saving maint plan SQL Server 2K5 & changing Windows SBS 2K3 PWD

By shridhar.naik.ind ·
We are having Windows Small Business Server 2003 R2 SP2 operating system & SQL Server 2005 Workgroup edition With SP2.

I have two problems which are as follows :

1) We have some maintenance plans for backing up our company's database. When I try to modify any plan following error appears e.g. :"Error loading 'MPLAN930 - sa' : One or more arguments are Invalid ."

Similarly if I try to create a new maintenence plan on saving the plan error "One or more arguments are Invalid" appears.

2) We had set password authentcation in SQL server 2005 to 'Windows Authentication Mode'. Now if I change password of user 'Administrator' & reboot the server, the SQL Server services fails to start. If I change the password again to the old one & reboot the server the SQL Server Service starts. Now I have changed Authentication Mode to SQL Server & Windows Authentication Mode (Mixed Mode) but unable to change Administrator Password.

For Security Purpose, I have to change my Administrator Password.

Please help me on above issues ASAP. I am trying to find some solution at me own since last 15 days but failed to have one.

Please Help me...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Two problems

by Tony Hopkinson In reply to Problem in saving maint p ...

There are specific accounts created to run sqlserver services if you do not want to use localsystem. You should not be using Admin.

The maintenance plan. Did you upgrade the DB from SQL Server 2000, if so check the server's compatibility mode. The last step is to switch it to 90, If it's on 80, all sorts of funnies with the newer system SPs can happen
Of course if you have your own SPs you need to make sure they are 2005 compatible.


Collapse -

Two Problems

by shridhar.naik.ind In reply to Two problems

Yes we have upgraded from SQL Server2000. can you plase explain how to check server's compatibility mode ?

We have database on the same machine we are having Windows SBS 2K3. I am not getting what do you mean by localsystem. How can I cahnge my Windows Administrator 's password so that my SQL Server also gets started, if I reboot the system ?

Please Help....

Collapse -

Tony is referring to the NT Service Account

by CG IT In reply to Two Problems

which run services. if you check in services you'll find SQL and it's associated dependencies. You can change what account is used to run the service. You should never use the administrator's account to run any services and/or on SQL use it or use the built in NT account [though I've use NT on SQL myself. ]

here's a link to MS Technet after reading it there are other links at the bottom which will take you to best practices which covers SQL 2005 security.

Related Discussions

Related Forums