Database application setup project. The database is not accesible..

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

Dear friends.
Happy new year to all..!!

i'm facing some problem in my one of database application.
As i have created one database application in vs2008 and sqlserver 2008.
I've also created the setup for my application. According to my database configuration the app is working fine on my PC on which I've developed the application. As per the configuration the database folder is in "D:\data".
On my PC after installing the application it is working fine.. but on other system it is showing error..regarding user instance, login failed etc.

please help me regarding database config to resolve the error.

Thanks.
Kundan

Posted 2-Jan-13 5:48am

abhinit gupta kumar

Add a Solution

2 solutions

Solution 2

Go through these set of connection strings - http://connectionstrings.com/sql-server-2008[^]. They should give you a fair idea of what you could be doing wrong.

Posted 2-Jan-13 6:19am

Abhinav S

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)

**AmitGajjar** · Accepted Answer · 2013-01-02T06:05:00

Solution 1

Hi,

First of all i suggest you to use SQL server instance to connect with the database instead of using database file.

Then you can set your connection string.

After installation of SQL server, Your database and your application, it should work fine.

Let me know if you are doing the same thing. please provide your connectionstring.

Best luck.

Posted 2-Jan-13 6:05am

AmitGajjar

Comments

AmitGajjar 2-Jan-13 13:04pm

reason for 3+ ?

abhinit gupta kumar 3-Jan-13 9:04am

Dear Amit
Thanks for the reply
Do i have to install Sql-Server on client system..??
The connection String : <add key="ConnectionString" value="Data Source=localhost;Initial Catalog=D:\data\playschool;Integrated Security=True">
Can you please tell me how to make the setup for database application ( using vs 2010 and SQLServer-2008)
So that it can work on all the systems.

Thanks
Kundan

AmitGajjar 3-Jan-13 9:10am

No, you do not have to install sql server on each client. on client server architecture one of the computer will be your server there you need to install sql server and on all other terminal you do not need to install sql server.

abhinit gupta kumar 3-Jan-13 9:13am

Dear Amit
Its A stand alone application for school.
So it will run on a single system. I've to install Sql server on That machine..??
Is there any process so that i do not have to install Sql on the system while creating the setup..?

AmitGajjar 3-Jan-13 9:16am

ok , in that case you do not need to install sql server. if you are using database file to store your data then just install sql server runtime and your database at particular directory. you will find a lots of article on that.

abhinit gupta kumar 3-Jan-13 9:21am

Thanks Mr amit
I'll try it and revert you back if any problem persists.
If you have any links regarding this then please send that for my reference.

Thanks & regards
Kundan

AmitGajjar 3-Jan-13 9:23am

http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed-sql-server-express-in-an-application.aspx

have a look at above article.

abhinit gupta kumar 3-Jan-13 9:06am

"Data Source=localhost;Initial Catalog=playschool;Integrated Security=True