Error copying SQL 2000 DB to SQL 2005

Hi all,
We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
is the error message received. We are doing this by using the 'copy
database' feature in SQL 2005, is this the correct way to migrate a DB
to 2005? The database is not in use so we are unsure why this error
would be occuring. And on top of this we did not instruct SQL to drop
the DB?
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message
ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USE R,(Job
outcome),,The job failed. The Job was invoked by User DOMAIN\user.
The last step to run was step 1 (CDW_BUBBA_USER_Step).,
00:02:28,0,0,,,,0
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Execute d as user: DOMAIN
\USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
Task Task just started the execution.: 0% complete End Progress
Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
Bubba_USER_Transfer Objects Task
Description: ERROR : errorCode=-1073548784 description=Executing the
query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
N'test_sb') DROP DATABASE [test_sb] " failed with the following
error: "Cannot drop database "test_sb" because it is currently in
use.". Possible failure reasons: Problems with the query<c/>
"ResultSet" property not set correctly<c/> parameters not set
correctly<c/> or connection not established correctly. helpFile=
helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
DA807BCDC2AC} StackTrace: at
Microsoft.SqlServer.Management.Dts.D... The package execution fa...
The step failed.,00:02:28,0,0,,,,0
Hello,
That should wor, do you the destination DB already there in SQL 2005 server.
If yes then try dropping the databaase and see if it works.
Alternate methodology is
1. Backup the database in sql 2000
2. COpy the file to SQL 2005 server
3. restore the database in SQL 2005. THis will automatically upgrade to SQL
2005.
4. Run a update statistics after upgrade,
Thanks
Hari
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegro ups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USE R,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Execute d as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>
|||>> "Cannot drop database "test_sb" because it is currently in use."
A database cannot be dropped if there is currently a connection open to it.
Try closing all connections on the server being copied to that are connected
to the database you are trying to copy over. sp_who2 will show you this,
and you can use the KILL command to kill off any spids that show connection
to that database. Make sure you are on the correct server when you do this!
:-)
TheSQLGuru
President
Indicium Resources, Inc.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegro ups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USE R,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Execute d as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>
|||The best way is backup the database, copy the backup to destination server,
restore the database at destination server, change the compatibility to 9.0,
update statistic.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegro ups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USE R,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Execute d as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>

Error copying SQL 2000 DB to SQL 2005

Hi all,
We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
is the error message received. We are doing this by using the 'copy
database' feature in SQL 2005, is this the correct way to migrate a DB
to 2005? The database is not in use so we are unsure why this error
would be occuring. And on top of this we did not instruct SQL to drop
the DB?
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message
ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USER,(Job
outcome),,The job failed. The Job was invoked by User DOMAIN\user.
The last step to run was step 1 (CDW_BUBBA_USER_Step).,
00:02:28,0,0,,,,0
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Executed as user: DOMAIN
\USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
Task Task just started the execution.: 0% complete End Progress
Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
Bubba_USER_Transfer Objects Task
Description: ERROR : errorCode=-1073548784 description=Executing the
query "IF EXISTS (SELECT name FROM sys.databases WHERE name = N'test_sb') DROP DATABASE [test_sb] " failed with the following
error: "Cannot drop database "test_sb" because it is currently in
use.". Possible failure reasons: Problems with the query<c/>
"ResultSet" property not set correctly<c/> parameters not set
correctly<c/> or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
DA807BCDC2AC} StackTrace: at
Microsoft.SqlServer.Management.Dts.D... The package execution fa...
The step failed.,00:02:28,0,0,,,,0Hello,
That should wor, do you the destination DB already there in SQL 2005 server.
If yes then try dropping the databaase and see if it works.
Alternate methodology is
1. Backup the database in sql 2000
2. COpy the file to SQL 2005 server
3. restore the database in SQL 2005. THis will automatically upgrade to SQL
2005.
4. Run a update statistics after upgrade,
Thanks
Hari
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name => N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>|||>> "Cannot drop database "test_sb" because it is currently in use."
A database cannot be dropped if there is currently a connection open to it.
Try closing all connections on the server being copied to that are connected
to the database you are trying to copy over. sp_who2 will show you this,
and you can use the KILL command to kill off any spids that show connection
to that database. Make sure you are on the correct server when you do this!
:-)
TheSQLGuru
President
Indicium Resources, Inc.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name => N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>|||The best way is backup the database, copy the backup to destination server,
restore the database at destination server, change the compatibility to 9.0,
update statistic.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Step,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name => N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>

Error copying SQL 2000 DB to SQL 2005

Hi all,
We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
is the error message received. We are doing this by using the 'copy
database' feature in SQL 2005, is this the correct way to migrate a DB
to 2005? The database is not in use so we are unsure why this error
would be occuring. And on top of this we did not instruct SQL to drop
the DB?
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message
ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW
_BUBBA_USER,(Job
outcome),,The job failed. The Job was invoked by User DOMAIN\user.
The last step to run was step 1 (CDW_BUBBA_USER_Step).,
00:02:28,0,0,,,,0
05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Ste
p,,Executed as user: DOMAIN
\USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
Task Task just started the execution.: 0% complete End Progress
Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
Bubba_USER_Transfer Objects Task
Description: ERROR : errorCode=-1073548784 description=Executing the
query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
N'test_sb') DROP DATABASE [test_sb] " failed with the following
error: "Cannot drop database "test_sb" because it is currently in
use.". Possible failure reasons: Problems with the query<c/>
"ResultSet" property not set correctly<c/> parameters not set
correctly<c/> or connection not established correctly. helpFile=
helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
DA807BCDC2AC} StackTrace: at
Microsoft.SqlServer.Management.Dts.D... The package execution fa...
The step failed.,00:02:28,0,0,,,,0Hello,
That should wor, do you the destination DB already there in SQL 2005 server.
If yes then try dropping the databaase and see if it works.
Alternate methodology is
1. Backup the database in sql 2000
2. COpy the file to SQL 2005 server
3. restore the database in SQL 2005. THis will automatically upgrade to SQL
2005.
4. Run a update statistics after upgrade,
Thanks
Hari
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW
_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Ste
p,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>|||>> "Cannot drop database "test_sb" because it is currently in use."
A database cannot be dropped if there is currently a connection open to it.
Try closing all connections on the server being copied to that are connected
to the database you are trying to copy over. sp_who2 will show you this,
and you can use the KILL command to kill off any spids that show connection
to that database. Make sure you are on the correct server when you do this!
:-)
TheSQLGuru
President
Indicium Resources, Inc.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW
_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Ste
p,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>|||The best way is backup the database, copy the backup to destination server,
restore the database at destination server, change the compatibility to 9.0,
update statistic.
"Ash" <ash.singh@.gmail.com> wrote in message
news:1177983868.501535.78840@.e65g2000hsc.googlegroups.com...
> Hi all,
> We are trying to copy a DB from SQL 2000 MSDE to SQL 2005 SP2 and this
> is the error message received. We are doing this by using the 'copy
> database' feature in SQL 2005, is this the correct way to migrate a DB
> to 2005? The database is not in use so we are unsure why this error
> would be occuring. And on top of this we did not instruct SQL to drop
> the DB?
>
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message
> ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,0,USER,CDW
_BUBBA_USER,(Job
> outcome),,The job failed. The Job was invoked by User DOMAIN\user.
> The last step to run was step 1 (CDW_BUBBA_USER_Step).,
> 00:02:28,0,0,,,,0
> 05/01/2007 09:05:31,CDW_BUBBA_USER,Error,
> 1,USER,CDW_BUBBA_USER,CDW_BUBBA_USER_Ste
p,,Executed as user: DOMAIN
> \USER. ...ersion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
> 1984-2005. All rights reserved. Started: 9:05:33 AM Progress:
> 2007-05-01 09:05:34.82 Source: Bubba_USER_Transfer Objects
> Task Task just started the execution.: 0% complete End Progress
> Error: 2007-05-01 09:07:58.57 Code: 0x00000000 Source:
> Bubba_USER_Transfer Objects Task
> Description: ERROR : errorCode=-1073548784 description=Executing the
> query "IF EXISTS (SELECT name FROM sys.databases WHERE name =
> N'test_sb') DROP DATABASE [test_sb] " failed with the following
> error: "Cannot drop database "test_sb" because it is currently in
> use.". Possible failure reasons: Problems with the query<c/>
> "ResultSet" property not set correctly<c/> parameters not set
> correctly<c/> or connection not established correctly. helpFile=
> helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-
> DA807BCDC2AC} StackTrace: at
> Microsoft.SqlServer.Management.Dts.D... The package execution fa...
> The step failed.,00:02:28,0,0,,,,0
>

Error Connecting to SQL 2000 from 2005 SSMS

I can connect to all but one of my SQL 2000 SP 4 servers with SQL 2005 SP2 SSMS on my workstation. I get the following error for the one:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I can connect to this server with the SQL 2000 Enterprise Manager from the same workstation I'm running SQL 2005 SSMS. I've also verified that tcp and named pipes are set up on the 2000 server. Can also telnet to the box with the default port #.

I'd appreciate any help you could give..

Thanks,

Dan

check the sql server 2005 is enabled for remote connection. check for firewall

http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

Madhu

Error connecting to Oracle via linked server after SP2 installatio

We have a test SQL Server box configured with the following:
Windows 2000, SP4
SQL Server: 8.00.944
Oracle Client Tools: 9.2.0.1
Microsoft ODBC for Oracle: 2.573.9030.00
We built a linked server to a 3rd party Oracle application. We used the
standard "Microsoft OLE DB Provider for Oracle" drvier from the drop down
list. We created views using this linked server and they worked fine.
However, after installing SP2 of Reporting Services, we now receive the
following error when we attempt to use the views:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned
error message: Oracle client and networking components not found. These
components are supplied by Oracle Corporation and are part of the Oracle
Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
We use a free SQL Tool called "Toad" to access the Oracle environment. This
tool uses the same Oracle Client Tools referred to in the error message.
This tool continues to function normally.
We really want to take advantage of some of the new features in SP2, but we
can't deploy this on our production SQL Reporting box until we get this issue
resolved. Any help in this matter would be greatly appreciated. Thanks!
--
Grande ApplicationsHello,
Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
are not supported with any Oracle versions later than 8i. For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:
244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
Therefore, the cause of the issue is not related to the reporting service.
If you want to use Oracle version 9i, you can use the following settings in
step 3 of this procedure in the article 280106:
280106 How to set up and troubleshoot a linked server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
However, this configuration is not supported and is discouraged.
Oracle Client Microsoft Windows 2000
9.x
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
You can refer to the article 280106 to set up and troubleshoot a linked
server. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
Thanks much for your response. We were able to resolve the problem by
restarting the SQL server (SQL Server service); however, we have discovered
from others that this resolution has been known to provide only a temporary
fix.
Do you know where I can find a list of all of the files (and file versions)
installed and updated by Reporting Services SP 2? This would be very helpful
to us.
Thank you.
Grande Applications
Thank you
"Sophie Guo [MSFT]" wrote:
> Hello,
> Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
> are not supported with any Oracle versions later than 8i. For more
> information, click the following article number to view the article in the
> Microsoft Knowledge Base:
> 244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
> Therefore, the cause of the issue is not related to the reporting service.
> If you want to use Oracle version 9i, you can use the following settings in
> step 3 of this procedure in the article 280106:
> 280106 How to set up and troubleshoot a linked server to Oracle in SQL
> Server
> http://support.microsoft.com/?id=280106
> However, this configuration is not supported and is discouraged.
> Oracle Client Microsoft Windows 2000
> 9.x
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
> "OracleXaLib"="oraclient9.dll"
> "OracleSqlLib"="orasql9.dll"
> "OracleOciLib"="oci.dll"
>
> You can refer to the article 280106 to set up and troubleshoot a linked
> server. I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Error after sp2 install

After installing sp2 on my production server ( went well in dev and qa) I got
this message:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: -- <html>
<head> <title> SQL Server Reporting Services </title><meta name="Generator"
content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
/> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) at
Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
Microsoft.ReportingServices.WebServer.Global.StartApp() at
Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
{FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
<li>The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
I'd really appriciate help on this!!
FredHaving same problem, any solution?
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred|||Me too!
Browser window error:
â?¢ The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
o Access to the path 'c:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServer__03_08_2007_15_56_35.log</Path>
<SystemName>TESS-RCREPS</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!3/8/2007-15:56:37:: i INFO: Reporting Web Server started
aspnet_wp!diagnostic!1!3/8/2007-15:56:37:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
aspnet_wp!diagnostic!1!3/8/2007-15:56:38:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
"Joe S." wrote:
> Having same problem, any solution?
> "Fred" wrote:
> > After installing sp2 on my production server ( went well in dev and qa) I got
> > this message:
> >
> > Client found response content type of 'text/html; charset=utf-8', but
> > expected 'text/xml'. The request failed with the error message: -- <html>
> > <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> > content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> > name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> > /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> > content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> > configFileName, String configLocation) at
> > Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> > Microsoft.ReportingServices.WebServer.Global.StartApp() at
> > Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> > sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> > FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> > FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> > 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> > {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> > <li>The report server has encountered a configuration error. See the report
> > server log files for more information. (rsServerConfigurationError) </li><ul>
> > <li>Access to the path 'C:\Program Files\Microsoft SQL
> > Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> > denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> > class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> >
> > I'd really appriciate help on this!!
> >
> > Fred|||Deleting encrypted content in RS configuration fixed this for us.|||I got my RS working again. Originally my IIS 6.0 was running in 32 bit mode
for the RS. The SP2 upgrade it appears changed the RS to need 64 bit for
which the OS and SQL are both running. By changing IIS not to run 32 bit apps
the RS web pages appeared again.
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred

Error After installing SQL SERVER 2005 SP2

I was wanting to use one of the samples called stock which is a notification sample and while i was reading the instrutions from the book, it did not match the managment studio for instance after i clicked on properties on a login there should have been a database access table on the right panel but it came up with user view, by then i thought i had an older version so i tried to update it to sp2 (x64 version the others came up with an hotfix error not being a win 32 app during extracting). after i installed it along with the new updates for documentation and samples it was no longer able to connect to my sql server instance that i had been using and this error comes up

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

i have gone to configuration manager and enabled named pipes as well as going to surface area config and enabled tcp/ip and named pipes but that has not resolve the area

Desperately need to get this problem resolve so if anyone can tell me how to fix i thank you in advance

Check the following link...

http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

|||

Hi Adam,

I updated my SQL Server 2005 with the SP2 and had no any problem.

I get this error message mostly when my SQL Service doesn't work. So i suggest you to check your SQL Services.

Ekrem ?nsoy

MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE

www.ekremonsoy.net

Error after installing SQL 2005 sp2

After installing this, when I try to open a backup maintenance plan in
Management Studio, I get this error:
Error 1 Error loading 'MSAAFullBackup' : Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass' to interface type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication90'. This operation
failed because the QueryInterface call on the COM component for the interface
with IID '{7591CC39-276A-4973-97C7-4EFEA5A5788F}' failed due to the following
error: No such interface supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE)).. server=CLAUDIA;package=Maintenance
Plans\MSAAFullBackup; 1 1
Any suggestions as to how I can fix this?
ThanksHi,
To let me better understand your issue, could you please confirm with me
the following questions:
1. What is your SQL Server edition?
2. Has SQL Server 2005 SP2 been installed on your computer?
3. What is your Windows OS edition?
4. Does the error occur even if you just create a new BACKUP maintenance
plan?
For now, you may try manually running:
regsvr32 ?C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll?
to see if this issue persists.
Please feel free to let me know if you have any other questions or
concerns. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles,
1. Standard
2. Yes, sp2 (the version after March 5) has been installed
3. Windows 2003 Server Standard
4. Yes
I can also tell you that when I was installing the sp, I got these messages,
which I have been unable to correct:
1. The Application data folder for Visual Studio Macros could not be created
2. The Application data folder for Microsoft Document Explorer could not be
created
Thanks,
Tom
"Charles Wang[MSFT]" wrote:
> Hi,
> To let me better understand your issue, could you please confirm with me
> the following questions:
> 1. What is your SQL Server edition?
> 2. Has SQL Server 2005 SP2 been installed on your computer?
> 3. What is your Windows OS edition?
> 4. Does the error occur even if you just create a new BACKUP maintenance
> plan?
> For now, you may try manually running:
> regsvr32 â'C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dllâ'
> to see if this issue persists.
> Please feel free to let me know if you have any other questions or
> concerns. Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
>|||Hi Tom,
Thanks for your response.
I am applying for a test environment as yours to check if this is a common
issue.
For now, I recommend that you mail me the following files for further
research:
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
The Hotfix folder may be large. I would like to create a workspace for your
uploading the files; however the process need your email address. Could you
please first send me (changliw_at_microsoft_dot_com) a email response now?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Tom,
After checked the hotfix logs, I found that SQL 2005 SP2 failed to be
installed on client tools . Please refer to the following errors:
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and
configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
From my research from our internal libraries, there are some similar issues
there but the root cause seems various and the troubleshooting steps were
complex.
You may try reinstalling COM+ and .NET Framework or check if your MSDTC was
disabled under your computer. Please refer to the following articles:
How to: Work Around COM+ System Configuration Check Failure in SQL Server
Setup
http://msdn2.microsoft.com/en-us/library/ms143690.aspx
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064
Also you may try uninstalling SQL Server 2005 client components from Add
Remove Programs and reinstall it from Tools folder of your SQL Server 2005
setup CD, and then apply SQL 2005 SP2 again.
If this issue persists, effectively and immediately I recommend that you
contact Microsoft Customer Support Service (CSS) via telephone for the best
support. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or
concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Error after installing SQL 2005 sp2

After installing this, when I try to open a backup maintenance plan in
Management Studio, I get this error:
Error 1 Error loading 'MSAAFullBackup' : Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass' to interface type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication90'. This operation
failed because the QueryInterface call on the COM component for the interfac
e
with IID '{7591CC39-276A-4973-97C7-4EFEA5A5788F}' failed due to the fol
lowing
error: No such interface supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE)).. server=CLAUDIA;package=Maintenance
Plans\MSAAFullBackup; 1 1
Any suggestions as to how I can fix this?
ThanksHi,
To let me better understand your issue, could you please confirm with me
the following questions:
1. What is your SQL Server edition?
2. Has SQL Server 2005 SP2 been installed on your computer?
3. What is your Windows OS edition?
4. Does the error occur even if you just create a new BACKUP maintenance
plan?
For now, you may try manually running:
regsvr32 C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
to see if this issue persists.
Please feel free to let me know if you have any other questions or
concerns. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Charles,
1. Standard
2. Yes, sp2 (the version after March 5) has been installed
3. Windows 2003 Server Standard
4. Yes
I can also tell you that when I was installing the sp, I got these messages,
which I have been unable to correct:
1. The Application data folder for Visual Studio Macros could not be created
2. The Application data folder for Microsoft Document Explorer could not be
created
Thanks,
Tom
"Charles Wang[MSFT]" wrote:

> Hi,
> To let me better understand your issue, could you please confirm with me
> the following questions:
> 1. What is your SQL Server edition?
> 2. Has SQL Server 2005 SP2 been installed on your computer?
> 3. What is your Windows OS edition?
> 4. Does the error occur even if you just create a new BACKUP maintenance
> plan?
> For now, you may try manually running:
> regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”
> to see if this issue persists.
> Please feel free to let me know if you have any other questions or
> concerns. Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> Get notification to my posts through email? Please refer to:
> [url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif[/ur
l]
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly
.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
>|||Hi Tom,
Thanks for your response.
I am applying for a test environment as yours to check if this is a common
issue.
For now, I recommend that you mail me the following files for further
research:
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
The Hotfix folder may be large. I would like to create a workspace for your
uploading the files; however the process need your email address. Could you
please first send me (changliw_at_microsoft_dot_com) a email response now?
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi Tom,
After checked the hotfix logs, I found that SQL 2005 SP2 failed to be
installed on client tools . Please refer to the following errors:
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB
921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and
configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
From my research from our internal libraries, there are some similar issues
there but the root cause seems various and the troubleshooting steps were
complex.
You may try reinstalling COM+ and .NET Framework or check if your MSDTC was
disabled under your computer. Please refer to the following articles:
How to: Work Around COM+ System Configuration Check Failure in SQL Server
Setup
http://msdn2.microsoft.com/en-us/library/ms143690.aspx
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064
Also you may try uninstalling SQL Server 2005 client components from Add
Remove Programs and reinstall it from Tools folder of your SQL Server 2005
setup CD, and then apply SQL 2005 SP2 again.
If this issue persists, effectively and immediately I recommend that you
contact Microsoft Customer Support Service (CSS) via telephone for the best
support. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or
concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============

Error after installing SQL 2005 sp2

After installing this, when I try to open a backup maintenance plan in
Management Studio, I get this error:
Error1Error loading 'MSAAFullBackup' : Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.Applicati onClass' to interface type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSAppli cation90'. This operation
failed because the QueryInterface call on the COM component for the interface
with IID '{7591CC39-276A-4973-97C7-4EFEA5A5788F}' failed due to the following
error: No such interface supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE))..server=CLAUDIA;package=Maintenance
Plans\MSAAFullBackup;11
Any suggestions as to how I can fix this?
Thanks
Hi,
To let me better understand your issue, could you please confirm with me
the following questions:
1. What is your SQL Server edition?
2. Has SQL Server 2005 SP2 been installed on your computer?
3. What is your Windows OS edition?
4. Does the error occur even if you just create a new BACKUP maintenance
plan?
For now, you may try manually running:
regsvr32 C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
to see if this issue persists.
Please feel free to let me know if you have any other questions or
concerns. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Charles,
1. Standard
2. Yes, sp2 (the version after March 5) has been installed
3. Windows 2003 Server Standard
4. Yes
I can also tell you that when I was installing the sp, I got these messages,
which I have been unable to correct:
1. The Application data folder for Visual Studio Macros could not be created
2. The Application data folder for Microsoft Document Explorer could not be
created
Thanks,
Tom
"Charles Wang[MSFT]" wrote:

> Hi,
> To let me better understand your issue, could you please confirm with me
> the following questions:
> 1. What is your SQL Server edition?
> 2. Has SQL Server 2005 SP2 been installed on your computer?
> 3. What is your Windows OS edition?
> 4. Does the error occur even if you just create a new BACKUP maintenance
> plan?
> For now, you may try manually running:
> regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”
> to see if this issue persists.
> Please feel free to let me know if you have any other questions or
> concerns. Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
>
|||Hi Tom,
Thanks for your response.
I am applying for a test environment as yours to check if this is a common
issue.
For now, I recommend that you mail me the following files for further
research:
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
The Hotfix folder may be large. I would like to create a workspace for your
uploading the files; however the process need your email address. Could you
please first send me (changliw_at_microsoft_dot_com) a email response now?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Tom,
After checked the hotfix logs, I found that SQL 2005 SP2 failed to be
installed on client tools . Please refer to the following errors:
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sql run_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and
configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notifications
ervices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
From my research from our internal libraries, there are some similar issues
there but the root cause seems various and the troubleshooting steps were
complex.
You may try reinstalling COM+ and .NET Framework or check if your MSDTC was
disabled under your computer. Please refer to the following articles:
How to: Work Around COM+ System Configuration Check Failure in SQL Server
Setup
http://msdn2.microsoft.com/en-us/library/ms143690.aspx
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064
Also you may try uninstalling SQL Server 2005 client components from Add
Remove Programs and reinstall it from Tools folder of your SQL Server 2005
setup CD, and then apply SQL 2005 SP2 again.
If this issue persists, effectively and immediately I recommend that you
contact Microsoft Customer Support Service (CSS) via telephone for the best
support. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or
concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====