Video Screencast Help

SEPM 12 Upgrade, SQL credential problem

Created: 06 Jul 2011 • Updated: 06 Jul 2011 | 4 comments
This issue has been solved. See solution.

I try to upgrade SEPM from version 11.0.6300.803  to 12.1

sepm is on one server and sql on another server

I follow the recomended steps but when I come to SQL Authentication it does not accept the login credentials

" Your SQL Server login credentials could not be validated. Please re-enter your sql server login information"

I have also run the "management server configurating wizard" to be sure that I have the right sql creddentials.

So in sepm 11 its ok with the connection to the sql server.

Comments 4 CommentsJump to latest comment

Paul Murgatroyd's picture

Hi cosp,

The installer needs either the SA account or an account with sysadmin priveleges as it needs to create maintenance plans and reconfigure the database - the SEM5 user account doesn't have those rights.

Are you giving the installer the right account?

Paul Murgatroyd
Principal Product Manager, Symantec Endpoint Protection
Endpoint twitter feed: http://twitter.com/symc_endpoint

SOLUTION
cosp's picture

Thanks

Now its working :-)

Is it ok to change back sem5 to not have sysadmin privilieges or ?

Paul Murgatroyd's picture

you should only need the SA account for install, it shouldn't change the default account that is used day to day.

Paul Murgatroyd
Principal Product Manager, Symantec Endpoint Protection
Endpoint twitter feed: http://twitter.com/symc_endpoint

pete_4u2002's picture

open the SQL mgmt. studio with the SA account and password, if successful use that account for migration purpose.