| Author |
Topic |
|
nasar31786
Starting Member
6 Posts |
 Posted - 2008-11-26 : 07:07:12
|
| I am trying to connect to sql server remotely. I am in Delhi and server are in UK. I am trying to access UK server on my local PC. tcp/ip and named pipes are enabled on both sides. there is no firewall on server. surface config on server allows remote connections. but every time i got error.Error is"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)"please help meThanxNasar |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-26 : 07:36:16
|
| Maybe you don't have access to server remotely. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-27 : 04:57:05
|
| If you have a windows logon on the server and windows remote connection is enabled, try connecting to the server directly (e.g Remote Desktop Web Connection or similar). Then you can adjust SQL Server settings if necessary. |
|
|
|
nasar31786
Starting Member
6 Posts |
Posted - 2008-11-27 : 06:08:26
|
quote:
Originally posted by darkdusky
If you have a windows logon on the server and windows remote connection is enabled, try connecting to the server directly (e.g Remote Desktop Web Connection or similar). Then you can adjust SQL Server settings if necessary.
HiI am not able to connect server through remote desktop directly? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-27 : 11:47:24
|
| Do you have a windows logon on the server?Is remote desktop enabled on the server? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-27 : 11:53:08
|
| Its better to ask Admin guys/Hardware/NT guys for it. |
|
|
|
nasar31786
Starting Member
6 Posts |
Posted - 2008-11-28 : 00:02:34
|
quote:
Originally posted by darkdusky
Do you have a windows logon on the server?Is remote desktop enabled on the server?
Hello Thanx for replyYes i have windows logon and remote desktop is enabled both side. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-28 : 06:03:53
|
| Google: "Remote Desktop Web Connection" - this is an Internet version of Remote Desktop.Your windows logon will need to be either an administrator or added to the remote users group.You should be able to use this to connect directly to server and make any changes to SQL Server to allow you to connect via SQL Server connection. |
|
|
|
nasar31786
Starting Member
6 Posts |
Posted - 2008-11-28 : 07:16:48
|
| hiThanx for replyActually i want relicate data from one domain to other domain so i need to connect remote sql on my local PC. but i got error. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-28 : 13:30:20
|
| Did you ask your hardware/admin guys ? |
|
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2008-11-28 : 13:40:23
|
| Hi,i wud suggest first of all check if the port is open then try to connect server by serverip followed by port number of sqlserver. for example server ip is 3.205.136.185 and the port no is 1433 in that case ur connection string look like 3.205.136.185,1433just try and check.regardschander |
|
|
|
|
how to connect remote sql server 2005