Unable to connect to the right SQL Server database

Giganews Newsgroups
Subject: Unable to connect to the right SQL Server database
Posted by:  MarceepooNu (mbh20…@aol.com)
Date: Mon, 24 Nov 2008

I'm setting up a new VB.Net and ADO.Net project Visual Studio 2008, and I
can't figure out how to connect to the right database.  It's located at this
path (when using Windows Explorer on Svr5):
      F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Ofc_Data.MDF

Several SQL server 2000 databases were set up (a few years ago) on our file
server ("Svr5") under this path (the "Old Path"):
      F:\Microsoft SQL Server\SQL2000\MSSQL$SQL2000\Data

Later, we uninstalled SQL Server 2000, and installed SQL Server 2005, and
someone copied the databases to the following new path ("New Path") on the
same file server:
      F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data

In Visual Studio 2008, I am unable to connect the new Windows form project
to a database located under the New Path, i.e.:
      F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Ofc_Data.MDF

When I use the Visual Studio SQL Server add connection utility, I input Svr5
in the field for the server name, and hit the refresh button.  After the
refresh, when I hit the down arrow to the right of the Server name field (to
select a server), "Svr5" has been replaced by "Svr5\SQL2000", i.e., part of
the Old Path ... to the old data.

If I input a path to a database under the New Path
    eg: \\svr5\F$\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Ofc_Data.MDF
I get this error message:  "Device activation error.  The physical file name
'\\svr5\F$\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Ofc_Data.MDF' may be
incorrect.  Could not attached to '\\svr5\F$\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\Ofc_Data.MDF'.

Any suggestions for where I could find a solution would be much appreciated.

Thanks,

                      MarceepooNu

--
MarceepooNu

Replies