March 29, 2012 at 3:01 pm
I am not a newbie, but it has been a while.
We have 2 servers, one for the web app and one for SQlServer.
I have been installing, configuring and now trying to connect the 2 servers.
I have been trying to resolve this now for 3 days and can't find a solution.
Both servers are running windows 2008...Using SqlServer 2008 Standard (with Express & Standard installed on the same machine (Db machine)).
I reviewed the article "Connecting from another computer" (http://msdn.microsoft.com/en-us/library/ms345343.aspx) and followed it through using the standard port 1433.
Nothing works...We have Mgt. Studio on both servers and I have tried to communicate to the other server using this and the TEST.UDL program that I found reference to.
If anyone has any suggestions, PLEASE let me know. I have taken snapshots of 3 different error messages that come up, depending on what I try.
Thank you to anyone who can help us.
Take care,
March 29, 2012 at 3:29 pm
Can you send the errors through please.
The first thing that comes to mind is: Is the Windows Firewall enabled on the SQL Server and if so have you setup firewall rules?
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 29, 2012 at 5:47 pm
The answers are yes, and yes. Firewall is active, and did create a rule for the port.
Here are the 3 error messages:
1. The server was not found or was not accessable: Names pipes provider Error 40.
2. ditto, SQL network interfaces, error 26.
3. ditto, TCP provider, error 0, ...error 10060.
Hope this helps in the diagnosis.
Thanks and take care,
March 29, 2012 at 6:26 pm
Is the WEB app in a DMZ? You will need to open ports in the firewall and probably NAT them to connect to the SQL Server. A good sys admin should know how to do this.
If not, then try creating Program rules to the sqlservr.exe the full path will be something like this:
C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Binn\sqlservr.exe
Allow access of type domain.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 29, 2012 at 8:12 pm
haven't worked with this in quite awhile.
don't know DMZ and NAT.
Is there a specific port, other than 1433?
What other entry could I make that isn't already in there?
Thanks for your help.
March 30, 2012 at 12:10 am
Sorry I have to say the whole DMZ thing is really out of my area. I know you need to open a hole in the firewall, but I leaveit to the sys admin to fix.
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 2, 2012 at 10:12 am
How is your SQL Instance configured? Named Pipes, TCP/IP, Remote connections enabled... We need to know these things, as it could simply be a configuration setting. Also, since you have 2 instances, at least 1 must be named. Which instance is named and are you referencing it correctly if that is the one you are trying to connect to? Are you sure the instance that you are trying to connect to is running?
Jared
CE - Microsoft
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply