Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Member List  Search  FAQ  Ticket List  Log Out

 

can't change new GFI install to SQL Database

  		Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Networking & Security] >> GFI LANguard >> can't change new GFI install to SQL Database Page: [1]
Login
Message << Older Topic   Newer Topic >>
can't change new GFI install to SQL Database - 25.Sep.2009 10:26:16 AM   
ac2009

 

Posts: 4
Joined: 25.Sep.2009
Status: offline 		I've installed GFI Languard 9 (build 20090709) on a new Win 2003 Server machine with SQL 2005 Express.  I tried changing the Database from the default Access database to SQL through the "Modify default settings" page. 

I choose to use NT authority (my account and the GFI service account are local admins on the server, therefor also admins on SQL) and I received the error "failed to connect to database"

I then tried SQL credentials, after following the instructions on this page to enable the sa account
http://kbase.gfi.com/showarticle.asp?id=KBID002804

I restarted SQL and GFI and I still receive the error "failed to connect to database"

What else can I do to get GFI to use SQL instead of Access?
Post #: 1
RE: can't change new GFI install to SQL Database - 25.Sep.2009 12:04:54 PM   
mblinde

 

Posts: 62
Status: offline 		Have you tried using SQL authentication and using the SA account for trouble shooting purposes?

(in reply to ac2009)
Post #: 2
RE: can't change new GFI install to SQL Database - 25.Sep.2009 12:08:00 PM   
ac2009

 

Posts: 4
Joined: 25.Sep.2009
Status: offline 		Yes I have tried the SA account.

"I then tried SQL credentials, after following the instructions on this page to enable the sa account
http://kbase.gfi.com/showarticle.asp?id=KBID002804

I restarted SQL and GFI and I still receive the error "failed to connect to database"

(in reply to mblinde)
Post #: 3
RE: can't change new GFI install to SQL Database - 25.Sep.2009 12:59:47 PM   
DrewE

 

Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline 		Does the GFI Languard database already exist on the SQL server? Is this a new install where the database should be empty? If so, try deleting it and using the SA password letting our application create it again.

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to ac2009)
Post #: 4
RE: can't change new GFI install to SQL Database - 25.Sep.2009 1:07:48 PM   
ac2009

 

Posts: 4
Joined: 25.Sep.2009
Status: offline 		These are the only databases on the machine.  They are the defaults, correct?

master
model
msdbdata
mssqlsystemresource
templog

(in reply to DrewE)
Post #: 5
RE: can't change new GFI install to SQL Database - 25.Sep.2009 1:09:46 PM   
DrewE

 

Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline 		Is SQL installed locally on the GFI Languard server?

Are you using SQL Express? If so, try using:
Servername: SQLSERVERNAME\SQLEXPRESS

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to ac2009)
Post #: 6
RE: can't change new GFI install to SQL Database - 25.Sep.2009 1:12:41 PM   
ac2009

 

Posts: 4
Joined: 25.Sep.2009
Status: offline 		That did it!  Thank you very much.

(in reply to DrewE)
Post #: 7
Page:   [1]
All Forums >> [Networking & Security] >> GFI LANguard >> can't change new GFI install to SQL Database Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts