RE: cannot log into Reporting Services from SMSS

Hello Ed,

You could try the following steps to add a domain user to sql logins.

1. In SQL Management studio, select Server name->Security->Logins

2. Right click the logins->New login

3. Type "domainname\username"(without quotes) in Login name box. For
example, you domain name is test and the user name is user1, you should
type "test\user1"(without quotes)

4. Click "server roles" on left panel, and check "sysadmin" role

5. Click OK to add.

After that, please use the login in Report Manager configuration utility:

1. On Database setup panel, select "Windows credential"

2. In Account name, type "domainname\username" (without quotes), and in
password box type the password you use for this account.

3. Check Servername and database to make sure they are correct. You could
click "connect" to test.

4. Click Apply to see the result. Please let me know the error message if
you encounter any.

Please add the domain user as local admin temporarily by following steps:

1. Right click "My Computer"->Manage->Local users and groups

2. Select Groups, and double click "Administrators" group.

3. Click "Add", and type "domainname\username" (without quotes), and click
OK.


Please try to connect http://servername/reportserver to see the result. If
you still see the same error message, please check the report server log to
see if it has the same exception we noticed in previous repot server log.
Thank you for your time.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
<http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone>.
Feedback on your service and satisfaction can be posted to:
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Win98 user acct cant connect - admin acct can
    ... I have made sure that everybody can login from the ... >If the administrator is the Domain Administrator, ... >account used a password that had a letter in it that ... A standard domain user account gets the ...
    (microsoft.public.windows.server.networking)
  • Re: can not login
    ... something in the link between their network and the one where the WSS ... > She is a domain user, that has previously been able to login to WSS. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Reporing service failure
    ... I did not find any login failure in the trace file. ... Also I recommend that you try explicitly adding your domain user account as ... your ReportServer and ReportServerTempDB databases. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Sharing Favorites Between Two Logins
    ... I have a local and domain user set up to share the same local profile on a ... local user login. ... due to some security configuration? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Help trying to login to myspace programatically in vb.net
    ... 'Dim myspacecookies As New Net.CookieContainer ... you should get the login page from a config file. ... Dim response As System.Net.WebResponse = Nothing ... ' You need to capture the cookies at this point and use ...
    (microsoft.public.dotnet.general)