Cannot connect to the Report Mgr.

Hi All,
I'm experiencing the error referenced in the following link to MS
Support
http://support.microsoft.com/Default.aspx?kbid=922656
I implemented the workaround but I'm still getting the error. Actually
when I started I was receiving "error message 1" and then when I
updated my RSWebApplication.config file to use the fully qualified URL
using the IP Address that is assigned to the Default Web Site's "IP
Address" property.
My config file now looks like this...
<ReportServerUrl>http://10.0.0.102:80/Reports</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
The server is a Windows 2003 server and the Reporting Services was
installed with SQL2005 but not configured. I was able to configure the
Reports server (from what I can tell) using the "Reporting Services
Configuration" tool).
Any idea as to what may still be causing the problem?
Thanks in advance for any help you can offer.
Mike Gorgone
Senior Software Engineer
PictureU PromotionsOn Aug 21, 2:06 pm, Mike <m_gorg...@.hotmail.com> wrote:
> Hi All,
> I'm experiencing the error referenced in the following link to MS
> Support
> http://support.microsoft.com/Default.aspx?kbid=922656
> I implemented the workaround but I'm still getting the error. Actually
> when I started I was receiving "error message 1" and then when I
> updated my RSWebApplication.config file to use the fully qualified URL
> using the IP Address that is assigned to the Default Web Site's "IP
> Address" property.
> My config file now looks like this...
> <ReportServerUrl>http://10.0.0.102:80/Reports</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> The server is a Windows 2003 server and the Reporting Services was
> installed with SQL2005 but not configured. I was able to configure the
> Reports server (from what I can tell) using the "Reporting Services
> Configuration" tool).
> Any idea as to what may still be causing the problem?
> Thanks in advance for any help you can offer.
> Mike Gorgone
> Senior Software Engineer
> PictureU Promotions
The last response in this link might be helpful.
http://www.sqlreportingservices.net/Ask/1730.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 21, 9:55 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 21, 2:06 pm, Mike <m_gorg...@.hotmail.com> wrote:
>
> > Hi All,
> > I'm experiencing the error referenced in the following link to MS
> > Support
> >http://support.microsoft.com/Default.aspx?kbid=922656
> > I implemented the workaround but I'm still getting the error. Actually
> > when I started I was receiving "error message 1" and then when I
> > updated my RSWebApplication.config file to use the fully qualified URL
> > using the IP Address that is assigned to the Default Web Site's "IP
> > Address" property.
> > My config file now looks like this...
> > <ReportServerUrl>http://10.0.0.102:80/Reports</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > The server is a Windows 2003 server and the Reporting Services was
> > installed with SQL2005 but not configured. I was able to configure the
> > Reports server (from what I can tell) using the "Reporting Services
> > Configuration" tool).
> > Any idea as to what may still be causing the problem?
> > Thanks in advance for any help you can offer.
> > Mike Gorgone
> > Senior Software Engineer
> > PictureU Promotions
> The last response in this link might be helpful.http://www.sqlreportingservices.net/Ask/1730.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Hi Enrique,
Thanks for the link. I've seen some information along those same lines
but I can't set the IP Address property to "All Addresses" the IP
needs to be set to the specific address we have in there.
Is there any war around that?
Mike

Cannot Connect to RS in SSMS

