Cannot create a datasource items

I'm trying to use WSS3 & RS 2005 as Integration Mode.
But i cannot create a data source item on sharepoint site library.

If i go to Central Administration > Configure Reporting Services Integration,

I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)

But from my production server web site ( //servername/ ), i cannot create those items.

I received the message

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

Can somebody help me to fix that strange behavior.

Thanks.I check the security on the at the below level :

- IIS Site and Application Pool (For Sharepoint:80 and Sharepoint Admin Console:12500)
- Permissions on the folder (Is the same).
- The site Owner is the same on both

The communication from the Sharepoint Admin Console allow any access to RS2005.
For some reason that site have permission to see Reporting Services.

But from Sharepoint Services Portal i can not.

Thanks again.

Cannot Create .mdf Database...

Hi,

I am just starting to use VS2005 and SQL Server Express 2005. One of the tutorials I've been looking at asks me to add a new Database Item by right clicking on my project and choosing Add Item, then SQL Database.

If I try and do this I get the following error:

Failed to generate a user instanceof SQL Server due to a failure in starting the process for the user instance. The Connection will be closed.

I have searched and found there is a similar problem down to trying to do this remotely, I have carried out their suggestions of changing the built in account to "Local System" in the SQL Server Express 2005 Properties. And also delete the folder SQL SERVER in the Microsoft folder in Application Data. But this hasn't worked and I still get the error.

If I try and create a new database in the Server explorer by right clicking and selecting "Create New SQL Server Database..." This works fine.

First of all, can anyone give me any suggestions to solve my problem? And secondly, can anyone tell me why I would use an .mdf file as opposed to creating a new SQL Server Database?

Thanks in advance...

JohnnyC

hi JohnnyC,

try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=152338&SiteID=1 to see if helps..

regards