Link to home
Start Free TrialLog in
Avatar of Roger Crane
Roger CraneFlag for United States of America

asked on

MS SQL Server connection error

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!
Avatar of Abhigyan Srivastava
Abhigyan Srivastava
Flag of India image

Firewall. Open the port in the windows firewall as well.
Avatar of Roger Crane

ASKER

Firewall currently disabled. No change. Strange that there is no listing in netstat output for port 1433.
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.
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?
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!
ASKER CERTIFIED SOLUTION
Avatar of Abhigyan Srivastava
Abhigyan Srivastava
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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