Connect To A SQL Server Database File

Hi,

I am a beginner on using SQL Server Express. I have two different questions. Here is the first:

I've developed a simple C# application in Visual Studio 2005 that connects to a SQL Server database file. In the application I connect to the database using this connection string:



@"Data Source=.SQLEXPRESS;AttachDbFilename=C:Databasesmydatabas.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";

and It works perfect.

But when I move the database file(and the corresponding log-file) to another computer it fails. I've changed the connection string to this



@"Data Source=.SQLEXPRESS;AttachDbFilename=\myserverDatabasesmydatabase.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";



This is the error message I get when I try to open the database



The file \myserverDatabasesmyDatabase.mdf is on a network path that is not supported for database files.An attempt to attach an auto-named database for file \myServerDatabasesmyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.



Both computer runs Windows XP SP2.



My second question is:

When I deployed my solution to my production PC(witch also runs Windows XP SP2, .NET Framwork 2.0 is installed on the computer) .When I then tried to run the application I did get this error message

An error has occured when establishing a connection to the server. When connection to a SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remomte conections.....

Appearently I cant treat SQL Server database files in the same way as Access-files, or?



Jan Olsson