|
Subject:
|
Connecting to MSDE from a remote ASP.NET App
|
|
Posted By:
|
kyle_shea
|
Post Date:
|
1/11/2006 3:19:36 PM
|
Hello,
I can connect to a given MSDE insatnce from my local (testing) web-application, i.e. by using "msde_server\msde_database" for the server name. When I try and connect via the same web application on the production (remote) server, I get an "sql server does not exist or access denied message." I replaced the "msde_server" portion of the server name with the appropriate fully-qualified internet url, i.e. "msde_server.host.com". So I'm trying to connection via "msde_server.host.com/msde_database" as the server name in the connection string. Is this valid? Can you connect to an MSDE store from an internet (remote) host in this fashion? Thank you!
|
|
Reply By:
|
planoie
|
Reply Date:
|
1/13/2006 4:00:30 PM
|
I'm not familiar with MSDE so can you explain what "msde_database" represents? Is that a file name or a connection address? (I think MSDE is just a slimmer version of regular MSSQL server, isn't it?
With standard SQL server, as long as the SQL port is open on the connection you are trying to use, you can access the database. This will work even thru a public address, though typically you never want to do that for fear of being hacked and having data stolen or destroyed but it is technically possible.
-Peter
|
