Maintenance Plan after upgrade

Okay... here's my issue

I got a Win2k3/SP1 server, where I used to have SQL 2000 on it, upgraded to SQL 2005/SP1

everything seems fine, database access is working just great, thought, I'm trying to create a full backup schedule for the databases I have using the maintenance plan wizard, but I keep on receiving this error, anyone can help? :/

---

Maintenance Plan Wizard Progress

- Creating maintenance plan "MaintenancePlan1" (Error)

Messages

Create maintenance plan failed.

ADDITIONAL INFORMATION:

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

- Adding tasks to the maintenance plan (Stopped)

- Adding scheduling options (Stopped)

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan1" (Stopped)

I got the same problem,...|||Nothing to do with the upgrade. I am running SQL Server 2005 Developer edition on an XP professional box and get this message when I try to create any maintenance plan.|||

Hi guys...

the same problem ocorring after upgrate to SP1 of the sqlserver 2005.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124887

Not even in the Maintenance Plan, but, SISS and Notification Server. I din't upgrade my server, only when Microsoft give us SP2.

thanks.

Maintenance Plan after upgrade

Okay... here's my issue

I got a Win2k3/SP1 server, where I used to have SQL 2000 on it, upgraded to SQL 2005/SP1

everything seems fine, database access is working just great, thought, I'm trying to create a full backup schedule for the databases I have using the maintenance plan wizard, but I keep on receiving this error, anyone can help? :/

---

Maintenance Plan Wizard Progress

- Creating maintenance plan "MaintenancePlan1" (Error)

Messages

Create maintenance plan failed.

ADDITIONAL INFORMATION:

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

- Adding tasks to the maintenance plan (Stopped)

- Adding scheduling options (Stopped)

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan1" (Stopped)

I got the same problem,...|||Nothing to do with the upgrade. I am running SQL Server 2005 Developer edition on an XP professional box and get this message when I try to create any maintenance plan.|||

Hi guys...

the same problem ocorring after upgrate to SP1 of the sqlserver 2005.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124887

Not even in the Maintenance Plan, but, SISS and Notification Server. I din't upgrade my server, only when Microsoft give us SP2.

thanks.

Maintenance Plan after upgrade

Okay... here's my issue

I got a Win2k3/SP1 server, where I used to have SQL 2000 on it, upgraded to SQL 2005/SP1

everything seems fine, database access is working just great, thought, I'm trying to create a full backup schedule for the databases I have using the maintenance plan wizard, but I keep on receiving this error, anyone can help? :/

---

Maintenance Plan Wizard Progress

- Creating maintenance plan "MaintenancePlan1" (Error)

Messages

Create maintenance plan failed.

ADDITIONAL INFORMATION:

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

Cannot create a task with the name "STOCK:SqlTask". Verify that the name is correct.
(OnPreExecute)

- Adding tasks to the maintenance plan (Stopped)

- Adding scheduling options (Stopped)

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan1" (Stopped)

I got the same problem,...|||Nothing to do with the upgrade. I am running SQL Server 2005 Developer edition on an XP professional box and get this message when I try to create any maintenance plan.|||

Hi guys...

the same problem ocorring after upgrate to SP1 of the sqlserver 2005.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124887

Not even in the Maintenance Plan, but, SISS and Notification Server. I din't upgrade my server, only when Microsoft give us SP2.

thanks.

maintain audit trail of access to SQL server 2000 database

Is there any way to maintain audit trail of access to my SQL server 2000 database by any user ? I need to log the timestamp of any insert/update/delete to any record in a table within the database by the user.

Alex

Hi,

You need to enable Audit Schema Object Access Event for an audit, which is responsible for recording access to all schema objects including tables. Further you need to filer by database name, such that only events in a database you are interested in are recorded. Since you want to audit insert/update/delete for tables in database you need to place additional filters:

ObjectType = 'U' -- means user table

Permissions = 0x1a -- 0x2 | 0x8 | 0x10

You can further filer by table name (ObjectName column) if you wish.

The setup of the event described above can be easily done using SQL Server Profiler. Use "Column Filters" button to setup filters.

Let me know if you have further questions,

Ruslan

|||

ruslan ovechkin1 wrote:

Hi,

You need to enable Audit Schema Object Access Event for an audit, which is responsible for recording access to all schema objects including tables. Further you need to filer by database name, such that only events in a database you are interested in are recorded. Since you want to audit insert/update/delete for tables in database you need to place additional filters:

ObjectType = 'U' -- means user table

Permissions = 0x1a -- 0x2 | 0x8 | 0x10

You can further filer by table name (ObjectName column) if you wish.

The setup of the event described above can be easily done using SQL Server Profiler. Use "Column Filters" button to setup filters.

Let me know if you have further questions,

Ruslan

