Cant Access a Database via the Database Explorer

Hi,

I have been able to view the databases and all of their tables but now when I cilck the "+" next to the database or try to connect a new one i get an error message:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user Instances enabled' to generate user instances"

I don't know what I have done and I don't know how to fix it, Please help me!

Best regards,

Elliot

I would do a backup first, before trying anything! Two backups!

It sounds like Sql Server wants you to enter the following command in a query window:

exec sp_configure 'user Instances enabled'

But you might want to google on that first...

|||

Thanks you didn't answer it 100% but I googled it and found the answer in another forum:http://www.mydatabasesupport.com/forums/sqlserver-faq/339672-generating-user-instances-sql-server-disabled.html

Thanks for your help,

Elliot

cannot view wsdl of endpoint.

i created this endpoint in SSMS:

Code Snippet

/****** Object: Endpoint [first_Endpoint] Script Date: 06/19/2007 16:39:22 ******/

CREATEENDPOINT [first_Endpoint]

AUTHORIZATION [Domain\username]--scrubbed my username out of post!

STATE=STARTED

ASHTTP(PATH=N'/sql',

PORTS=(CLEAR),

AUTHENTICATION=(NTLM,KERBEROS,INTEGRATED),

SITE=N'sitename,

CLEAR_PORT= 80,

COMPRESSION=DISABLED)

FORSOAP(

WEBMETHOD 'provideInfo'(NAME=N'[adventureworks].[dbo].[uspGetBillOfMaterials]'

,SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS),BATCHES=DISABLED,

SESSIONS=DISABLED,SESSION_TIMEOUT=60,

DATABASE=N'AdventureWorks',

NAMESPACE=N'http://tempuri.org/',

SCHEMA=STANDARD,

CHARACTER_SET=XML)

When i type http://localhost/sql/provideinfo?wsdl into internet explorer, i just get a 404 page cannot be found error.

When i type http://server/sql/provideinfo?wsdl in to the browser i get a Page cannot be displayd error.

I get the same when i type http://myServerName/sql/provideinfo?wsdl

I get the same when i type http://sitename/sql/provideinfo?wsdl

Sql server is running under an account with admin access to the box and sa access to the sql server. what am i doing wrong here that i cannot view my wsdl. oh, the OS is vista.

Could it be a configuration issue that im not seeing?

Can you try the following?
http://localhost/sql?wsdl

See also http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1372924&SiteID=1|||i tried http://localhost/sql?wsdl but still get a 401 not found error. as i am not getting the error speicifed in the link you provided, it would make me think that it is unrelated to my issue. thanks for the reply though.|||

when i use http://server/sql?wsdl i get a 502 error, a connection could not be made as the server actively refused it.

Are there some network settings i should change on my machine possibly?

|||Is server here the same name which you specified in SITE?|||no. the server and the site have different names. I have tried the url both ways though. when i specify the servername in the url, i get an iis page not found error. when i try with the sitename, i get a page cannot be displayed error.|||

The way the 'SITE' keyword value is treated is that it is passed to the OS HTTP.sys service. The HTTP.sys service uses a combination of information to determine which process to redirect the HTTP request to. In this scenario, only HTTP requests send to http://sitename/sql are redirected to this SQL Server endpoint. So, unless machine running SQL Server is named 'sitename', it is very unlikely that the HTTP request will get to SQL Server.

If possible, I recommend changing the SITE value to '*' or the actual machine name.

BTW, I believe the default value for the WSDL generation is NONE, so ?wsdl will get you a 502 HTTP error.

Jimmy

|||

Hi Jimmy.

That indeed was the problem!!! i dropped the endpoint, changed the site name to the name of the pc the endpoint is hosted upon and bingo!!!! cant believe i was so stupid in the first place!!!! it makes total sense now that i look at it! I expected to see the page that comes up when you view the definition of an enpoint in IE, but i also realise that that wont happen. i just see a lot of xml making up the wsdl file, and thats what i required. Thanks for the help and suggestions everyone, and Jimmy, for the answer that gave me the required results.

Cannot view the DTS

Hi ,

I have DTS created in my Development server using the save as option i tried to save it in my production server . All these works fine . But when i logged in to the production server i could not see the DTS . But when we tried loging to the prodcution server using the data base administrator passed we were able to see the DTS and the owner of the DTS is seems to be not a admin person rather it is me.

Why is that i am not able to view the DTS when i logged in with my user id ?

Can any on help us in resolution this issue .

Thanks

K.Karthik Doss

refer this... it may help u ... http://www.sqldts.com/212.aspx

Madhu

|||

Hi Madhu

Thnaks for the efforts . I think i have not made it clear for you .the problem what we have the DTS in the production server but the Owner is not able to view the DTS . but we were able to see the DTS in DB admin access . so what should be done to view the dts in the owners login .

Thanks

K.Karthik Doss

|||

have u checked the owner of this DTS in Production server... Is it still the same ?

Madhu

|||If your login is not a part of SYSADMIN group on the production server, then what you are getting is by default. If that package is owned by SA then only SYSADMIN privileged uses can view or edit.|||

Yes i was able to view the DTS thru the DB Admin userID and Password and the owner is me. But i could not view it when i logged in thru my UserID and Password .

|||

say if the package is owned by SA then how do i change that to a comman , Like if any one logs in to the system can view that package .

|||

AFAIK... there is not direct method in SQL Server 2000 ... yes u have Specific role available in SQL Server 2005(db_dtsadmin,db_dtsltduser etc)... in SQL 2000, if all the users want to view the package owned by others ... then u need to add all of them in SysAdmin Role, which is not recommened atall ..

Madhu

Cannot view sql server object properties in vstudio .net 2003

Hi!

Sudenly I stoped being able to view sql server object properties in the visual studio properties window . When I selected an sql server object in the server explorer i could see its properties in the prop. window . Now I can't see them anymore, the properties window apears blank.

Can anyone tell what do I need to do to be able to view them again.

Thanks & Best Regards
Pedro CostaHey-

I'm having this exact same problem. I'm researching to see if I can find anything, so if you beat me to it, please post the fix here. I'll do the same.|||What has changed between the time you COULD see them and right now? Did you install something? Apply a service pack? Remove something?|||I uninstalled VS.NET and installed VS.NET 2003. I'm using MSDE, BTW. I'm currently uninstalling and reinstalling MSDE, just for kicks. We'll see if it makes any difference. I'm wondering if the issue is permissions related somehow? But I'm logged in as a user with full admin rights on this machine, and I was under the impression that the IDE uses windows auth to connect to the database. Is this correct?
I've poked throught the environment preferences and I don't see anything that looks pertinent.

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476[/url]
BUTTONS:
OK
Everything else in the Management Studio works fine. Can anyone
interpret this?
I can't interpret or solve, but I can confirm that it also happens on our
clusters.

> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
--
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
--
BUTTONS:
OK
--
Everything else in the Management Studio works fine. Can anyone
interpret this?I can't interpret or solve, but I can confirm that it also happens on our
clusters.
> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>|||Interesting...I found out that when I was trying to view the logs, for
some reason it was trying to direct me to the virtual servername used
by the Data Group of the cluster. I don't know why it would do that.
I created an alias for the data group name, and pointed it to the ip
address of the sql server instance, and it connects properly now.
Not sure if I explained this right, I'm kinda new to clusters, but
hopefully this will help you.
Aaron Bertrand [SQL Server MVP] wrote:
> I can't interpret or solve, but I can confirm that it also happens on our
> clusters.
>
>
> > Everything else in the Management Studio works fine. Can anyone
> > interpret this?
> >

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink?Prod...=0&LinkId=20476
BUTTONS:
OK
--
Everything else in the Management Studio works fine. Can anyone
interpret this?I can't interpret or solve, but I can confirm that it also happens on our
clusters.

> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>|||Interesting...I found out that when I was trying to view the logs, for
some reason it was trying to direct me to the virtual servername used
by the Data Group of the cluster. I don't know why it would do that.
I created an alias for the data group name, and pointed it to the ip
address of the sql server instance, and it connects properly now.
Not sure if I explained this right, I'm kinda new to clusters, but
hopefully this will help you.
Aaron Bertrand [SQL Server MVP] wrote:[vbcol=seagreen]
> I can't interpret or solve, but I can confirm that it also happens on our
> clusters.
>
>

Cannot View Server Logs

I have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh. If I doule click nothing happens. I can view the Activity Monitor and the processes going.

