Error accessing registry value in report

We store environment specific information in the registry to ease moving from
dev, test and production environments. I'm making a call in the code window
to read from the registry and am getting this error:
Failed to load expression host assembly. Details: Request for the permission
of type System.Security.Permissions.RegistryPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
(rsProcessingError) Get Online Help
Just as a test I've changed all code access security zones to Full Trust but
this hasn't helped.
Please advise.This is what I had to do to get this working, if anyone's interested:
Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rssrvpolicy.config and modify the entry in the
Report_Expressions_Default_Permissions CodeGroup and change it from Execute
to FullTrust.
"Aaron" wrote:
> We store environment specific information in the registry to ease moving from
> dev, test and production environments. I'm making a call in the code window
> to read from the registry and am getting this error:
> Failed to load expression host assembly. Details: Request for the permission
> of type System.Security.Permissions.RegistryPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> (rsProcessingError) Get Online Help
> Just as a test I've changed all code access security zones to Full Trust but
> this hasn't helped.
> Please advise.
>|||Giving FullTrust to Report_Expressions_Default_Permissions totally opens
your server for hacker attacks. Now all expressions incliding VB.NET
snippets in Report.Code have fulltrust which allows them to perform any
operations, including formatting drives, reading and writing files etc...
The better way is to create a custom assembly with functions to read
registry and call this assembly from your reports. You will then give only
RegistryPermission to that assembly.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:281FF58C-043F-40DA-AFCF-4C413BFC2A49@.microsoft.com...
> This is what I had to do to get this working, if anyone's interested:
> Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\rssrvpolicy.config and modify the entry in the
> Report_Expressions_Default_Permissions CodeGroup and change it from
Execute
> to FullTrust.
>
> "Aaron" wrote:
> > We store environment specific information in the registry to ease moving
from
> > dev, test and production environments. I'm making a call in the code
window
> > to read from the registry and am getting this error:
> >
> > Failed to load expression host assembly. Details: Request for the
permission
> > of type System.Security.Permissions.RegistryPermission, mscorlib,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
> > (rsProcessingError) Get Online Help
> >
> > Just as a test I've changed all code access security zones to Full Trust
but
> > this hasn't helped.
> >
> > Please advise.
> >|||Aaron I have done similar kind of thing, If your still facing the problem
write to me, I can help you out to fix the issue.
My Email ID:
balajikkrishnan [AT] rediffmail [DOT] com
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comsql

Error accessing database

When I launch a client program that reads the database, I
get the following error message
Error while reading information from database
Error Code Login failed for user 'sa'
Reason Not associated with a trusted SQL Server Connection.
Has anyone got ideas on how to Fix this?
Thanks in advance
DarrinHave a look at the server properties. You should see that the server is set
up to use Windows Authentication only. sa is not a windows account. You
are using sa in a client app. Most people would advise against this.
--
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
"Darrin" <darrin.adams@.eei.ericsson.se> wrote in message
news:0a6801c3510d$b546da10$a501280a@.phx.gbl...
> When I launch a client program that reads the database, I
> get the following error message
> Error while reading information from database
> Error Code Login failed for user 'sa'
> Reason Not associated with a trusted SQL Server Connection.
> Has anyone got ideas on how to Fix this?
> Thanks in advance
> Darrin

Error access Custom Assembly in Deploying

Please,

i did a class in C# that return a array of bytes... in preview mode (design) i can see this return, but when i use Deploy (Server) i can′t see.

I already put the lines on of security in file srrsvpolicy.config and copy the file dll to folder, however i cant see the result.

Anybody help me?

I′m using:

- SQL 2005
- dll no strong name

Thanks

Jota

Assuming you have put the right security settings and deployed the assembly to the Report Server bin folder, your method may need additional CAS security rights depending on what your code is trying to do, as explained in more details here. What I suggest you do is put a breakpoint in your assembly code, attach to the ASP.NET process, and run the report so you can debug your code and see where the exception is thrown.

Error accesing RS

I change the windows authentication from the default site folder security and before I change again to windows authentication. But now when I want to open reportmanager It raises Unable to generate a temporaty class (result=1) . error CS2001: Source file 'C:\WINDOWS\TEMP\ugmf4j6-0.cs' could not be found error CS2008: No inputs specified.

Any ideas?
RS Services April CTP.
Thanks in advanceI need to solve this quickly!!! I have a presentation with a director.

I thinking in reinstall IIS.

What can I do?|||I found no solution to this. I finally reinstalled IIS.

Error accepting connection request via Net-Library 'SSNETLIB'

Hi,
I installed SP3 over SQL2K on NT Server SP6. The Server
hangs on startup. This is after I did an upgrade
installation of SQL 7 to SQL Server 2000 and applied SP3
over it. Everything runs fine for afew hours and then we
get the message below and some of our servers lose the
ability to connect to the sql server.
2003-12-18 10:20:08.84 spid65 Using 'xp_AltaMX.dll' version
'0002.00.00' to execute extended stored
procedure 'xp_AltaMX'.
2003-12-18 11:01:49.43 spid62 Using 'xpipass.dll'
version 'UNKNOWN'to execute extended stored
procedure 'xp_ipass_actualiza'.
2003-12-18 12:24:01.62 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:24:01.62 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:24:01.62 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:24:01.62 server Operating system error 1:
Incorrect function...
2003-12-18 12:31:58.09 server SQL Server could not spawn
process_loginread thread.
2003-12-18 12:31:59.09 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:31:59.09 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:31:59.09 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:31:59.09 server Operating system error 1:
Incorrect function...
2003-12-18 12:41:30.01 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:41:30.01 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:41:30.01 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:41:30.01 server Operating system error 1:
Incorrect function...
2003-12-18 12:51:21.10 server SQL Server is disallowing new
connections due to 'pause' request from Service Control
Manager.
2003-12-18 12:53:09.60 spid3 SQL Server is terminating due
to 'stop' request from Service Control Manager.
I would be greatful if anyone has any ideas on how to deal
with this ?
I already reviewed this article but me it has not been
helpful.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;811887&Product=sql2k
I am of course afraid that someday we will not be able to
access the
sql server.
Regards,
LeoWho supplied you with
xp_AltaMX
xpipass.dll
xp_ipass_actualiza
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
The development area supplied them. Let me tell you=20
something, when this server was working under SQL 7, this=20
error never appeared. After upgrade the error appeared.
Do you think that the problem may be are the xp=B4s?
thanks,
Leo|||Drop /remove the xp's and see if the problem persists. Do this in your
Test environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Error about Report builder

I login in my server do report with report builder , when i run report , the error is:

The permissions granted to user 'ADSYSTEC-CZW\users11' are insufficient for performing this operation.

1. The server and my machine are not the same computer,My machine name is adsystec-czw.

2. The reports web site's Authentication is Integrated Windows Authentication.

3. I use the given user(users11) login in belongs to the user groups.

thanks for helps!

Since you are saying you get the error when running the report, I am assuming you have no problem launching Report Builder, viewing Models, and creating and saving a Report to the server. Have you tried running your report directly from the server, after saving it there?

It sounds like your problem may be that the datasource your report uses is not set up correctly. If the data you are trying to retrieve is on a different server than your Report Server, you may need to check the "Use Windows credentials" checkbox in (ie. edit your Datasource in Report Manager).

|||I login in the server's report builder with the URL http://adsystec-czw/reportserver/reportbuilder/reportbuilder.application If I use the server's administrators to login in the server's report server, That error doesn't exist.

Error about OLAP Admin permissions

Hi iam executing this code and iam getting the error

Unable to connect to the registry on the server (SQLSERVER), or you are not a member of the OLAP Administrators group on this server.

The code is

Private Sub cbDataBaseList_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbDataBaseList.SelectedIndexChanged

Dim dsoServer As New DSO.Server

Dim dsoDB As DSO.MDStore

Dim dsoCube As DSO.MDStore

' Create a connection to the Analysis server.

dsoServer.Connect("Localhost")

' Step through the databases in the server object.

For Each dsoDB In dsoServer.MDStores

' Print the name of the database into drop down box

cboDbName.Items.Add(dsoDB.Name)

Next dsoDB

listCubes.Items.Clear()

Dim strDataBaseName As String
strDataBaseName = cbDataBaseList.SelectedItem

Dim dsoDb As DSO.MDStore

If dsoServer.MDStores.Find(strDataBaseName) Then

dsoDb = dsoServer.MDStores.Item(strDataBaseName)

