Solved

Error 3355 and Error 3351 SharePoint Foundation

Posted on 2013-07-01
11
3,625 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
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39289749
0
 

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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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…

732 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