Month: November 2014

Create SQL Server Login

1. Local / Domain User (Windows Authentication)

USE master

EXEC sp_grantlogin '{Server Name}\{User Name}'

USE {Database Name}
GO

EXEC sp_grantdbaccess '{Server Name}\{User Name}'
GO

ALTER ROLE db_datareader ADD MEMBER [{Server Name}\{User Name}]
GO

ALTER ROLE db_datawriter ADD MEMBER [{Server Name}\{User Name}]
GO

2. IIS Application Pool (Windows Authentication)

USE master

EXEC sp_grantlogin 'IIS APPPOOL\{Application Pool Name}'

USE {Database Name}
GO

EXEC sp_grantdbaccess 'IIS APPPOOL\{Application Pool Name}'
GO

ALTER ROLE db_datareader ADD MEMBER [IIS APPPOOL\{Application Pool Name}]
GO

ALTER ROLE db_datawriter ADD MEMBER [IIS APPPOOL\{Application Pool Name}]
GO

3. SQL Server Login (SQL Authentication)

USE master

CREATE LOGIN {Login Name} WITH PASSWORD = 'Pass1234';

USE {Database Name}
GO

CREATE USER {Login Name} FOR LOGIN {Login Name};

ALTER ROLE db_datareader ADD MEMBER [{Login Name}]
GO

ALTER ROLE db_datawriter ADD MEMBER [{Login Name}]
GO

IIS Windows Authentication with Server Error 401

I tried to setup a website in IIS with Windows Authentication, however, encountered the 401 server error.

Server Error 401
Server Error 401

The following procedure resolved by problem.
1. Open Internet Information Services (IIS) Manager
2. Select your web site
3. In Features View, double-click Authentication
IIS Features View
IIS Features View

4. On the Authentication page, right-click Windows Authentication, click Providers
5. Move NTLM above Negotiate
Windows Authentication Providers
Windows Authentication Providers

6. Completed!!!

Configure SharePoint Outgoing E-mail

Configure Outgoing E-mail for a Farm
1. In Central Administration, click System Settings
2. In E-Mail and Text Messages (SMS) section, click Configure outgoing e-mail settings
3. In Outbound SMTP server text box, input the SMTP server name for outgoing e-mail
4. In From address text box, input the e-mail address as you want it to be displayed to e-mail recipients
5. In Reply-to address text box, input the e-mail address to which you want e-mail recipients to reply
6. In Character set drop down list, select the character set that is appropriate for your language
7. Click OK

Configure Outgoing E-mail for a Web Application
1. In Central Administration, click Application Management
2. In Web Applications section, click Manage web applications
3. Select a web application, click General Settings > Outgoing E-mail
4. In Outbound SMTP server text box, input the SMTP server name for outgoing e-mail
5. In From address text box, input the e-mail address as you want it to be displayed to e-mail recipients
6. In Reply-to address text box, input the e-mail address to which you want e-mail recipients to reply
7. In Character set drop down list, select the character set that is appropriate for your language
8. Click OK

References