Running Backup Jobs

Hi everyone
I have a SQL Server 2005. On this server is a database that only a handfull
of users may access - This excludes the normal IT people such as Domain
Admins etc. Only problem is that if I remove BuiltIn\Administrators from the
sysadmin server role I am no longer able to do backups of the database. If I
leave the BuiltIn\Administrator in the SysAdmin role they can access the
database.
Any help would be appriciated.
Thanks.
Regards
JonasJonas
By default all members of Administrators group have login SQL Server .
What is an account SQL Server Agent running under? Is it Local Account?
Create a user domain account/group on the box SQL Server running on. Change
Sql Server Agent's/MSSqlService account to this new one but make sure that
this account has an appropriate permissions to access the network
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
> Hi everyone
> I have a SQL Server 2005. On this server is a database that only a
> handfull
> of users may access - This excludes the normal IT people such as Domain
> Admins etc. Only problem is that if I remove BuiltIn\Administrators from
> the
> sysadmin server role I am no longer able to do backups of the database. If
> I
> leave the BuiltIn\Administrator in the SysAdmin role they can access the
> database.
> Any help would be appriciated.
> Thanks.
> Regards
> Jonas|||Thanks for that. The Agent was running Local System, changed that as
suggested and then removed builtin admin from the sysadmin role. Everything
works.
"Uri Dimant" wrote:

> Jonas
> By default all members of Administrators group have login SQL Server .
> What is an account SQL Server Agent running under? Is it Local Account?
> Create a user domain account/group on the box SQL Server running on. Chan
ge
> Sql Server Agent's/MSSqlService account to this new one but make sure that
> this account has an appropriate permissions to access the network
>
>
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
>
>sql

Run Time Error '-2147467259(80004005)':

WE have couple of applications using sql and were working
till friday 01/02/04. This morning when users are trying
to access it giveing the error Run Time Error '-2147467259
(80004005)':
Invalid connection String.
Any Idea.
Application connects to 2 sql 6.5 servers and 1 sql 2000
server. I changed the TCP/Ip ports on one of the server
in server network Utility to 1521 and changed it back to
1433 . nothing else. has changed as far as I can think
of.. please help THanks in advanceReply back with the connection string syntax.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:
>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?
Take a look at
http://msdn.microsoft.com/library/de...other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>
|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:

>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?Take a look at
other_8reb.asp" target="_blank">http://msdn.microsoft.com/library/d...
other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:

>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>