Configuration :: Webservice WebConfig File Not Recognized By Windows App?

I have created a webservice, which debugs fine with no errors, and published this on my localhost server for testing.

I have created a windows app which calls the webservice but am hitting problems as soon as I reach the point where the webservice tries to connect to its database.

The connectionstring is held within the web.config file of the webservice as

>><connectionStrings>
<add name="MyConnectionName" providerName="System.Data.ProviderName" connectionString="server=MyServerName; database=MyDataBaseName;uid=MyUser;pwd=MyPassword;"/>
</connectionStrings>

and called within the code by using the statement

>> System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionName"].ConnectionString

, and as I said before, this works perfectly when debugging the webservice application directly.

However, the windows application is not seeing the connection properly, if I use the statement as above I get a debug error stating that it is a NULL reference. If I change it to

>> System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString

I no longer get a debug error, but the connection is not made. On testing the above code it believes the name for connection 0 is "localSqlServer" and in both the web app and the webservice the error below is returned.

>>An attempt to attach an auto-named database for file \MyServerMyDirectoryMyProjectMyProjectApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

why the windows application see's the correct connection string code as null? Is there additional security I need to add for the web.config file to be accessible? Or does the connection strings need to be relicated within the app.config of the windows app?

Both applications are written in C# and I use Visual Studio 2010, ASP.Net version 4.0.30319