PDA

View Full Version : InstallShield Security



TVNDEV
03-15-2005, 07:39 AM
Hi,
I'm trying to execute some script through InstallShield - when viewing my SQL Profiler while the Installer is running I have noticed this.....

-- 'sp_addlogin' was found in the text of this event.
-- The text has been replaced with this comment for security reasons.

The application name in SQL Profiler is InstallShield - I require this bit of code to execute - how can I get around this issue - I have been unable to find any info relating to this in the InstallShield help....
The full section of code which has been removed / not executed is:
--get default language and database to add user
DECLARE @strPassword nvarchar(50)
SET @strPassword = N'ONCORE_PASSWORD'
DECLARE @stronCoreName2 nvarchar(50)
SET @stronCoreName2 = N'USERNAME'

if not exists (select * from master.dbo.syslogins where loginname = @stronCoreName2 )
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'us_english'
if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
select @logindb = N'master'
if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language
exec sp_addlogin @stronCoreName2 , @strPassword, @logindb, @loginlang
END
GO

Any help / information on this matter would be great.
Thanks
Tracey