Remote Connection and 2008 r2 sp1

Question

Post reply

Remote Connection and 2008 r2 sp1

Staggerlee

SSCertifiable

Points: 5272
More actions
July 19, 2011 at 6:04 am

#241667

Driving me nuts here..
Installed 2008 r2 then upgraded to SP1.
Remote connections are enabled
SQL Browser is on
Firewall is off
I can ping the server.
Soon as i try a SQL connect via SSMS i get the normal error of:
An error occurred while establishing a connection to server. When connectiing to SQL Server
--
Secondly and possibly related.
Ive downloaded all the 64bit installs for sp1. I ran the "SQLServer2008R2SP1-KB2528583-x64-ENU" and joy. upgrade works. But what is the "SQLManagementStudio_x64_ENU" for? When i try and run it. It comes up like the normal install of SQL Server 2008. So im not sure if i should be Upgrading or adding features to an existing install.
Thanks for any advice
S

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

CarpenterBob Ten Centuries Points: 1026 More actions · Answer 1

you have tryed both windows and SQL server Authentication ?

dec_obrien Default port Points: 1486 More actions · Answer 2

Hi,

I've been scratching my head on something similar. I couldn't connect to the database from the server on which it was running (test DSN). I tried every combination of creating the database user first, then the login/ vice versa, changed permissions etc all to no avail. i then tried connecting using Windows Authentication and it worked. After a bit more head-scratching, I found out that there is an Authentication Mode setting on the install set by default to Windows Authentication only which you need to change to Windows & SQL Server Authentication. You need to restart teh SQL Server service after this. Also, for remote connections, enable TCP/IP connections.

Hope this helps.

Staggerlee SSCertifiable Points: 5272 More actions · Answer 3

hi guys thanks for the replies.

so i thought of a few more things that it might be and have still had no joy connecting to it.

1: The new server is on the same domain as the machine that im connecting from.

2: SQL Browser is on

3: TCIP named pipes etc are all on.

4: It is in Mixed mode, And i cant connect via a SQL Account or a Windows domain Account.

5: Tried a restart just to try it.. (Im in IT)

Ive never seen this issue before and been creating quite a few SQL boxs recently. Is it to do with the upgrade to SP 1?

Again for SP1 all i have done is run the SQLServer2008R2SP1-KB2528583-x64-ENU. and dont know what the other one is for.

If anyone can even answer that one it would be good!

Thanks for the help

S

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 4

I had faced something like same 3-4 years back. That day network guy came and did some changes in IP configuration. Most probably DNS Server. Sorry, Do not know actually. But you can check that also.

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Staggerlee SSCertifiable Points: 5272 More actions · Answer 5

C.K

you got me excited there! Ive managed to put them in the wrong way before and thought that be it! sadly they are in correct 🙁

Still not solved.

Thanks for the idea though

S

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 6

Can you connect by using the IP-Address and the port number?

My blog

Staggerlee SSCertifiable Points: 5272 More actions · Answer 7

ive tried ip address and ip:1433 (its a default instance, no other instances installed on that machine)

and no joy on either..

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 8

stebennettsjb (7/20/2011)
ive tried ip address and ip:1433 (its a default instance, no other instances installed on that machine)
and no joy on either..

Instead of "ip:1433", try "ip,1433".

My blog

Staggerlee SSCertifiable Points: 5272 More actions · Answer 9

Sorry yes.. I did it that way! getting late in day mind is go a stray. No joy

thanks

Stephen

Staggerlee SSCertifiable Points: 5272 More actions · Answer 10

Still got this problem

tried the random idea of it being SP1 that caused the problem so removed SP1, but still cant connect.

Suammry:

2008 r2 Dev edt

remote connections allowed

sql browser enabled

Windows firewall is disabled

checked TCP settings. They are correct

I can ping both DNS name and IP

I can remote from the problem machine to any other SQL Server via SSMS

I cant connect with DNS name

I cant connect with IP and port

If i try to connect with SQLCMD i get:

A network-related or in stance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For information see SQL Server Books Online..

SQLCMD: Error: Microsoft SQL Server Native client 10.0 : Login timeout expired.

When i attempt to remote SSMS on. On the problem machine i can see a successful login for the machine im remoting from!?

Any ideas?

thanks

s

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 11

stebennettsjb (7/26/2011)
Still got this problem
tried the random idea of it being SP1 that caused the problem so removed SP1, but still cant connect.
Suammry:
2008 r2 Dev edt
remote connections allowed
sql browser enabled
Windows firewall is disabled
checked TCP settings. They are correct
I can ping both DNS name and IP
I can remote from the problem machine to any other SQL Server via SSMS
I cant connect with DNS name
I cant connect with IP and port
If i try to connect with SQLCMD i get:
A network-related or in stance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For information see SQL Server Books Online..
SQLCMD: Error: Microsoft SQL Server Native client 10.0 : Login timeout expired.
When i attempt to remote SSMS on. On the problem machine i can see a successful login for the machine im remoting from!?
Any ideas?
thanks
s