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:
------------------------------
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:
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