Problem in accessing the database.. please help!

Hi There !!

CAn you please help me to solve my probelm and i will appreciate it if you help me. I installed SQL server on my machine and i installed tables in a database called "otters" when i run the application, i got an error message on the browser as shown below although in the application it says that it recognise the source of the dastabase. CAn you please help me to sort out tis problem and please try to look back to this thread after givingf me the soultion as it might not work and i need more assistant. I really, appreciate your help and thank you in advance. Please read the error message below
**************************************************

Server Error in '/Otters' Application.
------------------------

SQL Server does not exist or access denied.
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.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:

Line 403: Dim conn As New SqlConnection(connStr)
Line 404: cmd.Connection = conn
Line 405: conn.Open()
Line 406:
Line 407: ' Allocate an empty array list to hold the performance objects found

Source File: C:\CSE506\Theater\Performance.vb Line: 405

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Theater.Performance.Find(SqlCommand cmd) in C:\CSE506\Theater\Performance.vb:405
Theater.Performance.FindByDateRange(DateTime st, DateTime et) in C:\CSE506\Theater\Performance.vb:369
Otters.admin.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Otters\secure\admin.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET

------------------------Show your connection string. Are you using integrated security?|||Hi Sir !!

Thank you for your message. T o be honest with you, I do not know how can i show the connection string or where would i find it and i do not know about the integrated security?....... :( i am very soooorry

I wish you can help me. I have a code that need to build a data base. I did install SQL Server and the database with all tables. when i run the application as you can see i had the error message. I wish if you can help me.

The material in the application is very important to me run as i am new in web development and .NET Framework. I am really grateful and will be more grateful if you can help as much as you can to sort this problem out.|||In this code:

Dim conn As New SqlConnection(connStr)

The string connStr is what you need to show (if there are usernames and passwords, just change them to USER and PASSWORD).|||Hi Mr Douglas.reilly !!

This is the code below, it does not have a password or user name. Can you please advice what to do. Thank you again and i look froward to hearing from you.

****************** Code ***********************************
' Write a new customer object out to the primary database, retrieving the
' newly allocated identity field. Should only be called from inside a
' constructor.

Private Function Insert() As Integer

' Copy the customer out to the table of customers.

Dim conn As New SqlConnection(connStr)
Dim cmd As New SqlCommand("INSERT INTO Customers (Name, Address, " _
& "Email) VALUES ( @.nm, @.ad, @.em);" _
& "SELECT ID FROM Customers WHERE (ID = SCOPE_IDENTITY())", conn)
cmd.Parameters.Add("@.nm", custName)
cmd.Parameters.Add("@.ad", custAddress)
cmd.Parameters.Add("@.em", custEmail)

' Now execute the insertion onto the primary table

conn.Open()
Dim identity As Integer = CType(cmd.ExecuteScalar(), Integer)
conn.Close()
Return identity

End Function|||SOMEPLACE in the code, connStr is set. Find out where it is. Or, if you are not using OPTION EXPLICIT, perhaps it is not ever set, and that would also explain the problem. In your code, connStr MUST be a valid connection string, as specified in the link I have previously posted. If you do not know what must be in that string, it is not really something anyone else can help with.|||Hi Mr Douglas!!

Thank you again for your message. I searched the whole file and i could not find it. It is very disappointed for me that you can help. I can attached the application with the datadase .sql files to see yourself and if you do not mind i can email it to you. I wish you will be able to help it is very important to me and please, do not let me down. I wish i do not embaress you or ask you for what you can not do.

I wish you will able to help and anything i will do to sort this problem out.|||Do a control-F and search for 'connStr'

if you can't find a place where it specifically assigns a connection string (the way your script 'connects' to the database), then it won't work any way - - you must connect to the database, in order to display or edit data.
it will look like:
connStr = "...your connection 'string' will be here..."

Problem in accessing the database(Sqlserver 2005) from client machine

Hi

We have upgraded sql server 2000 to sqlserver 2005 on the development server.

To access the database server, we installed the sql server management studio on the client PC with Admin Account. The .Net framework and sqlserver management studio were installed and I am able to access the database from the client PC using Admin Login. Then we logged off and tried to login as user account on the client PC. From the user account login we are unable to open the sql server management studio. The error is as follows

“The proper type library could not be found in system registry”

The client PC configuration : windows 2000 Professional ( sp4)

Regards,

K.S.Subba Rao

Hi K.S. Subba,

What is probably happening is the non-Admin user that you are logging on with does not have permissions to read the appropriate type library informations for SQL-specific COM components from registry. The fastest approach you can take to troubleshoot that is to use RegMon from http://www.microsoft.com/technet/sysinternals/SystemInformation/Regmon.mspx, find out which keys are "Access Denied" or "Not Found" and when logged as Admin, grant the permissions to those to the non-Admin user. As a lazy alternative you could try to grant permissions to the user to HKEY_LOCAL_MACHINE\SOFTWARE\Classes and all the subcomponents, but that might expose a security risk.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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 accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

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

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

problem in accessing report manager and server

hi,

i installed RS 2005 on windows XP with local system account,report manager does not access.it gives

The page cannot be displayed

HTTP 500 - Internal server error
Internet Explorer

although reportmanager and reportserver directory is available in its default location.

and also when i clicked on any report on report server it gives

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

Requested registry access is not allowed.

i am using my account having admin privlge

please help me.....

Amit,

Could you, please, take a look at the log files for the windows service and for the web service and let me know what errors you find there?

The RS log files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

The log files for the RS windows service look like this: ReportServerService_(timestamp).log and the log files for the RS web service look like this: ReportServer_(timestamp).log.

Mihaela

problem getting refreshed data while accessing the cube from excel(OWC)

If I save a report using a cube in an excel spreadsheet, the next time when I open it, and try to drag a dimension, I cannot see any data. I need to refresh the document every time

I process the cube.

Is there way we can automatically refresh these reports ? Has anyone had this problem

before?

I'll appreciate your help.

thanks,

Rok

In 2007, you can configure your connection to refresh data everytime the file is opened or on a fixed interval. In 2003, this appears as a Pivot Table option.

B.

Problem connection to FoxPro database via ole db

Hi,
I'm accessing a FoxPro database via ole db and ths works fine on my local
report server. However, when I deploy the report to the live report server
I'm getting the error 'Invalid path or file name'
The FoxPro database is on a separate server and the connection string is :
string connectionString = @."provider=vfpoledb;" +
@."data source='\\server\data\foxpro.dbc';" +
"password='';user id=''";
I've read a few articles explaining that it's a permissions problem. I've
tried granting full permissions to the data folder for myself and 'Network
Service' but this still occurs. The web.config file for the report server has
impersonate set to true and IIS is configured for 'Integrated Windows
authentication' and does not use anonymous access.
Any ideas would be much appreciated.
Regards
MikeHi Mike,
Does the report server's account have permissions to the directory?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"MikeD" <MikeD@.discussions.microsoft.com> wrote in message
news:9A295512-41F7-48A0-B406-08AE86F55CA8@.microsoft.com...
> Hi,
> I'm accessing a FoxPro database via ole db and ths works fine on my local
> report server. However, when I deploy the report to the live report server
> I'm getting the error 'Invalid path or file name'
> The FoxPro database is on a separate server and the connection string is :
> string connectionString = @."provider=vfpoledb;" +
> @."data source='\\server\data\foxpro.dbc';" +
> "password='';user id=''";
> I've read a few articles explaining that it's a permissions problem. I've
> tried granting full permissions to the data folder for myself and 'Network
> Service' but this still occurs. The web.config file for the report server
> has
> impersonate set to true and IIS is configured for 'Integrated Windows
> authentication' and does not use anonymous access.
> Any ideas would be much appreciated.
> Regards
> Mike