Previous Post Next Post

SQL installation

Created: 25 Jan 2013 | Updated: 28 Jan 2013 | 10 comments

annie74416

This issue has been solved. See solution.

SQL server 2008 installation..?

Discussion Filed Under:

Security, Endpoint Protection (AntiVirus)

Comments RSS Feed

Comments 10 Comments • Jump to latest comment

Ambesh_444 Partner Accredited

SQL installation - Comment:25 Jan 2013 : Link

Hi,

Please follow the below steps for the same and let know if it helps you.

http://blog.sqlauthority.com/2008/06/12/sql-server...

http://experiencing-sql-server-2008.blogspot.in/20...

http://www.sqlserverclub.com/essentialguides/how-t...

Thank& Regards,

Ambesh

Please mark your thread as 'SOLVED' with the answer that helps you.

SebastianZ Symantec Employee

SQL installation - Comment:25 Jan 2013 : Link

If you need information for installing SEPM with a database on SQL Server please have a look here:

http://www.symantec.com/docs/HOWTO36029

http://www.symantec.com/docs/HOWTO17973

Mithun Sanghavi Symantec Employee Technical Support Accredited

SQL installation - Comment:25 Jan 2013 : Link

Hello,

Could you be a little more specific??

Are you looking forward for assistance to know -

1) If the SEP/SEPM is supported on SQL Server 2008?

If yes, then yes it is supported. Check this Article:

http://www.symantec.com/business/support/index?page=content&id=TECH163806

2) Best Practices of SEP installation in SQL server 2008??

Check this -

Best Practices for Installing Symantec Endpoint Protection (SEP) on Windows Servers

http://www.symantec.com/docs/TECH92440

3) What are the SQL Server configuration settings ?

Check these Articles:

http://www.symantec.com/docs/HOWTO55330

http://www.symantec.com/docs/TECH191859

4) Migrating to Microsoft SQL 2008 from a previous version?

http://www.symantec.com/docs/HOWTO17917

Hope that helps!!

Mithun Sanghavi
Symantec Technical Support Engineer, SEP
MIM | MCSA | MCTS | STS | ITIL v3

Twitter: @mithun_sanghavi

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<&a

annie74416

SQL installation - Comment:28 Jan 2013 : Link

Hi Team,

Is there any query for sep host name?

Ambesh_444 Partner Accredited

SQL installation - Comment:28 Jan 2013 : Link

Hello Annie,

Please let me know if your sql installation problem id resolved or not...? If yes then plz mark as a solutions which articles you helps best.

and please find the below query for the sep host name and check i hope it will be help you.

Use sem5

SELECT DISTINCT "SEM_AGENT"."DELETED","PATTERN"."VERSION","PATTERN"."PATTERNDATE","SEM_AGENT"."AGENT_VERSION","SEM_CLIENT"."COMPUTER_NAME" "Computer Name",

"SEM_COMPUTER"."OPERATION_SYSTEM" "Operation System",dateadd(s,convert(bigint,"SEM_AGENT"."CREATION_TIME")/1000,'01-01-1970 00:00:00') CREATION_DTTM, dateadd(s,convert(bigint,"SEM_AGENT"."LAST_UPDATE_TIME")/1000,'01-01-1970 00:00:00') Lastupdatetime,

DATEADD(s, convert(bigint,LAST_SCAN_TIME)/1000, '01-01-1970 00:00:00')"Last Scan Time",

"PATTERN"."PATTERNDATE" "Pattern Date", "SEM_CLIENT"."USER_NAME" "User Name",

"V_SEM_COMPUTER"."IP_ADDR1_TEXT" "IP Address", "IDENTITY_MAP"."NAME" "Group Name"

FROM (((("SEM_AGENT" "SEM_AGENT" INNER JOIN "SEM_CLIENT" "SEM_CLIENT" ON (("SEM_AGENT"."COMPUTER_ID"="SEM_CLIENT"."COMPUTER_ID") AND ("SEM_AGENT"."DOMAIN_ID"="SEM_CLIENT"."DOMAIN_ID")) AND ("SEM_AGENT"."GROUP_ID"="SEM_CLIENT"."GROUP_ID")) INNER JOIN "SEM_COMPUTER" "SEM_COMPUTER" ON (("SEM_AGENT"."COMPUTER_ID"="SEM_COMPUTER"."COMPUTER_ID") AND ("SEM_AGENT"."DOMAIN_ID"="SEM_COMPUTER"."DOMAIN_ID")) AND ("SEM_AGENT"."DELETED"="SEM_COMPUTER"."DELETED")) INNER JOIN "PATTERN" "PATTERN" ON "SEM_AGENT"."PATTERN_IDX"="PATTERN"."PATTERN_IDX") INNER JOIN "IDENTITY_MAP" "IDENTITY_MAP" ON "SEM_CLIENT"."GROUP_ID"="IDENTITY_MAP"."ID") INNER JOIN "V_SEM_COMPUTER" "V_SEM_COMPUTER" ON "SEM_COMPUTER"."COMPUTER_ID"="V_SEM_COMPUTER"."COMPUTER_ID" and "SEM_AGENT"."DELETED"=0 and "V_SEM_COMPUTER"."computer_name" in

('2356-w-6001',

2356-w-6002',

2356-w-6003',

2356-w-6004',

' 2356-w-6005')

Note:- (2356-w-6001 to 2356-w-6005 are the host name of your coputer's, So whenever you run the query the delete the below host name and add your system's host name.)

Thank& Regards,

Ambesh

Please mark your thread as 'SOLVED' with the answer that helps you.

SOLUTION

zafar1907 Partner

SQL installation - Comment:28 Jan 2013 : Link

Hi Annie,

Please check this thread. Here are some Queries

https://www-secure.symantec.com/connect/forums/sql...

And please be more specific while Questioning...

Regards,
Zafar

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

SebastianZ Symantec Employee

SQL installation - Comment:28 Jan 2013 : Link

Have a look at the SQL database Scheme reference - this may be helpful for you:

http://www.symantec.com/docs/DOC4324

As well note that you can get logs and reports about the SEPM clients by using logs and reports:

http://www.symantec.com/business/support/index?pag...

Here another thread about SQL Queries to SEPMd database:

https://www-secure.symantec.com/connect/forums/sql...

zafar1907 Partner

SQL installation - Comment:28 Jan 2013 : Link

Hi Ambesh,

This query is for ?

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

Ambesh_444 Partner Accredited

SQL installation - Comment:28 Jan 2013 : Link

Hi All,

This query for sep host name.

Thank& Regards,

Ambesh

Please mark your thread as 'SOLVED' with the answer that helps you.

annie74416

SQL installation - Comment:28 Jan 2013 : Link

Hi Ambesh,

Thanks for prompt reply.