Showing posts with label sqlserver2005. Show all posts
Showing posts with label sqlserver2005. Show all posts

Wednesday, March 21, 2012

Error when deploying Report Model

I installed SQL Server 2005 on my laptop, this also contains my SQL Server 2000, so I couldnt use localhost and I used CreweAlex/SQLSERVER2005 as the hostname.

What do I need to fill in the field:

TargetServerURL

Because when I type http:\\localhost\ReportServer it doesn't work (as mentioned in the tutorial which I am following), also CreweAlex/SQLSERVER2005/ReportServer doesnt work.

I tried all kinds of combinations, but nothing works.

Everything is installed on my laptop, also the Reporting Server.

Try http://crewealex/reportserver$sqlserver2005|||

Thanks for the quick respons, but I still get an error:

Connection could not be made to the report server

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.SemanticQueryDesign)

|||

When I type http://crewealex/reportserver in my browser then I can see that I log in into my Report Server, because this is the message that I get:

Microsoft SQL Server Reporting Services Version 9.00.1399.00

I typed http://crewealex/reportserver in my TargetServerURL and this works now. But my instance name is SQLSERVER2005. > Problem solved.

Sunday, February 19, 2012

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.
|||The key does not exist there either. Thanks for the suggestion though.

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.|||The key does not exist there either. Thanks for the suggestion though.|||Did you find a solution, I have the same problem with no registry entry either.

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.|||The key does not exist there either. Thanks for the suggestion though.