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:
- What is the connection string in you app or DSN (please specify)
- If client fails to connect, what is the client error messages (please specify)
- Is the client remote or local to the SQL server machine [Remote | Local]
- Can you ping your server [YES | NO ]
In cmd.exe console, type “ping -a <server_name>”.
- 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>.
- 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).
- Is your client computer in the same domain as the Server computer (Same domain | Different domains | WorkGroup)
- What protocol the client enabled [Shared Memory | TCPIP | Named Pipes].
- 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.
- Do you select force encryption on server and/or client
[2] Server side:
- What is the MS SQL version [ SQL Server 2005 | SQL Sever 2005 ]
- What is the SKU of MS SQL [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
- 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.
- Does the server start successfully [YES | NO] If not what is the error messages in the SQL server ERRORLOG
- If SQL Server is a named instance, is the SQL browser enabled [YES | NO]
- What is the account that the SQL Server is running under [Local System | Network Service | Domain Account]
- Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider [YES | NO | not applicable]
- 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:
- What is the OS version [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
- Do you have third party antivirus, anti-spareware software installed [Symantec | Norton | other (please specify)].
[4] Misc:
- 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.
Guideline for Connectivity Question Posting
Claudio Livio
you can do this by entering CONTROL PANEL--------------> FIREWALL
N Camp
mvang
Iron Architect
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:
John Chef
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