Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 at 2-Jan-13 13:04pm
   
reason for 3+ ?
abhinit gupta kumar at 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 at 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 at 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 at 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 at 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 at 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 at 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
0 CHill60 360
1 OriginalGriff 343
2 Sarvesh Kumar Gupta 168
3 RyanDev 145
4 Sergey Alexandrovich Kryukov 128


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