Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance targeted for site database installation or the SQL Server inst

Hi,

I get the below error. When  u run the preequesit in SCCM.

Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance targeted for site database installation or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue.

What could the problem be.?

Regards
Sharath
ASKER CERTIFIED SOLUTION
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Atish78
Atish78

I have the same problem but my setup is slightly different i guess. I have 2 servers A and B. A is installed with sql 2005 and on B i am trying to install SCCM 2007. Thre pre requisites pass everything except sql server sysadmin rights.

On both servers i log on as the domain admin account. On sql server i am able to perform permissions and other modification using WINDOWS authentication system.

I would like to know how i can add server B account to the sql server and grant it sysadmin permissions. but i keep getttng the following error:
Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance targeted for site database installation or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue.
The link is dead
I have the same problem.
All the sql server and the SCCM are on the same vmware server running win 2K3 R2 entreprise.

But when I tried a telnet on  port 1433 but  no response.
I did a netstat and nothing is listening on port 1433.

TCP/IP is enabled.
But when I open the properties for all my IP adresses "enabled" was set to "no".

restart of all services :
telnet is OK
but le prereq is always  wrong.
any Idea ?
I am having the same exact problem.  Does anyone know how to fix this error?
I have installed SQL on the DC while running the pre -requisite for SCCM it give error
''Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance targeted for site database installation or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue'' . Please suggest,,.