+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Corero - SQL Permissions [Solved] in Technical; Hi, We have the Corero Financial system and have setup on a SQL 2010 Database. It worked fine on training ...
  1. #1

    Join Date
    Sep 2010
    Location
    NE Lincolnshire
    Posts
    137
    Thank Post
    22
    Thanked 3 Times in 3 Posts
    Rep Power
    9

    Question Corero - SQL Permissions [Solved]

    Hi,

    We have the Corero Financial system and have setup on a SQL 2010 Database. It worked fine on training (I wasnt here) but now no one can get on due to SQL permissions.

    The users have dbowner permissions on both live and training databases so cant understand why that is not enough!

    Does anyone know what persmissions users need on teh SQL databases to be able to connect??

    Thanks
    E

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,601
    Thank Post
    725
    Thanked 1,685 Times in 1,500 Posts
    Rep Power
    432
    Have you spoken to Corero about it?

    Ben

  3. #3

    Join Date
    Sep 2010
    Location
    NE Lincolnshire
    Posts
    137
    Thank Post
    22
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    Yes. No one on there Helpdesk knows how to deal with it!

  4. #4

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,601
    Thank Post
    725
    Thanked 1,685 Times in 1,500 Posts
    Rep Power
    432
    Connection settings in the application are correct?

    Is this web based system or tradditional client/server?

    Firewall?

    Ben

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,156
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Are the training and real databases on the same server? If not, are external connections enabled for SQL?

  6. #6

    Join Date
    Aug 2011
    Location
    Rickmansworth
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi. I am the IT manager at Corero and will look at this issue for you tomorrow morning (24th August). Either the support department or myself will call you to see if we can resolve the problem.

    Regards

  7. #7

    Join Date
    Aug 2011
    Location
    Rickmansworth
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi

    The issue, as you have found out, is the Windows Firewall which blocks access to the required ports.

    When you turn the firewall back on you will need to create a rule to allow access to SQL Server. If SQL Server is installed in the default instance then the TCP port you will need to allow access to is 1433, If SQL in installed into a named instance then the TCP port is normally 1434.
    Regards
    Mark

  8. Thanks to CoreroIT from:

    vikpaw (27th August 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Installer couldn't detect a valid SQL instance [Solved]
    By harryeds in forum MIS Systems
    Replies: 16
    Last Post: 2nd October 2013, 06:23 PM
  2. [SIMS] SQL Backup with dbAttach [Solved]
    By Rawns in forum MIS Systems
    Replies: 5
    Last Post: 6th January 2011, 10:17 AM
  3. MS SQL server database permissions and users
    By localzuk in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 30th September 2009, 10:40 AM
  4. Local system permissions on SQL Server 2005
    By powdarrmonkey in forum Coding
    Replies: 2
    Last Post: 30th September 2008, 12:38 PM
  5. Keep them permissions!
    By woody in forum Windows
    Replies: 5
    Last Post: 2nd August 2005, 11:15 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •