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

[Giuseppe Pezzella]

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 Mendo]

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.