SPIRITweb Account SQL (2.15.05)

The Database Administrator needs to execute the following query with a System Administrator username and password to create a SPIRITweb account with limited rights. The SPIRIT web applications use this user account when executing any query against the database.

The <DataBaseName> must be replaced with the actual database where the user account is to be created.

use master

GO

CREATE LOGIN [spiritweb]

WITH PASSWORD = 'sp1r1t7676',

CHECK_POLICY = OFF;

GO

USE <DataBaseName>

GO

CREATE USER [spiritweb] FOR LOGIN [spiritweb]

GO

USE <DataBaseName>

GO

EXEC sp_addrolemember N'db_datawriter', N'spiritweb'

GO

USE <DataBaseName>

GO

EXEC sp_addrolemember N'db_datareader', N'spiritweb'

GO

GRANT EXECUTE TO [spiritweb]

GO

After executing the above query, change the web configuration files for Vendor Online Application and Vendor Online Price Survey to use the new user account created.

<connectionStrings>

<addname="ConnString" connectionString="Data Source=CSCRPTLXA004;Initial Catalog=WMNC11U;User ID=spiritweb;Password=sp1r1t7676" providerName="System.Data.SqlClient"/>

</connectionStrings>

·