Remote access to SQL 2005

[lvolle]

I have an MDF file that sits on my server. I am writing an app on my local machine that updates that database. A website on the server can view and update the database.

The Website was created in VWD2005.
The SQL on the server is 2005 Express
The app is in VB.Net2005

The website works awesome.
The connection string is like:

data source=.\SQLEXPRESS;AttachDBFilename=C:\Inetpub\wwwroot\MockUP\App_Data\ISC_DB.mdf;Integra ted Security=True;Connect Timeout=30;User Instance=True

The app is not working. I get an error "User does not have permission to perform this action." when I use this connection string to try and open the connection.

Data Source=Server1\SQLEXPRESS;User Instance=true;Integrated Security=true;AttachDbFilename=C:\Inetpub\wwwroot\MockUP\App_Data\ISC_DB.mdf;

I can get the app to connect if I use the SQL authentication and take out the Integrated Security, but then I can't look at it with the website and the app at the same time. I have remote connections enabled in the surface configurator.

Please Help!

[vaidee325]

Hi,

Leave out the app. Can you access the file remotely from the machine your app resides on through explorer?

[lvolle]

I can go through the network and rename the file. I can go through the network using SQL Server Managment and connect to the server instance.

[vaidee325]

Hi,

Is there any reason why you cant attach the mdf file to the sql server and connect to the server itself? I somehow have a feeling connecting to a remote mdf file is not that easy.

[lvolle]

I would rather it stay un-attached for deployment reasons, but... We'll see.