Showing posts with label active. Show all posts
Showing posts with label active. Show all posts

Monday, March 26, 2012

Report Delivery -- HELP

Is SSRS limited to delivering reports to recipients inside your domain (active directory)? I'm using an SMTP server for report delivery an have set the SendMailToUserAlias to False and still can only send reports to e-mails with my domain (user@.mycompany.com). I need to send reports to recipients outside my company -- is SSRS capable? If so, how do I configure it to do so?If PermittedHosts config setting is not set there shouldn't be restrictions to the receiving hosts. Look at the RS logs and see if there are any exceptions. The restriction could be set at the SMTP server as well.sql

Tuesday, February 21, 2012

reply

I am not using the SA account when I log in using windows authentication it seems to pick up my domain and active directory ID which is "us\app1dxd" it appears greyed out as well as the password on the login screen so you can't change it.

If you go into the management studio and right click on the server name in the left hand pane go to properties security the radio button for sql server and Windows authentication mode is selected.

It is normal because the BOL says if you install SQL Server with Windows Authentication the sa account gets disabled, the account remains disabled even when you change to mixed authentication you have to enable the account after changing to mixed authentication.


http://msdn2.microsoft.com/en-us/library/ms144284.aspx