test connection failed because of an error in initializing provider sql server 2008

Question

0.00/5 (No votes)

See more:

Dear all

Iam new to sql server and I was just trying to convert an application done with acess database to SQL server database
Since SQL server 2008 is already present in the visual studio I had created a service based database but when i try to connect this using oledbdataconnection Iam getiing a error message as below(at test connection)

Test connection failed because of an error in intializing provider.
Unable to open the physicalfile "D:\WindowsFormsApplication3\WindowsFormsApplication3\masterdatabase.mdf"
Operation system error 5 : 5"(Access is denied)",

I don't know whether its problem with my security setting or some thing else but i had tried many tips on firewall to solve this

mine is msqlserver located localy and its running .

can anyone pls suggest me some idea to solve this

Posted 9-Feb-12 10:01am

SREENATH GANGA

Updated 19-Sep-19 21:22pm

Add a Solution

Comments

ZurdoDev 9-Feb-12 17:00pm

Can you use a SQLConnection instead of an OLEDBConnection?

SREENATH GANGA 10-Feb-12 5:18am

I tried it but same result

ZurdoDev 10-Feb-12 8:02am

What does same result mean? If you got the same error then you used the SQLConnection incorrectly.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2012-02-12T00:48:00

It sounds like that the database file you're trying to use, has security issues to access.

As an alternative, try to create a sample Windows Application and drag and drop an OleDbConnection onto the WinForm，according to the wizard，you should get a correct conn str，copy and paste it into your app.config or web.config。

Salim TS · Answer 2 · 2019-09-19T21:22:00

Solution 2

I found out to be a simple security issue, just closed the application VS2008 and opened it again by right clicking and opening it as "Run As Administrator" and all was set.

Posted 19-Sep-19 21:22pm

Salim TS