[Swapnilbarde007]

I have a problem in connecting SQL Sever through VB.NET. When I create a connection it shows, " Connection failed. Server not found or change server to accept remote connections". Is there any setting to be changed when connecting to sqlserver. I am able to query my database through SQL server management studio but unable to connect my application to database.

[Swapnilbarde007]

Swapnilbarde007, on 24 September 2012 - 12:43 AM, said:

I have a problem in connecting SQL Sever through VB.NET. When I create a connection it shows, " Connection failed. Server not found or change server to accept remote connections". Is there any setting to be changed when connecting to sqlserver. I am able to query my database through SQL server management studio but unable to connect my application to database.

Please help

[lucky3]

Are you connecting to remote server, or local (on your computer)?

[Swapnilbarde007]

local one

[lucky3]

There are numerous ways to fail connecting. Paste code, and describe what you are doing, and how.

[Swapnilbarde007]

I have newly installed SQL Sever Express edition and SQL server management studio on my system. I have created a demo application in vb.net to test the SQL server connection. I have a form and a DataGridView dragged on it. I inserted following code on load event of form.

Imports System.Data
Imports System.Data.SqlClient

        Public  Class Form1

                Private Sub Form1_load(sender As Object, e As EventArgs)
                        Dim connetionString As String
                        Dim connection As SqlConnection
                        Dim command As SqlCommand
                        Dim adapter As New SqlDataAdapter()
                        Dim ds As New DataSet()
                        Dim sql As String

                        connetionString = "Data Source=SWAPNIL;Initial Catalog=MyTestDb;User ID=sa;Password="
                        sql = "SELECT * FROM tblTEST"

                        connection = New SqlConnection(connetionString)

                        Try
                                connection.Open()
                                command = New SqlCommand(sql, connection)
                                adapter.SelectCommand = command
                                adapter.Fill(ds)
              
                                connection.Close()

                                DataGridView1.DataSource=Ds.Tables(0)
                        Catch ex As Exception
                                MessageBox.Show("Can not open connection ! ")
                        End Try
                End Sub
        End Class
End Namespace

[lucky3]

Try using SqlConnectionStringBuilder class, so you can pinpoint what exactly isn't working.

[hemantwithu]

Swapnilbarde007, on 24 September 2012 - 05:07 PM, said:

I have newly installed SQL Sever Express edition and SQL server management studio on my system. I have created a demo application in vb.net to test the SQL server connection. I have a form and a DataGridView dragged on it. I inserted following code on load event of form.

Imports System.Data
Imports System.Data.SqlClient

        Public  Class Form1

                Private Sub Form1_load(sender As Object, e As EventArgs)
                        Dim connetionString As String
                        Dim connection As SqlConnection
                        Dim command As SqlCommand
                        Dim adapter As New SqlDataAdapter()
                        Dim ds As New DataSet()
                        Dim sql As String

                        connetionString = "Data Source=SWAPNIL;Initial Catalog=MyTestDb;User ID=sa;Password="
                        sql = "SELECT * FROM tblTEST"

                        connection = New SqlConnection(connetionString)

                        Try
                                connection.Open()
                                command = New SqlCommand(sql, connection)
                                adapter.SelectCommand = command
                                adapter.Fill(ds)
              
                                connection.Close()

                                DataGridView1.DataSource=Ds.Tables(0)
                        Catch ex As Exception
                                MessageBox.Show("Can not open connection ! ")
                        End Try
                End Sub
        End Class
End Namespace

I think you are missing some parameters in the Connection String.Please look at you are missing Password.If you want to get the Correct Connection String try to connect to your database in VS 2010 or 2008 using Server Explorer.After It is Connected Successfully right click on the DB in Server Explorer where you will find the Properties Click on it.You will get the Correct Connection String.

Try this and let me know :-)

[Swapnilbarde007]

When I am going to connect it through server explorer it is showing the same message. Server not found or make your server to accept remote connections" something like that. My server name is "SWPNIL". I am using SQL server authentication. its user name is 'sa' and password is blank. When I am connecting through server explorere, it is not showing the name of server in dialog box...

[lucky3]

Try adding ; in your connectionString after Password=, so it will look like: connetionString = "Data Source=SWAPNIL;Initial Catalog=MyTestDb;User ID=sa;Password=;"

Edit: is your server SWAPNIL or SWPNIL (notice the missing A)?

This post has been edited by lucky3: 24 September 2012 - 07:37 AM

[Swapnilbarde007]

Hi. my problem is same like this. It is unable to find the server not only in code but in server explorer window also. Ignore the code behind in image

Attached image(s)

• 

This post has been edited by Swapnilbarde007: 25 September 2012 - 04:06 AM

[CharlieMay]

You might want to take a look at some of these links. There are a few different scenerios that may cause this.

With it not working in Server Explorer, it could be the instance name is not matching in VS. Also, have you downloaded SQL Server Management Express Studio and installed it. If so, can you access it from there?

This post has been edited by CharlieMay: 25 September 2012 - 05:05 AM

[Swapnilbarde007]

yeah I have SQL server management studio installed on my pc. I am able to query that too from mgmnt studio. But when I am going to create new connection at design time, it shows the above error. In addtion to that I have XAMPP server installed on my PC. Does it affecting this?

[lucky3]

Quote

In addtion to that I have XAMPP server installed on my PC. Does it affecting this?

Sure can, and probably is. You need to find out on what port your IIS is running, and where XAMPP. In your browser enter localhost:80 and see what it will show. If it's xampp, than you have IIS on other port.

[Swapnilbarde007]

On 80 Port it is XAMPP, So what should I do now. Shall I uninstall XAMPP?