| Author |
 Topic  |
|
|
maya_zakry
Constraint Violating Yak Guru
Malaysia
377 Posts |
 Posted - 06/13/2012 : 01:36:26
|
Hi.
can we actually connect to sql server 2008 R2 remotely from sql server 2008??
i had below error to do that even the remote connection is set to allow.
TITLE: Connect to Server
------------------------------
Cannot connect to xxxxx.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
~~~who controls the past controls the future, who controls the present controls the past. ¯\(º_o)/¯ ~~~ |
|
|
ahmeds08
Constraint Violating Yak Guru
India
425 Posts |
Posted - 06/13/2012 : 02:19:07
|
quote:
Originally posted by maya_zakry
Hi.
can we actually connect to sql server 2008 R2 remotely from sql server 2008??
i had below error to do that even the remote connection is set to allow.
TITLE: Connect to Server
------------------------------
Cannot connect to xxxxx.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
~~~who controls the past controls the future, who controls the present controls the past. ¯\(º_o)/¯ ~~~
Please check wether the remote system is set to accept remote connection. |
 |
|
|
maya_zakry
Constraint Violating Yak Guru
Malaysia
377 Posts |
Posted - 06/13/2012 : 02:41:52
|
yes, the setting in connection tab for server properties is tick for "Allow remote connections to this server.
can sql 2008 connect to sql R2 actually? they are same version (sort off)?
~~~who controls the past controls the future, who controls the present controls the past. ¯\(º_o)/¯ ~~~ |
|
|
| |
Topic |
|
connection problem
