Πρόβλημα με τη βάση Northwind

Συζητήσεις για θέματα που σχετίζονται με software.
Post Reply
User avatar
PASCAL
Wow! Terabyte level
Wow! Terabyte level
Posts: 3587
Joined: Wed Nov 23, 2005 10:58 pm
Academic status: Alumnus/a
Gender:

Πρόβλημα με τη βάση Northwind

Post by PASCAL » Mon Nov 09, 2009 10:39 pm

Μολίς κατέβασα την βάση Northwind της Microsoft και την εγκατέστησα στον C:\. Ωστόσο στον MS SQL Server 2008 όταν κάνω
Database>Δεξί κλικ>Attach..>Add...>NORTHWIND.MDF>OK, πετάει το εξής σφάλμα:

Code: Select all

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'PASCAL-PC'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "C:\SQL Server 2000 Sample Databases\NORTHWND.MDF". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Ξέρει κανείς πώς να το διορθώσω;
User avatar
emperormario
Wow! Terabyte level
Wow! Terabyte level
Posts: 2569
Joined: Fri Jun 15, 2007 12:30 pm
Gender:
Location: Over the hills and far away..

Re: Πρόβλημα με τη βάση Northwind

Post by emperormario » Mon Nov 09, 2009 10:57 pm

Tι λειτουργικό έχεις? Μήπως για κάποιο λόγο δεν του επιτρέπεται (του sql server) η πρόσβαση στο .mdf σου?
Don't drink and drive. You might spill your drink :b-The Snake
Spoiler: εμφάνιση/απόκρυψη
Giggity giggity goo! [img]http://www.eternalduel.com/forums/images/smiles/quag.gif[/img]
Spoiler: εμφάνιση/απόκρυψη
[color=#800000][size=85]1) You are on the internet 2) You are visiting Venus forum 3) You are reading my signature 5) You didn't notice that point 4 is missing 6) You just checked for point 4 7) You are smiling [/size][/color]
User avatar
PASCAL
Wow! Terabyte level
Wow! Terabyte level
Posts: 3587
Joined: Wed Nov 23, 2005 10:58 pm
Academic status: Alumnus/a
Gender:

Re: Πρόβλημα με τη βάση Northwind

Post by PASCAL » Mon Nov 09, 2009 11:11 pm

Έχω Windows 7 Professional Edition(English, x86).
User avatar
emperormario
Wow! Terabyte level
Wow! Terabyte level
Posts: 2569
Joined: Fri Jun 15, 2007 12:30 pm
Gender:
Location: Over the hills and far away..

Re: Πρόβλημα με τη βάση Northwind

Post by emperormario » Mon Nov 09, 2009 11:25 pm

Googlarontas, είδα ότι μπορεί να φταίει το UAC..Δες και εδώ
και μας λες

Ή αυτό
My problem was solved, bu running the SQL server Management Studio as administrator, and then attach the database.
Don't drink and drive. You might spill your drink :b-The Snake
Spoiler: εμφάνιση/απόκρυψη
Giggity giggity goo! [img]http://www.eternalduel.com/forums/images/smiles/quag.gif[/img]
Spoiler: εμφάνιση/απόκρυψη
[color=#800000][size=85]1) You are on the internet 2) You are visiting Venus forum 3) You are reading my signature 5) You didn't notice that point 4 is missing 6) You just checked for point 4 7) You are smiling [/size][/color]
User avatar
PASCAL
Wow! Terabyte level
Wow! Terabyte level
Posts: 3587
Joined: Wed Nov 23, 2005 10:58 pm
Academic status: Alumnus/a
Gender:

Re: Πρόβλημα με τη βάση Northwind

Post by PASCAL » Wed Nov 11, 2009 11:08 pm

Μπα ούτε το UAC ήταν ούτε η σύνδεση ώς admin...
Παρεμπιπτώντος η pubs γίνεται attach. :smt001
Post Reply

Return to “Software”