MSDE Most Misterious of Egipt Pyramid.......

Dear friend, I'm using MSDE and VB.Net

My problem is that when try to connect at database message box say me: "SQL
server don't exist or denide access".

Now:

I have reistall Msdn but nothing is changed

I have manually change login autentication mode from Windows NT to SQL
(article 285097) but nothing is changed

I have try many string connection mode. This is the last:
Imports System.Data.SqlClient

.
.

Try

Dim conn As New SqlConnection("Server=Home/VSdotNET; Database=master; User
Id=sa; Password=;")

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

My question is:
How I can verify the correct installation and functionality of MSDE ( I have
WinXP)
How I can set Login and Password on MSDE so to be shure of their value?

Prosper
Mon Aug 18 21:03:29 CDT 2003

Hi,

1- check that an instance of msde is actually running on
your machine (u should see its icon on the task bar; by
the same occasion check its name, which 'd look like
[machine]\netsdk or [machine]\vsnet200x
if ok
2- modify the loginmode key of the sql server in the
registry : set value to 2 (mix mode NT and sql server
authentication).It means that from this moment u can use
your network acount/pwd as is to get access to your msde

3- you can now via vs.net or osql command line check that
you can access to your db server

osql: run osql in prompt command line
osql -? for help
osql -E -S (local)\netsdk
then you can create new login and pwd

exec sp_addlogin 'giusseppe', 'y_pwd'

Prosper M,
France.
>-----Original Message-----
>Dear friend, I'm using MSDE and VB.Net
>
>My problem is that when try to connect at database
message box say me: "SQL
>server don't exist or denide access".
>
>Now:
>
>I have reistall Msdn but nothing is changed
>
>I have manually change login autentication mode from
Windows NT to SQL
>(article 285097) but nothing is changed
>
>I have try many string connection mode. This is the last:
>Imports System.Data.SqlClient
>
>..
>..
>
>Try
>
>Dim conn As New SqlConnection("Server=Home/VSdotNET;
Database=master; User
>Id=sa; Password=;")
>
>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
>
>My question is:
>How I can verify the correct installation and
functionality of MSDE ( I have
>WinXP)
>How I can set Login and Password on MSDE so to be shure
of their value?
>
>
>
>
>
>.
>