Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 15, 2010 05:47 AM by Rajneesh Verma
Oct 20, 2010 09:11 AM|LINK
I Hope I can explain and express this well.. I'm getting tired figuring out this error. Well, Basically. I have uploaded my ASP.net website to a server (IIS installed) as well as the VB project I made.
BOTH are connecting to a DB named CLIENTS.
the website uses a datagrid to show data, while the VB Project updates the DB based on a monitored folder.
The Problem is If the website is opened first the VB project shows an error "Unable to open the physical file (MDF). Operating system error 32 (error not found)"
and Vice Versa if the VB project is first started.
Oct 20, 2010 10:11 AM|LINK
It seems you connect to a SQL Server 2005 instance in SQL Server 2008 Management Studio. If you have installed SQL Server Express 2008, please make sure the SQL Server Express 2008 instance name and connect to it in SQL Server 2008 Management Studio. Try the
1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, in the left pane, click SQL Server Services.
3. In the details pane, right-click each SQL Server, and then click Properties.
4. Go to Advanced tab, check the file version that should be 2007.100.xxxx.x.
5. Click OK to close SQL Server Configuration Manager.
6. In SQL Server 2008 Management Studio, connect to the correct server name for SQL Server 2008 instance.
check below links:
Oct 21, 2010 02:13 AM|LINK
Hi.. THe version is 10.50.1600.1
and the servername I have is SQLEXPRESS <- THis is all I got
Nov 05, 2010 07:04 AM|LINK
I copied the connection string of my ASP Page for my VB project.. Now i get a new error.
"An attempt to attach an auto-named database for file"
I tried following
this but I still get the error
When I convert my VB project to an ASP.net webpage it works...
Nov 05, 2010 02:31 PM|LINK
Could be your database is in single-user mode. Try this:
ALTER DATABASE [MyDataBaseName] SET MULTI_USER
Nov 08, 2010 02:37 AM|LINK
errr.. Sorry Mr. TabAlleman, I'm new to this.. where to I check this?
I only use the SQL Server Management Studio tool.
Nov 08, 2010 01:47 PM|LINK
execute it as you would a query in Management Studio.
Nov 08, 2010 06:21 PM|LINK
where to I check this?
check below link:
Nov 11, 2010 08:34 AM|LINK
Sorry for the late reply.. I've been busy for a while..
I tried executing your snippet via NEW QUERY on the management tool..
Here's what i got.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'MyDataBaseName', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Nov 11, 2010 12:51 PM|LINK
Try it, replacing "MyDataBaseName" with your database name.