Guideline for Connectivity Question Posting

Question

In order to better assist troubleshooting connectivity related issue, the more specific the problem you describe, the faster we can help you out. Please take a few minutes to answer the following questions and post the answers as much as possible along with your specific repro steps. 

 

http://blogs.msdn.com/sql_protocols/ may already have your question answered. Check it out.

 

[1] Client side:

1. What is the connection string in you app or DSN? (please specify)
2. If client fails to connect, what is the client error messages? (please specify)
3. Is the client remote or local to the SQL server machine? [Remote | Local]
4. Can you ping your server? [YES | NO ]

In cmd.exe console, type “ping -a <server_name>”.

5. Can you telnet to your SQL Server? [YES | NO, please specify the error message ]

In cmd.exe console, type “telnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+’[‘ to bring up telnet prompt and type “quit” <enter>.

6. What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify).
7. Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
8. What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
9. Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. You can use cliconfg.exe (SS 2000) or SQL Server Configuration Manager (SS 2005) to configure the alias.
10. Do you select force encryption on server and/or client?

 

[2] Server side:

 

1. What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
2. What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
3. What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
4. Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
5. If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
6. What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
7. Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
8. Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance.[YES | NO | not applicable ]

[2a]  Tool Used to Connect

What tool or Application are you using to connect to SQL Server (eg: Visual Studio, SQL Server Management  Studio, SQLCmd.exe, OSQL, etc) and especially the version of SQL Server (Express, Workgroup, Standard, Enterprise, Developer)

 

[3] Platform:

1. What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
2. Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)].

 

[4] Misc:

1. If you have certificate configuration issue: Please use “certutil.exe –v –store my” to dump certificate specific info and post it in your question.

Tips:

1. Find SQL Server Errorlog: Default to C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\LOG

 

Last but not least:

There is a wealth of information already available to help you answer your questions.

 

(1) SQL Server 2005 Books Online: http://msdn2.microsoft.com

(2) Microsoft Support Knowledge Base:  http://support.microsoft.com

(3) SQL Protocol Team Blog: http://blogs.msdn.com/sql_protocols

(4) MSN Search: http://search.msn.com/ or use your favorite search engine.

 

Answer 1

thank u very much, its really helpful

Answer 2

5.- Can I telnet to the sql server? NO, the error on telnet says:

 

the connection to the host can't be opened on port 1433: Connection error

 

 

- Error on ODBC says:

 

 

Connection Failed:

SQLState: '08001'

SQLServer Error: 2

[Microsoft][SQL Server Native client 10.0]Named pipes provider: Could not open a connection to SQL Server [2]

Connection failed:

SQLState: 'HYT00'

SQLServer Error: 0

[Microsoft][SQL Server Native client 10.0]Login timeout expired

Connection failed:

SQLState: '08001'

SQLServer Error: 2

[Microsoft][SQL Server Native client 10.0]An error has ocurred while establishing a connection to the server. When connecting to SQL Server 2005 or above, this failure maybe caused by the fact that under the default settings SQL server does not allow remote connections

Answer 3

You can fix this by unblocking your port 1433 in your local machine.

you can do this by entering CONTROL PANEL--------------> FIREWALL

Answer 4

I have searched all over and I hope you can help me.  First and most important I am new to this type of programming, I am an old VB6 guy that has been away for 4 years and needless to say it has all changed.  I am not a beginner to programming but new to .net and so on.  I work with SQL for about 10 years and it is different now in some ways.

A friend of mine told me about all the free stuff, VB Express 2008, SQL 2005 Express and so on and I got hooked on programming again.  Now am just doing shareware stuff and having fun.

Anyway, here is my problem.  I created an app using VB 2008.  I used a DB I had in sql 2005 express.  Attached the DB to my project (then copied it to the project so it would be include in the publish) and everything is fine. Published the app using the tool included in VB. Burned a CD using Nero and installed it on my Dev machine, which is XP-Pro(SP2) and has SQL Express 2005. Ran like a dream, no problems at all.  Then I took the CD and did the install on my Vista laptop. THat is where the problem occured.  Got the error 26 can not connect to the server/istance because it doesn't allow remote connections.  This problem has been memtioned many times but not in the context I am talking about. I set the surface Area Config for local and remote with TCPIP only in SQL 2005 on the Dev machine and set the UDF 1434 to open(execption) in the fire wall on the vista laptop(hope that is the right one, I can't find the blog I read it on but I had it open when I made the changes I followed it exactly).  Can you tell me what else I need to do?

BTW I have not tried this on any other machines execpt the two memtioned above, if I do will I have problems with others also if they do not have SQL on the machine?  I think that I read in one of the help topics that the build includes a compact SQL server in the install when I publish.  Hope you can help me here as I have posted on the VB express forum and all I got was some smart A$$ telling there are programs out there to help but didn't tell me where or anything else but to not waste nary a something or a byte.  Real wiseguy.  Any help would be greatly appricated.

TIA,

Coz

Answer 5

Explains that clients may not be able to communicate to SQL Server through port 1433 or the port on which SQL Server is listening. ...

Answer 6

there is a social networkin website we're creating... the client is supposed to register to the website... the registration form contains aroud 20 fields n we 'the admin' are supposed to store this data in the database...

as the client fills the form n submit it...after a long time he gets an error as 'Request Time Out'...n even data doesnt get stored in d database....

if i use the same connection for a table containing less number of fields...its working fine.....

didnt get any help yet...

even tried to increase the response time...

hope u help me with this...

 

connection string in my app :

connprof.ConnectionString = "Data Source=P2-P4100;Initial Catalog=sns;Integrated Security=True";

 

database provider is ADO.NET 2.0

 

SQL version : MS SQL 2005 (express edition)

Application used to connect to SQL Server : Visual Studio

OS version : Windows XP

Answer 7

Nan tu,

 

Can you please help me on this.

 

I have a document with some information on the guidelines you 'asked' to check. i also have some print screens to be sure....but that i cannot post.

can i email you with my issues?

 

my name is soenita. i'm a student and i've been trying to create a datasource to my sql server but i'm having allot of problems.

 

PLEASE HELP ME WITH THIS.

I'm a beginner and do not know much about this. Please let me know if I can email you, then I can sent you my document with all the details and screen shots.

 

Thank you!!!

 

Regards,

Soenita

 

ps. my email is [e-mail]

Answer 8

Hi Nan Tu

 

I hope you can help me with my problem, because it's driving me crazy

 

I have upgraded my sql server 2000 Enterprise Edition to the 2005 Enterprise Edition.

In 2000 I had my cubes in analisis services but when I upgraded, I cannot access any more my cubes.

 

If I use the Microsoft Visual Studio, I can process and deploy my cube. But when I use Excell 2007 and try to access the analysis services, he says he has no access (all locally done from the server who is running Windows server 2003)

 

So, from the browser in Microsoft Visual Studio, I can see the data

But when I try to deploy the cube throw the menu Microsoft SQL server --- Analysis Services --- Deployment Wizard, I have the following error with exactly the same cube:

Error de OLE DB: Error de OLE DB u ODBC: Invalid authorization specification; 28000. Errores del motor relacional de alto nivel. No se pudo establecer una conexión al origen de datos con DataSourceID 'BD SBOBI', Nombre 'BD SBOBI'. Errores del motor...

 

I've been checking everywhere and I cannot understand why he has no access to that database while I can access it from Sql Server Intelligent Business Studio and Sql Server Management Studio

 

Thanks for any help you can give me

 

Answer 9

 I have sql connection related problem in dotnet application.
Some time this give following error message:

“A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)”

This is happened some time only. My application scenario is as follow:
I have window forms based application. I am using a two connections (in shared scope) and Two threads. First thread is the main application thread and other thread  which is started after application start. Second thread is also running continuously. To avoid the one connection sharing, i have created another shared connection (i.e. second connection with same connection string).
Our connection class structure looks like this.

Public Class MyConnection

    Private Shared ObjMyConnection As SqlConnection

    Private Shared ObjConn As MyConnection

    Private Shared ObjCommand As SqlCommand

    Public Shared Function GetInstance() As MyConnection
    If ObjMyConnection Is Nothing Then
        ObjMyConnection = New MyConnection
    End If
        Return ObjConn
    End Function

End Class

Get instance function is called if i want to perform any db operations.
both thread uses different class (but have the same type and scoped member)

I hope this is helpful to find the problem root.

Answer 10

Hi Experts,

Today I faced an strange problem with SQLSERVER 2005 and SQLSERVER 2008 R2 on same machine. Actually, I was trying to interconnect my other SQLSERVER's having identical structure and name on the other room within same network. So, I have done all procedure described in the beginning of this article. However, I can't figure out the solution to resolve this issue. 

Basically, If I tried to manipulate any objects from SQLSERVER GUI after connecting to the SQLSERVER database with authenticate username and password, I am getting the following error

" A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) "

Based on my previous experience, its seems like the ports are not listening each other and remote server is disabled but, I check that and those are enabled and seems fine in configuration side. 

Any suggestion will be highly appreciated to resolve this problem?

Thanks,

Prks

Answer 11

Hello,

Do  you know this link  ( go to the message 4 )?

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/22/sql-server-2005-connectivity-issue-troubleshoot-part-i.aspx

But i am fearing that your error message is not full . This kind of message is in 3 parts , you have done only the 1st and 2nd part .

I don't think that your problem is related to http://support.microsoft.com/kb/815915

Try also these links :

http://blogs.msdn.com/b/sql_protocols/archive/2006/07/26/678596.aspx

http://blogs.objectsharp.com/cs/blogs/max/archive/2009/02/26/no-process-is-on-the-other-end-of-pipe.aspx

For every connectivity problem, i would suggest you to have a look at the blog which is the reference :

http://blogs.msdn.com/b/sql_protocols/    ( as Nan Tu did in this thread )

It is rare to have to do a search in another place

Please, PRSK ,  don't post in this thread, Nan Tu has written this thread to give a very useful link ( the same as mine ) . I have given it a new time as it seems that very few people have enough time to read links or to do search in this blog.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.