SQL Server

My client has an existing Server 2003 running SQL 2000 Standard. It is a Thompson Router IP Master mdf database with the ldf file. It is used to query the mdf for patents and trandmark cases.

The Client is moving to a Win 8 Laptop and needs to have a SQL version installed with the management component so she can attach this database.

I have tried the express versions of 2005 and 2008 and I cannot see how to attach the database. I need something that will work, and I am NOT a SQL user/knowitall, so I need some direction. I need to get it working in SQL on a WIN 8 laptop.
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
The easiest way is to copy the mdf and ldf file to the new machine then attach the database.

http://technet.microsoft.com/en-us/library/ms165673(v=sql.105).aspx
0
BSAS_ITGuyCommented:
I believe Microsoft Access will read the MDF, do you have the Pro Version of Office on the Laptop with Access.You can do some of the same Queries in there.
0
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
Bricrowe missed that SQl is N O T installed in the WIN 8 machine, I need it to be there but can't find a version that lets me attach the database..Express versions won't do it.

The client is NOT computer savvy in the least, I would really like to get SQL installed.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

DcpKingCommented:
Firstly, how big is the database? If it's over 10GB then you're out of luck on any version of Express. If not, read on ...

Get the user a copy of SQL Server 2012 Express, install it on the Win8 machine, and check that it works ok and that the user understands how to use it.

Then try to detach the database from SQL Server 2000, make a copy of the mdf and ldf files, copy them to the Win8 machine, and try to attach them again using the Management Studio (right-click on "Databases", left click on "Attach..."  and follow the instructions).

hth

Mike
0
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
DepKing,

I have a copy of the current MDF anf LDF, do I need the studio management as well, or simply the 2012 SQL express program?

MS has  different varieties of programs,


ENU\x64\SQLEXPR_x64_ENU.exe

132.3 MB



ENU\x64\SQLEXPRADV_x64_ENU.exe

1.3 GB



ENU\x64\SQLEXPRWT_x64_ENU.exe

669.9 MB



ENU\x64\SqlLocalDB.MSI

33.0 MB



ENU\x64\SQLManagementStudio_x64_ENU.exe

600.2 MB

Thanks.
0
DcpKingCommented:
You'll need a copy of Express with SSMS (Management System) on it, so you can attach the database and check  that you've got what you want. This means either Express With Tools (ENU\x64\SQLEXPRWT_x64_ENU.exe) or Express With Advanced Services (ENU\x64\SQLEXPRADV_x64_ENU.exe). Either way, you're looking for an interface for you to use to attach the database to the system.

Once that's installed you can attach the .mdf file as I explained above.

How does your user intend to get access to the data? Do you have a program to do it, or will she use SSMS for direct access to the tables?

Mike
0
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
Mike,

It's rejecting the attachment, it seems to have the old pathway showing an F drive\shared folder\ pathway, May also be too much of a version issue ?
0
DcpKingCommented:
No. That isn't a problem - just a feature! When you attach the database it "knows" where it used to be and offers you there as a default (it has to go somewhere!). That is where it used to be, so it tries to make it easier if you're replacing a broken database with a saved copy.

What the Attach dialog used are whatever it can glean from the files to be attached: then it offers you those as suggestions. Once you get to the stage of being able to see the locations and named you can edit them so that they reflect where the two files actually are on the laptop.

Then you'll be able to tell it to attach them.

hth

Mike
0
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
Mike,

The current user name and password differ from the default sql instance of SQLEXPRESS.. I added the user in management with her password, but getting a access is denied on the attaching process.

Your help is spot on. any ideas ?
0
DcpKingCommented:
In summary, getting at your database is a two-step process - you set up permissions at the server level, and then refine them at the database level.

You'll need to check out the permissions for the user wrt the database you just attached. Adding her in SSMS was the right thing to do - now she needs to be able to access the database.

You should have set her up as a Windows user (for example see second screenshot - I mis-typed - it should have been "WIN7SQL\Your_Manager" in the screenshot, sorry!).

Go back to where you set up her Login, back to Login Properties and User Mapping (see screenshot). I'm mai, and you can see that for the database mai I'm a user and my default schema is "dbo" (if I create anything it'll normally be "dbo.thing").

You'll need to set her up in database roles (third shot) so edit her login, go to the roles, and you'll find her as "public". This may be enough, but giving her db_datareader and db_datawriter probably won't harm anything - she's only working on her own private copy of the database.

Now go to the database itself, drill in until you get into Security and Users and her properties. In Membership you'll see whatever you granted at the server level. Now she should be able to access the database.

If you're still having problems please keep asking!

hth

Mike
Screenshot-from-2013-09-26-23-41.png
Screenshot-from-2013-09-26-23-46.png
Screenshot-from-2013-09-26-23-52.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
Mike,

Great help from you.

I managed to install SQL server 2005 express and attach the database, couldn't log in but had support from the IP Master tech peeps, and it is now on the Win 8 laptop. Finally.

Thank you.
0
Kevin CaldwellOwner of RUseeingRed Tech SolutionsAuthor Commented:
Great step by step, This advice lead to the client issue being resolved, and the client being happy.
0
DcpKingCommented:
Great to hear of your success, Kevin. Like Paul Simon sang, it's all about "Keepin the Customer Satisfied"!

Now you have to make arrangements for her to get updates to her data, and also make backups of any changes she makes. You'll get some resistance at first, probably, but after you rescue her with a backup she'll be sold! Literally yesterday evening I went through exactly that scenario ... it's so nice to see the expressions of relief!

Mike
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.