GoldMine Loading Error

[MASolutions]

Folks,

Since installing Norton 360 on my server I have been receiving the following message when trying to load GoldMine OE 9.0:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I have un-installed the software, however am still receiving the same error. Could it be a firewall issue blocking the SQL server access? Or??

Looking forward to your response.

Thanks!

 

[gmmastros]

Could it be a firewall issue blocking the SQL server access?

Probably.

For a quick test....

click start -> Run
type firewall.cpl
click ok

temporarily turn off your firewall and try to connect. Whether you can connect or not, immediately put the firewall back on. report back here with the results of this quick test.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MASolutions]

Thank you for your response, George.

After turning the firewall off and rebooting the machine -- I am receiving the same message.

 

[gmmastros]

Is the sql server service started?

click start->run
type services.msc

scroll down to SQL Server, does it show the service as started?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MASolutions]

No - I get an 17058 error when trying to start the service.

 

[gmmastros]

That sounds like a permissions issue.

If you double click the service, and then click on the "log on" tab, what is configured? Sometimes you will see "Local System Account", and sometimes you will see an actual active directory account.

In either case, it seems like there is a permission problem. I would suggest that you create a new account in active directory specifically for the SQL Server service. Make sure this service has appropriate permissions to the server it is running on, and then configure the SQL Server service to use this new account.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MASolutions]

Now I am getting an 3417 error code.

 

[gmmastros]

Still sounds like a permissions issue. Please double check that the account you are using for the service log on has full permissions to the folder where your databases are. There may be multiple folders involved. It appears as though this error is specifically complaining about the folder where the master database is stored.

Do a search on the server for master.mdf and then make sure the service has full permissions to that folder.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MASolutions]

Hi George,

I have dbl-checked the folder permissions, and created a user named: SQLM; and still receive the 3417 error. Thoughts/Comments?

 

[gmmastros]

As a test, can you set the SQLM account to be a local administrator? You may not want to leave it that way, but if that account is local administrator, it rules out permissions issues.

Just like the firewall, this is probably not something you want to keep like this.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MASolutions]

Same error...

 

[gmmastros]

Bad news.

From my understanding, there are 2 causes for that error.

1. Permissions error on the master database files.
2. Corrupt master database.

Since it doesn't seem like a permissions error, I would guess it's a corrupt master database file. I understand that there are ways to rebuild the master database, but I have never done it, and wouldn't feel comfortable advising it.

I strongly suggest that you make sure you have a good backup of the entire system before proceeding, no matter what you decide to do.

Sorry I couldn't help more. I wish you the best of luck.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom