Click here to Skip to main content
12,403,983 members (64,861 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: .NET3.5 .NET SQL-Server , +
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
Rate this: bad
 
good
Please Sign up or sign in to vote.

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160721.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100