hi:

as u said in the query anylazer is used the sql server = (local) and used windows authentication to retrieve the database.i could see all the all the databse in the sql server, i.e Northwind, master etc.i tried ti use vb.net coding to connect to this sql server.but it says login failed or unknown server.i have enclosed the code i used to connect to this server.could you please let me know where the mistake could be.

Imports System.Data.SqlClient

Public Class Form1
Inherits System.Windows.Forms.Form
Private Sub connectsql()
Dim cnNwind As New SqlConnection()
Dim strserver, strDB, strUsername, strpwd As String

strserver = "(local)"
strDB = "Northwind"
strUsername = "cdburn"
strpwd = "cd"

Try
cnNwind.ConnectionString = "server=" & _
strserver & ";database=" & _
strDB & ";" & _
"Username=" & strUsername & ";Password=" & _
strpwd & ";Connection Timeout = 15;"

cnNwind.Open()
MessageBox.Show("connected successfully.")
Catch exc As Exception
MessageBox.Show(exc.Message.ToString())
Finally
cnNwind.Close()
MessageBox.Show("Disconnected successfully")
End Try
End Sub


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
connectsql()
End Sub
End Class