SQLServer Express permissions

[fieldtechuk]

I have installed SQLServer 2005 Express with Adv services sp1 onto a windows 2003 platform. I have published some existing reports and when trying to run these from the Report Manager on the actual server, I get the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'Mydb'.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have checked the settings for SQLServer and remote connections are enabled (I can access the database ok). The datasource Mydb has the correct connection settings for the database and the credentials are set to be stored in report server and are valid.

I can't see what else is wrong - any ideas?

 

[TheBlondOne]

Are you using windows authentication in the datasource properties as your authentication?

If you are, have a look in SQL Server 2005 and check that you have the correct credentials to the database. You can check them under the security folder for the database, just make sure that you've got dbo selected and that should fix it

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )