?
Solved

Error 3355 and Error 3351 SharePoint Foundation

Posted on 2013-07-01
11
Medium Priority
?
3,717 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 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