Setup failed to connect to SQL database
Hello all,
I'm getting this error while trying to install MS SharePoint Server 2010.
Actually, i'm not very sure on what to put on SQL setup asked. Maybe you can help with some pictured errors as below:
This is what I put on the setup config:
and this is my SQL console:
http://i.imgur.com/VQgTv.jpg
I'm trying to install SharePoint on server SXC05
While SQL server (MS SQL Server 2008 R2) is installed in server SXC02
Both servers are using Windows Server 2008 R2.
Appreciate your help and advice.
Thanks!---Packie
June 29th, 2012 12:55am
Hi Packie
You need make sure your user have full permission to create database. Please try to give it "dbcreator" permission or above. Here is a screenshot link about it:
http://sdrv.ms/QZ2tW4
Thanks,
Lhan Han
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2012 10:39pm
Hi,
Also while executing configuration wizard right click on the wizard and select run as administrator.Thanks, Rahul Rashu
July 2nd, 2012 11:08pm
Apart from above recommendations, you may check if your firewall on SXC02 is enabled or not.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2012 5:31am
Hi,
Give "DBCrreator" and "SecurityAdmin" permissions to the account.Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights
July 4th, 2012 3:22am
^Thanks. I've disabled firewall and able to proceed to the next screen.
Now i'm thinking to apply port exception on my server than to disable the firewall off forever.
Thank you again :)---Packie
Free Windows Admin Tool Kit Click here and download it now
July 5th, 2012 10:14am