Is there SQL 2005 tool needed after application deployed?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Is there SQL 2005 tool needed after application is deployed and installed.
SQL2005 has been used as a database tool in an application development.
Please don't mind my so simple questions...I'm a new learner.
Thanks and regards.

Posted 10-Mar-11 5:18am

Muhamamd Islam

Updated 10-Mar-11 5:19am

v2

Add a Solution

Comments

Corporal Agarn 10-Mar-11 11:28am

Are you using a front end? You might want to add that to the tags.

Henry Minute 10-Mar-11 11:33am

Are you asking because you have deployed your application and it does not work or just out of curiosity?

If the first of these, you will get better answers if you tell us what errors you are getting.

Muhamamd Islam 10-Mar-11 14:05pm

application developed in VS2005pe IDE which has built-in SQL2005. I used a DB connection via SQL2005. I published it OK. runs on my PC OK. BUT!!! when I run this application on another PC having no SQL2005 installed, it does not recognize my published application files, until I install SQL2005, then runs OK.

AspDotNetDev 10-Mar-11 16:55pm

You probably need to change your connection string to point to your database from outside of your network. Likely, you are using a local connection string, which would not work from an external computer.

Muhamamd Islam 10-Mar-11 20:35pm

OK Thanks. I check my connection string.

1 solution

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)

AspDotNetDev · Answer 1 · 2011-03-10T07:05:00

So, you are wondering what you need to deploy SQL Server 2005? One typically does not deploy SQL Server 2005. Instead, you host it on your servers and your connection strings (bundled with your application) should point to the SQL Server instances you are hosting. If you want a database that can be easily installed on a client computer, go with SQL Server CE (though that has some annoying limitations). You could also use some of the other SQL implementations out there.