Authenticating User to access SQL DB through VB.Net app

[score]

Hello Folks,

Here is the situation:

I have SQL Desktop Engine sitting on a Windows 2000 Workstation sitting on a Novel Netware enviornment.

The VB.Net application is installed on other Windows 2000 pc.

In order to access the SQL DB sitting on the dedicated Win2000 box, each user has to have user account with same login information (username and passoword) what they provide when they login into LAN (Novel Netware).

Once they change/update Network password, we have to update the password on the SQL Win2000 Box as well.

This is causing major problems now, and it is getting pain in the ass.

We had set up SQL Server to use SQL Server Authentication,
And under Properties, Security TAB it shows
SQL Server and Windows

While supplying the connection string I tried the following options
CONN = "data source=GCBEDM23\VSdotNET;initial catalog=CMOS;integrated security=SSPI;"

CONN = "data source=GCBEDM23\VSdotNET;initial catalog=CMOS;"

CONN = "data source=GCBEDM23\VSdotNET; user id=cmode;password=cmode;initial catalog=CMOS;"

They all work fine if I had user account setup on the SQL Win2000 box with same (Network) login info.

How could I setup that to access the SQL DB through VB.Net app, I do not need to setup the local user on SQL Win2000 machine?

Please advise.

Thanks in adavance.

[Borry]

Hello,


You can also look to an application role. You can find this on your dbase > roles...
With this, you can set up an account with password per application.

After it, you could implement your own security, based on the logon username.

HTH,

Bjorn

[score]

Thanks Borry,

It's not that I'm having problem with.
I do not want to implement any security, it is handled through SQL DB.

My problem is, I had to create an identical Windows User account on the machine where SQL Server is residing and whenever someone changes there netowrk password (Novell Netware), we had to go and manuelly update the local windows passoword on the SQL machine else the VB application throws an error "SQL Server could not be found OR Access is denied".

Any ideas how I can resolve this?

Thanks,
Amit