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.
| Author |
Topic |
|
Timf1234
Starting Member
4 Posts |
 Posted - 2010-09-08 : 03:50:09
|
| I am using Windows 2008 server R2 and SQL Server 2008 Developer Edition with SP1 and SP2.using sql server management studio I couldn't connect to the sql server. I opened up all the necessary ports. But still couldn't connect.Error message:A network related or instance-specific error occurred while establishing a connection to sql server.Error 40- ........Any idea? |
|
|
nilupa
Starting Member
8 Posts |
Posted - 2010-09-08 : 23:34:52
|
| can u elaborate more on this will be helpful.. |
 |
|
|
Timf1234
Starting Member
4 Posts |
Posted - 2010-09-11 : 00:14:42
|
| How can one tell which of the IP1, IP2, .....IPn, in sql server configuration manager->Database engine is for the sql server? I want to assign a specific port number to the sql server.I am aware of the fact that I also need to open that pors in the windows firewall.I will type up the ip address, port number in the SSMS connection user interface to connect to the server from a remote location |
|
|
|
nilupa
Starting Member
8 Posts |
Posted - 2010-09-11 : 01:12:40
|
| the default port is 1433. did u try to connect using that port or you assign a custom port for it.ur requirement is connect to sql server 2008 r2 from sql server 2008 developer edition using management studio, isn't it.then check whether the communication between to server possible using ping command. |
|
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-13 : 08:55:34
|
| You can assign specific IP and custom port to SQL server under SQL SERVER CONFIGURATION ->SQL SERVER NETWORK CONFIGURATION -> TCP/IP setting |
|
|
|
Timf1234
Starting Member
4 Posts |
Posted - 2010-09-20 : 19:27:57
|
| Yes, I am aware of sql server default port 1433. I tried and failed.Yes, I also tried to assign specific port at SQL Server Configuration Manager but it did not work. There were several IPs. IP1 through IP4. I couldn't tell which one is for the instance I am using. I even tried one IP port at a time but still did not work. |
|
|
|
|
|
|
Can't connect to sql server 2008 developer ed.