We help IT Professionals succeed at work.

MS SQL Server connection error

rojiru
rojiru asked
on
96 Views
Last Modified: 2016-01-20
I am no dba by any means. The unfortunate one tasked with migrating a CRM to a new server. The server is Windows Server 2012 R2 with all patches installed. I've installed MS SQL Server 2008 R2 Express SP2 Advanced. I've installed the CRM (tigerpaw) per their instructions.

The error is [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. The error comes up, when I try to connect with the crm database utility from the server itself.

I've searched for any info. I've enabled both TCP and NamedPipes in SQL Configuration Manager. I've set SQL to listen on specific IP addresss and TCP port 1433. Rebooted server. Running netstat -a at cmd prompt does not list port 1433 as a listening port.

What am I missing?

Thanks for the help!
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Firewall. Open the port in the windows firewall as well.

Author

Commented:
Firewall currently disabled. No change. Strange that there is no listing in netstat output for port 1433.
CERTIFIED EXPERT

Commented:
Hmm... OK. Try connecting to SQL Server using SQL Server Management Console. Let me know if you are able to connect to it via MMC.
Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:
Since you have installed the advanced edition, you surely have SSMS installed. Can you open it and try to connect? Is your instance name something like YourServer\SQLExpress by any chance? What do you provide as the connection string to your CRM?

Author

Commented:
Connection via SSMS works fine from the server. Instance name is servername\SQLEXPR2K8R2. I just use the IP address to connect from CRM database Utility. I've tried the servername only, but did not work. On the production server I can connect using the IP address from the database utility.

I ran netstat -a  on production server. The output lists port 1433 as listening.

I've checked the compatibility for MS SQL Server 2008 R2 and Windows Server 2012 R2. As far as I can tell, SP3 needs to be installed. Unfortunately the download site is not responding.


Thanks!
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
My apologies for the delayed response. It worked using servername\instance name. Nuts... and I was sniffing down the wrong trail! Oh welll!

Thanks guys for the help!
Roger

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.