SQL Problems

05/09/2013 12:25 lullerock12#1
Im on my way to create a new server but i ran into some problems.
Its when im attach to the database, i can attach with the windows authentication but with SQL authentication i get this error trying to attach: TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'LUCAS-PC'. (Microsoft.SqlServer.Smo)

For help, click: [Only registered and activated users can see links. Click Here To Register...]

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "C:\shaiyaserver\DATABASE\PS_Billing_Data.MDF" . Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

For help, click: [Only registered and activated users can see links. Click Here To Register...]

Since i can attach with Windows Authentication i bet its something wrong with the account somehow, And yes i have read the error.

Thanks in advance
- Lucas
05/09/2013 12:44 {Skrillex}#2
Is that only by this Database?
05/09/2013 12:51 lullerock12#3
What do you mean? This happens right after i hit ok after adding the files to Database
05/09/2013 18:03 JohnHeatz#4
He is asking if PS_Billing_Data.MDF is the only one showing this error, or if you weren't able to attach any of the databases to SQL.

I'd suggest first, running SQL as administrator, second, check your SQL Login credentials, see if you are connecting with a user that has all of the rights, and then, if nothing else helps, download a different set of databases.