This relates to my previously unanswered post "HTTP Error 401.2" but when I
try to connect to Reporting Services via SSMS using Windows Authentication
(signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
request failed with HTTP status 401: Unauthorized.
(Microsoft.SqlServer.Management.UI.RSClient)"
So, what needs to be configured to connect? Should I reinstall something?
I'm lost here, and dead in the water until I can connect, thanks for any
help.On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
> This relates to my previously unanswered post "HTTP Error 401.2" but when I
> try to connect to Reporting Services via SSMS using Windows Authentication
> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
> request failed with HTTP status 401: Unauthorized.
> (Microsoft.SqlServer.Management.UI.RSClient)"
> So, what needs to be configured to connect? Should I reinstall something?
> I'm lost here, and dead in the water until I can connect, thanks for any
> help.
This link might be helpful.
http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the reference although I didn't come up with how to fix IIS or RS
so they will work together.
Here's the abbreviated logs when trying to open RS using SSMS
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2 2148074254
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 2148074248
And here's the log when trying to open reports with browser, with signon
dialog displayed first (and I signed on as the Administrator)
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
Any ideas?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but when
>> I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>
> This link might be helpful.
> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Solved! (after two days of random permutations and finally a tip from
Enrique Martinez - Thanks again, Enrique).
I used AuthDiag mentioned in the article and found out that Enable HTTP
Keep-Alives was unchecked for the website in IIS and NLTM requires
Keep-Alives. How that checkbox ever got unchecked I will never know.
"Don Miller" <nospam@.nospam.com> wrote in message
news:%23j4pEQXFIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Thanks for the reference although I didn't come up with how to fix IIS or
> RS so they will work together.
> Here's the abbreviated logs when trying to open RS using SSMS
> #Software: Microsoft Internet Information Services 6.0
> #Version: 1.0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2
> 2148074254
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1
> 2148074248
> And here's the log when trying to open reports with browser, with signon
> dialog displayed first (and I signed on as the Administrator)
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
> Any ideas?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
>> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but
>> when I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall
>> something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>>
>> This link might be helpful.
>> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>

Cannot connect to ms sql server 2005

http://server5.pictiger.com/img/990335/computers-and-electronic-gadgets/connection.jpg

I don't know how to connect sql server 2005 with sqljdbc.jar which is used in Netbeans IDE 5.5
how can I solve the above problem?

thx a lot

jdbc:sqlserver://localhost:1433;databaseName=mydatabase

is this url correct?

You need to post all of the information needed for anyone to help you with your problem.

(No one is likely to go to your url out of concern for malware, Trojans, etc.)

|||

Are you trying to use runtime connection.

Try this

jdbc:sqlserver://Owncomputername\SQLEXPRESS

Server management studio shows name like this:

OWNCOMPUTERNAME\SQLEXPRESS

Is TCP/IP enabled at server configuration manager (protocols for SQLEXPRESS).

If you havent setup you server read this thread faq.

|||In the sql server 2005, I'm using windows authenication method to login.
jdbc:sqlserver://DCPRJ007\SQLEXPRESS;

and I use this connection URL, but it said that "Login failed for user. The user is not associated with a trusted SQL server connection."

How can I solve this problem?
thank you|||

your server is configured for Windows Authenticaton ...but you are using SQL Server for connectivity...

refer : http://support.microsoft.com/kb/555332

http://support.microsoft.com/kb/889615

Madhu

cannot connect to http://localhost/ReportServer

how to give deploy roles using Report Manager
--
Message posted via http://www.sqlmonster.comUser that will be deploying reports need to have publisher permissions for RS.
"pavan kumar via SQLMonster.com" wrote:
> how to give deploy roles using Report Manager
> --
> Message posted via http://www.sqlmonster.com
>|||how to give permissions using rsconfig. its giving an error that 'report
server is not found'
--
Message posted via http://www.sqlmonster.com

Cannot Connect Remotely to HTTP EndPoint

Dear all,

I appologise that incarnations of this topic have been posted several times on this forum, however I cannot find a scenario that is the same as my own so I've resorted to starting a new thread.

I can successfully create and connect remotely to an HTTP EndPoint on my Windows 2003 machine using Integrated security, the administrator username and password via my static IP address.

I have read that Windows XP SP2 supports HTTP EndPoints, and it would be much more convenient for me to be able to create EndPoints in XP, and connect remotely.

I have created the endpoint like so...

CREATE ENDPOINT sql_tvr10
STATE = STARTED
AS HTTP(
PATH = '/sql/tvr10', AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR))

FOR SOAP (
WEBMETHOD 'StoredProcedure1'
(name='master.dbo.StoredProcedure1'),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'master',
NAMESPACE = 'http://194.106.11.11/' )

In visual studio I can retrive a list of services running at http://localhost/sql/tvr10?WSDL absolutely fine. However, in Visual Studio on the remote machine, I cannot connect to http://194.106.11.11/sql/tvr10?WSDL - it prompts me for a username and password, however I cannot select the username - it is set to "Athlon64\Guest" (Athlon64 is my server computer name). I have no passwords on any of my windows accounts (except administrator), and I have no database passwords set.

Could someone please tell me how I should go about accessing the HTTP EndPoint?

Just so it is clear, I am running a small LAN with no domain, just a workgroup. I need the client application to be able to connect via http regardless of which network it is on. I am using VS2005 and SQL Server 2005 Dev Ed.

Many thanks in advance,
Simon

Hi Simon,

On a workgroup network, I would recommend changing the "AUTHENTICATION" value on the endpoint from "INTEGRATED" to "NTLM". By default VS2005 will try Kerberos first when the server reports that it supports "INTEGRATED" authentication. I remember encountering issues where it will not retry with NTLM. By forcing NTLM on the SQL Server, will help elminate this problem. From a security perspective, I would recommend creating an user on the WinXP machine for use as the user who will access this HTTP Endpoint. You can then grant specific permissions in SQL (including endpoint connect permissions) for this user. This way, when prompted for credentials, you can specify this user "Athlon64\myUser".

Note: If VS2005 does not allow you to specify/choose the correct user, I suggest that you use Internet Explorer to retrieve the WSDL document. You can then save the WSDL document on your development machine and reference the file in VS2005.

A couple of things to remember,
- Ensure the WinXP firewall is not blocking TCP port 80
- Ensure that the WinXP IIS is not running (as it will take over port 80 and you will not end up connecting to SQL Server)

Jimmy

|||

Thanks for your advice, I think I had already tried a NTLM endpoint with no success. However I did as you said, and created a new windows user called db (and set a password),
then from the console I typed ...

"CREATE LOGIN [Athlon64\db] FROM WINDOWS; go",
"CREATE USER [Athlon64\db] FOR LOGIN [Athlon64\db]; go",
"grant connect on endpoint ::sql_tvr14 to [Athlon64\db]; go"

And tried searching http://194.106.11.11/sql_tvr14 for web services, and this time instead of prompting for the password of "Athlon64\GUEST", it prompted for the password of "Athlon64\db" - I thought 'BINGO', but alas when I type the password I specified in Windows control panel it just throws it back at me :'(. I'm pulling my hair out on this one!

I have disabled all my firewalls (router and windows), and I have stopped the ISSAdmin service in Control Panel -> Admininstrator -> Services.

If anyone can solve this I will owe them some sort of Wookie life debt!

|||

If you are in a workgroup environment using integrated logins will be problematic because there is no shared trust (no domain controller). One trick that might work is creating the same account on client and server machines with the same password (create db account on client machine with same pwd as account on Athlon64 machine), then log in as db user, run IE and hit the site, it should work with NTLM because the hash for both accounts will be the same.

Another thing you can try is use digest or basic, which work by hashing or sending the userid and password and then doing the authentication on the server side. Basic over SSL will definately work, I have not tried digest in this case but in theory it should work.

|||Thanks, I'll give that a go now.
Is it worth mentioning that the "Athlon64\db" user I created cannot even log on on the server computer using "osql -U [Athlon64\db]" from the command line? Is there a problem with the way I created a new login/user above?|||I have just tried your suggestions, including creating a new endpoint using BASIC or DIGEST, and I'm still having no luck. BASIC over SSL just refuses the connection (Error 400), DIGEST prompts for a UN and password, but rejects the input.

I am beginning to suspect there's a problem with the user accounts on the server. If I try "osql -U [Athlon64\db]" and the password I specified when I created the user account in control panel, should I be able to connect (because I can't!)? The only way I can connect to the db via the command line is "osql -E", and that logs me in without asking for any passwords.

:'(|||

osql -U [Athlon64\db] will not work.

Instead do this:

goto c:\windows\system32 in explorer, hold down shift key and right click cmd.exe, select Run As... and then enter userid and password for Athlon64\db.

Then from this command prompt (whcih is now running as Athlon64\db) run:

osql -E

This will attempt integrated login.

You can also test launching IE from this console window (run iexplore.exe) and then IE will be running as this user.

Also, inside IE make sure you goto Tools | Internet Options -> Advanced and check "Enable Integrated Windows Authenication" and restart IE if this is not checked.

|||

That worked, so now where do I go from here?

I'd also just like to thank everyone for their support; it's most kind of you guys to volunteer your time to a stranger!

|||

Not sure what your end result is, what are you trying to accomplish with the endpoint?

|||Basically I need to be able to query a personal database via http/the internet in C#, including use from a PDA.

As I said in my first post I had it working well with Server 2003, so I may have to go back to that. The only trouble being that my Server2003 drive crashed and I'll need to reinstall and configure everything :(|||

Yes if it's from a PDA I would use https and basic authentication, this would be the simplest and easiest thing to configure.

With basic the client sends the user id and password and this is authenticated on the server side using only the local security authority so you don't need a domain controller.

Basic should work well even from IE no matter what.