Dim dsoCube As DSO.MDStore
For Each dsoCube In dsoDb.MDStores
listCubes.Items.Add(dsoCube.Name)
Next

End If

End Sub

I donno whats that error and how to fix it if some one could help me it would be great.

Thank You

Emily

There are two common causes of this error that I am aware of

1) You are not a member of the OLAP Administrators group on the server (obviously, but I assume you have double checked this)

2) The server has had a service pack applied, but the client has an older version of the DSO libraries.

If item 1) is not your issue then what I would suggest is to find out what service pack has been applied to the server.

To find out the current level of Windows 2000 Analysis Services, start the Analysis Manager, right-click on the Analysis Servers node, and select "About Analysis Services." (Note that this tells you the SP that is on the machine running Analysis Manager - so you might want to run this check on the server console)

Once you have the version number, then match it to the list below to find which SQL Server service pack you are using.

2000.8.0.2039 Analysis Services SP 4 2000.8.0.760 Analysis Services SP 3 2000.8.0.532 Analysis Services SP 2 2000.8.0.382 Analysis Services SP1 2000.8.0.194 Analysis Services "gold" release, no SP

Error 954: Database has invalid schema - SQL2000

I'm restoring a database on another server, the restore from disk goes
through successfully, until I try to click on tables or views I get the
message below:
Error 954: Database 'dbname' has invalid schema
Thanks in advance for any help.ITDUDE27,
Are you using SharePoint and Small Business Server? If so, here are a
couple of links:
http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
I do have one weird thought: it sounds as if the file location for the files
in the database does not match the actual file locations of the mdf and/or
ldf. Did you use the MOVE option during the RESTORE in order to position
the files properly?
Other than that, I have no really useful suggestions.
RLF
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> I'm restoring a database on another server, the restore from disk goes
> through successfully, until I try to click on tables or views I get the
> message below:
> Error 954: Database 'dbname' has invalid schema
> Thanks in advance for any help.
>|||Thanks Russ.
I'am running SP on SBS 2003. my Live sharepoint site is running fine and I
was able to install SP 2.0 on another server and it came up fine. I trying to
restore a copy of the live db as test and that is what is causing the error.
I had seen the second link you refered too, it was not help full. The point
of this exercise is to restore the sp database using Enterprize manager and
query it and then map it as my SP content database.
I've tried the move command using osql with no success. I think you are
absoluty correct about the Move, I'm just not having any luck, which ever way
I restore the SP db I get the same message.
Thanks in advance for any other feedback.
"Russell Fields" wrote:
> ITDUDE27,
> Are you using SharePoint and Small Business Server? If so, here are a
> couple of links:
> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
> I do have one weird thought: it sounds as if the file location for the files
> in the database does not match the actual file locations of the mdf and/or
> ldf. Did you use the MOVE option during the RESTORE in order to position
> the files properly?
> Other than that, I have no really useful suggestions.
> RLF
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > Thanks in advance for any help.
> >
> >
>
>|||Russell,
Can you comfirm the syntax for me.
Current location: N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche.bak from other server
New location: N:\Program Files\Microsoft SQL Server\MSSQL\Data
RESTORE DATABASE avalanche_new FROM DISK = 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche.bak'
WITH
MOVE 'northwind' TO 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche_new.mdf'
MOVE 'northwind_log' TO 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche_log.ldf'
Thanks in advance.
"Russell Fields" wrote:
> ITDUDE27,
> Are you using SharePoint and Small Business Server? If so, here are a
> couple of links:
> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
> I do have one weird thought: it sounds as if the file location for the files
> in the database does not match the actual file locations of the mdf and/or
> ldf. Did you use the MOVE option during the RESTORE in order to position
> the files properly?
> Other than that, I have no really useful suggestions.
> RLF
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > Thanks in advance for any help.
> >
> >
>
>|||ITDUDE27,
Syntax looks correct, but the code does not match your spec. Compare:
N:\Program Files\Microsoft SQL Server\MSSQL\Data
N:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\avalanche_new.mdf
If N:\ is a network drive that is not a supported configuration for SQL
Server databases. You will need to place the database files on locally
attached storage or on your SAN.
And, of course, I assume that the 'northwind%' logical names are correct.
I also usually specify a couple of things that should not be necessary in my
RESTORE command. Habit, you know, but I include the options:
RECOVERY, REPLACE
FWIW,
RLF
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:F7C1965F-448C-44F1-8DEF-9860E15E1A86@.microsoft.com...
> Russell,
> Can you comfirm the syntax for me.
> Current location: N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche.bak from other server
> New location: N:\Program Files\Microsoft SQL Server\MSSQL\Data
>
> RESTORE DATABASE avalanche_new FROM DISK = 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche.bak'
> WITH
> MOVE 'northwind' TO 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche_new.mdf'
> MOVE 'northwind_log' TO 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche_log.ldf'
> Thanks in advance.
>
> "Russell Fields" wrote:
>> ITDUDE27,
>> Are you using SharePoint and Small Business Server? If so, here are a
>> couple of links:
>> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
>> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
>> I do have one weird thought: it sounds as if the file location for the
>> files
>> in the database does not match the actual file locations of the mdf
>> and/or
>> ldf. Did you use the MOVE option during the RESTORE in order to position
>> the files properly?
>> Other than that, I have no really useful suggestions.
>> RLF
>> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
>> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
>> > I'm restoring a database on another server, the restore from disk goes
>> > through successfully, until I try to click on tables or views I get the
>> > message below:
>> >
>> > Error 954: Database 'dbname' has invalid schema
>> >
>> > Thanks in advance for any help.
>> >
>> >
>>

