45,000 Jobs - Get an Interview Call,  Post Your Resume Here
SURESHKUMAR.NET FORUMS
Registered Member Login:
Not a member? Register today!



Welcome to the SURESHKUMAR.NET FORUMS.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.




Unable to Connect SQL Server 2005

        

Reply
 
LinkBack Thread Tools Display Modes
Old 19-08-09, 09:42 PM   #1 (permalink)
TAM
Senior Member
 
TAM's Avatar
 
Join Date: Oct 2006
Location: Mayiladurai (TN)
Posts: 243
Thanks: 8
Thanked 12 Times in 8 Posts
Rep Power: 7 TAM will become famous soon enough TAM will become famous soon enough
Unable to Connect SQL Server 2005

An Error has occurred while establishing a connection to the server. When Connecting to a SQL Server2005, this failure may be caused by the fact that under the default settings SQL server doesn’t allow remote connection (provider: Named Pipe Provider, error: 40- Could not open a connection to SQL Server)I want to connect to the SQL Server 2005 Express Edition which is running on my system from a VB.NET application. I am using Visual Basic 2008 Express Edition. Here is the Coding,
Dim sqlConn As SqlClient.SqlConnection
sqlConn = New SqlClient.SqlConnection("server=localhost" & "initial catalog=LIB")
Try
sqlConn.Open()
Catch ex As Exception
MsgBox(ex.Message)
End Try
On Execution, I got the Following Message as Exception,
“An Error has occurred while establishing a connection to the server. When Connecting to a SQL Server2005, this failure may be caused by the fact that under the default settings SQL server doesn’t allow remote connection (provider: Named Pipe Provider, error: 40- Could not open a connection to SQL Server)”

I have enabled remote connection for SQL Server 2005 for both TCP/piped connections using SQL Server Surface Area Configuration Tool and enable SQL Browser service too. I reinstalled the SQL Server 2005 but the problem still persisting. I have also added both SQLSERVER and SQLBROWSER exe files in the Firewall Exceptions list. Kindly help me to come out of this problem. Thanks in advance.

TAM is offline Offline   Reply With Quote
Reply

Tags
2005 , connect , server , sql , unable


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mega Free Download S/W Links A-Z yathish OTHERS 516 21-03-09 10:06 AM
(Exp : 5-10 yrs) Openings for Oracle 10g & SQL Server 2005 DBA at Nvidia Corporation jobs Experienced Jobs 0 04-10-08 04:12 PM
SQL Server 2005 Books Online (July 2006) vjsreevs ORACLE , SQL SERVER , SYBASE & Others 2 11-07-08 02:01 AM
Requirement for SQL DBA /SQL Database Administrator jobs Experienced Jobs 1 13-06-08 10:02 AM
difference between app server &web server Unregistered JAVA Technologies 3 06-09-06 12:06 PM


All times are GMT +6.5. The time now is 07:58 AM.

More Interview Questions Here...

Content Relevant URLs by vBSEO 3.3.0