Search results for query: *

domain users" group is not added to any local groups other than local "users" group local "users" group doesn't have permissions to sql server

I haven’t given permissions to individual users. “Domain Users” group do not have any permissions other than they are part of the “public” and one custom database role which allows access to few tables.

Domain users do not have admin rights in the domain. They are able to create users, create DTS packages, run jobs, modify tables, etc on SQL server. I tried assigning different roles like “db_datareader”, db_datawriter”, etc, but nothing seems to work.

I have a SQL server 2000 with ONLY windows authentication is enabled. Domain Users are part of the public role and a custom database role that has permissions only for few tables. For some reason SQL server allows ALL Domain users to have Admin RIGHTS on the server. Anyone has any...

Thanks J. That fixed the problem Scheduled DTS jobs use SQL Agent service startup account. I had target server share permission set only for the DTS package owner. Looks like both accounts need write permission.

That was my mistake. I am not trying to save the job on the IIS server. Job is on the database server. I have a share on the target server. I want the job to create a text file on the IIS server share. But it fails. If I manually execute the DTS Package, then it creates the text file on the...

I have two NT servers in a small domain with one running IIS and the other SQL 2000. I logged into both server using a domain user account. Account is part of the local administrator group in both servers. I want to create a DTS job and schedule it to run at night. I am trying to export some...

test

I have two NT servers in a small domain with one running IIS and the other SQL 2000. I logged into both server using a domain user account. Account is part of the local administrator group in both servers. I want to create a DTS job and schedule it to run at night. I am trying to export some...

Can someone tell me how to configure SQL server 2000 to send job notifications to multiple operators (net send option)? Thanks.

Can someone tell me how to configure SQL server 2000 to send job notifications to multiple operators (net send option)? Thanks.

Calahans, I need to replicate complete database. Bringing just tables wouldn't help. If I just bring the tables then I have to recreate all the security, stored procedures, indexers, etc. There must be a way to replicate same SQL 6.5 database onto SQL 7. Thanks for your response though!

I have 2 database servers one running SQL 6.5 and other SQL 7.0. I want to import 6.5 database to SQL 7.0 (not upgrade). Can anyone help me with this? Thanks.