Remote access to SQL 2005
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.
Leave out the app. Can you access the file remotely from the machine your app resides on through explorer?
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.
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.
I would rather it stay un-attached for deployment reasons, but... We'll see.
By svibuk in forum Database
Last Post: 12-19-2009, 05:10 AM
By luca90 in forum Database
Last Post: 01-14-2007, 07:03 AM
By Oscar99 in forum Database
Last Post: 09-29-2006, 05:23 PM
By David Jones in forum Database
Last Post: 09-02-2001, 03:17 AM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 12:48 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL