Error invalid Domain user name during installing sql 2008 r2 Power pivot feature

Question

hi, I am having Windows server 2008 SP2 and have installed SQL server 2008 r2 and also successfully install Sharepoint 2010 Enterprise RTM trial.

I have followed the instructions on the following link:

http://www.powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint

I have enabled mixed mode for sql authentication and have added the system Administrator there.

I have getting an error of "Invalid Domain user name" on the "New Sharepoint Farm configuration" form. I have tried system Administrator <MachineName/Administrator> as well as network Users (Active directory Users) but it gives the error every time

Am i missing something here ?

Answer 1

 

Hi Ovais,

You should use a domain account that has enough privileges to be the SharePoint Farm administrator. Did the network user you tried had such privileges?

 

Best,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 2

thanks for your response.

I have given dbcreator and owner roles to one of my domain credentials from sql management studio and i have successfully logged in remotely from that domain credentials. I have restarted the setup and it gives me the following error:

"The credentials you provided for the farm account are not valid. To continue, enter a valid user name and password."

if i have not given rights properly, can you you please help me out that how to gives previliges to a network user ?

Answer 3

Hello Ovais,

 

Just to be sure, you did not configured SharePoint in your server, did you? You should onlu have installed it, but not ran the Wizard.

Assuming you didn't run the Wizard, that is, you didn't configure the farm, the SQL Server PowerPivot for SharePoint "New Server" option will take care of configuring the farm for you. In order to do that, you need to provide a domain user to be the SharePoint Server account. This account should have administrative privileges on that server (you need to add it to the server admin group).

 

Did it help?

 

Best,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 4

thanks for your response.

as you have assumed, i haven't run the wizard.

From where i can give these privilages ? r u talking about SQL Server or Windows Server ?

Thanks..

Answer 5

 

Hi Ovais,

 

I'm talking Windows Server, not SQL Server. If that still doesn't work, could you send me the installation details.txt log under the SQL Server shared installation folder?

Best,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 6

Thanks for your response.

I have added domain user to Windows server 2008 Administrator group but it didn't worked out for me.

I have search the file in "C:\Program Files\Microsoft SQL Server\100\Shared" but haven't find any...

 

 

Answer 7

can i mapped domain user profile to some builtin admin profile in order to get through ?

Answer 8

 

 

It should be under

 

[SystemDrive]\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\[folder_based_on_date]\

If it has more than one foder under the Log folder, can you send me all of the details.txt log files? My email is mtn at microsoft.com.

 

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

Answer 9

 

Thanks for your reply.

i have found the folder, i will be mailing you a zip file having Log folder very shortly...

thanks again

Answer 10

thanks Mariano for your responses.

Actually, as i have figured it out, this error occurs if you are logged in from a system account no matter you provide the domain user account. I was logged in as a System administrator and giving the domain user credentials  but the setup is using my logged in credentials and therefore, the error keep coming until i logged in with the domain user credentials and then provide those credentials again...

if you still feel that i am missing something, please reply...

thanks again....