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 connect to Sql Server 2005 Express. Any idea why ?

Hi everybody
I have a system with :
WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer
2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager
from SQLServer 2000 to connect to it (manual says I can) but with no
success. I tried to log on with windows authentication as well as with Sql
authentication . I tried the following names to connect :
(local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
so on but never got connected. It always say that the
SQL Server does not exist or Access denied.
I checked in the services where it is set to automatic and is running. I
also stopped and restarted but with no success. What i am missing ?
At the end I uninstalled everything and reinstalled only Framework 2.0 and
Sql Server 2005 Beta but having the same problem.
Anyone know how to fix this ?
Thanks in advance
Raja
hi, Raja,
"Ing. Rajesh Kumar" <iambad(Without This)@.post.cz> ha scritto nel messaggio
news:OFSx33CcEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi everybody
> I have a system with :
> WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed
SqlServer
> 2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise
Manager
> from SQLServer 2000 to connect to it (manual says I can) but with no
> success. I tried to log on with windows authentication as well as with Sql
> authentication . I tried the following names to connect :
> (local)\SQLEXPRESS; COMP_NAME\SQLEXPRESS; SQLEXPRESS; MSSQL$SQLEXPRESS and
> so on but never got connected. It always say that the
> SQL Server does not exist or Access denied.
> I checked in the services where it is set to automatic and is running. I
> also stopped and restarted but with no success. What i am missing ?
> At the end I uninstalled everything and reinstalled only Framework 2.0 and
> Sql Server 2005 Beta but having the same problem.
frorm microsoft.private.sqlserver2005.express newsgroup:
1. Enable Protocols
a. Launch SQL Computer Manager
b. Expand "Server Network Configuration"
c. Expand Protocols for "SQLEXPRESS"
d. Enable Np (for local access)
e. Enable TCP (for remote access)
2. Restart SQL Express
a. can be done from either SQL Computer Manager, Services applet, or
command line
3. Start SQL Browser service from Service applet or command line
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Cannot connect remotely to MSDE2000 database

Hi,
I have a win98 Pc connecting to a winxp pc - trying to connect to the
MSDE2000 database - the database is operating in mixed mode (allows SQL
logins) rather than windows integrated. The database is working ok on winxp
pc - i can use the SQL Web Data adminsitrator to verify that SQL Logins work
ok - also the ODBC Adminstrator can make connections to the database.
Now when i try using the ODBC Administrator to connect using the same
details it fails - SQL server does not exist or access denied.
Now i have disabled windows firewall to rule that out (although i had
enabled port 1433- sql server listening port).
Now how can i verify SQL server is listening on port 1433 for remote
connections?
How do i configre SQL server to listen for remote connections?
Any other ideas for resolving my connection problem?
Thanks a lot!
hi John,
John Blair wrote:
> Hi,
> I have a win98 Pc connecting to a winxp pc - trying to connect to the
> MSDE2000 database - the database is operating in mixed mode (allows
> SQL logins) rather than windows integrated. The database is working
> ok on winxp pc - i can use the SQL Web Data adminsitrator to verify
> that SQL Logins work ok - also the ODBC Adminstrator can make
> connections to the database.
> Now when i try using the ODBC Administrator to connect using the same
> details it fails - SQL server does not exist or access denied.
> Now i have disabled windows firewall to rule that out (although i had
> enabled port 1433- sql server listening port).
> Now how can i verify SQL server is listening on port 1433 for remote
> connections?
> How do i configre SQL server to listen for remote connections?
> Any other ideas for resolving my connection problem?
> Thanks a lot!
please verify, using Server Network Utility (svrnetcn.exe), that the MSDE
instance allows remote connections via the desired/required network
protocol...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a lot - very immpressed - that did the trick - TCP/IP protocol was
disabled - i enabled it and it worked!
I've spent 2 days trying to get this working - eventually found out the
registry needed changing to allow mixed mode (SQL login)- found out my
firewall was blocking port 1433 - and finally your suggestion for enabling
the protocol - never even heard of that utility svrnetcn.exe - thanks very
much! John.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:37md0nF5eceloU1@.individual.net...
> hi John,
> John Blair wrote:
> please verify, using Server Network Utility (svrnetcn.exe), that the MSDE
> instance allows remote connections via the desired/required network
> protocol...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Exposing SQL through a firewall by opening port 1433 is generally considered
to be a bad thing.
-Andrew
"John Blair" <john_blair@.hotmail.com> wrote in message
news:H2oRd.910$gv6.611@.newsfe3-gui.ntli.net...
> Thanks a lot - very immpressed - that did the trick - TCP/IP protocol was
> disabled - i enabled it and it worked!
> I've spent 2 days trying to get this working - eventually found out the
> registry needed changing to allow mixed mode (SQL login)- found out my
> firewall was blocking port 1433 - and finally your suggestion for enabling
> the protocol - never even heard of that utility svrnetcn.exe - thanks very
> much! John.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:37md0nF5eceloU1@.individual.net...
>
|||I am only exposing this port on a local intranet - so i wasn't aware that
there are any security risks. Do you have a better way of letting VB6 apps
access a remote SQL Server database? Thanks.
"Andrew" <nemoby@.nospam.nospam> wrote in message
news:uVC2%23ofFFHA.4016@.TK2MSFTNGP09.phx.gbl...
> Exposing SQL through a firewall by opening port 1433 is generally
> considered to be a bad thing.
> -Andrew
> "John Blair" <john_blair@.hotmail.com> wrote in message
> news:H2oRd.910$gv6.611@.newsfe3-gui.ntli.net...
>