I am sure it is a permission thing or something along those lines. I can not for the life of me figure it and have spent a couple days on google and these forums. I have tried with the SA, my defined users, and the local windows administrator. Is log viewing not allowed in SQL Server Express?

Thanks!

Michael

hi Michael,

SSMSE does not provide that feature.. if you like to inspect the SQL Server log files, you can navigate to the \Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG folder and open the ERRORLOG file with Notepad, as it's just plain text..

regards

|||Thanks, good to know I am not crazy.

So does any of the Express additions support logging? I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.

Thanks!
Michael
|||

hi Michael,

wait a moment ...

SQLExpress logs it's "system" activities to the SQL Server Errolog file(s) as full blown editions do.. just the SSMSE tool does not provide a direct way to view the errorlog file(s)...

>I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.
this is another story... all SQL Server editions use the database's transaction log file(s).. but you can not directly inspect those files as no public API exists... there's a bunch to third party tools like Luminigent's Log Explorer that can perform that task, but you probably looking for another feature as well.. your last sentence implies the use of Profiler, but this tool is not available with the Express edition... you can use SQL Traces, the underlying architecture used by Profiler, but with no graphical tool to examine results/setting options..

regards

|||Wow I did not expect it to be so annoying to just watch incoming queries into the server.

There is nothing like mysqls logging where I can log incoming queries to a file?

$1000 to view some logs is alot...

Thanks!
Michael
|||

hi Michael,

not directly... but, again, you can start your own trace to capture server's activity..

regards

Cannot view reports, SSRS on Vista

Hello!
I have installed/configured SSRS on a Vista-laptop but I cannot view reports
in IE.
Finally, I got the reportserver running under IIS 7.0.The report works fine
in VS2005 and deployment (finally!!) works fine from the editor.
But the infamous 'rsReportNotReady'-error shows once I try to view a report.
Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
shows the reportServer root-directory. And the same thing happens if I
create a dumb .aspx-file and put into the reportServer/Pages directory.
The installation has been hellish so far, and I have read SO many blogs and
tips but nothing works...
* Yes, I have tried to turn off database snapshot isolation level for the
SSRS-databases
* Yes, I have installed Service Pack 2 (twice)
Im hoping for your help, as I see no path to a solution for this mystery!
Cheers DavidTwo things to try (I have never done this, this is from the newsgroup).
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
My advice is to try #1 first. I have seen this multiple times. As far as #2,
that I have only seen once in the newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I have installed/configured SSRS on a Vista-laptop but I cannot view
> reports in IE.
> Finally, I got the reportserver running under IIS 7.0.The report works
> fine in VS2005 and deployment (finally!!) works fine from the editor.
> But the infamous 'rsReportNotReady'-error shows once I try to view a
> report.
> Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> shows the reportServer root-directory. And the same thing happens if I
> create a dumb .aspx-file and put into the reportServer/Pages directory.
> The installation has been hellish so far, and I have read SO many blogs
> and tips but nothing works...
> * Yes, I have tried to turn off database snapshot isolation level for the
> SSRS-databases
> * Yes, I have installed Service Pack 2 (twice)
> Im hoping for your help, as I see no path to a solution for this mystery!
> Cheers David|||I managed to get thíngs running by un-installing the whole SQL-server package.
(I believe that I might have had a mix-up of editions installed)
Took me anothier full two hours, but now the thing works!
Thx for helping out!
David
"Bruce L-C [MVP]" wrote:
> Two things to try (I have never done this, this is from the newsgroup).
> 1) Control Panel / User Accounts / Turn User Account Control - off
> 2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
> My advice is to try #1 first. I have seen this multiple times. As far as #2,
> that I have only seen once in the newsgroup.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
> news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> > Hello!
> >
> > I have installed/configured SSRS on a Vista-laptop but I cannot view
> > reports in IE.
> >
> > Finally, I got the reportserver running under IIS 7.0.The report works
> > fine in VS2005 and deployment (finally!!) works fine from the editor.
> >
> > But the infamous 'rsReportNotReady'-error shows once I try to view a
> > report.
> >
> > Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> > shows the reportServer root-directory. And the same thing happens if I
> > create a dumb .aspx-file and put into the reportServer/Pages directory.
> >
> > The installation has been hellish so far, and I have read SO many blogs
> > and tips but nothing works...
> >
> > * Yes, I have tried to turn off database snapshot isolation level for the
> > SSRS-databases
> > * Yes, I have installed Service Pack 2 (twice)
> >
> > Im hoping for your help, as I see no path to a solution for this mystery!
> >
> > Cheers David
>
>

Cannot View Reports in Report Manager

Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.

Cannot view reports but able to see ReportManager from different

My RS was installed on server which is accessed from 2 domains (lets
named Domain1 and Domain2).
Server belongs to Domain1 and RS service has admin privileges on
Domain1 as well. Viewing reports on Domain1 cause no problem. But I
have users in Domain2. They have got RUSER server role to access to RS
with Windows Auth.
When I open reports on Domain2 I could see Report Manager home page,
but when I click report I get "Internet Explorer cannot display the
webpage".
Is it possible to have access from 2 different domains to RS?
Any help appreciate.
Regards,
BartekAre the domains trusted? Does Domain1 trust Domain2?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> My RS was installed on server which is accessed from 2 domains (lets
> named Domain1 and Domain2).
> Server belongs to Domain1 and RS service has admin privileges on
> Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> have users in Domain2. They have got RUSER server role to access to RS
> with Windows Auth.
> When I open reports on Domain2 I could see Report Manager home page,
> but when I click report I get "Internet Explorer cannot display the
> webpage".
> Is it possible to have access from 2 different domains to RS?
> Any help appreciate.
> Regards,
> Bartek|||Yes, both domains are trusted.
Bartek
On 4 Kwi, 17:50, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Are the domains trusted? Does Domain1 trust Domain2?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bartolo" <andrew...@.gmail.com> wrote in message
> news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> > My RS was installed on server which is accessed from 2 domains (lets
> > named Domain1 and Domain2).
> > Server belongs to Domain1 and RS service has admin privileges on
> > Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> > have users in Domain2. They have got RUSER server role to access to RS
> > with Windows Auth.
> > When I open reports on Domain2 I could see Report Manager home page,
> > but when I click report I get "Internet Explorer cannot display the
> > webpage".
> > Is it possible to have access from 2 different domains to RS?
> > Any help appreciate.
> > Regards,
> > Bartek

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

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

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

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

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

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

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot View Report Manager

OK.. I'm stumped.
My IE 7 is working fine. I can access any websites I want with one
exception. What is this exception?
I recently installed MS Reporting Services 2000 on this computer. All went
well.
When I try to access the http:// site where all of my reports have been
deployed, IE 7 shows a blank page with the message:
"Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
during the DNS lookup. Contact your system administrator if the problem is
not found by retrying the URL.
I have tried using another Browser (Firefox) on this computer and it
accesses the page just fine. I have even went one step further by trying to
access the http site
from another computer (also using IE7) via an Intranet. It works fine.
This is the only webpage that is not working.
Where can I make changes? It is not asking me for a password. It is not
even partially bringing up the webpage.
I have tried clearing all history inside IE7. I have tried to check the
settings in
the IIS section. I have updated my IE7. I have even uninstalled IE7 and
tried to use IE6 but to no avail. I am using XP Professional.
I don't know where to look next! Is it a Reporting Services issue? IIS
issue? IE7 issue?
Any suggestions would be welcomed.
PatOn Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
<PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> OK.. I'm stumped.
> My IE 7 is working fine. I can access any websites I want with one
> exception. What is this exception?
> I recently installed MS Reporting Services 2000 on this computer. All went
> well.
> When I try to access the http:// site where all of my reports have been
> deployed, IE 7 shows a blank page with the message:
> "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> during the DNS lookup. Contact your system administrator if the problem is
> not found by retrying the URL.
> I have tried using another Browser (Firefox) on this computer and it
> accesses the page just fine. I have even went one step further by trying to
> access the http site
> from another computer (also using IE7) via an Intranet. It works fine.
> This is the only webpage that is not working.
> Where can I make changes? It is not asking me for a password. It is not
> even partially bringing up the webpage.
> I have tried clearing all history inside IE7. I have tried to check the
> settings in
> the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> tried to use IE6 but to no avail. I am using XP Professional.
> I don't know where to look next! Is it a Reporting Services issue? IIS
> issue? IE7 issue?
> Any suggestions would be welcomed.
> Pat
This link might be helpful.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Yes... your suggestion worked like a charm. I made the adjustment in IE7.
While I believe that this approach did solve the problem, I cannot say that
it was the exclusive controlling factor. You see, I also un-installed RS
2000 and re-installed it again. My belief is that your recommendation was
the determining factor and not the reinstall of RS 2000.
Thank you.
Pat
"EMartinez" wrote:
> On Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
> <PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> > OK.. I'm stumped.
> >
> > My IE 7 is working fine. I can access any websites I want with one
> > exception. What is this exception?
> >
> > I recently installed MS Reporting Services 2000 on this computer. All went
> > well.
> > When I try to access the http:// site where all of my reports have been
> > deployed, IE 7 shows a blank page with the message:
> >
> > "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> > during the DNS lookup. Contact your system administrator if the problem is
> > not found by retrying the URL.
> >
> > I have tried using another Browser (Firefox) on this computer and it
> > accesses the page just fine. I have even went one step further by trying to
> > access the http site
> > from another computer (also using IE7) via an Intranet. It works fine.
> > This is the only webpage that is not working.
> >
> > Where can I make changes? It is not asking me for a password. It is not
> > even partially bringing up the webpage.
> >
> > I have tried clearing all history inside IE7. I have tried to check the
> > settings in
> > the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> > tried to use IE6 but to no avail. I am using XP Professional.
> >
> > I don't know where to look next! Is it a Reporting Services issue? IIS
> > issue? IE7 issue?
> >
> > Any suggestions would be welcomed.
> >
> > Pat
>
> This link might be helpful.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 27, 12:34 am, Pat (Disciple of Aloof-ism)
<PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> Yes... your suggestion worked like a charm. I made the adjustment in IE7.
> While I believe that this approach did solve the problem, I cannot say that
> it was the exclusive controlling factor. You see, I also un-installed RS
> 2000 and re-installed it again. My belief is that your recommendation was
> the determining factor and not the reinstall of RS 2000.
> Thank you.
> Pat
> "EMartinez" wrote:
> > On Jun 26, 6:30 pm, Pat (Disciple of Aloof-ism)
> > <PatDiscipleofAloof...@.discussions.microsoft.com> wrote:
> > > OK.. I'm stumped.
> > > My IE 7 is working fine. I can access any websites I want with one
> > > exception. What is this exception?
> > > I recently installed MS Reporting Services 2000 on this computer. All went
> > > well.
> > > When I try to access the http:// site where all of my reports have been
> > > deployed, IE 7 shows a blank page with the message:
> > > "Bad Gateway 502". [code=DNS_HOST_NOT_FOUND] The host name was not found
> > > during the DNS lookup. Contact your system administrator if the problem is
> > > not found by retrying the URL.
> > > I have tried using another Browser (Firefox) on this computer and it
> > > accesses the page just fine. I have even went one step further by trying to
> > > access the http site
> > > from another computer (also using IE7) via an Intranet. It works fine.
> > > This is the only webpage that is not working.
> > > Where can I make changes? It is not asking me for a password. It is not
> > > even partially bringing up the webpage.
> > > I have tried clearing all history inside IE7. I have tried to check the
> > > settings in
> > > the IIS section. I have updated my IE7. I have even uninstalled IE7 and
> > > tried to use IE6 but to no avail. I am using XP Professional.
> > > I don't know where to look next! Is it a Reporting Services issue? IIS
> > > issue? IE7 issue?
> > > Any suggestions would be welcomed.
> > > Pat
> > This link might be helpful.
> >http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=842755&SiteID=1
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Cannot View My Database Diagrams

I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
onto a new (larger) hard drive and so far everything has been working as
before for my database, but when I went to view my database diagrams, I am
now getting this message. I tried as the message suggested to change the
database owner, but this only results in error messages. Neither can I add
any new database diagrams.
Anyone have any ideas as to how to solve such a problem?
Thanks,
Paul
---
TITLE: Microsoft SQL Server Management Studio
--
Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first use the Files page of the
Database Properties dialog box or the ALTER AUTHORIZATION statement to set
the database owner to a valid login, then add the database diagram support
objects.What is the compatibility mode of the database?
You can check with:
select compatibility_level
from sys.databases
where name = 'YourDatabase'
It needs to be at 90 to use the diagrams. I think this was
fixed in the service pack so the other alternative is to
apply SP1.
-Sue
On Tue, 17 Oct 2006 08:37:01 -0700, a
<a@.discussions.microsoft.com> wrote:

>I recently reinstalled Visual Studio and SQL Server 2005 Developer Edition
>onto a new (larger) hard drive and so far everything has been working as
>before for my database, but when I went to view my database diagrams, I am
>now getting this message. I tried as the message suggested to change the
>database owner, but this only results in error messages. Neither can I add
>any new database diagrams.
>Anyone have any ideas as to how to solve such a problem?
>Thanks,
>Paul
>---
>
>TITLE: Microsoft SQL Server Management Studio
>--
>Database diagram support objects cannot be installed because this database
>does not have a valid owner. To continue, first use the Files page of the
>Database Properties dialog box or the ALTER AUTHORIZATION statement to set
>the database owner to a valid login, then add the database diagram support
>objects.
>--

Cannot View Master.sysdatabase Names in Webpage

I have a webpage that should display the database names from the master.sysdatabases in a dropdownlist.

The code for the stored procedure works fine in Query Analyzer and returns the list of all database names under that instance of SQL-Server 2000.

The code:

select name from master.dbo.sysdatabases
order by 1

doesn't return the sysdatabase names to the ASP.NET webpage when executing the stored procedure.

It returns:

System.Data.DataRowView

Why does it do this and how can I fix it?

Tx

I don't know what you are trying to do but the Master database and it's content are Microsoft Property, I don't think you can use them in your web application. If you look inside the Master or look at the System tables Poster you know using those tables in your application is not something you do. Hope this helps.|||Probably a permissions issue.|||

Thanks.

The lookup is for our administrative/development purposes.
Since we have multiple databases to search through, the app shows the databases, you select a database, there's a lookup and display of tables, views and sprocs, and the contents are displayed in a large textbox for cutting and pasting purposes.

So the sysdatabases lookup is needed to select though the production databases.

The sproc doing the work has remote privs.
Other than that, how would you assign a priv to access the tables?
I didn't need it in QA.

Your help is appreciated.

|||I don't think it's a security/permissions issue. The built-in stored procedure sp_databases, which does exactly what your sql query does, has its execute permissions default to thepublic role. I think the problem is in your code, so you should post your code snippet here.|||

A quick test is to run this in both the webpage and your QA and see the difference:

SELECT SUSER_NAME(),USER_NAME()

That will tell you who are logged into SQL Server as, and what login are you being mapped to.

Although, rereading your original message, herman is most likely correct. It appears that your .NET code is wrong, considering that system.whatever.dataview is a .NET class, I would say that you've assigned a dataview to a variable using the .ToString method, or have done so implicitly.

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.
Hi Johnny
"Johnny" wrote:

> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed, I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John
|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQL
> Server 2000, this launches Notepad to view the output file.
>
> John
>
|||Hi Johnny
"Johnny" wrote:
[vbcol=seagreen]
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John
|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.Hi Johnny
"Johnny" wrote:

> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed,
I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQ
L
> Server 2000, this launches Notepad to view the output file.
>
> John
>|||Hi Johnny
"Johnny" wrote:
[vbcol=seagreen]
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
>
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then i
t
> will bring up the log file in Notepad!!!!
> John|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then i
t
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.Hi Johnny
"Johnny" wrote:
> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed, I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi,
> >
> > I've set up jobs and output files in SQL2005. When the job is completed, I
> > would like to check the output file by clicking VIEW button. However, the
> > button is grey-out.
> >
> > The owner of the job is sa. What is other permission I missed ?
> >
> > Thanks.
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQL
> Server 2000, this launches Notepad to view the output file.
>
> John
>|||Hi Johnny
"Johnny" wrote:
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
> > According to Books Online it is not available in SQL 2005
> >
> > From Books Online:
> >
> > View
> > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > Server 2000, this launches Notepad to view the output file.
> >
> >
> > John
> >
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi John,
> >
> > Thank you. Why leave the button there ?
> >
> > Regards,
> > Johnny
> >
> > "John Bell" wrote:
> >
> > > According to Books Online it is not available in SQL 2005
> > >
> > > From Books Online:
> > >
> > > View
> > > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > > Server 2000, this launches Notepad to view the output file.
> > >
> > >
> > > John
> > >
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
And it does!!
John