New at SQL. Created a database at work and needed to work on program development at home. Copied the .mdf file to a thumb drive, copied the contents to my c: and tried to open within the SQL Server Management and got an access is denied error. File is not protected yet and rights are all rights. Office computer is xp home computer is 7. Could that be the problem?
nope did you set up server at home and try to attach the mdf in it with name given as your database name?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
I used the same database name and tried to import when I got the error message. Thanks for the reply
Larry Pace
dont try to import but you should use attach option and point it to mdf file. then give it name of db you want and you will be able to access the db. I'm assuming you've installed sql server instance at home and also client tools like sql management studio.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
nope did you set up server at home and try to attach the mdf in it with name given as your database name?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/ That Worked but in 'Read Only'
I used the same database name and tried to import when I got the error message. Thanks for the reply
Larry Pace
dont try to import but you should use attach option and point it to mdf file. then give it name of db you want and you will be able to access the db. I'm assuming you've installed sql server instance at home and also client tools like sql management studio.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
I think I am having a permissions difficulty -- when I tried to 'Attach' the file from my office I get this error: System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
I am using 7 pro and I am the only user. Checking the file attributes it indicates that it is not protected?
work on .mdf home & office
Posted - 07/23/2011 : 06:35:09
