This is a migrated thread and some comments may be shown as answers.

SQLExpress local connection not working

1 Answer 129 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chad
Top achievements
Rank 2
Chad asked on 15 Aug 2014, 05:07 PM
I have 2 websites that I am running in localhost. 1 is the main web app and the 2nd is the telerik reporting application.
My connection string looks like this:
Data Source=.\SQLExpress;AttachDbFilename=C:\ODI\ODI_AGBSafety.mdf;Trusted_Connection=Yes;

I keep getting the following error and don't know what to do

"CREATE DATABASE permission denied in database 'master' An attempt to attach an auto-named database for the C:\ODI\Example.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 

Any help would be greatly appreciated.

thannks,

Chad

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 20 Aug 2014, 10:44 AM
Hello Chad,

Please verify the connection strings is correct - Attach a database file on connect to a local SQL Server Express instance. Then check if the path to the database is the correct one on the server, where the application is deployed. Finally grant access to the running process to access the database, which can be done trough the used application pool.

Let us know if you need any further help.

Regards,
Stef
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
Chad
Top achievements
Rank 2
Answers by
Stef
Telerik team
Share this question
or