Unable to locate database.mdf in production server 1) I want to attach a database from my development server to my production server.

The database ESpiceHerbs from my development server is located at:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA


2) When I log in using my production server credentials and right click on the Databases folder in Object Explorer and select Attach Databases and click Add,  I cannot find it there! :(



3) I am really confused as to why it cannot be located although its pointing to the same folder.

Could it be because the development server is running on 32 bit and the production server is running on 64 bit?
Might be a rights issue. Have a look at the security settings on the physical .mdf file and make sure the user you are using for SSMS has access to that .mdf file.

Most probably, as you are supplying credentials, you are logging on with your Windows user id, so make sure that you have read-write priviliges on the .mdf file.

To get to the security settings:
Explore -> Locate your file -> Right click -> Properties -> Security Tab

Your user group or your user should be in that list.