After enabling this, is it possibel to take report for the same ?

Vishal

maintain audit trail of access to SQL server 2000 database

Is there any way to maintain audit trail of access to my SQL server 2000 database by any user ? I need to log the timestamp of any insert/update/delete to any record in a table within the database by the user.

Alex

Hi,

You need to enable Audit Schema Object Access Event for an audit, which is responsible for recording access to all schema objects including tables. Further you need to filer by database name, such that only events in a database you are interested in are recorded. Since you want to audit insert/update/delete for tables in database you need to place additional filters:

ObjectType = 'U' -- means user table

Permissions = 0x1a -- 0x2 | 0x8 | 0x10

You can further filer by table name (ObjectName column) if you wish.

The setup of the event described above can be easily done using SQL Server Profiler. Use "Column Filters" button to setup filters.

Let me know if you have further questions,

Ruslan

|||

ruslan ovechkin1 wrote:

Hi,

You need to enable Audit Schema Object Access Event for an audit, which is responsible for recording access to all schema objects including tables. Further you need to filer by database name, such that only events in a database you are interested in are recorded. Since you want to audit insert/update/delete for tables in database you need to place additional filters:

ObjectType = 'U' -- means user table

Permissions = 0x1a -- 0x2 | 0x8 | 0x10

You can further filer by table name (ObjectName column) if you wish.

The setup of the event described above can be easily done using SQL Server Profiler. Use "Column Filters" button to setup filters.

Let me know if you have further questions,

Ruslan

After enabling this, is it possibel to take report for the same ?

Vishal

Magic Blank Page

Getting the magic blank 2nd page for a report that seems to be well within 1
page (brings back Access memories). Can't seem to figure out how to diag or
what to look for.
--
William Stacey [MVP]This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm with ya pal. I have 5 charts + a header all easily fitting on a =8.5x11.0 with point 25s all the way around and print preview is actual =pages * 2.
Unfortunately, this is one of those engagements where printing is =important.
-- TIM ELLISON
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message =news:%23Bw5dDTHGHA.3532@.TK2MSFTNGP14.phx.gbl...
Getting the magic blank 2nd page for a report that seems to be well =within 1 page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.
-- William Stacey [MVP]

--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

I'm with ya pal. I have 5 charts =+ a header all easily fitting on a 8.5x11.0 with point 25s all the way around and =print preview is actual pages * 2.
Unfortunately, this is one of those =engagements where printing is important.
-- TIM ELLISON
"William Stacey [MVP]" = wrote in message news:%23Bw5dDTHGHA.=3532@.TK2MSFTNGP14.phx.gbl...Getting the magic blank 2nd page for a report that seems to be well within 1 =page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.-- William Stacey [MVP]

---

--=_NextPart_000_0015_01C61D8A.A9892E70--

Machine Name Change slows ODBC link intolerably

Hello Everyone,
I have had an ODBC link between Access and Oracle at work for some time
now which has worked without problem. The other day, one of our
technicians came to change the name of my machine. Despite my best
efforts, I could not keep him off my machine and sure enough, my ODBC
linking to Oracle is now incredibly slow. I've tried deleting the
Microsoft Oracle ODBC DSN, but to no avail. I know this is the
sqlserver group but the only results for a machine name change came up
in this group, I am presuming the principal is the same. Can anyone
tell me the full procedure to re-establish my working link? Thanks.
P.S. I work for a local council, so I can't ask anyone here. I have had
to explain file permissions to a Network Manager before... :-(The issues with machine name changes with SQL Server are completely
different. In SQL Server, when you change the machine name, you have
to update system tables that store the name of the local server and
update the registry for the new machine name. It's really a different
issue as it has to do with how the SQL Server service knows what is
local to itself as a server.
-Sue
On 4 Nov 2004 02:39:01 -0800, reclusive.monkey@.gmail.com wrote:

>Hello Everyone,
>I have had an ODBC link between Access and Oracle at work for some time
>now which has worked without problem. The other day, one of our
>technicians came to change the name of my machine. Despite my best
>efforts, I could not keep him off my machine and sure enough, my ODBC
>linking to Oracle is now incredibly slow. I've tried deleting the
>Microsoft Oracle ODBC DSN, but to no avail. I know this is the
>sqlserver group but the only results for a machine name change came up
>in this group, I am presuming the principal is the same. Can anyone
>tell me the full procedure to re-establish my working link? Thanks.
>P.S. I work for a local council, so I can't ask anyone here. I have had
>to explain file permissions to a Network Manager before... :-(

Machine Name Change slows ODBC link intolerably

Hello Everyone,
I have had an ODBC link between Access and Oracle at work for some time
now which has worked without problem. The other day, one of our
technicians came to change the name of my machine. Despite my best
efforts, I could not keep him off my machine and sure enough, my ODBC
linking to Oracle is now incredibly slow. I've tried deleting the
Microsoft Oracle ODBC DSN, but to no avail. I know this is the
sqlserver group but the only results for a machine name change came up
in this group, I am presuming the principal is the same. Can anyone
tell me the full procedure to re-establish my working link? Thanks.
P.S. I work for a local council, so I can't ask anyone here. I have had
to explain file permissions to a Network Manager before... :-(
The issues with machine name changes with SQL Server are completely
different. In SQL Server, when you change the machine name, you have
to update system tables that store the name of the local server and
update the registry for the new machine name. It's really a different
issue as it has to do with how the SQL Server service knows what is
local to itself as a server.
-Sue
On 4 Nov 2004 02:39:01 -0800, reclusive.monkey@.gmail.com wrote:

>Hello Everyone,
>I have had an ODBC link between Access and Oracle at work for some time
>now which has worked without problem. The other day, one of our
>technicians came to change the name of my machine. Despite my best
>efforts, I could not keep him off my machine and sure enough, my ODBC
>linking to Oracle is now incredibly slow. I've tried deleting the
>Microsoft Oracle ODBC DSN, but to no avail. I know this is the
>sqlserver group but the only results for a machine name change came up
>in this group, I am presuming the principal is the same. Can anyone
>tell me the full procedure to re-establish my working link? Thanks.
>P.S. I work for a local council, so I can't ask anyone here. I have had
>to explain file permissions to a Network Manager before... :-(

Machine account access

Hi everyone,
I'm trying to access SQL Server from an application that is a service
running under the "Local System" account in a computer which is not the same
as the one running SQL Server. The service must run under this account, and
still should have access to an SQL Server database.
I've given permissions to the computer account in SQL Server, as both
computers are in Active Directory, but the service still does not connect
(due to permissions).
Is it possible to have this scenary running? Any idea on how to make it work
?
Thanks in advance,
Lleonard.Local system does not have access to network resources.
-Sue
On Wed, 27 Jul 2005 09:17:06 -0700, "lleonard"
<lleonard@.discussions.microsoft.com> wrote:

>Hi everyone,
>I'm trying to access SQL Server from an application that is a service
>running under the "Local System" account in a computer which is not the sam
e
>as the one running SQL Server. The service must run under this account, and
>still should have access to an SQL Server database.
>I've given permissions to the computer account in SQL Server, as both
>computers are in Active Directory, but the service still does not connect
>(due to permissions).
>Is it possible to have this scenary running? Any idea on how to make it wor
k?
>Thanks in advance,
>Lleonard.

MAC address

Hi,
I have a win 2000 adv + sql 2000 box. I would like to know if it is
possible to not allow access to the server using some machines MAC address o
r
Name. I know we can do a lot by using logins and other ways, but in my case
I
have no other choice except either MAC or machine name.
Thanks for your help.
SalamHi
Do this at network router level as it is really efficient down there and the
right place to do it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
> Hi,
> I have a win 2000 adv + sql 2000 box. I would like to know if it is
> possible to not allow access to the server using some machines MAC address
> or
> Name. I know we can do a lot by using logins and other ways, but in my
> case I
> have no other choice except either MAC or machine name.
> Thanks for your help.
> Salam|||This is my problem, I have no control on the router.
So as I said I have no other choice rather thatn machine name or mac adresse
Thanks
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Do this at network router level as it is really efficient down there and t
he
> right place to do it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "SalamElias" <eliassal@.online.nospam> wrote in message
> news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
>
>|||Hi
If you have Windows 2003 (preferably with SP1), you can use IPSec at OS
level to filter the traffic. Look up IPSec on technet for more information.
No an elegant solution, but it is the only thing that you could do.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:E2528C86-EFEF-43E4-A998-EDC6F6153136@.microsoft.com...[vbcol=seagreen]
> This is my problem, I have no control on the router.
> So as I said I have no other choice rather thatn machine name or mac
> adresse
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>

Mac Address

Hello,
I want to block certain mac address to access my MS-SQL server. for that what can i do. for example
I want to block the mac address [abc]. how is it possible to block the mac address [abc]Use a firewall. You can't do it from MS SQL Server|||Or from a router on the network, a sample:
To determine the corresponding IP address for this MAC address, run the following DOS networking command in a DOS window:
arp -aThis displays the IP address of all connected machines.
Match up the net_address value from the sysprocesses query (step 1) with the corresponding Physical Address in the arp -a results (step 2) to determine the IP address corresponding to the Physical Address is the IP address of the machine running the blocking process. To find the corresponding hostname of this machine, run the following DOS networking command in a DOS window:
ping -a <IPaddress>In the command above, <IPaddress> indicates the IP address identified with the arp -a command.