Error running report: working

Showing posts with label working. Show all posts

Monday, March 26, 2012

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing?
Thanks in advance
jouj
I've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:

> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing?
> Thanks in advance
> jouj
|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing?
> Thanks in advance
> jouj
sql

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:

> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore t
he
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj

Wednesday, March 21, 2012

Error when exporting to PDF

I am having an issue exporting reports to PDF.

I am connecting to the report server via https and all of the reports I'm using are working fine, but when I try and export the reports to PDF I run into problems.

On one machine running XP when I try and export a report to PDF; it will let me open the PDF, but if I try and 'save' the PDF it gives me an error that the site cannot be found.

On another machine running Windows 2000, I cannot save or open the report when trying to export to PDF with the same site cannot be found popup from Internet Explorer.

Anyone know of anything special that I need to setup to get this working? Could this be a mime type issue on the server?

Any help is greatly appreciated!

Just to add to this..

I am able to export to PDF and open on a machine running Acrobat reader 5.0,and a machine running Acrobat reader 6.0 but not from any computer running Acrobat reader 7.0!

Any ideas?

Error when deploying forms authentication sample

Hello

I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

My particular mistake was in the line Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll" because I had the path wrong. I corrected that and corrected the problem.

Hope this helps.

The RSSrvPolicy.config that has to be changed:

Monday, March 19, 2012

Error when deploying forms authentication sample

Hello

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

Hope this helps.

The RSSrvPolicy.config that has to be changed:

Error when deploying forms authentication sample

Hello

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

Hope this helps.

The RSSrvPolicy.config that has to be changed:

Monday, March 12, 2012

Error when changing sa password or when trying to access DB via sa

Hi,
Two weird things with the sa account, and I found a solution on
Microsoft.com, but it's not working.
First, when I go to change the SA password in Enterprise Manager, I
get the following error:
Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
collection. If the name is a qualified name, use [] to separate
various parts of the name, and try again.
So, I checked the knowledgebase and found this:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
This is the exact issue I'm having, but when I run: sp_changedbowner
sa
... I get the following message in Query Analyzer:
Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
22
Cannot change the owner of the master database.
So, I searched for this error and found this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
Catch-22... I need to change the Master DB to be owned by 'sa', yet it
won't let me change it since it's not already owned. Am I missing
something? This did happen just after I restored a database, just as
discribed in the first support doc, but it gives no exact syntax on
what to plug into Query Analyzer to resolve the issue, other then
using the sp_changedbowner stored procedure. And I must be using it
incorrectly to get the error, or it's another bug in MS SQL.
Can someone point me to the right direction? What should be an easy
back-up and restore is turning into a multi-hour ordeal.
Thanks,
Alex.If your a local admin or domain admin connect to the SQL Server using Query
Analyser and ask for a 'WinNT Authentication' then issue the following
command
A. Change the password of a login without a former password
This example changes the password for the login Victoria from a NULL
password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
In EnterPrise manager Delete and Re-Register the troublesome server, when
registering use the new password.
--
HTH
Ryan Waight, MCDBA, MCSE
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270835.36d6e245@.posting.google.com...
> Hi,
> Two weird things with the sa account, and I found a solution on
> Microsoft.com, but it's not working.
> First, when I go to change the SA password in Enterprise Manager, I
> get the following error:
> Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users
> collection. If the name is a qualified name, use [] to separate
> various parts of the name, and try again.
> So, I checked the knowledgebase and found this:
>
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q218/1/72.ASP&NoWebContent=1#appliesto
> This is the exact issue I'm having, but when I run: sp_changedbowner
> sa
> ... I get the following message in Query Analyzer:
> Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
> 22
> Cannot change the owner of the master database.
> So, I searched for this error and found this:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328173
> Catch-22... I need to change the Master DB to be owned by 'sa', yet it
> won't let me change it since it's not already owned. Am I missing
> something? This did happen just after I restored a database, just as
> discribed in the first support doc, but it gives no exact syntax on
> what to plug into Query Analyzer to resolve the issue, other then
> using the sp_changedbowner stored procedure. And I must be using it
> incorrectly to get the error, or it's another bug in MS SQL.
> Can someone point me to the right direction? What should be an easy
> back-up and restore is turning into a multi-hour ordeal.
> Thanks,
> Alex.|||Yes, you cannot change database owner to MASTER.
If you run sp_helpuser on your restored database, should
show the "LoginName" as NULL if 'sa' do not own it.
You only needed to run sp_changedbowner on your restored
database. -->
use <restored_db>
go
sp_changedbowner 'sa'
go

Friday, February 24, 2012

Error trying to save a date field

Hi there, right now i'm working with a VB6 project that connects to a
SQLSERVER 2000.
I discovered a problem that, i hope you can help me.
The problem is that, when i try to save a record with a date field - the
date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!!
Don't know why.
In order to save a record to DB i try to use val = cdec(val), where val is a
date value, and for strings values i just use val = "'" & val & "'", and so
on... for diferent types of fields.
Because i'm developing for a spanish environment i decided to convert dates
in the right format ("dd/mm/yyyy") and try to have regional settings that
match national language and location.
If anybody can help me, please i will appreciate it.
Felix.You probably represent the date as some umber datatype (float, int or so) an
d the VB "base date"
differs from the SQL Server "base date" by 2 days. Never use numbers to repr
esent datetime in SQL,
represent them as strings. Or better yet, use a date datatype in your host l
anguage and use
parametized queries. Read here about datetime datatype in SQL Server:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in messag
e
news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
> Hi there, right now i'm working with a VB6 project that connects to a
> SQLSERVER 2000.
> I discovered a problem that, i hope you can help me.
> The problem is that, when i try to save a record with a date field - the
> date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!
!
> Don't know why.
> In order to save a record to DB i try to use val = cdec(val), where val is
a
> date value, and for strings values i just use val = "'" & val & "'", and s
o
> on... for diferent types of fields.
> Because i'm developing for a spanish environment i decided to convert date
s
> in the right format ("dd/mm/yyyy") and try to have regional settings that
> match national language and location.
> If anybody can help me, please i will appreciate it.
> Felix.|||Sounds like VB is converting the date to an integer and back again, and
using its own base date (1899-12-30) instead of SQL Server's (1900-01-01).
Try taking the literal string and passing it as a string. If you do this,
be sure to type in a proper format, e.g. YYYYMMDD. If you type in
mm/dd/yyyy there are several points along the way where this can easily
convert to dd/mm/yyyy.
A
"Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in
message news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
> Hi there, right now i'm working with a VB6 project that connects to a
> SQLSERVER 2000.
> I discovered a problem that, i hope you can help me.
> The problem is that, when i try to save a record with a date field - the
> date saved in database is 2 days more that the typed date. ALWAYS 2
> DAYS!!!
> Don't know why.
> In order to save a record to DB i try to use val = cdec(val), where val is
> a
> date value, and for strings values i just use val = "'" & val & "'", and
> so
> on... for diferent types of fields.
> Because i'm developing for a spanish environment i decided to convert
> dates
> in the right format ("dd/mm/yyyy") and try to have regional settings that
> match national language and location.
> If anybody can help me, please i will appreciate it.
> Felix.|||thanks a lot Tibor. My problem is solved - Felix.
"Tibor Karaszi" wrote:

> You probably represent the date as some umber datatype (float, int or so)
and the VB "base date"
> differs from the SQL Server "base date" by 2 days. Never use numbers to re
present datetime in SQL,
> represent them as strings. Or better yet, use a date datatype in your host
language and use
> parametized queries. Read here about datetime datatype in SQL Server:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in mess
age
> news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
>

Friday, February 17, 2012

Error selecting from a database

I have a database running on MSDE it was working fine. Recently when I try to select from the database I am getting the following error after a few records have been returned. All of the tables are giving this problem. Not sure what to do.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Connection Broken
Have you installed SP or changed password? Can you connect to the database
locally using Windows or SQL authentication? Does it fail when you run the
queries locally?
Thanks,
Amy
| Thread-Topic: Error selecting from a database
| thread-index: AcQcwIQNBPeO2TYQSyWHTFoBm4eMiw==
| X-Tomcat-NG: microsoft.public.sqlserver.msde
| From: =?Utf-8?B?V2FycmVu?= <anonymous@.discussions.microsoft.com>
| Subject: Error selecting from a database
| Date: Wed, 7 Apr 2004 09:51:04 -0700
| Lines: 6
| Message-ID: <B1588E26-CFBE-441B-A743-E607EB44679D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13485
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| I have a database running on MSDE it was working fine. Recently when I
try to select from the database I am getting the following error after a
few records have been returned. All of the tables are giving this problem.
Not sure what to do.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.
Connection Broken
|
|||Thanks Amy
I don't have a problem connecting to the database locally or remotely. I also haven't installed or change
anything recently but for some reason or another it will not run a simple select query.

Monday, March 26, 2012

Error when restoring master database

Error when restoring master database

Error when restoring master database

Wednesday, March 21, 2012

Error when exporting to PDF

Error when deploying forms authentication sample

Monday, March 19, 2012

Error when deploying forms authentication sample

Error when deploying forms authentication sample

Monday, March 12, 2012

Error when changing sa password or when trying to access DB via sa

Friday, February 24, 2012

Error trying to save a date field

Friday, February 17, 2012

Error selecting from a database

Error running report

Blog Archive

About Me