Question

Locked

SQL connection

By wraidy ·
Hello,

I have 2 sql server on 2 different domain but there's ping between both sites.but suddently the 2 servers stopped to get connected to each other both can't connect either by NAme of the serve or by IP .

I checked my access-list by i everyhtign is allow.

Can some advise

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

SQL2000 or 2005 onwards ?

by Tony Hopkinson In reply to SQL connection

And what changed things like this don't just suddenly stop working.

Collapse -

Exactly

by mamies In reply to SQL2000 or 2005 onwards ?

I would also be looking at the firewall as well. Infact their is probably a number of issues that could stop this

Collapse -

Firewall no access-list to block sql

by wraidy In reply to Exactly

I gave it permit IP any any and i can ping telnet ip 1433 i've been told it's used by sql connection is there 's any other thing to make sure or other port number but the think is nothing changed on the network and the 2 sites are connected by a core swith and then tunnel on the router in both sites and on my sitch the vlan can permit both IP


But can you kinldy suggest a test to make sure 100 % ?

Collapse -

SQL Browser server uses port 1434

by Tony Hopkinson In reply to Firewall no access-list t ...

introduced in SQL 2005.
.Net ADO connection query the browser and get a dynamic port for the instance.
Previous to that DNS.exe implemented SSRP protocol for same (ish) purpose.

There are masses of things that can break connectivity depending on your set up. But something must have changed for it to break suddenly.

Collapse -

Urgent Help

by wraidy In reply to SQL2000 or 2005 onwards ?

The thing that changed is that i think i have a DNS problem.
because i tried Telnet ip 1433 on the both server and they can connect to each other and as i know it's the protocol used for sql connection.
but i don't have a name resolving between both sites i can access there sites using \\Ip but not \\servername i think it's affecting the SQL server .
I added an entry in DNS in my site but still not working could it be from the DNS in the other site if the DNS is not working there and mine is working with the entry of his server can i still connect by server name..

Please advice because i need to weel define the problem.Thanks in advanced

Collapse -

SQL 2000 or SQL 2005 onwards ?

by Tony Hopkinson In reply to Urgent Help

??????

From 2000 onwards you could have more than one instance on each sql server, all 1433 and now 1434 does is resolve the instance name (default MachineName/MSSQLServer).

Then there's surface re config, windows fire wall, routing/switching, hardware fire walls. Service pack collisions, particularly pre 2005.

I've seen all sorts of reasons why connections were refused. If it's one server to another, then there's remote servers to consider as well.

If you can't answer the question 2000 or 2005/2008 any help you get will be down to extreme luck.

Collapse -

Why the duplicate?

by scott_heath In reply to SQL connection

You already posted this question and I made some suggestions. Did you try them?

Regards,
Scott

http://scottisageek.spaces.live.com

Collapse -

DNS issue

by wraidy In reply to Why the duplicate?

Dear Scott,


i tried an entry on the DNS as you suggested on one site by creating a Hostname and it didn't work shall i create same hostname entry on the DNS of the other site or can it stoped if the other DNS is not working

Back to Networks Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums