Problem in form Authentication

Dear All,
I have problem while calling my report from report server using URL METHOD.
we have config'red our reporting service using forms Authentication.
(so we have login page)
My problem is i have to call the report, using URL METHOD, by supressing
that login page
why becos, some Credentials i will get it from my aplication.
Pls guide me how to supress and call the report from codebehind using URL
METHOD.
Million of Thanx in advance
Gopal PrabhakaranYou need to Logon to the Report Server using the LogonUser() WebService
method

Problem in Drillthrough report

Hi Friends,

I am very new to MSSQL Reporting service 2005. I wanted to create a drithrough report. I have created a master report using a cube created using MSSQL Analysis service 2005. The master report contains a column called 'Territory', which details some other columns also. My child report contains the same 'Territory' column, but with displays some other detailed information. If I click on the territory column data on master report, it should take me to child report where it should show only Territory which matches with the master territory.

I have created both master & child reports. In my master report, Jump to Report, I have given the name of my child report. In my child report, if I have created a hidden parameter by providing available value through query. But while clicking the territory column master report I'm getting error parameter xxx is missing a value. If I uncheck as hidden parameter it pops up for the value & it works.

How to go about it, can someone help?

Thanks & Regards,

Naveen J V

Hi,

Its a long time ago as I had built my last report - but at the Jump to Report there is also a part where you map the Target Report Paramter to something of your current Report. There you have to specify the value for Target Report Parameter - your current Territory.

If you not specify the paramters it get set to the default parameter of null - which seems to be not allowed for your parameter.

It looks like this is more related to report server - I recommend you to post your question there if my hint does not help.

Mabe someone from MS moves it to the report server forum.

Best Regards

Hannes

Problem in Deploying Analysis service projects using SQL server Business Intelligence Developmen

after creating Analysis service projects using SQL server Business Intelligence Development Studio when the project is deployed it gives following error.........

Error 1 The project could not be deployed to the 'Solversa-201\SQL2005' 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

connection to the server problem doesnt come at the time of creating data base,at that time it is accepting server name and displaying the database list...............

even test connection is also sucessful...................

problem is only at the time of deployment of project

Please make sure that the instance name in the Deployment tab refers to your Analysis Services instance and not your SQL Server 2005 database server instance.

problem in connecting to sql server Express

Hi to all,

i'm installing sql server in my pc as netwrok service.

when i try to connect it, it showing me a error
sql server does not allow remote connections error 26 error locating server/instance (MS Sql server )

how can i resolve this
plz help me out.

it not able to connect the server locally.
when i try to connect it with .\SQLEXPRESS or localhost\SQLEXPRESS it will connect to the DB
But when i use ServerName\SQLEXPRESS it wont connect to DB what the problem plz help me

with Regards
Amjath

Hi Amjath,

Ensure that you have enable remote connection in Surface Area Configuration for Service and also check you have enable TCP/IP and Named Pipe too.

Hemantgiri S. Goswami

|||Hi Goswami,

this time also i faced the same problem Goswami.

the message contains the Following

Cannot connect to ServerName\SQLEXPRESS

An error has occured 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)

i enabled the remote connection in Surface Area Configuration for Service and also check the third option enable both TCP/IP and Named Pipe .

but this time also i can enter the db using the .\SQLEXPRESS or localhost\SQLEXPRESS.
wat can i do now, plz help me

with Regards

Amjath|||

Hi Amjath,

ensure NET DDE and NET DDE DSDM and SQL Browser Service are started in Control Panel -> Administrative Tools-> Services and firewall rules are also set properly .

Refer sp_setname which will set network name sys.servers .... When did you get this error !? From Application!? Which? Or from SSMS ?

Hemantgiri S. Goswami

|||Hi Goswami,

sorry to ask this what is mean by NET DDE and NET DDE DSDM,
but SQL Browser by defult is in disabled(I have to change that thing to Automatic and then i have to start it manually right).

Right now I'm using sql server studio express only.

With Regards
-Amjath|||

Hi,

These are the Services , SQL Broswer service required because it gives connection information to client computers, start them and see if it works.

And what about the other question i asked !!! When did you get this error ?! While runing any application or while connecting SQL Express from another machine on network ?

Hemantgiri S. Goswami

|||

Sorry to butt in, but I got the same problem and was looking for a solution as well thus found this thread

I get exactly the same message when I try to connect to the SQL EXpress Database from Visual Basic in Visual Studio Express

Both when running Visual Studio Express from a PC with the SQL server loaded on that PC and on another PC with SQL on a network

I click on 'Tools' in VBE then

'Connect to Database'

I navigate via the connect to SQL Server Database dialog to the MS SQL Database.MDF that I wish to connect to

The dialog stays up for some 25 - 30 secs and times out with the error message provided earlier in the threads

(I have not tried the suggested solution - yet - just answering the specific question of where this is happening)

|||

" 26 error locating server/instance ..." means we are not able to locate your server, make sure SQL Browser is running evenif it's local connection. Please refer http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1 to trouble-shoot connectivity issues.

|||

Let's try the simple things first...

Ensure that you've fully configured your instance to accept remote connections per the KB article on the topic, here. If that doesn't solve the problem then try some of the more advanced troubleshooting.

Mike

|||Hi to ALL,

guys that wont get connected.
but when change the property of Alias in sql server configuration manager then its working i dont know wat to do
i changed the protocol to named pipe then its working....
when i changed that to tcp it wont work whats the problem.....

