Hi Expert
I am working with a project in c# vs.net 2005 and sql express as backend. I have successfully completed the works. I want to connect my application and SQL Express on LAN. I have successfully connected the database one day before but because of some problem I have formatted the hard-disk on both client and server machines.
My application is throwing this error:
Create databse permission denied in database 'master'.
An attempt to attach an auto named database for file
C:\myDB.mdf failed.
a database with same name exist , or specified file cannot be opened, or is located on UNC share.
In this regard I have some questions.
1. Is there any way to create a login without using sql management studio. Using this query "CREATE LOGIN user WITH PASSWORD='pwd'"
It executes successfully but gave this error:
"Login failed for user user. the user is not associated with a trusted sql server connection"
2. If I login with Windows authentication then I receive this error:
Create database permission denied in database 'master'.
An attempt to attach an auto named database for file C:\myDB.mdf failed.
a database with same name exist , or specified file cannot be opened, or is located on UNC share.
What is the problem with my application?
thnx