March 3, 2009 at 9:44 am
Greetings. Please bare with me, I am studying SQL like mad at the moment, but my job is to get a demo up and running asap. Our developer quit yesterday leaving me to deploy this.
Our development was done on a single machine with SQL 5 express used as the database, again all local. This works fine. I am now trying to move the database to a different machine on the network, with SQL 2008 loaded. I get this when I try to attach the database to the new sqlserver:
Attach database failed for Server 'SQLSERVER1' (Microsoft.SqlServer.Smo)
Additional Information:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Unable to open the physical file c:\database\filename.mdf . Operating system error 5 - then reason 15105 and SQL Server Error 5120
What do I need to do to rectify this? Again, your help and patience is most appreciated. Back to the studies......
March 3, 2009 at 11:45 am
Make sure the database files are placed in a folder the sqlserver has permission to. Also try using the sp_attach_db if you tried it with the graphical interface and if you run the sql server under a operatiing system like vista try running the ssms as administator.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply