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 |
|
vbc22
Starting Member
4 Posts |
 Posted - 2006-08-06 : 03:23:29
|
| Hi,I'm having difficulty registering an MSDE database in SQL Server Mgmt Studio Express (SSMSE).The MSDE database resides on a laptop. I wish to connect to that database on my desktop computer to work off it.Here's what I have done in terms of SQL Server set up on the laptop:- enabled TCP/IP- created exception in Windows Firewall to run sqlservr.exeHere's the funny thing: On my desktop computer I cannot register the remote database in Mgmt Studio Express, but I can, however, connect via ODBC.I find this especially frustrating--how ODBC can connect, but Mgmt Studio cannot.The server name I use is [computer name]\[server name]Any help would be very much appreciated. I've tried everything I could think of, and am stuck.Regards. |
|
|
vbc22
Starting Member
4 Posts |
Posted - 2006-08-06 : 06:50:33
|
| I finally got the connection to work.I was confused with the naming scheme of the server.The MSDE engine was automatically named after the computer name. The server name I had used which failed was the computer name/database name.After changing the server name to just the computer name, which coincidentally is the same as the actual server name, it worked. |
 |
|
|
|
|
|
Connect MSDE in SSMSE