Database Access Right Issues

Recently I have changed the VB Application for Authentication method
to connect to the SQL Server 7.0 database using the Windows NT
Authentication.

Later I had created permissions for Select, Insert, Update, Delete,
Exec everything based on the Windows NT Authentication on an Active
Directory Group based.

Now I am trying to use the application from the Windows 2000 machine.
It runs normal with the all rules applied.

When I run from a windows 98 PC. It connects to the database without
any problem. When I tried to run the transactions or reports, It
throws the error as either Permission denied or Runt-time Error '13'
Type mismatch like that.

Can anybody tell me the work around for this issue?

I doubt this is something do with OS incompatiblity to access database
tables from Windows 98. Where as it is ok with Windows 2000.

Thanks in advance
SaravanakumarYour problem is with Win98, I believe. Win98 does not use named pipes,
nor does it use Windows Authentication since it does notprovide
security for different users in the same way that Windows 2000 Pro
does.

The solution to the security aspect is to set the sqlserver up with
Mixed mode logon security, and then create, in the sqkserver, a user
name and password for the user that works from thw Win98 machine. Each
time that user attempts to access sqlserver, he will have to specify
the username and password.

You may be able to solve the named pipes problem by disabling this
protocol in the client computer with the Client Network Utility. Run
this utility from the dos command Start>Run>cliconfg.exe. Then disable
Named pipes, or alternatively define an alias for the server instance
that enables only TCP/IP.

I'm not experienced with Win98 so another reader should verify this.
Also check the SQL server 2000 Books Online (download and install from
microsoft web site). This handy help file explains authentication
methods and may also have specific recommendations for Win98.

Mark Ferguson.
Ottawa Canada

On 21 Jun 2004 22:21:28 -0700, kssaran@.hotmail.com (Saravanakumar)
wrote:

>Recently I have changed the VB Application for Authentication method
>to connect to the SQL Server 7.0 database using the Windows NT
>Authentication.
>Later I had created permissions for Select, Insert, Update, Delete,
>Exec everything based on the Windows NT Authentication on an Active
>Directory Group based.
>Now I am trying to use the application from the Windows 2000 machine.
>It runs normal with the all rules applied.
>When I run from a windows 98 PC. It connects to the database without
>any problem. When I tried to run the transactions or reports, It
>throws the error as either Permission denied or Runt-time Error '13'
>Type mismatch like that.
>Can anybody tell me the work around for this issue?
>I doubt this is something do with OS incompatiblity to access database
>tables from Windows 98. Where as it is ok with Windows 2000.
>Thanks in advance
>Saravanakumar