Avatar of rojiru
rojiru 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!
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
rojiru

8/22/2022 - Mon
Abhigyan Srivastava

Firewall. Open the port in the windows firewall as well.
ASKER
rojiru

Firewall currently disabled. No change. Strange that there is no listing in netstat output for port 1433.
Abhigyan Srivastava

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Éric Moreau

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?
ASKER
rojiru

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
Abhigyan Srivastava

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
rojiru

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.