Showing posts with label sp3. Show all posts
Showing posts with label sp3. Show all posts

Monday, March 19, 2012

cannt remove data file from user database

We are running SQL server 2003 with SP3. I'm trying to
shrink a data files with the emptyfile option so I can
eventually remove the file using the alter database
command. However, I get the following error message when I
run the alter database command:

Error: the file PRADATA4 cannot be removed because it is
not empty.

The file that I'm trying to remove still has 62 extents on it.
I looked MS Knowledge base 254253 and 279511 on this problem but they say it is corrected by SQL server 7.0 with service pack 3.
commands that I'm running are as follows:

1) USE PRA
DBCC TRACEON(8901)
DBCC SHRINKFILE ('PRADATA4', EMPTYFILE)
DBCC TRACEOFF(8901)

2) USE PRA
GO
ALTERDATABASE PRA
REMOVE FILE PRADATA4
GO

Can anyone help?

ThanksYou are shrinking one file, but removing another. This sounds like a sub-optimal approach to me.

-PatP|||Originally posted by Pat Phelan
You are shrinking one file, but removing another. This sounds like a sub-optimal approach to me.

-PatP
sorry,I write error,the commands are:
1) USE PRA
DBCC TRACEON(8901)
DBCC SHRINKFILE ('PRADATA4', EMPTYFILE)
DBCC TRACEOFF(8901)

2) USE PRA
GO
ALTERDATABASE PRA
REMOVE FILE PRADATA4
GO|||First make sure there are no open transactions that are stopping this piece of data from being moved and ensure to try with trace flags as specified in one of the KBAs.|||Originally posted by Satya
First make sure there are no open transactions that are stopping this piece of data from being moved and ensure to try with trace flags as specified in one of the KBAs.

How to check open transactions?Use sp_who2?|||DBCC OPENTRAN and refer to books online for more information.|||Originally posted by Satya
DBCC OPENTRAN and refer to books online for more information.
Hi Satya:
Yesterday , I restarted our database service,and used DBCC OPENTRAN to check there are no open transactions,but we still cann't remove the PRADATA4 from database.

Thanks|||Books Online (BOL) documents the REMOVE FILE option of ALTER DATABASE, but BOL doesn't tell you that you first need to run SHRINKFILE('file_name', EMPTYFILE). This command shrinks the file to 0MB of space used and ensures that you've removed all the objects from the file.|||Originally posted by Satya
Books Online (BOL) documents the REMOVE FILE option of ALTER DATABASE, but BOL doesn't tell you that you first need to run SHRINKFILE('file_name', EMPTYFILE). This command shrinks the file to 0MB of space used and ensures that you've removed all the objects from the file.
Hi Satya:
Thanks for your help,I have used KB 324432 to resolve the problem.

cannot write to sql 2000 database after about 2 hours uptime

Hi
I have a sql 2000 sp3 database running on SBS 2003 that seems to
ignore any writes after about 2 hours of it being up. It works fine after i
reboot the server or restart the sql service, but after a couple hours it
will not edit the database again. If i restart the service, it works fine
again. Also, i was looking at the sql logs and they are odd. it says
'starting up database {my database name}' about 20 times in a row when the
database is started, then says 'Configuration option 'show advanced options'
changed from 1 to 1. Run the RECONFIGURE statement to install' and then
gives an error 15457. Please help me fix my database.
Thanks in advance.
Leszek
Hi
Error 15457 is just an informational one. Ig gets generated the Enterprise
Manager and has nothing to do with the Db issue.
If there are no other errors in you event log, it means that SQL is Ok and
your application is the problem.
You may want to make sure that your DB is not set as 'Auto Close' as this
affects performance.
Regards
Mike
"Leszek" wrote:

> Hi
>
> I have a sql 2000 sp3 database running on SBS 2003 that seems to
> ignore any writes after about 2 hours of it being up. It works fine after i
> reboot the server or restart the sql service, but after a couple hours it
> will not edit the database again. If i restart the service, it works fine
> again. Also, i was looking at the sql logs and they are odd. it says
> 'starting up database {my database name}' about 20 times in a row when the
> database is started, then says 'Configuration option 'show advanced options'
> changed from 1 to 1. Run the RECONFIGURE statement to install' and then
> gives an error 15457. Please help me fix my database.
> Thanks in advance.
> Leszek
>
>
|||Hi
Db is not set as 'Auto Close'. I have noticed that problem occured when is
more then 100 process in sql .
Regards
Leszek
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:4F13D7AF-1570-47AC-85B5-0515AD58D2AA@.microsoft.com...[vbcol=seagreen]
> Hi
> Error 15457 is just an informational one. Ig gets generated the Enterprise
> Manager and has nothing to do with the Db issue.
> If there are no other errors in you event log, it means that SQL is Ok and
> your application is the problem.
> You may want to make sure that your DB is not set as 'Auto Close' as this
> affects performance.
> Regards
> Mike
> "Leszek" wrote:
after i[vbcol=seagreen]
it[vbcol=seagreen]
fine[vbcol=seagreen]
the[vbcol=seagreen]
options'[vbcol=seagreen]
then[vbcol=seagreen]
|||The problem here is not going to be an easy one to fix.
There are a couple of things you can look at however to
get a bit closer to the proble.
Firstly have you run the performance monitor to see what
is happening to your server i.e. Disk, Memory and the like.
Secondly you may want to set up a trace to see what
commands are being sent to the server.
Finally another thing you can do is send me a copy of your
database script, I don't need the table definitions, sp,
views or functions, just the configuration options when
you create the database, for security purposes leave the
create database statement in, but change the db name. I
will have a quick look at it and see if I can spot
anything odd.
Finally what is your server specification i.e. ram, hard
disk space ect.
My email if you need it is
peter.nolan@.REMOVETHISpinnacle.co.uk, nb its my work one.
Peter
"The length of this document defends it well against the
risk of its being read."
Winston Churchill

>--Original Message--
>Hi
>Db is not set as 'Auto Close'. I have noticed that
problem occured when is
>more then 100 process in sql .
>Regards
>Leszek
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in
message[vbcol=seagreen]
>news:4F13D7AF-1570-47AC-85B5-0515AD58D2AA@.microsoft.com...
generated the Enterprise[vbcol=seagreen]
that SQL is Ok and[vbcol=seagreen]
as 'Auto Close' as this[vbcol=seagreen]
2003 that seems to[vbcol=seagreen]
It works fine[vbcol=seagreen]
>after i
after a couple hours[vbcol=seagreen]
>it
service, it works[vbcol=seagreen]
>fine
are odd. it says[vbcol=seagreen]
times in a row when[vbcol=seagreen]
>the
option 'show advanced[vbcol=seagreen]
>options'
to install' and
>then
>
>.
>
|||Aplication works since few monts on other server and there everything is
fine.
Regarding performance monitor. When system works fine and i try to open site
with many difficult query , procesor usage show about 50 % and it take 10
sec - site is loaded. If it doesn't work procesor usage is always about 1%
but i can't load the site.
Sql Profile show that query is sent to server.
Leszek
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:158001c4a221$b242cfc0$a301280a@.phx.gbl...[vbcol=seagreen]
> The problem here is not going to be an easy one to fix.
> There are a couple of things you can look at however to
> get a bit closer to the proble.
> Firstly have you run the performance monitor to see what
> is happening to your server i.e. Disk, Memory and the like.
> Secondly you may want to set up a trace to see what
> commands are being sent to the server.
> Finally another thing you can do is send me a copy of your
> database script, I don't need the table definitions, sp,
> views or functions, just the configuration options when
> you create the database, for security purposes leave the
> create database statement in, but change the db name. I
> will have a quick look at it and see if I can spot
> anything odd.
> Finally what is your server specification i.e. ram, hard
> disk space ect.
> My email if you need it is
> peter.nolan@.REMOVETHISpinnacle.co.uk, nb its my work one.
> Peter
> "The length of this document defends it well against the
> risk of its being read."
> Winston Churchill
>
> problem occured when is
> message
> generated the Enterprise
> that SQL is Ok and
> as 'Auto Close' as this
> 2003 that seems to
> It works fine
> after a couple hours
> service, it works
> are odd. it says
> times in a row when
> option 'show advanced
> to install' and
|||Hi Leszek,
Have you used the enterprise manager to see if anything is locking a table
and preventing the updates? Perhaps a certain function or piece of code is
being executed after about 2 hours and that may look like the database won't
accept updates.
Wayne
"Leszek" <aaa@.addressnotexists.com> wrote in message
news:Odc7a3goEHA.2380@.TK2MSFTNGP14.phx.gbl...
> Hi
>
> I have a sql 2000 sp3 database running on SBS 2003 that seems to
> ignore any writes after about 2 hours of it being up. It works fine after
> i
> reboot the server or restart the sql service, but after a couple hours it
> will not edit the database again. If i restart the service, it works fine
> again. Also, i was looking at the sql logs and they are odd. it says
> 'starting up database {my database name}' about 20 times in a row when the
> database is started, then says 'Configuration option 'show advanced
> options'
> changed from 1 to 1. Run the RECONFIGURE statement to install' and then
> gives an error 15457. Please help me fix my database.
> Thanks in advance.
> Leszek
>

cannot write to sql 2000 database after about 2 hours uptime

Hi
I have a sql 2000 sp3 database running on SBS 2003 that seems to
ignore any writes after about 2 hours of it being up. It works fine after i
reboot the server or restart the sql service, but after a couple hours it
will not edit the database again. If i restart the service, it works fine
again. Also, i was looking at the sql logs and they are odd. it says
'starting up database {my database name}' about 20 times in a row when the
database is started, then says 'Configuration option 'show advanced options'
changed from 1 to 1. Run the RECONFIGURE statement to install' and then
gives an error 15457. Please help me fix my database.
Thanks in advance.
LeszekHi
Error 15457 is just an informational one. Ig gets generated the Enterprise
Manager and has nothing to do with the Db issue.
If there are no other errors in you event log, it means that SQL is Ok and
your application is the problem.
You may want to make sure that your DB is not set as 'Auto Close' as this
affects performance.
Regards
Mike
"Leszek" wrote:
> Hi
>
> I have a sql 2000 sp3 database running on SBS 2003 that seems to
> ignore any writes after about 2 hours of it being up. It works fine after i
> reboot the server or restart the sql service, but after a couple hours it
> will not edit the database again. If i restart the service, it works fine
> again. Also, i was looking at the sql logs and they are odd. it says
> 'starting up database {my database name}' about 20 times in a row when the
> database is started, then says 'Configuration option 'show advanced options'
> changed from 1 to 1. Run the RECONFIGURE statement to install' and then
> gives an error 15457. Please help me fix my database.
> Thanks in advance.
> Leszek
>
>|||Hi
Db is not set as 'Auto Close'. I have noticed that problem occured when is
more then 100 process in sql .
Regards
Leszek
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:4F13D7AF-1570-47AC-85B5-0515AD58D2AA@.microsoft.com...
> Hi
> Error 15457 is just an informational one. Ig gets generated the Enterprise
> Manager and has nothing to do with the Db issue.
> If there are no other errors in you event log, it means that SQL is Ok and
> your application is the problem.
> You may want to make sure that your DB is not set as 'Auto Close' as this
> affects performance.
> Regards
> Mike
> "Leszek" wrote:
> > Hi
> >
> >
> > I have a sql 2000 sp3 database running on SBS 2003 that seems to
> > ignore any writes after about 2 hours of it being up. It works fine
after i
> > reboot the server or restart the sql service, but after a couple hours
it
> > will not edit the database again. If i restart the service, it works
fine
> > again. Also, i was looking at the sql logs and they are odd. it says
> > 'starting up database {my database name}' about 20 times in a row when
the
> > database is started, then says 'Configuration option 'show advanced
options'
> > changed from 1 to 1. Run the RECONFIGURE statement to install' and
then
> > gives an error 15457. Please help me fix my database.
> >
> > Thanks in advance.
> >
> > Leszek
> >
> >
> >|||The problem here is not going to be an easy one to fix.
There are a couple of things you can look at however to
get a bit closer to the proble.
Firstly have you run the performance monitor to see what
is happening to your server i.e. Disk, Memory and the like.
Secondly you may want to set up a trace to see what
commands are being sent to the server.
Finally another thing you can do is send me a copy of your
database script, I don't need the table definitions, sp,
views or functions, just the configuration options when
you create the database, for security purposes leave the
create database statement in, but change the db name. I
will have a quick look at it and see if I can spot
anything odd.
Finally what is your server specification i.e. ram, hard
disk space ect.
My email if you need it is
peter.nolan@.REMOVETHISpinnacle.co.uk, nb its my work one.
Peter
"The length of this document defends it well against the
risk of its being read."
Winston Churchill
>--Original Message--
>Hi
>Db is not set as 'Auto Close'. I have noticed that
problem occured when is
>more then 100 process in sql .
>Regards
>Leszek
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in
message
>news:4F13D7AF-1570-47AC-85B5-0515AD58D2AA@.microsoft.com...
>> Hi
>> Error 15457 is just an informational one. Ig gets
generated the Enterprise
>> Manager and has nothing to do with the Db issue.
>> If there are no other errors in you event log, it means
that SQL is Ok and
>> your application is the problem.
>> You may want to make sure that your DB is not set
as 'Auto Close' as this
>> affects performance.
>> Regards
>> Mike
>> "Leszek" wrote:
>> > Hi
>> >
>> >
>> > I have a sql 2000 sp3 database running on SBS
2003 that seems to
>> > ignore any writes after about 2 hours of it being up.
It works fine
>after i
>> > reboot the server or restart the sql service, but
after a couple hours
>it
>> > will not edit the database again. If i restart the
service, it works
>fine
>> > again. Also, i was looking at the sql logs and they
are odd. it says
>> > 'starting up database {my database name}' about 20
times in a row when
>the
>> > database is started, then says 'Configuration
option 'show advanced
>options'
>> > changed from 1 to 1. Run the RECONFIGURE statement
to install' and
>then
>> > gives an error 15457. Please help me fix my database.
>> >
>> > Thanks in advance.
>> >
>> > Leszek
>> >
>> >
>> >
>
>.
>|||Aplication works since few monts on other server and there everything is
fine.
Regarding performance monitor. When system works fine and i try to open site
with many difficult query , procesor usage show about 50 % and it take 10
sec - site is loaded. If it doesn't work procesor usage is always about 1%
but i can't load the site.
Sql Profile show that query is sent to server.
Leszek
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:158001c4a221$b242cfc0$a301280a@.phx.gbl...
> The problem here is not going to be an easy one to fix.
> There are a couple of things you can look at however to
> get a bit closer to the proble.
> Firstly have you run the performance monitor to see what
> is happening to your server i.e. Disk, Memory and the like.
> Secondly you may want to set up a trace to see what
> commands are being sent to the server.
> Finally another thing you can do is send me a copy of your
> database script, I don't need the table definitions, sp,
> views or functions, just the configuration options when
> you create the database, for security purposes leave the
> create database statement in, but change the db name. I
> will have a quick look at it and see if I can spot
> anything odd.
> Finally what is your server specification i.e. ram, hard
> disk space ect.
> My email if you need it is
> peter.nolan@.REMOVETHISpinnacle.co.uk, nb its my work one.
> Peter
> "The length of this document defends it well against the
> risk of its being read."
> Winston Churchill
>
> >--Original Message--
> >Hi
> >
> >Db is not set as 'Auto Close'. I have noticed that
> problem occured when is
> >more then 100 process in sql .
> >
> >Regards
> >Leszek
> >
> >
> >"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in
> message
> >news:4F13D7AF-1570-47AC-85B5-0515AD58D2AA@.microsoft.com...
> >> Hi
> >>
> >> Error 15457 is just an informational one. Ig gets
> generated the Enterprise
> >> Manager and has nothing to do with the Db issue.
> >>
> >> If there are no other errors in you event log, it means
> that SQL is Ok and
> >> your application is the problem.
> >>
> >> You may want to make sure that your DB is not set
> as 'Auto Close' as this
> >> affects performance.
> >>
> >> Regards
> >> Mike
> >>
> >> "Leszek" wrote:
> >>
> >> > Hi
> >> >
> >> >
> >> > I have a sql 2000 sp3 database running on SBS
> 2003 that seems to
> >> > ignore any writes after about 2 hours of it being up.
> It works fine
> >after i
> >> > reboot the server or restart the sql service, but
> after a couple hours
> >it
> >> > will not edit the database again. If i restart the
> service, it works
> >fine
> >> > again. Also, i was looking at the sql logs and they
> are odd. it says
> >> > 'starting up database {my database name}' about 20
> times in a row when
> >the
> >> > database is started, then says 'Configuration
> option 'show advanced
> >options'
> >> > changed from 1 to 1. Run the RECONFIGURE statement
> to install' and
> >then
> >> > gives an error 15457. Please help me fix my database.
> >> >
> >> > Thanks in advance.
> >> >
> >> > Leszek
> >> >
> >> >
> >> >
> >
> >
> >.
> >|||Hi Leszek,
Have you used the enterprise manager to see if anything is locking a table
and preventing the updates? Perhaps a certain function or piece of code is
being executed after about 2 hours and that may look like the database won't
accept updates.
Wayne
"Leszek" <aaa@.addressnotexists.com> wrote in message
news:Odc7a3goEHA.2380@.TK2MSFTNGP14.phx.gbl...
> Hi
>
> I have a sql 2000 sp3 database running on SBS 2003 that seems to
> ignore any writes after about 2 hours of it being up. It works fine after
> i
> reboot the server or restart the sql service, but after a couple hours it
> will not edit the database again. If i restart the service, it works fine
> again. Also, i was looking at the sql logs and they are odd. it says
> 'starting up database {my database name}' about 20 times in a row when the
> database is started, then says 'Configuration option 'show advanced
> options'
> changed from 1 to 1. Run the RECONFIGURE statement to install' and then
> gives an error 15457. Please help me fix my database.
> Thanks in advance.
> Leszek
>

Thursday, March 8, 2012

Cannot Upgrade MSDE 2000 Sp3 to SP4

Hi!

Here's the scenario:

I have a MSDE 2000 installation running, already patched to SP3. Instancename is "STO". I've downloaded SQL2000.MSDE-KB884525-SP4-X86-ENU.exe and extracted the archive to C:\SQL2KSP4.

After starting setup from the command prompt with "setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*V C:\MSDELog.log" i get a message box, telling me "The product is not installed". This happens even if I specify the exact instancename and supply the sa user and pwd!

Any ideas?`

Thanks in advance and regards

Clemens

In your command line, you need to specify the instance name and sa pass word. Would you try the following command line?

start /wait setup.exe /qb INSTANCENAME=sto SAPWD="<sa pass word>" SECURITYMODE=SQL

|||

Thx for your reply, but if you look at my post above, you'll see that i also tried that! ;-)

Quote:

"This happens even if I specify the exact instancename and supply the sa user and pwd!"

Rgds

Clemens

|||In your command line, you do not specify the instance name. It is required for an upgrading. Would you check and try?

Friday, February 24, 2012

Cannot shrink the transaction logs.

I have a SQL Server 2000 SP3 database that has a large transaction
file (Size 9384.99 space used 87MB). I would like to shrink it, but
it's not working. I don't get any errors, the file just doesn't get any
smaller.
I'm using the Enterprise Manager. Datavbases.. Tasks.. Shrink
Databases.. Shrink File.. selecting the log file and trying both
"Compress" and "Truncate: options.
I can see a progress bar, so i know its doing something However the
file does not get smaller. And I have no idea why.
Any suggestions (including "go find someone who knows what he's
doing") are welcome
Jim Helfer
WTW Architects
Pittsburgh PACheck out http://www.karaszi.com/SQLServer/info_dont_shrink.asp, and pay special attention to the
section about DBCC LOGINFO.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:eyczNyvSHHA.1200@.TK2MSFTNGP04.phx.gbl...
> I have a SQL Server 2000 SP3 database that has a large transaction file (Size 9384.99 space
> used 87MB). I would like to shrink it, but it's not working. I don't get any errors, the file
> just doesn't get any smaller.
> I'm using the Enterprise Manager. Datavbases.. Tasks.. Shrink Databases.. Shrink File..
> selecting the log file and trying both "Compress" and "Truncate: options.
> I can see a progress bar, so i know its doing something However the file does not get smaller.
> And I have no idea why.
> Any suggestions (including "go find someone who knows what he's doing") are welcome
> Jim Helfer
> WTW Architects
> Pittsburgh PA
>
>

Cannot shrink the transaction logs.

I have a SQL Server 2000 SP3 database that has a large transaction
file (Size 9384.99 space used 87MB). I would like to shrink it, but
it's not working. I don't get any errors, the file just doesn't get any
smaller.
I'm using the Enterprise Manager. Datavbases.. Tasks.. Shrink
Databases.. Shrink File.. selecting the log file and trying both
"Compress" and "Truncate: options.
I can see a progress bar, so i know its doing something However the
file does not get smaller. And I have no idea why.
Any suggestions (including "go find someone who knows what he's
doing") are welcome
Jim Helfer
WTW Architects
Pittsburgh PACheck out http://www.karaszi.com/SQLServer/info_dont_shrink.asp, and pay spe
cial attention to the
section about DBCC LOGINFO.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:eyczNyvSHHA.1200@.TK2MSFTNGP04.phx.gbl...
> I have a SQL Server 2000 SP3 database that has a large transaction file
(Size 9384.99 space
> used 87MB). I would like to shrink it, but it's not working. I don't get
any errors, the file
> just doesn't get any smaller.
> I'm using the Enterprise Manager. Datavbases.. Tasks.. Shrink Databases
. Shrink File..
> selecting the log file and trying both "Compress" and "Truncate: options.
> I can see a progress bar, so i know its doing something However the file
does not get smaller.
> And I have no idea why.
> Any suggestions (including "go find someone who knows what he's doing") a
re welcome
> Jim Helfer
> WTW Architects
> Pittsburgh PA
>
>

Tuesday, February 14, 2012

cannot save storedproc after SP3

hi
we found a bug in EM. we are unable to save/export/transfer a DTS package to
another remote box. is there any workaround or hotfix available?
AlexAlex
See if this helps
http://www.sqldts.com/default.aspx?6,105,204,0,1
Regards
John|||How are you trying ?
File | Save As | SQL Server ?
File | Save As | Structured Storage File ?
Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"alex" <ntnewsNO@.SPAM.hrz3.hrz.tu-darmstadt.de> wrote in message
news:OgI#tPoUDHA.1280@.tk2msftngp13.phx.gbl...
> hi
> we found a bug in EM. we are unable to save/export/transfer a DTS package
to
> another remote box. is there any workaround or hotfix available?
>
> Alex
>|||hi
> How are you trying ?
> File | Save As | SQL Server ?
> File | Save As | Structured Storage File ?
this are 3 "save as" options in SP3 and 4 "save as" options in SP2 and
prior.
the third in SP3 is "Visual Basic File". in SP2 there is another Option
"Save as DTS package file" (sorry - the options is gone - i don't know the
exact name). we need this DTS package option for transfer...
Alex

Sunday, February 12, 2012

Cannot Run SP3

I cannot install SQL 2000 SP3, when I run setup it cannot verify the windows
account logged on and then I try to use the sa password and it cannot verify
that password. I am using the correct password, there are no errors in the
event viewer and the DB is running and accessible. I am running this on
Windows 2000 SP4. Any ideas?
Thanks,
DerekYes i had a client with this problem before , check this article out:
http://support.microsoft.com/?kbid=814844
HTH
Dylan kruger
"Derek" <derekb@.nospamderekb.com> wrote in message
news:u51JTwTjDHA.3204@.tk2msftngp13.phx.gbl...
> I cannot install SQL 2000 SP3, when I run setup it cannot verify the
windows
> account logged on and then I try to use the sa password and it cannot
verify
> that password. I am using the correct password, there are no errors in the
> event viewer and the DB is running and accessible. I am running this on
> Windows 2000 SP4. Any ideas?
> Thanks,
> Derek
>

Cannot restore Report Server to a new machine

Original machine is Windows 2000 with SQL Server 2000 Enterprise SP3 and RS
SP1 all english, new machine is Win2003 with SQL Server 2000 Enterprise SP3
and RS SP1, all german.
The new machine doesn't have the same network name as the original machine.
After a first failed attempt, I decided to start over again on the new
machine:
I de-installed Reporting Services, and reinstalled, applied SP1.
The RS server was functionnal.
I applied the Forms Authentication changes as per the Microsoft article.
The RS server was functionnal.
I restored the ReportServer and ReportServerTempDB from the Win2000 server
and copied the encryption key using rskeymgmt. I made sure that the accounts
on the restored DBs are ok by running sp_change_users_login
I'm still getting the same error:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)
I run rsactivate, and I'm still getting the error.
All possible users have been given SA priviledges on the SQL Server (ASPNET,
IUSR_xxx, the account used by RS to connect to SQL, the local admin and the
administrators group)
Could it be because:
1) You cannot restore a RS server from a Win2000 English machine to a
Win2003 German machine?
2) You cannot restore a RS Server to a server that has a different name?
PS: This is a continuation of post about RSActivate since I have now been
able to narrow down the problem to the reporting server restore, instead of
rsactivate.
Here are the logs, from ReportServer and ReportServerWebApp:
<Header>
<Product>Microsoft SQL Server Reporting Services, Version
8.00.878.00</Product>
<Locale>de-DE</Locale>
<TimeZone>Mitteleuropäische Sommerzeit </TimeZone>
<Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__05_09_2005_14_33_11.log</Path>
<SystemName>xxxxxxTEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!c10!09.05.2005-14:33:11:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: Unable to communicate with report
server. Please verify that the report server is operational.
w3wp!ui!ac!5/9/2005-14:33:15:: e ERROR: HTTP status code --> 500
<Header>
<Product>Microsoft SQL Server Reporting Services, Version
8.00.878.00</Product>
<Locale>de-DE</Locale>
<TimeZone>Mitteleuropäische Sommerzeit </TimeZone>
<Path>C:\Programme\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__05_10_2005_10_05_47.log</Path>
<SystemName>xxxxxTEST</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!a44!10.05.2005-10:05:47:: i INFO: Reporting Web Server started
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!a44!10.05.2005-10:05:47:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!a44!10.05.2005-10:05:47:: i INFO: Running on 0
physical processors, 1 logical processors
w3wp!resourceutilities!a44!10.05.2005-10:05:47:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!a44!10.05.2005-10:05:47:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!af8!05/10/2005-10:06:07:: i INFO: Call to GetPermissions:/
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!af8!05/10/2005-10:06:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.
w3wp!library!af8!05/10/2005-10:06:11:: i INFO: Call to GetSystemPermissions
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:12:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:12:: i INFO: Client is not a local admin.
Not attempting activation.
w3wp!library!af8!05/10/2005-10:06:12:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information.Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you are not able to move Reporting
Services from Windows 2000 to Windows Server 2003. If I have misunderstood
your concern, please feel free to point it out.
Based on my knowlege, we have a Knowledge Base article describes how to
move a Reporting Services database from a computer that is running
Microsoft SQL Server Reporting Services to another computer. You could
follow the step by step in the MORE INFORMATION section
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/kb/842425
From the log file you have posted, I have noticed following entries
=============w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
NT-AUTORITÃ?T\NETZWERKDIENST
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
Not attempting activation.
=============
Though the user can login to SQL machine, this error happens if the logged
user account which is used to run the Rsactivate did not have permission on
the database and database objects in SQL Server, specifically the
reportserver and reportservertempdb.
You should add the user account which is used to run the rsactivate to the
sql server box as a local admin. By default local admin has full privileges
on the database and the database objects. If you cannot add them as local
admin, you can add them just to the reportserver and reportservertempdb.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
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 Michael,
As far as I can tell, I did follow the procedure, and also I did run the
rsactivate as a local admin.
In the meantime, I have opened a support case with Microsoft in Germany.
Many thanks.
"Michael Cheng [MSFT]" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you are not able to move Reporting
> Services from Windows 2000 to Windows Server 2003. If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowlege, we have a Knowledge Base article describes how to
> move a Reporting Services database from a computer that is running
> Microsoft SQL Server Reporting Services to another computer. You could
> follow the step by step in the MORE INFORMATION section
> How to move a Reporting Services database from a computer that is running
> Reporting Services to another computer
> http://support.microsoft.com/kb/842425
> From the log file you have posted, I have noticed following entries
> =============> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Initializing crypto as user:
> NT-AUTORITÃ?â'T\NETZWERKDIENST
> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Exporting public key
> w3wp!crypto!af8!05/10/2005-10:06:07:: w WARN: Web Service not activated
> w3wp!crypto!af8!05/10/2005-10:06:07:: i INFO: Client is not a local admin.
> Not attempting activation.
> =============> Though the user can login to SQL machine, this error happens if the logged
> user account which is used to run the Rsactivate did not have permission on
> the database and database objects in SQL Server, specifically the
> reportserver and reportservertempdb.
> You should add the user account which is used to run the rsactivate to the
> sql server box as a local admin. By default local admin has full privileges
> on the database and the database objects. If you cannot add them as local
> admin, you can add them just to the reportserver and reportservertempdb.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> 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,
Thanks for your understanding, you are welcome to let us know the result
when your case was finally resolved. Share it in the newsgroup and I
believe others will definitely benefit from your contribution.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
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.|||Got a solution after 2 weeks of hard work from PSS.
See resolution under thread "RS Activation is failing"
"Michael Cheng [MSFT]" wrote:
> Hi,
> Thanks for your understanding, you are welcome to let us know the result
> when your case was finally resolved. Share it in the newsgroup and I
> believe others will definitely benefit from your contribution.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> 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 James,
GREAT!
Thanks for your sharing it with us! For others convenience, I post the
RESOLUTION here
--
Newsgroups: microsoft.public.sqlserver.reportingsvcs
From: "James" <aa1...@.nospam.nospam> - Find messages by this author
Date: Fri, 27 May 2005 08:32:10 -0700
Local: Fri,May 27 2005 11:32 am
Subject: RE: RS Activation is failing
I got the solution. One needs to first transfer the 2 databases and restore
them on the new server, copy the encryption key and run rskeymgmt.
Then go to the Report manager so that the RS installation gets activated.
And then and only then, reapply all changes necessary to implement forms
auth.
My problem was that I had copied the 6 config files that are involved in
forms auth from the old server, and there is encrypted info in there that
isn't valid on the new server. Also, activation only works in Windows
authentication mode, that's why one has to start in Windows mode, and only
then move to Forms Auth.
--
Thanks James!! Once more for your efforts!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
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.