Solved

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

Posted on 2008-06-21
6
4,366 Views
Last Modified: 2013-11-21
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
0
Comment
Question by:bsharath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 21848597
0
 

Expert Comment

by:Atish78
ID: 21967647
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.
0
 

Expert Comment

by:DeoGracia
ID: 24902739
The link is dead
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

Expert Comment

by:DeoGracia
ID: 24903420
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 ?
0
 

Expert Comment

by:ITPULASKI
ID: 26382876
I am having the same exact problem.  Does anyone know how to fix this error?
0
 

Expert Comment

by:shivadev
ID: 39105595
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,,.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question