Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

error setting up my SQL Server Db

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support
View previous topic :: View next topic  
Author Message
althurm



Joined: 09 Aug 2016
Posts: 9

PostPosted: Wed Aug 17, 2016 2:09 pm    Post subject: error setting up my SQL Server Db Reply with quote

Hello All,

I am installing infralution license tracker 6.2.0. Going through the wizard I use SQL Server and then get to the point where is asks for me to put the name of the sQL Server DB. I have an existing db that i use and i know it works because I have installed on another computer. When i clikc next I get an error: "There was an error opening a connection to the databse. Check the connection parameters are correct"

I am wondering if there are logs created during the install or what else i can do to figure out what is wrong. Any help appreciated
Back to top
View user's profile Send private message
juwi_uk



Joined: 10 Mar 2014
Posts: 47

PostPosted: Wed Aug 17, 2016 5:28 pm    Post subject: Re: error setting up my SQL Server Db Reply with quote

If I understand correctly the the DB is on one PC and you are trying to install ILS on another PC and go through the wizard?

One quick check you could do is try to setup a quick ODBC connector to your SQL database on this PC as if this works and TEST OK you know your credentials are OK and nothing blocking the inter-machine comms such as a firewall/AV.

My thoughts.

althurm wrote:
Hello All,

I am installing infralution license tracker 6.2.0. Going through the wizard I use SQL Server and then get to the point where is asks for me to put the name of the sQL Server DB. I have an existing db that i use and i know it works because I have installed on another computer. When i clikc next I get an error: "There was an error opening a connection to the databse. Check the connection parameters are correct"

I am wondering if there are logs created during the install or what else i can do to figure out what is wrong. Any help appreciated
Back to top
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 4782

PostPosted: Wed Aug 17, 2016 11:43 pm    Post subject: Reply with quote

Along the same lines. I would try installing SQL Management Studio (https://msdn.microsoft.com/en-us/library/mt238290.aspx) and try connecting to the remote machine using the same credentials. Most likely it is a problem with how you have specified the SQL Server name.
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
juwi_uk



Joined: 10 Mar 2014
Posts: 47

PostPosted: Thu Aug 18, 2016 7:12 am    Post subject: Reply with quote

I had thought about that too, but installing management studio a more lengthy process that a quick ODBC connection test as that utility is part of windows OS. That said Management Studio would probably be useful anyway if the DBMS is on another PC.

I agree with support it is likely to be the server name especially if you didnt install SQL under the default instance name.

Infralution wrote:
Along the same lines. I would try installing SQL Management Studio (https://msdn.microsoft.com/en-us/library/mt238290.aspx) and try connecting to the remote machine using the same credentials. Most likely it is a problem with how you have specified the SQL Server name.
Back to top
View user's profile Send private message
althurm



Joined: 09 Aug 2016
Posts: 9

PostPosted: Thu Aug 18, 2016 12:40 pm    Post subject: Reply with quote

Thanks guys for your help. Turns out I had the SQL Server name and the DB name reversed in the boxes in the wizard.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group