I have tried posting questions on this topic but still to no avail. For some reason I cannot attach a database(including northwind or adventureworks) from visual studio 2005 using sql server 2005 and get a different answer depending upon how I run it.
I have tried to check on a number of tips from everybody on how to resolve this but nothing works. I am trying to move on with my studying and this is holding me back. Any help would be appreciated.
The error message depends on how I run it.
Run it normally:
Error: Do not have permission, check with the database owner or administrator
Run it as administrator:
enter a new name or close the file that's open in another program.
I have gone in ssms, configuration manager, checked my windows firewall, etc, etc. and can't believe it has to be this complicated to attach a database from VS 2005. I am running this on my laptop, not through a network.
I have tried to check on a number of tips from everybody on how to resolve this but nothing works. I am trying to move on with my studying and this is holding me back. Any help would be appreciated.
The error message depends on how I run it.
Run it normally:
Error: Do not have permission, check with the database owner or administrator
Run it as administrator:
enter a new name or close the file that's open in another program.
I have gone in ssms, configuration manager, checked my windows firewall, etc, etc. and can't believe it has to be this complicated to attach a database from VS 2005. I am running this on my laptop, not through a network.