Solved

MSSQLServer 2005

Posted on 2011-02-17
2
1,384 Views
Last Modified: 2012-05-11
Client received this error when trying to contact the server do you know what could be the problem:
Ett nätverksrelaterat eller instansspecifikt fel uppstod när en anslutning skulle upprättas till SQL Server. Servern hittades inte eller var inte tillgänglig. Kontrollera att instansnamnet är korrekt och att SQL Server är konfigurerad till att tillåta fjärranslutningar. (provider: Namngivna rör-provider, error: 40 - Det gick inte att öppna en anslutning till SQL Server)
Mandator Client Layer Exception
1 SqlException: Ett nätverksrelaterat eller instansspecifikt fel uppstod när en anslutning skulle upprättas till SQL Server. Servern hittades inte eller var inte tillgänglig. Kontrollera att instansnamnet är korrekt och att SQL Server är konfigurerad till att tillåta fjärranslutningar. (provider: Namngivna rör-provider, error: 40 - Det gick inte att öppna en anslutning till SQL Server)
   vid System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   vid System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   vid System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   vid System.Data.SqlClient.SqlConnection.Open()
   vid Mandator.Cenit.Services.ServiceHandlerBase.get_Connection()
   vid Mandator.Cenit.Services.ServiceHandlerBase.LookupValue(String field, String domain, String where, SqlParameter[] bindVariables)
   vid Mandator.Cenit.Services.ServiceHandlerBase.GetSetting[T](String name, T defaultValue)
0
Comment
Question by:vera2006
2 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 34915097
Well, the message says that it cannot find the Sql server, which suggests one of a few possibilities.

1) The server/database name in the connection string is incorrect
2) The SQL Server box is blocking incoming traffic on the port for SQL Server (1433 by default)
3) The client machine firewall/anti-virus is blocking the outgoing traffic
4) SQL is not configured for remote connections (although this is unlikely unless you are running SQL Express)
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 34915303
please confirm the language?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

713 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