View previous topic :: View next topic |
Author |
Message |
althurm
Joined: 09 Aug 2016 Posts: 9
|
Posted: Wed Aug 17, 2016 2:09 pm Post subject: error setting up my SQL Server Db |
|
|
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 |
|
|
juwi_uk
Joined: 10 Mar 2014 Posts: 47
|
Posted: Wed Aug 17, 2016 5:28 pm Post subject: Re: error setting up my SQL Server Db |
|
|
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 |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Wed Aug 17, 2016 11:43 pm Post subject: |
|
|
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 |
|
|
juwi_uk
Joined: 10 Mar 2014 Posts: 47
|
Posted: Thu Aug 18, 2016 7:12 am Post subject: |
|
|
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 |
|
|
althurm
Joined: 09 Aug 2016 Posts: 9
|
Posted: Thu Aug 18, 2016 12:40 pm Post subject: |
|
|
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 |
|
|
|