Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in accessing reporting services web service, unable to set credentials I guess....

I am trying to access the Reporting Services Web Service, but i m not able to make it work. i tried with default credentials and network credentials

ReportingService

service =newReportingService();

service.Credentials =new System.Net.NetworkCredential("dbo","coreobject5","");

service.CreateSubscription(report, extSettings, description, eventType, matchData, parameters);

This is the exception i get

The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. --> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Web.Services.Protocols.SoapException: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. --> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Source Error:

Line 3382: [return: System.Xml.Serialization.XmlElementAttribute("SubscriptionID")]Line 3383: public string CreateSubscription(string Report, ExtensionSettings ExtensionSettings, string Description, string EventType, string MatchData, ParameterValue[] Parameters) {Line 3384: object[] results = this.Invoke("CreateSubscription", new object[] {Line 3385: Report,Line 3386: ExtensionSettings,

Tried to solve this and found that its the problem with the datasource I created for the report, tried to use 'sa' user in

data source->credentials->Use a specified user name and password, but did'nt worked.

One more thing i am able to accessGetExtensionSettings("Report Server Fileshare");API with

service.Credentials = System.Net.CredentialCache.DefaultCredentials;

Not able to find out what users to create in Report Server database or the database i am connecting to?

Will appreciate any kind of help.

Problem in accessing reporting services web service, unable to set credentials I guess....

I am trying to access the Reporting Services Web Service, but i m not able to make it work. i tried with default credentials and network credentials

ReportingService service = new ReportingService();

service.Credentials = new System.Net.NetworkCredential("username", "password", "domain");

service.CreateSubscription(report, extSettings, description, eventType, matchData, parameters);

This is the exception i get

The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. > The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. > The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.
Source Error:

Line 3382: [return: System.Xml.Serialization.XmlElementAttribute("SubscriptionID")] Line 3383: public string CreateSubscription(string Report, ExtensionSettings ExtensionSettings, string Description, string EventType, string MatchData, ParameterValue[] Parameters) { Line 3384: object[] results = this.Invoke("CreateSubscription", new object[] { Line 3385: Report, Line 3386: ExtensionSettings,

Tried to solve this and found that its the problem with the datasource I created for the report, tried to use 'sa' user in

data source->credentials->Use a specified user name and password, but did'nt worked.

Onemore thing i am able to access GetExtensionSettings("Report Server Fileshare"); API with

service.Credentials = System.Net.CredentialCache.DefaultCredentials;

Not able to find out what users to create in Report Server database or the database i am connecting to?

Will appreciate any kind of help.

|||

I believe your problem does not lie with a user in a database; I have used RS WS to Create / Fire Subscriptions and to UpdateSnapshots. Whatever user you pass to the Web Service must have Generate Events permission under Site Settings. Give the user those permissions and I think you will find that it will resolve your problem

Please let me know

Thanks

|||Report's data source must use stored credentials.sql

Problem in accessing reporting services web service, unable to set credentials I guess....

I am trying to access the Reporting Services Web Service, but i m not able to make it work. i tried with default credentials and network credentials

ReportingService service = new ReportingService();

service.Credentials = new System.Net.NetworkCredential("username", "password", "domain");

service.CreateSubscription(report, extSettings, description, eventType, matchData, parameters);

This is the exception i get

The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. > The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. > The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.
Source Error:

Line 3382: [return: System.Xml.Serialization.XmlElementAttribute("SubscriptionID")] Line 3383: public string CreateSubscription(string Report, ExtensionSettings ExtensionSettings, string Description, string EventType, string MatchData, ParameterValue[] Parameters) { Line 3384: object[] results = this.Invoke("CreateSubscription", new object[] { Line 3385: Report, Line 3386: ExtensionSettings,

Tried to solve this and found that its the problem with the datasource I created for the report, tried to use 'sa' user in

data source->credentials->Use a specified user name and password, but did'nt worked.

Onemore thing i am able to access GetExtensionSettings("Report Server Fileshare"); API with

service.Credentials = System.Net.CredentialCache.DefaultCredentials;

Not able to find out what users to create in Report Server database or the database i am connecting to?

Will appreciate any kind of help.

|||

I believe your problem does not lie with a user in a database; I have used RS WS to Create / Fire Subscriptions and to UpdateSnapshots. Whatever user you pass to the Web Service must have Generate Events permission under Site Settings. Give the user those permissions and I think you will find that it will resolve your problem

Please let me know

Thanks

|||Report's data source must use stored credentials.

Problem deploying reports

Hi,

I have an application that involves 3 components one of which is
Reports.
My system's configuration:
SQL 2000 - Default instance
SQL 2005 - Named instance (Instance1).

I provide the user with an option of selecting the SQL Server instance.
If the user chooses Instance1, then I need to deply the reports in SQL
2005.
The exceptions encountered during installation are logged in the Event
log.
When I do the installation for the in a machine, I always
get the following error in the event log:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.
I tried giving the rs.exe options from commandline. I got an error like:

Error in DetermineReportUrlSecurity().

I don't have the exact error with me now.

Note that I do not get this error when I do the installation in a
machine where both default and named instances are SQL 2005.

Can anyone tell me why this happens?

Thanks,

Sandhya

Are you installing RS2005 on the same machine as RS 2000? If so you should be prompted to do a files only install, is that the case? If it is then I am not sure when you are seeing this error. During configuration? If you could provide the error message and a better description of exactly what you are doing, perhaps I can offer some help.|||

Hi,

I am deploying my reports during the time of installation of my application i.e., throwugh an msi. I deploy the reports using rs.exe command and any error encountered would be logged in event log.

While installing SQL 2005. I selected the option 'Install and configure' for Reporting Services component. I also verified that I am able to browse to the Reports page. So there is no problem with the configuration. Someone had a similar problem which I saw in another forum. There a solution was given as to disable the firewall/create exceptions for report server. But in my system the firewall is already disabled.

I am deploying my reports from the installer by giving the rs.exe command wherein I get the following error:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.

I tried giving the rs.exe from the command line with -t parameter to trace the error.
Folowing is the exact error that I am getting:
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Why do I get this error?

Thanks,
Sandhya

|||

You need to connect to http://machinename/ReportServer/ReportingServices.asmx.

I hope this help.s

|||Hi,
I am connecting to http://machinename/ReportServer/ReportingServices.asmx.
Still I get the error. Any clues as to why I face this problem?
Thanks,
Sandhya|||According to the error the report server does not exist. Does the report server come up if you browse to http://machinename/reportserver? Does http://machinename/reports work?|||

Hi,

For Yukon, the default configuration for the Report page would be:

Default instance - http://<machinename>/reports

Named Instance - http://<machinename>/reports$<InstanceName>

In my case, I have Yukon in the named instance(Instance1). Hence I need to connect to http://<machinename>/reports$Instance1 and I verified that I am able to browse to this page. I get the Reports homepage.

When I browse to http://machinename/reportserver$Instance1, I get the following displayed in the page:

chnshl13423/ReportServer$Instance1 - /

---

---

Microsoft SQL Server Reporting Services Version 9.00.1399.00

So what might be the problem?

Thanks,

Sandhya

|||you should pass in -s http://machinename/reportserver$Instance1 to rs.exe.|||

Hi,

I am already giving the following:

rs.exe -i "C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -s "http://chnshl13423/reportserver$Instance1" -v parentFolder="DCM Reports For Yukon" -v reportLocation="C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -v serverName="chnshl13423\Instance1" -v databaseName="DCMSolution"

Thanks,

Sandhya

|||Any suggestions?|||

Hmm, It looks like you are doing everything that you should be. All the script host does at this point is call the soap method ListSecureMethods, using the ReportService2005.asmx endpoint. Your command looks correct and the server is up and running. I really don't know what would be causing this error.

The only thing I can think of is if the user you are running rs.exe as can not be authenticated with RS or RS is setup to use forms or basic auth. You could try using a different user, or if you are using basic auth, pass in the username and password options.

Problem deploying reports

Hi,

I have an application that involves 3 components one of which is
Reports.
My system's configuration:
SQL 2000 - Default instance
SQL 2005 - Named instance (Instance1).

I provide the user with an option of selecting the SQL Server instance.
If the user chooses Instance1, then I need to deply the reports in SQL
2005.
The exceptions encountered during installation are logged in the Event
log.
When I do the installation for the in a machine, I always
get the following error in the event log:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.
I tried giving the rs.exe options from commandline. I got an error like:

Error in DetermineReportUrlSecurity().

I don't have the exact error with me now.

Note that I do not get this error when I do the installation in a
machine where both default and named instances are SQL 2005.

Can anyone tell me why this happens?

Thanks,

Sandhya

Are you installing RS2005 on the same machine as RS 2000? If so you should be prompted to do a files only install, is that the case? If it is then I am not sure when you are seeing this error. During configuration? If you could provide the error message and a better description of exactly what you are doing, perhaps I can offer some help.|||

Hi,

I am deploying my reports during the time of installation of my application i.e., throwugh an msi. I deploy the reports using rs.exe command and any error encountered would be logged in event log.

While installing SQL 2005. I selected the option 'Install and configure' for Reporting Services component. I also verified that I am able to browse to the Reports page. So there is no problem with the configuration. Someone had a similar problem which I saw in another forum. There a solution was given as to disable the firewall/create exceptions for report server. But in my system the firewall is already disabled.

I am deploying my reports from the installer by giving the rs.exe command wherein I get the following error:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.

I tried giving the rs.exe from the command line with -t parameter to trace the error.
Folowing is the exact error that I am getting:
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Why do I get this error?

Thanks,
Sandhya

|||

You need to connect to http://machinename/ReportServer/ReportingServices.asmx.

I hope this help.s

|||Hi,
I am connecting to http://machinename/ReportServer/ReportingServices.asmx.
Still I get the error. Any clues as to why I face this problem?
Thanks,
Sandhya|||According to the error the report server does not exist. Does the report server come up if you browse to http://machinename/reportserver? Does http://machinename/reports work?|||

Hi,

For Yukon, the default configuration for the Report page would be:

Default instance - http://<machinename>/reports

Named Instance - http://<machinename>/reports$<InstanceName>

In my case, I have Yukon in the named instance(Instance1). Hence I need to connect to http://<machinename>/reports$Instance1 and I verified that I am able to browse to this page. I get the Reports homepage.

When I browse to http://machinename/reportserver$Instance1, I get the following displayed in the page:

chnshl13423/ReportServer$Instance1 - /

---

---

Microsoft SQL Server Reporting Services Version 9.00.1399.00

So what might be the problem?

Thanks,

Sandhya

|||you should pass in -s http://machinename/reportserver$Instance1 to rs.exe.|||

Hi,

I am already giving the following:

rs.exe -i "C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -s "http://chnshl13423/reportserver$Instance1" -v parentFolder="DCM Reports For Yukon" -v reportLocation="C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -v serverName="chnshl13423\Instance1" -v databaseName="DCMSolution"

Thanks,

Sandhya

|||Any suggestions?|||

Hmm, It looks like you are doing everything that you should be. All the script host does at this point is call the soap method ListSecureMethods, using the ReportService2005.asmx endpoint. Your command looks correct and the server is up and running. I really don't know what would be causing this error.

The only thing I can think of is if the user you are running rs.exe as can not be authenticated with RS or RS is setup to use forms or basic auth. You could try using a different user, or if you are using basic auth, pass in the username and password options.

problem conneting to SQL server 2000 on Win2k3 from ASP page using dsn connectio

Hi,
the log in user has default database set and also in the
connection string information i am specifying database
name along with DSN.But still i am not able to
connect.Please help me in this

>--Original Message--
>Make sure that your login has its default database
>properly set. Another option is to ensure that your DSN
>is changing the database from the default to the one you
>wish to use.
>Sincerley,
>Invotion Engineering Team
>Advanced Microsoft Hosting Solutions
>http://www.Invotion.com
>
>connect.I
>responding
>pointing
>then
>connection
>.
>If you go into the DSN and choose "test connection" and enter the same id
and password you specify in your ASP page does the test work?
If you use trusted authentication in your ASP page connection string will
it work?
Use SQL Profiler and/or netmon to see exactly what is happening when you
see the "hang". It may not have anything to do with the connection, it may
be a problem with the code after the initial connection.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem connecting to SS2K5 named instance using client tools

Hi,

The problem I have is this:

I have installed SQL Server 2005 Enterprise Edition on a W2K3 server that already has a SQL Server 2000 default instance installed. The installation appears to be a success. The problem is that having installed the client tools, and trying to connect, I get the following error message in a dialog:

"Cannot connect server SERVERNAME\INSTANCENAME
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)(Microsoft SQL Server)"

The funny thing is that I can connect to the SQL Server 2000 default instance that is on that server.
So it's obviously not a connection problem per se at my end i.e. bad dns etc which might stop me resolving the server name.

Googling for this error text gives the following advice on various web sites:

1. Check that the remote server allows connections.

It does, as other colleagues in my team have successfully installed the tools and can connect with no problems.

2. Check that the SQL Browser service is running.

It is, as without this running, my colleagues would not be able to connect either.

3. Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need.

The required protocol (TCP/IP) is enabled. Named pipes is also enabled, although I don't think that we're using that. And shared memory is also enabled by default.

4. Open the firewall and add exceptions for sqlbrowser.exe or UDP port
1434

There is no firewall running at either end of the connection and as mentioned I can connect to the SS2K default instance.

5. Make sure that the server machine is reachable.

I can connect to the SS2K default instance so it must be reachable. I can't see that I would need to change any configuration settings as my colleagues are using exactly the same default settings for their connections and they work fine.

The only thing that I have done differently is that I originally installed the client tools using someone else's privileged account as I didn't have admin rights on my box. The client tools didn't work, so I got admin rights to my box, uninstalled the client tools and then reinstalled them using my account. Still no luck. Not sure if something is still hanging around after the uninstallation that would cause me a problem.

To help, I've also filled out the following questionnaire:

[1] Client side:

> What is the connection string in you app or DSN?

There isn't one. I'm trying to connect from the SQL Server Management Studio | 'Connect to Server' dialog.

> If client fails to connect, what is the client error messages?

"Cannot connect server Y\Z
An error has occurred while establishing a connection to the server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)(Microsoft SQL Server)"

Is the client remote or local to the SQL server machine? Remote

Can you ping your server? YES

Can you telnet to your SQL Server? YES

What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] N/A
What is your client application? SQL Management Studio
Is your client computer in the same domain as the Server computer? Different domains
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes]. All 3 protocols are enabled
Do you have aliases configured that match the server name portion of your connection string? No
Do you select force encryption on server and/or client? No

[2] Server side:

What is the MS SQL version? SQL Server 2005
What is the SKU of MS SQL? Enterprise
What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. All 3
Does the server start successfully? YES. Other people can connect to the same instance.
If SQL Server is a named instance, is the SQL browser enabled? YES
What is the account that the SQL Server is running under? Domain Account
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? N/A. Firewall not running.
Do you make firewall exception for SQL Browser UDP port 1434? N/A. Firewall not running.
What tool or Application are you using to connect to SQL Server SQL Server Management Studio

[3] Platform:

What is the OS version? Windows 2003 (Server side), Windows XP Pro Version 2002 SP 2
Do you have third party antivirus, anti-spareware software installed? Symantec AntiVirus

[4] Misc:

If you have certificate configuration issue: N/A

Has anybody else come across this problem, as I've run out of ideas.

Many thanks,

Hi,

I've fixed the problem.
One of my colleagues who can log onto the SS2005 named instance from his workplace came to my workplace today and found that he also couldn't connect from there. That ruled out my installation. So we played with SQLCMD trying to connect and found that we could if we specified the TCP port (1776). So then it was just a question of working out
what the syntax was to specify the port in the Connection dialog. Turns out that server-name\,1776 works and allows us to connect.

Thanks.