SQL Server not exist or denide access

Dear friends my problem is this:
I have installed MSDE and when try to connect to it by this code:
Try

Dim conn As New SqlConnection("server=VSDOTNET;uid=sa;database=master")

conn.Open()

If (conn.State = ConnectionState.Open) Then

MessageBox.Show("Connection opened successfully")

End If

conn.Close()



Catch ex As SqlException

MessageBox.Show(ex.Message)

End Try

....an msgbox show this message:"SQL Server not Exist or Denide Access". Why
??

William
Sun Aug 17 15:27:49 CDT 2003

You don't have a password included in your connection
string....add in pwd='' if your SA password is blank, if
not, make sure you include it. BTW, and this is just my
two cents, if you have a SQL Server and a blank password,
you probably want to add a password unless you are 100%
positive that the machine can't be accessed by anyone you
don't want to access it. You may even want to kill SA
altogether or give it a 20+ character strong password and
don't use it. Instead use an account that you change
periodically that has the same permissions.

I think the PWD thing will work for you.

Let me know if this doesn't fix it.

Good Luck,

Bill

W.G. Ryan
dotnetguru@comcast.nospam.net
www.knowdotnet.com

>-----Original Message-----
>Dear friends my problem is this:
>I have installed MSDE and when try to connect to it by
this code:
>Try
>
>Dim conn As New SqlConnection
("server=VSDOTNET;uid=sa;database=master")
>
>conn.Open()
>
>If (conn.State = ConnectionState.Open) Then
>
>MessageBox.Show("Connection opened successfully")
>
>End If
>
>conn.Close()
>
>
>
>Catch ex As SqlException
>
>MessageBox.Show(ex.Message)
>
>End Try
>
>.....an msgbox show this message:"SQL Server not Exist
or Denide Access". Why
>??
>
>
>
>
>
>
>.
>