Windows groups for SQL Server - what am I doing wrong?

[Barb]

Hi there,

I have an Access front end application that uses a SQL Server 2000
Desktop Edition backend. I have created a package with the Access
2003 runtime that I'd now like to deploy. I have created a global
group in the domain and placed the users that I'd like to give access
to the database (via my application front end) in that group. I've
then created a local group on the SQL Server machine and added my
global SQL Server group to it. I've also added that local group as
database user from SQL Server. From my reading of the various
material on the Internet this should work but it doesn't. I can't
access the database via the application from any machine other than my
development machine. My VBA code specifies integrated security for
the connection string.

Help please! I'm so close to deploying this and now I'm bogged down
in security. Any ideas anyone has would be appreciated. Account
administration and Windows security is not my strong suit.

Barb

[Simon Hayes]

"Barb" <fu*******@gmail.com> wrote in message
news:2e**************************@posting.google.c om...

Hi there,

I have an Access front end application that uses a SQL Server 2000
Desktop Edition backend. I have created a package with the Access
2003 runtime that I'd now like to deploy. I have created a global
group in the domain and placed the users that I'd like to give access
to the database (via my application front end) in that group. I've
then created a local group on the SQL Server machine and added my
global SQL Server group to it. I've also added that local group as
database user from SQL Server. From my reading of the various
material on the Internet this should work but it doesn't. I can't
access the database via the application from any machine other than my
development machine. My VBA code specifies integrated security for
the connection string.

Help please! I'm so close to deploying this and now I'm bogged down
in security. Any ideas anyone has would be appreciated. Account
administration and Windows security is not my strong suit.

Barb

The first thing to check would be network access to MSDE - you don't mention
which version you've installed, but starting from SP3a, network access is
disabled by default, so it's normal that users can't connect from another
machine. You can use the Server Network Utility to change this, and these
articles give more information:

http://support.microsoft.com/default...b;en-us;814130
http://support.microsoft.com/default...b;en-us;319930

Simon

[funkybarb]

Hi Simon,

Thanks for the suggestion but I don't think that's the problem. I can
connect to the database from the other machine with my account and
another user account that are in the global and local SQL Server group
(using Windows Authentication via a third party bit of software similar
to Enterprise Manager). I have SP3 installed on the remote machine so
the SP3a issue wouldn't have come into play.

My last guess is that it must be something to do with the package
itself.

Thanks again ... at least I know that it's not security related.

B.

Simon Hayes wrote:

"Barb" <fu*******@gmail.com> wrote in message
news:2e**************************@posting.google.c om...

Hi there,

I have an Access front end application that uses a SQL Server 2000
Desktop Edition backend. I have created a package with the Access
2003 runtime that I'd now like to deploy. I have created a global
group in the domain and placed the users that I'd like to give access to the database (via my application front end) in that group. I've
then created a local group on the SQL Server machine and added my
global SQL Server group to it. I've also added that local group as
database user from SQL Server. From my reading of the various
material on the Internet this should work but it doesn't. I can't
access the database via the application from any machine other than my development machine. My VBA code specifies integrated security for
the connection string.

Help please! I'm so close to deploying this and now I'm bogged down in security. Any ideas anyone has would be appreciated. Account
administration and Windows security is not my strong suit.

Barb
The first thing to check would be network access to MSDE - you don't

mention which version you've installed, but starting from SP3a, network access is disabled by default, so it's normal that users can't connect from another machine. You can use the Server Network Utility to change this, and these articles give more information:

http://support.microsoft.com/default...b;en-us;814130
http://support.microsoft.com/default...b;en-us;319930

Simon