Hello,
Could you explain me please the following error:
"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.
Here is tail of ERRORLOG:
2006-06-12 21:19:55.68 Logon Error: 18456, Severity: 14, State:
16.
2006-06-12 21:19:55.68 Logon Login failed for user 'PC\Robert'.
[CLIENT: <local machine>]
2006-06-12 21:20:43.39 Server Server resumed execution after
being idle 1 seconds: user activity awakened the server. This is an
informational message only. No user action is required.
Please help to solve this.
Thank you.
/RAM/ 3 9739
R.A.M. (r_********@poc zta.onet.pl) writes: "Database 'DemoDotNET' cannot be opened due to inaccessible files or insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
I have checked: free disk space is large enough, I have much enough memory, other files in the directory are accessible.
Or there is some file for DemoDotNET which is located somewhere where
you don't think it is.
Unfortunately, with the information at hand it's impossible to say. You
could at least have posted the part of the error log where this message
appears. Or tell us when you get this error. Does it happen at startup?
Do you try to attach the database? Something else?
And, not the least, you did not tell us which version of SQL Server
you are using.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
On Mon, 12 Jun 2006 21:36:15 +0000 (UTC), Erland Sommarskog
<es****@sommars kog.se> wrote: R.A.M. (r_********@poc zta.onet.pl) writes: "Database 'DemoDotNET' cannot be opened due to inaccessible files or insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
I have checked: free disk space is large enough, I have much enough memory, other files in the directory are accessible.
Or there is some file for DemoDotNET which is located somewhere where you don't think it is.
Unfortunatel y, with the information at hand it's impossible to say. You could at least have posted the part of the error log where this message appears. Or tell us when you get this error. Does it happen at startup? Do you try to attach the database? Something else?
And, not the least, you did not tell us which version of SQL Server you are using.
I am using SQL Server 2005.
In directory of the database I have files: DemoDotNET.mdf,
DemoDotNET_log. ldf.
I got the error when I try to see properties of database, or script
database or open in C#.NET or VB program.
R.A.M. (r_********@poc zta.onet.pl) writes: I am using SQL Server 2005. In directory of the database I have files: DemoDotNET.mdf, DemoDotNET_log. ldf. I got the error when I try to see properties of database, or script database or open in C#.NET or VB program.
If you do
SELECT name, physical_name
FROM sys.master_file s
where database_id = db_id('DemoDotN et')
does physical_name agree with the files you see in Explorer?
If they do, my suspicion is that the log file has been tampered with,
and is not usable.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Russell Read [MSFT] |
last post by:
Hi all,
I am using VB script in ASP to access a MS Access database. This works fine
until I want to access the same db placed on a file share.
The code I am using is...
'create connection object
Set db = Server.CreateObject("ADODB.Connection")
'specify the database provider
|
by: Enska |
last post by:
I have problems connecting my access database I get information .. I
cant use my database and I'm administrator on my computer so permission
shutnot bee problem, but I dont know Where is the problem. Can enybody
help me!!!!
Server Error in '/Koulu/tietokannat' Application.
--------------------------------------------------------------------------------
The Microsoft Jet database engine cannot open the file...
|
by: Rico |
last post by:
Hello,
I have an ASP web app with an SQL back end. I am currently migrating to a
new Windows 2003 Server machine and SQL Server 2005 Express. When I import
the old database, I'm trying to grant the IUSR_MachineName account access to
the database, but I can't seem to find that user account. I'm clicking new
users, and when I type this user in, SQL doesn't recognize it, and when I
click "Browse" all I see is BUILTIN/Administrators,...
|
by: Martin B |
last post by:
Hallo!
I'm working with C# .NET 2.0, implementing Client/Server Applications which
are connecting via Network to SQL-Server or Oracle Databases.
To stay independent from the underlaying Database I use
System.Data.Common.DBConnection and .DBCommand.
How can I keep aware from connection losses (network not availeable,
db-server not available...)?
Are there any strategies to detect this broken connections, and how can I
|
by: Arpan |
last post by:
I recently installed SQL Server 2005 (Management Studio Express) along
with SQL Server 2005 Express (Configuration Manager) in my Win2K Pro
m/c & use IIS 5.0 to run ASPX projects. I could add my database, named
"MyDB", successfully. I am using the Windows Authentication mode to
login to SQL Server. My server name is "AD\SQLEXPRESS" where "AD" is
the name of my m/c.
I could even establish a connection to the server & the database from...
| |
by: Miro |
last post by:
I think i have found my problem following an example ive searched for on the
net.
I am using vb.net 2005 express.
What I am looking for is a drag drop from the toolbar that is an
OleDbConnectionOleDbConnection and a OleDbDataAdapter so I can drag and drop
these on the from, and Connect them to an mdb file.
What I think I have come to, is that in 2005 Express you cannot do this.
|
by: Chris |
last post by:
Ok,
I have a vb.net application that connects to a network file share.
The vb.net application bases certain functions (whether or not the
user can or can't update for example) by polling the system.username
variable and checking that against a table in the database. When I or
any other domain admin is logged on and using the system we are
allowed to update and delete whatever we wish. My problem lies in
that when a normal domain user...
|
by: ricoiii |
last post by:
Hello,
i have created a service in vb.net 2005 and want to create an access-database at runtime. The code is:
Dim cat As ADOX.Catalog
cat = CreateObject("ADOX.Catalog")
If IO.File.Exists(dbname) = False Then
Try
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & dbname & ";Jet OLEDB:Engine Type=5")
cat.ActiveConnection.close()
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |