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 |
|
msch-prv
Starting Member
11 Posts |
 Posted - 2010-05-17 : 17:20:38
|
| My ISP provider has migrated to SQL Server 2008 last month. As a result I am unable to connect to my db via SSMSE 2005 (SQL Server Management Studio Express 2005). I downloaded SSMSE 2008 but it seems that the only server types supported are Database Engine and SQL Server Compact Edition. Has the remote server access option been discontinued or am I missing something? Remote access was very handy in SSMSE 2005 to add sprocs and modify data. TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
msch-prv
Starting Member
11 Posts |
Posted - 2010-05-17 : 17:29:11
|
| Thanks for your quick reply. I tried this out but for some reason it does not accept remote servers ie vcnsql85.xxx.com for example. The ODBC connection to the same server works fine. Is this perhaps related to a faulty option setting? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
msch-prv
Starting Member
11 Posts |
Posted - 2010-05-17 : 17:36:22
|
| If the server name is entered as:vcnsql85.xxx.com\Andersthe following error message pops up: Cannot connect to vcnsql85.xxx.com\Anders... |
|
|
|
msch-prv
Starting Member
11 Posts |
Posted - 2010-05-17 : 17:43:24
|
| For some reason, the connection is working now. ;=) Thanks again!It seems that the instance name in this specific case is not required. |
|
|
|
|
|
|
Remote SQL Server access via SSMSE 2008