Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Unable to connect to Sql Server

Author  Topic 

steinster
Starting Member

5 Posts

Posted - 2012-08-25 : 05:37:28
Hi,

I've just installed Sql Server 2008 on a Windows Server 2008 R2, but I cant figure out how to connect to it remotely.

I've done everything suggested in this article http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

but still no-go.

I tried connecting to the IP and IP/InstanceName.
But its the only instance on the server so I only need to connect to IP, right ?

Any ideas would be appreciated :)

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-25 : 12:52:25
1) Can you connect while on the server? With servername\instance_name?
2) From remote can you ping the server?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

steinster
Starting Member

5 Posts

Posted - 2012-08-25 : 18:11:38
Thanks for replying,

I figured it out after looking over all the settings like 30 times.
It was I firewall I didnt know was there. I saw the link as I pressed "Reset server".
So after reinstalling everything and changing the secret firewall it worked ! :)
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-26 : 02:06:13
That's good news. Was it a firewall on the OS?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

steinster
Starting Member

5 Posts

Posted - 2012-08-26 : 04:39:08
I just recently rented a virtuel server, and the company who hosts the server apparently had an extra firewall just for safety. I configured and reconfigured windows firewall to allow for sql server traffic, but its a no go when you're on the wrong firewall :)
Go to Top of Page
   

- Advertisement -