in the surface area configuration i set the option as work for both tcp and named pipe....

i enabled the sql browser also wat goswami said, i did that

plz help me out...from this problem i struggle a lot

with Regards
Amjath|||

Hi Amjath,

Have you opened up Exceptions in the firewall as described in the KB article that I provided? If the firewall is not open you will not be able to connect to SQL Express.

How are you trying to connect?

Mike

|||Hi Mike

Nice to hear from u
i switch off the firewall for this purpose only mike.

till now it wont work

-Amjath|||

Hi Amjath,

Are you saying that once you open an Exception in the firewall you are able to connect?

Be sure you're following the instructions in the KB and opening an Exception, not just turning the firewall off. An Exception will allow specific applications to communicate through the firewall while still offering protection for the rest of your computer.

Mike

|||

This is a very common question that's exacerbated by the generic OSFA error message that gives irrelevant information as often as not. To address this question, I've written a rather long blog entry that walks through the issues and should help get anyone connected to SQL Server. I've also included a very long chapter in my new book that goes even deeper into the mechanics of getting connected. See http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html and www.hitchhikerguides.net

Problem in connecting after service pack 3a installed in MSDE 2000

Hi All,
I have installed MSDE 2000 server and i installed service pack
3a. The server machine has SQL Server 2000 client connectivity. When i
connect from client machine to Server machine it is showing error.
[Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
SQL Server does not exists or access denied.
I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
Any suggestion would be greatly appreciated.
Regards,
A.Chellam.How do you connect? Try specify the IP for the server/data source and see if
you
can connect.
-oj
http://www.rac4sql.net
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>|||Verify on the MSDE machine using Server Network Utility what netlibs it is
listening on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>

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 in " NT AUTHORITY\NETWORK SERVICE "

I just install a sql2k and csk
After all installation , This message occurs when I start the csk
What is 'NT AUTHORITY\NETWORK SERVICE' ?
How can I solve this problem please?

'/CommunityStarterKit' ?????
------------------------

? 'NT AUTHORITY\NETWORK SERVICE' ??
??: ??? Web ????????????,?????

??: System.Data.SqlClient.SqlException: ? 'NT AUTHORITY\NETWORK SERVICE' ??

??:

??? Web ??,??????????,??????

??:

[SqlException: ? 'NT AUTHORITY\NETWORK SERVICE' ??]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunitiesFromDB() +92
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunities() +56
ASPNET.StarterKit.Communities.CommunityUtility.GetCommunityInfo() +332
ASPNET.StarterKit.Communities.CommunitiesModule.Application_BeginRequest(Object source, EventArgs e) +204
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

------------------------
??: Microsoft .NET Framework ??:1.1.4322.573; ASP.NET ??:1.1.4322.573see thread "Connecting to MSDE using SSPI". Looks like you have hit the same problem as I did.

John B

Problem getting SQL Server Express Service to Start

I have had SQL Server 2005 (Full Version) installed along with SQL Server Express and suddenly SQL Express quit starting and will not start manually. I have reinstalled VS 2005 (Team Edition for Software Dev) and tried to reinstall SQL Express but the installation fails when it tries to start the service. Any suggestions?

Keith

If it had been working for a while but stopped, and it logs on with an account other than local I would check to see if the account's password has expired. If that isn't the case, when you try to start it are there any messages in the Event Logs?|||

You should also check the SQL Error logs in addition to the Event logs. Let us know what they say.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

I get the following in the SQL Server Express Log:

SQL Trace ID 1 was started by login "sa".

2006-04-17 16:16:32.77 spid5s Starting up database 'mssqlsystemresource'.

2006-04-17 16:16:33.14 spid5s Error: 15209, Severity: 16, State: 1.

2006-04-17 16:16:33.14 spid5s An error occurred during encryption.

2006-04-17 16:16:33.16 spid5s SQL Trace was stopped due to server shutdown.

Any thoughts?

|||

Thanks Keith,

Just to be clear, are you getting this error while installing or just when trying to start the server?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

When the server quit starting and repairing visual studio didn't help, I removed the following registry entries:

Under the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL, the string named SQLEXPRESS with data MSSQL.1 and

the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1

so that sql express would install under the same instance name. I then reinstalled sqlexpress and during the installation it was unable to start the service and reported the encryption error in the sql server log.

|||

Do not delete registry entries. Use the setup program to uninstall/reinstall the SQL Server Express product.

Normally, SQL Server setup creates the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Security

If the Security key is not present, the creation of the service master key will fail with the error that you've encountered. The key was probably not created because you partially deleted the registry entries for this product.

You can attempt to create the key manually (don't create anything under it), to see if this will allow the installation to complete. If it works, I suggest to backup your databases, then uninstall and reinstall SQL Server Express again, because the correct installation will create this key and it will also apply the proper access restrictions on it.

Thanks
Laurentiu

|||The Add/Remove Programs utility in the control panel will not let me uninstall SQLEXPRESS. It says that the product has already been uninstalled. When I try to add SQLEXPRESS it states the the instance name is already in use and won't install. This lead me to make the registry changes mentioned earlier. I have repaired the registry. Is there any way to delete the entry for the SQLEXPRESS instance from the list of installed instances in the the Add/Remove programs list that appears when I select "Change" under Microsoft SQL Server 2005?|||

Try posting this question on the Setup forum: SQL Server Setup & Upgrade.

Thanks
Laurentiu