Solved

Error 3355 and Error 3351 SharePoint Foundation

Posted on 2013-07-01
11
3,668 Views
Last Modified: 2013-07-09
Hello,

I have a recurrent problem from more month. We have always the same message on SharePoint Servers

Event 3355 SharePoint Foundation - Critical

Cannot connect to SQL Server. "Name Alias DSN" not found. Additional error information from SQL Server is included below.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Event 3351 SharePoint Foundation - Critical


SQL database login for "Name Database Farm configuration" on instance 'PName Alias DSN' failed. Additional error information from SQL Server is included below.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

And in fact, we can have often error message on Webapplication "RunTime Error". We have to recycle application pool and warmup site and situation come back ok..

We had runned an action plan with Disable TCPChymney but not effect positive.

Have you an idea ?
0
Comment
Question by:evinazza
[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
  • 8
  • 2
11 Comments
 

Author Comment

by:evinazza
ID: 39289774
Hello,

I'm sorry but I have already readed all this post on the Web. All vérifications are already done but the problem persist.

We suppose that maybe an erreur when

Start/Stop Service
or
Backup period

But we don't know exactly.

Another idea ?
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39289788
On the services what account you using to logon with?

Make sure that account has sql permissions
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:VirastaR
ID: 39289839
Hi,

Had you tried this ??

1) Set up the DNS Alias.
2) Determine what ports are going to be used for each SQL Server instance. Registered Ports are those from 1024 through 49151 and Dynamic and/or Private Ports are those from 49152 through 65535. The registered ports number ranges should not be used for named SQL Server instances as a future conflict is possible. Reference http://www.iana.org/assignments/port-numbers
3) Reserve the port numbers so that no other program requests a dynamic port assigned to your SQL server. "How to reserve a range of ephemeral ports on a computer that is running Windows Server 2003 or Windows 2000 Server" http://support.microsoft.com/kb/812873/
4) "Configuring SQL Server Named instances to use a fixed port" http://technet.microsoft.com/en-us/library/ms345327(SQL.90).aspx. This will require a SQL Server restart.
5) Map the DNS aliases to the SQL Server instance name using the SQL Server 2005/2008 Configuration Manager but with SQL Server 2000, use the SQL Server Network Utility. This utility can only be run on the server hosting the SQL Server.

Source - http://www.sqlservercentral.com/Forums/Topic748728-146-1.aspx

Also run the Sharepoint 2010 Best Practise Analyzer and run a Health Check
http://social.technet.microsoft.com/Forums/en-US/c059e250-bd4a-42fc-b3f5-ebf90f450bc4/microsoft-best-practices-analyzer-for-windows-sharepoint-2010

Hope that helps :)
0
 

Author Comment

by:evinazza
ID: 39289864
Hi

I have already verify SQL Permissions for Account Service. All is ok. :-(

We have disabled TCP Chymney et TCP OffLoad
We have configure no dynamic port on DSN client (We have two SQL Servers) by cliclonfg

So

Alias DNS is ok for both SQL Servers
DNS Alias is created too for both SQL Servers
Dynamic port is disabled on all CliConfg configuration client (Web Server, App Server etc..)
1433 is the port used for Each Instance by default on SQL Servers

Finaly I going to try

3) Reserve the port numbers so that no other program requests a dynamic port assigned to your SQL server. "How to reserve a range of ephemeral ports on a computer that is running Windows Server 2003 or Windows 2000 Server" http://support.microsoft.com/kb/812873/
4) "Configuring SQL Server Named instances to use a fixed port" http://technet.microsoft.com/en-us/library/ms345327(SQL.90).aspx. This will require a SQL Server restart.

But I have question :

For Point 3 : I have to do it on wich servers ? SQL Servers or SharePoint Servers
For Point 4 : I going to test it But it's prerequisite Microsoft for SharePoint 2010 ?

Thanks for your help

Emmanuel
0
 

Author Comment

by:evinazza
ID: 39289925
Hi

just a precision

Point 4 : It is this configuration .We have already done it.

So, Reserved port on Registry is only for SQL or both SQL and SharePoint ?

Thanks
0
 

Author Comment

by:evinazza
ID: 39290026
Hi

This is a screen of Event.

Thanks for your help
Error.png
0
 

Author Comment

by:evinazza
ID: 39292418
Hi

1) Set up the DNS Alias. => It's done

2) Determine what ports are going to be used for each SQL Server instance. Registered Ports are those from 1024 through 49151 and Dynamic and/or Private Ports are those from 49152 through 65535. The registered ports number ranges should not be used for named SQL Server instances as a future conflict is possible. Reference http://www.iana.org/assignments/port-numbers
=> it's done

3) Reserve the port numbers so that no other program requests a dynamic port assigned to your SQL server. "How to reserve a range of ephemeral ports on a computer that is running Windows Server 2003 or Windows 2000 Server" http://support.microsoft.com/kb/812873/

=>it's done only for SQL Servers.

4) "Configuring SQL Server Named instances to use a fixed port" http://technet.microsoft.com/en-us/library/ms345327(SQL.90).aspx. This will require a SQL Server restart. =>it's done

5) Map the DNS aliases to the SQL Server instance name using the SQL Server 2005/2008 Configuration Manager but with SQL Server 2000, use the SQL Server Network Utility. This utility can only be run on the server hosting the SQL Server. =>it's done

So my last question and attempt..is "Point 3 : I have to do it on wich servers ? SQL Servers or SharePoint Servers" ?

I'm very tired and it's pending for a long time ago :-(....Thanks for your help

See you
0
 

Author Comment

by:evinazza
ID: 39292588
Hi

I forget to tell a important thing :

I have SharePoint Servers on VMware and SQL Servers are physical servers. It's might be a error on TCP couche VMWare ?

Error come when processor is high level more 98%...

So ? An idea?
0
 

Accepted Solution

by:
evinazza earned 0 total points
ID: 39300852
Hello

I Find ! In fact, problem occur only when servers are in full 100% process. And it's always between some period in day.

VMWare drop network paquet when VM is at 100% of CPU and also we have an TimeOut on database.

Thanks for help
0
 

Author Closing Comment

by:evinazza
ID: 39309802
Because I have find alone :-)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

717 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