Home > Connect To > Sharepoint 2010 Cannot Connect To Sql

Sharepoint 2010 Cannot Connect To Sql


If it answered your question, remember to "Mark as Answer". - Gokan Ozcifci - SharePoint Infrastructure Consultant Proposed as answer by That.Guy Thursday, August 21, 2014 8:52 AM Tuesday, October 25, Friday, February 07, 2014 3:03 AM Reply | Quote 0 Sign in to vote Thanks for this. asked 3 years ago viewed 3220 times active 3 years ago Related 1Error During Configuration Wizard on SharePoint 20100Error Running SharePoint 2010 Product Configuration Wizard2Error running SharePoint 2010 Product Configuration Wizard In your scenario I gues your setup account is administrator (that's the reason he was in the event log) and it needs these permissions on sql. this content

Created Virtual Machines For this exercise, I'm using Hyper-V to host virtual machines. Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? Two days head banging to table. This brings me to the error I am facing when running Sharepoint 2010 products configuration wizard and trying to use existing farm : Cannot connect to database master at SQL server https://technet.microsoft.com/en-us/library/ee513066(v=office.14).aspx

Event Id 3355 Sharepoint 2013

The administrative account cannot make any changes to the logins or databases even though it is a member of the WSS_ADMIN_WPG group. accessing the server locally is not a problem. On the SQL Server computer, I opened Windows Firewall with Advanced Services and added an inbound rule to allow traffic over port 1433. Go to SQL Server Network Configuration. 2.

Other connectivity check between your servers If your telnet does not even reach the SQL server and there is nothing in the logfile maybe you have connectivity issues between your machines. more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Reply Roger says: April 5, 2013 at 18:33 Ok, I totally get it now, I assumed that I needed to setup the sharepoint farm user in the database myself granting all Sharepoint 2013 New-spconfigurationdatabase Cannot Connect To Database Master At Sql Server Double-click Security.

In the Select an account for this component drop-down list, click the domain account that you want to associate with this Web application pool, or click Register new managed account to But this was not the hole truth... I would appreciate it. Took me a day and a half to figure this out through multiple threads/blogs/etc...

You may see this error: Cannot connect to database master at SQL Server at . Sharepoint 2013 Configuration Wizard Failed To Connect To The Configuration Database Recently I've been working on getting my test environment set up with SharePoint Server 2010 for the first time. A bit of history before I give details on the error. If you do not use the default port, create an inbound rule for the port you use in your environment.

When I went back to run the SharePoint Products Configuration

Cannot Connect To Database Master At Sql Server Sharepoint 2013

share|improve this answer answered Oct 30 '08 at 7:30 Anders R add a comment| up vote 0 down vote I had that problem with sharepoint I used this to fix the http://sharepoint-community.net/profiles/blogs/cannot-connect-to-database-master-at-sql-the-database-might-not During the untap step, can I copy a vehicle with Felhide Spiritbinder's Inspired trigger? Event Id 3355 Sharepoint 2013 Start a coup online without the government intervening Mimsy were the Borogoves - why is "mimsy" an adjective? Event Id 3355 Sharepoint 2010 Timeout Expired I went back to the SQL Server computer and verified that my SharePoint administrator account had the correct server roles assigned, and that the master database existed.

Make sure you know how your application servers are connecting to your SQL server You can either put in the database name as it is in your SQL server or you news First thing, when you installed SP2010 and SQL2008R2, you have to you the same DOMAINADMIN, then log on SQL2008R and give the DOMAINADMIN rights as SYSADMIN. My SQL alias points to server sql01 on port 1433 so I can use "sql5" in configuration wizard to set up a connection SQL alias has the advantage to change SQL If you don’t know how to do, try the following: Firewall,  UAC, .. Cannot Connect To Database Master At Sql Server Sharepoint 2016

Double click on TCP/IP and go to the 'IP Addresses' tab. 5. Or, run the setup as an administrator. Changed back to the right account and the WSS started to work, but with an error (Application / error or something) This new problem was something I just got for free have a peek at these guys I need assistance to set SharePoint on my Nokia E7, using the latest Microsoft Applications 2.0 for Nokia phones.

Proposed as answer by spy590 Thursday, May 23, 2013 7:23 PM Wednesday, June 20, 2012 1:44 PM Reply | Quote 0 Sign in to vote The dynamic port was my issue Sharepoint 2013 Event Id 3355 Cannot Connect To Sql Server Under the Permit column, click to select the Windows SharePoint Services database. Browse other questions tagged sql-server iis windows-server-2003 or ask your own question.

domain administrator ) we don't get this problem.

Firewall inbound rule set for port! If not, you got the same error message, allthough they are properly configured all aspects as detailed here. share|improve this answer answered May 8 '13 at 10:40 hupseb 739315 I was hoping to avoid reinstallation of Sharepoint. –Sameen Ali May 8 '13 at 10:48 Well... Sharepoint 2016 Cannot Connect To Database Master This might be useful for others looking for a solution.

After some trial and error, I remembered an issue I'd had with another product where the Windows Firewall on the SQL Server computer was blocking traffic to the port that the share|improve this answer answered May 8 '13 at 10:46 Zakir HC 2,24921742 Firewall is not on. If the account is not listed, click Add. http://stevemattley.com/connect-to/sharepoint-2007-configuration-wizard-cannot-connect-to-database.html Reply gtrmurthi says: August 1, 2012 at 10:52 am Go to SQL Server and run SQL Server Configuration Manager Doube click SQL Server Network Configuration Click on Protocols for {you SQL

Batty: You could by trying to connect to the db server via the wrong port. I was still unable to view the SharePoint site, so I did a restore of the SharePoint database. There is already a very detailed and helpful blog is available for you to follow to start troubleshooting: http://blogs.technet.com/b/tothesharepoint/archive/2011/01/12/troubleshooting-sharepoint-configuration-error-cannot-connect-to-database-master-at-server-name.aspx The possible causes of that error are as follows, first 2 are Additional error information from SQL Server is included below.

And both servers have the firewall disabled.