Video Screencast Help
Search Video Help Close Back
to help

Error 11501: Unable to create the database for Symantec Endpoint Protection Manager

Created: 24 Feb 2012 | 8 comments
Prakash_007's picture
0 0 Votes
Login to vote

Hi,

 

I tried to re-configure SEPM 12.1 with SQL database but getting error Error 11501: Unable to create the database for Symantec Endpoint Protection Manager

I tried to creat new database still same issue

Steps I tried :

Not able to connect to database Error 11501: Unable to create the database for Symantec Endpoint Protection Manager

Ping the SQL server no issue.

Telenet the port 1433 no issue.

Used both SA and windows Authentication  but still same issue.

In SQL Server Configuration Manager,

Checked SQL Server Network Configuration > Protocols for MSSQLSERVER, found enable TCP/IP protocol.

Provide Ip address of SQL server and FQDN tried but still same issue. 

Comments 8 CommentsJump to latest comment

pete_4u2002's picture

  • Microsoft SQL Server 2000:
    In SQL Server Network Utility, add TCP/IP to the Enabled protocols list.
  • Microsoft SQL Server 2005 or 2008:
    In SQL Server Configuration Manager, go to SQL Server Network Configuration > Protocols for MSSQLSERVER, and enable TCP/IP protocol.
  •  
  • Once you enable the TCP/IP protocol, restart the SQL Server service.

     

  •  
  •  
  • check this link
  • http://www.symantec.com/business/support/index?page=content&id=TECH95291
  • 0
    Login to vote
    • Actions
    Prakash_007's picture

    I already tried that but still no GO

    ~~~~~> Prakash A

    Please mark thread as solved if you consider this to have answered your question(s).

    0
    Login to vote
    • Actions
    pete_4u2002's picture

    can you open sql studio, then check the name server name, is it the same you entered?

    0
    Login to vote
    • Actions
    Prakash_007's picture

    Followed the Article : Article URL http://www.symantec.com/docs/TECH95294
    Article URL http://www.symantec.com/docs/TECH104826

    Installed SQL in new machine but still same issue

    ~~~~~> Prakash A

    Please mark thread as solved if you consider this to have answered your question(s).

    0
    Login to vote
    • Actions
    sandra.g's picture

    Exactly which version of SQL is on the remote server? If it is an Express or Compact version, that is not supported.

    If it is a supported version, are the SQL Client Tools installed on the SEPM box?

    sandra

    Symantec, Information Development, IMDP
    Symantec Endpoint Protection / Core Security Engineering Group

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

    0
    Login to vote
    • Actions
    AravindKM's picture

    Are you able to login to SQL server by using SQL studio which is installed in SEPM?

    Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

    0
    Login to vote
    • Actions
    Yahya's picture

     

     

    create a file with any name and its extension is udl (eg. sql.udl). Open the file and enter the details you have for sql and check if you have access or not. If you do have access, connect to sql studio and check the permissions you have.

     
     

    0
    Login to vote
    • Actions
    SameerU's picture

    There are two problems that can cause this error message to appear.

    Network connectivity between the Symantec Endpoint Protection Manager and the Microsoft SQL Server is unavailable
    Ensure that the Symantec Endpoint Protection Manager can communicate with the SQL server.
    Ensure that the SQL server's IP address is entered correctly in the Server Configuration Wizard on the Manager.
    Use the ping command to determine whether network traffic can flow between the Manager and the SQL server.

    The TCP/IP protocol is disabled in Microsoft SQL Server itself
    In this case, enable the TCP/IP protocol in Microsoft SQL Server. To enable TCP/IP, follow the instructions for your version of Microsoft SQL Server:

    • Microsoft SQL Server 2000:
      In SQL Server Network Utility, add TCP/IP to the Enabled protocols list.
    • Microsoft SQL Server 2005 or 2008:
      In SQL Server Configuration Manager, go to SQL Server Network Configuration > Protocols for MSSQLSERVER, and enable TCP/IP protocol.

    Once you enable the TCP/IP protocol, restart the SQL Server service.

    0
    Login to vote
    • Actions