Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Brad Green
Starting Member
2 Posts |
 Posted - 2009-07-30 : 10:18:18
|
Hello Guys,This is my first post. I am fairly new to SQL, but with the SQL project that was just handed to me, I will be an expert in no time. I am trying to install Best Practices Analizer Tool for SQL server 2000 on a server running Windows Server 2003 service pack 2 with SQL 2000 installed. The installation almost completes, but ends with this error:Device activation error. The physical file name...\sqlbpa.mdf' may be incorrect.CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.Database 'sqlbpa' does not exist. Check sysdatabases. ALTER DATABASE statement f...When I go look at the event log, this is the error that I see:The following information is part of the event: Product: Best Practices Analyzer Tool for Microsoft SQL Server 2000 -- Error 1001. Device activation error. The physical file name '\sqlbpa.mdf' may be incorrect.CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.Database 'sqlbpa' does not exist. Check sysdatabases.ALTER DATABASE statement failed. --> Device activation error. The physical file name '\sqlbpa.mdf' may be incorrect.CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.Database 'sqlbpa' does not exist. Check sysdatabases.I have been unsuccessful in trying to find a solution. Is anyone familiar with this error? Got any suggestions? |
|
|
Brad Green
Starting Member
2 Posts |
Posted - 2009-07-30 : 10:31:37
|
| It appears that maybe this should be in the SQL 2000 forum, if so, please move it. |
 |
|
|
|
|
|
Best Practices Analyzer installation error