hi
What I did is in VS2005, right click the report name, change it and then rebuilt it, deploy it. And then go to Report Manager, I can see the new one, but when i run it, it shows this error:
It should be fine after changing the name.
I delete it from report manager, and re-build, delopy to the report server, then it works fine.
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
I have installed:
* SQL Server 2005 Express Edition SP1
* SQL Management Studio Express
* SQL Server 2005 Express Edition with Advanced Services SP1
* SQL Server 2005 Express Edition Toolkit SP1
I'm trying to create a simple report, that display only a list of names. "Select * From Table"
Any ideas?
Hi,
switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hey, Jens
I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message. 
Lloyd Arcales
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
I have installed:
* SQL Server 2005 Express Edition SP1
* SQL Management Studio Express
* SQL Server 2005 Express Edition with Advanced Services SP1
* SQL Server 2005 Express Edition Toolkit SP1
I'm trying to create a simple report, that display only a list of names. "Select * From Table"
Any ideas?
Hi,
switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hey, Jens
I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message. 
Lloyd Arcales
I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).
I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,
But, when I try to deploy the cube, I have this error message:
" the user XXXX don't have permission to modify the object or the object does not exist"
I don't know if I must configure some specific access.
Could you help me please, I search a solution since 2 days with any results.
Betty
Betty,
This is probably one of two things:
- Your impersonation information is not correct, for the AS server
- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.
Post back if this still does not fix the issue...
|||
Where can I add the user into the SQLSERVER2005MSOLAP group?
And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?
I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.
Betty
|||You can add the user to the group through the Local Users and Groups menu.
( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )
The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.
The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.
Tell me if that helps,
Tristan
|||
Sorry but all that don't resolve my problem
|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||
i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.
But, when I try to deploy the cube, I have this error message:
Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
i dont know is it configaration mistake or the cube creation mistake
Could you help me please
I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).
I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,
But, when I try to deploy the cube, I have this error message:
" the user XXXX don't have permission to modify the object or the object does not exist"
I don't know if I must configure some specific access.
Could you help me please, I search a solution since 2 days with any results.
Betty
Betty,
This is probably one of two things:
- Your impersonation information is not correct, for the AS server
- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.
Post back if this still does not fix the issue...
|||
Where can I add the user into the SQLSERVER2005MSOLAP group?
And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?
I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.
Betty
|||You can add the user to the group through the Local Users and Groups menu.
( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )
The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.
The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.
Tell me if that helps,
Tristan
|||
Sorry but all that don't resolve my problem
|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||
i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.
But, when I try to deploy the cube, I have this error message:
Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
i dont know is it configaration mistake or the cube creation mistake
Could you help me please
sqlI have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).
I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,
But, when I try to deploy the cube, I have this error message:
" the user XXXX don't have permission to modify the object or the object does not exist"
I don't know if I must configure some specific access.
Could you help me please, I search a solution since 2 days with any results.
Betty
Betty,
This is probably one of two things:
- Your impersonation information is not correct, for the AS server
- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.
Post back if this still does not fix the issue...
|||
Where can I add the user into the SQLSERVER2005MSOLAP group?
And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?
I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.
Betty
|||You can add the user to the group through the Local Users and Groups menu.
( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )
The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.
The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.
Tell me if that helps,
Tristan
|||
Sorry but all that don't resolve my problem
|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||
i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.
But, when I try to deploy the cube, I have this error message:
Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
i dont know is it configaration mistake or the cube creation mistake
Could you help me please
Hello, I just did a report and it compiles ok, when I try to deploy then popups a window asking username and password, I put my username and password of active directory and it asks again and again, I am supposed to be an administrator on the report server.
What can I do?
When I try to connecto from sql management studio to reporting service Instance I got this error
TITLE: Connect to Server
Cannot connect to agamenon.
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
but the strange thing is that I can see the report manager
|||Do I have to change something on the config file? or in IIS?
Here it is the config file
<ConnectionType>Default</ConnectionType>
<LogonUser></LogonUser>
<LogonDomain></LogonDomain>
<LogonCred></LogonCred>
<InstanceId>MSSQL.3</InstanceId>
<InstallationID>{fece13ec-acc5-4ebd-84bf-2534c30f2f7f}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShareStorage" Value="false"/>
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException"/>
<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://agamenon:90/reportserver</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
<FileShareStorageLocation>
<Path></Path>
</FileShareStorageLocation>
</Service>
I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).
I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,
But, when I try to deploy the cube, I have this error message:
" the user XXXX don't have permission to modify the object or the object does not exist"
I don't know if I must configure some specific access.
Could you help me please, I search a solution since 2 days with any results.
Betty
Betty,
This is probably one of two things:
- Your impersonation information is not correct, for the AS server
- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.
Post back if this still does not fix the issue...
|||
Where can I add the user into the SQLSERVER2005MSOLAP group?
And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?
I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.
Betty
|||You can add the user to the group through the Local Users and Groups menu.
( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )
The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.
The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.
Tell me if that helps,
Tristan
|||
Sorry but all that don't resolve my problem
|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||
i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.
But, when I try to deploy the cube, I have this error message:
Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
i dont know is it configaration mistake or the cube creation mistake
Could you help me please
Hi All,
I developed one web service,Here i am making connection to the Analysis Server and working on Database,cubes,partitions.when i deploy this code it is failing to run and it is throwing error like."object reference not set to an instance of the object",so i added Impersonate = true code in my web service config file then it is working fine.
( am expecting My Analysis Server is not allowing to create object ,how to handle this)
But what i want is it should work with out providing Impersonate in config.
Help is needed it is very urgent.
Thanks in Advance.
You code has to run under the priviledges of some sort of account. There are only 3 possible configurations that I can think of.
1. Setup an account in the application pool (if using IIS6)
2. Set a fixed account using the <identity impersonate="true" userName="..." password="..." /> tag in the web.config
3. Set the current client account to be impersonated using <identity impersonate="true" /> in the web.config
Note that 3) will only work if the web service and SSAS are on the same machine, or if you have Kerberos configured. Otherwise the user credentials will not pass from client to Web server to SSAS server.
