SQL Desktop Data Engine (MSDE) and VB.NET Access from Clients.

[Manuel Canas]

Hi There,

I'm kind of new to this new technology.

I have an application on my development machine, I have the SQL desktop Data
Engine (MSDE) Installed on my development machine as well. Now When I
install Data Application on other machines that are on the same LAN.

The Clients that I'm testing on, they already have the .NET Framework 1.1
and the MDAC 2.7, which is the lastest I believe for data access.

Now When I run the application on those clients, I got a error saying the
"SQL Server does not exist or Access denied"
This is the connection object that VB.NET Standard generates :

Me.SqlConnection1.ConnectionString = "workstation id=""P4-MAN"";packet
size=4096;integrated security=SSPI;data source=""P4" & _
"-MAN"";persist security info=False;initial catalog=NorthwindSQL" on
the class file.

Any ideas on how can I resolve this? As I mentioned before I'm new to this
technology and it's probably a couple of steps to fix this or should I get a
different approach to connect to my development machine?

Thanks for your help on this one.

Manuel

 

[Guest]

You should install MSDE with this parameters

setup.exe SAPWD=sa DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL INSTANCENAME=MSD

else you will not able to connect from another machine or use SQL authentication

Connect using SQL Authentication: User: sa, password: sa

 

[Manuel Canas]

Thank you very much Andrea for you accurate input!!!

Manuel