Can't attach db - says read-only

Hi all,
SQL novice here.
I had a SQL Server 2000 machine that died, but it had some
data I need, so i pulled the drive, found the SQL data folder
and copied it to a network location.
On my SQL Server 2003 machine runnig SQL Server Express, I
right click on Databases, select Attach, point to the database
I want, and the process fials saying the data is read-only, make
it read write and try again.
Problem is, the files are not read-only. I checked and reset
them several times, and each attempt fails with the same message.
How can I attach this database to my sql server?
Thanks,
kpgThere is a article on Microsoft's web site that briefly discusses this issue
on SQL 2005 Express:
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
If you've already checked the permissions on the file, see if you can check
the permissions you have on the database server and folder where the file is
being written to. Your permissions may be different than what they were on
the original DB server.
"kpg*" wrote:
> Hi all,
> SQL novice here.
> I had a SQL Server 2000 machine that died, but it had some
> data I need, so i pulled the drive, found the SQL data folder
> and copied it to a network location.
> On my SQL Server 2003 machine runnig SQL Server Express, I
> right click on Databases, select Attach, point to the database
> I want, and the process fials saying the data is read-only, make
> it read write and try again.
> Problem is, the files are not read-only. I checked and reset
> them several times, and each attempt fails with the same message.
> How can I attach this database to my sql server?
> Thanks,
> kpg
>|||> There is a article on Microsoft's web site that briefly discusses this
> issue on SQL 2005 Express:
> http://msdn2.microsoft.com/en-us/library/bb264564.aspx
> If you've already checked the permissions on the file, see if you can
> check the permissions you have on the database server and folder where
> the file is being written to. Your permissions may be different than
> what they were on the original DB server.
Thank you * 100!
I copied the db file into the data folder of the sql 2005 instance
and yes, I was able to attach it. So it was a folder permission
issue.
Thanks again!
kpg

Cant attach database

I've created a database inside my ASP.net project, the database is in the App_Data folder as exepcted.

I can't run the aspnet_regsql until I have attached it using SQL Server Management Studio, but when I try to attach the database it doesn't let me navigate through my folders properly.

The database is in C:\Users\Wardie\Documents\FirstProject\App_Data but SQL SMS only lets me navigate to the folder C:\Users\Wardie and no further for some reason, meaning I can't attach the database and can't use the aspnet_regsql service to create the membership tables.

Does anyone know how to fix this?

I had this problem and discovered that SQL Server Management Studio doesnt navigate long directory paths off windows user directories like "My Documents". I ended up creating all my web projects in a sub directory off C:\ something like C:\My Websites\Web1\App_Data\MyDatabase.MDF will work fine. Sorry, but as far as I'm aware you'll have to move your project directory to a shorter path off the root directory.

|||

I guess i'll just have to do the same then, cheers smc.

A bit of a stupid thing though isn't that really?

|||

I agree. There's probably a logical reason... maybe its to do with virtual paths that are used for user "My Directory" folders not being supported. I.e. the "My Documnets" directory is actually something like "C:\Documents and Settings\UserName\My Documents"

Please mark as answered if I was helpful in someway to you.

Can't Add New Report

In Visual Studio when I create a new Report Project, once it's created I go
into Solution Explorer, right click on the "Reports" folder and select "Add
New Report", and I get the following error:
Exception from HRESULT: 0x8013141A
I've re-installed Visual Studio, the .NET framework, and Reporting Services,
and after all that it still gives me the error.
Any suggestions?
Michael BodnarSome DLL is failing to load. The only sure way to diagnose the problem is
to attach a debugger and see what exceptions it's throwing.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||Can you dump out a list of DLLs that are loaded into the VS process when the
error occurs? You can either use a tool like procexp.exe
(http://www.sysinternals.com/ntw2k/freeware/procexp.shtml) or attach another
instance of VS as a debugger. Using VS, display the Modules window, select
all rows, copy, and paste into a text file.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||The whole problem was I was trying to install it off a network drive. It
must not have been seeing some files over the network or something, or maybe
some files got corrupt. I installed it with the CD and it works fine now.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>

Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.
Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.

Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx
.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.

Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.

Cannot view http://webserver/Reports/Pages/Folder.aspx page from my system

Hi,
I am trying to view http://webserver/Reports/Pages/Folder.aspx page that resides on my collegues system as he has got SQL Reporting Services installed on it, but what all i can see is the title 'SQL Server Reporting Services' and 'Home' written on it. I am not able to view tabs like 'Contents', 'properties' which my collegue can when he browses for the page from his system.

Is there any problem with the rights. Please suggest how can I view these options like 'Contents' etc.

Ashu

Report server out of the box only gives local admins any rights. All other rights must be granted by a local admin.

Have a local admin click on the properties tab on the home page and then on the security tab. From there they can add new users and give them the desired permissions.

You can find more information on the predefined roles here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_01h4.asp

cannot save trace output to a local file?

Hi,
This is SQL 2000 on a win2k3 box.
In Trace Properties, when I checked 'Save to file' and clicked the folder
icon and specified a local file name, I got the following message:
For SQL server to write to a file, file path should have the following
format \\servername\sharename\filename
But I'm trying to write to a local file on the database server. How do I
have to use that format? Also in the Save As window, there is no way to
specify the path name like that given in the above message.
Thanks for any help,
Bingbing wrote:
> Hi,
> This is SQL 2000 on a win2k3 box.
> In Trace Properties, when I checked 'Save to file' and clicked the
> folder icon and specified a local file name, I got the following
> message:
> For SQL server to write to a file, file path should have the following
> format \\servername\sharename\filename
> But I'm trying to write to a local file on the database server. How
> do I have to use that format? Also in the Save As window, there is
> no way to specify the path name like that given in the above message.
> Thanks for any help,
>
> Bing
You don't. You can specify any local drive with a drive letter.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com