AutoSpInstaller Aliases

May 31, 2012 at 6:32 AM

I have requirement to use 3 aliase

sp_saerch

sp_admin

sp_content for content sites...

autospinstaller xml has 2 places where i can use sp_search and sp_admin for my db requiremnet.

i need to use my 3rd alias fro my webapplication and mysites.

help wd be appreciated...

 

 

May 31, 2012 at 7:11 PM

Do you mean SQL Server aliases or are you talking about service accounts?

May 31, 2012 at 10:30 PM

yep i am talking about sql server aliases

http://splog.cairo.ag/2011/02/22/using-sql-server-alias-names-with-sharepoint-server-2010/

autospinstaller xml has 2 places where i can use sp_search and sp_admin for my db requiremnet.

i need to use my 3rd alias fro my webapplication and mysites.

help wd be appreciated...

 

Jun 5, 2012 at 1:58 AM

In the "WebApplication" section of the input XML there is a place to create and use a SQL alias (around line 193 in version 3.0.3):

<DBAlias Create="false"
                         DBInstance="SERVER\INSTANCE"
                         DBPort="" />

This is where you'd specify the alias you want for the content databases.