| Reinstall - now cant connect (resolved) | |
Posted: Thu Feb 13, 2014 11:43 am |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
Got a new computer, Windows 8.1 64 bit, so had to reinstall everything. SQL Server Express 2012 installed successfully. Goldmine database was successfully restored into SQL Server from recent bak. I can successfully log in to and browse GM database via Management Studio.
Installed Goldmine 2013.1.0.298 successfully but get errors logging in to the database. I believe it is something to do with dbalias.ini. The server name has changed and my log in credentials for SQL Server changed as well.
I changed these credentials in dbalias.ini but noticed the password is encrypted so I left that as is hoping it would ask for it. Still can't log in. Any suggestions? |
|
Last edited by jrich7 on Sat Feb 15, 2014 1:47 pm; edited 1 time in total |
|
|
|
| Error | |
Posted: Thu Feb 13, 2014 11:54 am |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
|
|
|
|
| dbalias.ini | |
Posted: Thu Feb 13, 2014 11:57 am |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
Here is the dbalias.ini
[General]
BDEMigrated=1
[Alias1]
Name=Goldmine
ServerType=MSSQL
HOST=JRSSSERVER\SQLEXPRESS
DATABASE=Goldmine
OWNER=dbo
LOGIN=sa
PASSWORD="H.*35!Q>= ; 1G%I>#3(@^4#7\;*5$5W2PT$YWV)^ \?_#[!2L6#4Z^-0#1,U!5!_P\#E$"
USE_SSPI= |
|
|
|
|
Posted: Thu Feb 13, 2014 12:35 pm |
Points: 0 |
|
cdohmen |
Cuckoo for GoldMine Puffs |
|
|
Joined: 06 Mar 2009 |
Posts: 255 |
Location: Pittsburgh, PA |
|
|
|
|
|
|
|
Backup your dbalias.ini. Delete the encrypted password and keep everything including the "=" sign. Try logging in again and you'll be promted to enter your credentials for SQL. If successful a new encrypted password will be placed in the dbalias.ini, if not you can restore your backup and try something else. |
|
|
|
|
| Can't connect | |
Posted: Thu Feb 13, 2014 5:50 pm |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
Thanks cdohmen but that didn't work. As you can see from my above picture I am already prompted for my log in name and password.
You see...problem is the name of the SQL Server has changed and so has my SQL log in and SQL password.
How can I create a new dbalias.ini? Should I reinstall Goldmine and state that I am creating a new database or something? Or can I modify my old dbalias.ini somehow to make this work? |
|
|
|
|
| Can't connect | |
Posted: Thu Feb 13, 2014 6:09 pm |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
|
Last edited by jrich7 on Thu Feb 13, 2014 6:13 pm; edited 3 times in total |
|
|
|
Posted: Thu Feb 13, 2014 6:10 pm |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
You need to enter the correct SQL login information: Usually "sa" and the proper password. If needed, you can go into SQL and change SA's password. |
|
|
|
|
| | |
Posted: Thu Feb 13, 2014 6:15 pm |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
I entered sa and the password when prompted at the window, Bob. See picture. Still fails to connect. Maybe this will provide more info:
Original dbalias.ini before reinstalling
[Alias]
Name=Goldmine
ServerType=MSSQL
HOST=JRSSJOHN\SQLEXPRESS
DATABASE=Goldmine
OWNER=dbo
LOGIN=SAM
PASSWORD="H.*35!Q>= ; 1G%I>#3(@^4#7\;*5$5W2PT$YWV)^ \?_#[!2L6#4Z^-0#1,U!5!_P\#E$"
USE_SSPI=
Modified dbalias.ini. Items in red were changed to match new SQL credentials
[Alias]
Name=Goldmine
ServerType=MSSQL
HOST=JRSSSERVER\SQLEXPRESS
DATABASE=Goldmine
OWNER=dbo
LOGIN=sa
PASSWORD="H.*35!Q>= ; 1G%I>#3(@^4#7\;*5$5W2PT$YWV)^ \?_#[!2L6#4Z^-0#1,U!5!_P\#E$"
USE_SSPI=
The original SQL log in name was called SAM because we used that instead of the common sa for security reasons. For this install we just went with the typical sa name. The HOST name (SQL Server name) seems to match the computer name so it has changed too. The new computer name is called JRSSSERVER, the old one was called JRSSJOHN.
Help appreciated. |
|
|
|
|
| RESOLVED ISSUE | |
Posted: Thu Feb 13, 2014 10:25 pm |
Points: 0 |
|
jrich7 |
GoldMine Nut |
|
|
Joined: 18 Mar 2009 |
Posts: 211 |
Location: Tampa, FL |
|
|
|
|
|
|
|
Through trial and error I resolved this issue somehow. Seemingly complex problems are usually simple as usual. The dbalias.ini said
[Alias]
Name=Goldmine
ServerType=MSSQL
HOST=JRSSSERVER\SQLEXPRESS
DATABASE=Goldmine
OWNER=dbo
LOGIN=sa
PASSWORD="H.*35!Q>= ; 1G%I>#3(@^4#7\;*5$5W2PT$YWV)^ \?_#[!2L6#4Z^-0#1,U!5!_P\#E$"
USE_SSPI=
All I had to do was remove the word "\SQLEXPRESS" from the line HOST in the dbalias.ini. When I changed it to this it worked and accepted my new SQL log in and password.
HOST=JRSSSERVER
This issue had nothing to do with the fact that I changed my SQL user name or password or even the new SQL Server name in my new installation. It had to do with the way the previous dbalias.ini was displaying the host name. |
|
|
|
|
| | |
Posted: Mon Feb 17, 2014 6:26 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
As you may or may not already know the \SQLExpress denotes the instance of SQL Server that is being used. If you used the Default SQL Server instance then only the Server Name is required.
Also, don't forget to open up Ports 1433 & 1434 through the Firewall for SQL Server. |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
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
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|