New answers tagged network
1
You can have database files on network mount-points in SQL Server 2012. See http://support.microsoft.com/kb/819546 for more information.
However, what you're suggesting does sound like you really need to use a single SQL Server instance that can be accessed by all your users, in much the same way that you would have a file server, or an exchange server...
5
An MDF files is not the database, as such. It is merely the on-disk storage used by the SQL Server database engine.
When your app "uses" the MDF, it is actually attaching them to an SQL Server install and running queries against that. This is transparent really.
Instead of this, you can install SQL Server on the network (even Express edition), attach tehe ...
2
You need to change port 1158 to 1521 in your connection properties.
Oracle's listener for database connections runs on port 1521 by default.
Port 1158 is the web listener for Database Control, a webgui for managing the database.
In addition, the servicename should be something like "database.domain.com", or you can try using SID and specifying ORCL.
Top 50 recent answers are included