Error 954: Database 'dbname' has invalid schema

I'm restoring a database on another server, the restore from disk goes
through successfully, until I try to click on tables or views I get the
message below:
Error 954: Database 'dbname' has invalid schema
any thoughts?Hi
Can you provide us with more info? What is the version are you using? Do you
try restore from SS2000 to SS2005?
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:35AE8C40-3659-44DB-BABB-8B65D1223181@.microsoft.com...
> I'm restoring a database on another server, the restore from disk goes
> through successfully, until I try to click on tables or views I get the
> message below:
> Error 954: Database 'dbname' has invalid schema
> any thoughts?|||Thanks for the response uri.
I'm doing the restore on SS2000 to SS2000. I'm trying to test the install of
WSS3.0 on a test environment but the restore is displaying that error.
Thanks in advance.
"Uri Dimant" wrote:
> Hi
> Can you provide us with more info? What is the version are you using? Do you
> try restore from SS2000 to SS2005?
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:35AE8C40-3659-44DB-BABB-8B65D1223181@.microsoft.com...
> >
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > any thoughts?
>
>

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.
sql

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.|||

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.sql

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level to
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?
Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?
|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:

> I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level to
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:
> I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi, you are right my log file did not have enough space, however, do you know
what these messages mean?
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
Does it mean its upgrading the DB from 70 compatibility to 80'
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> For an Upgrade, SQL Server needs space in the transaction log to work. You
> don't have enough.
> On the SQL Server 7.0, before you make the backup, dump the log, grow the
> transaction log to at least 10% of the database size, then do the backup and
> then the restore the SQL Server 2000.
> Regards
> Mike
> "Pari" wrote:
> > I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> > SQL Server 2000 @. 70 compatibility level.
> >
> > But when execute restore stmt (cmd), I keep getting the errors:
> >
> > Server: Msg 9002, Level 17, State 6, Line 2
> > The log file for database 'my_db' is full. Back up the transaction log for
> > the database to free up some log space.
> > Server: Msg 3013, Level 16, State 1, Line 2
> > RESTORE DATABASE is terminating abnormally.
> > Converting database 'my_db' from version 515 to the current version 539.
> > Database 'my_db' running the upgrade step from version 515 to version 524.
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
> > Database 'my_db' running the upgrade step from version 529 to version 530.
> > Database 'my_db' running the upgrade step from version 530 to version 531.
> > Database 'my_db' running the upgrade step from version 531 to version 532.
> > Database 'my_db' running the upgrade step from version 532 to version 533.
> > Database 'my_db' running the upgrade step from version 533 to version 534.
> > Database 'my_db' running the upgrade step from version 534 to version 535.
> > Error 946: Cannot open database upgrade the database to the latest version
> >
> >
> > Any idea, how I can restore w/o errors?

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level t
o
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:

> I am trying to move a database from SQL Server 70 @. 70 compatibility level
to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?sql