Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL installation

Created: 25 Jan 2013 • Updated: 28 Jan 2013 | 10 comments
This issue has been solved. See solution.

SQL server 2008 installation..?

Discussion Filed Under:

Comments 10 CommentsJump to latest comment

Ambesh_444's picture

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

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

SebastianZ's picture

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's picture

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
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

annie@1's picture

Hi Team,

Is there any query for sep host name?

Ambesh_444's picture

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

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

SOLUTION
zafar1907's picture

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's picture

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's picture

Hi Ambesh,

This query is for ?

Thanks and Regards,

Mohammad zafar

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

Ambesh_444's picture

Hi All,

This query for sep host name.

 

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

annie@1's picture

Hi Ambesh,

Thanks for prompt reply.