Instances of SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,
I am using .\Sqlexpress as my instance in the connection string.
But I want to use .\MyApp as new instance. My issues are:

1) When I install application on the new computer, does use manually needs to make this instance and attach database to it? Could any body give me code for it so my installation performs this fucntion.

Thanks

Posted 13-Jan-12 0:24am

Furqan Sehgal

Add a Solution

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)

Not Active · Accepted Answer · 2012-01-13T01:33:00

Solution 1

What difference does the instance name make? Are you expecting users to open SQL Manager and look at the data?

http://msdn.microsoft.com/en-us/library/ms143722(v=sql.90).aspx[^]

Posted 13-Jan-12 1:33am

Not Active

Comments

Furqan Sehgal 14-Jan-12 1:59am

Hi,
I used my connection string as
Data Source=.\SQLEXPRESS;Initial Catalog=dbTestSharing;Integrated Security=True

On development computer it works fine. But when I made setup (using Visual Studio) and installed on my home computer, it says

"Can not connect the database dbMyTest requested by the login, the login failed.
Login failed for user p4\admin"

My questions are:
1) I did not include the database to setup. Do I need to do so?
2) Does my user need to make servers and instances when SQL Server to run my application?
I installed another application based on SQL Server Express, that did not have anything like that.

Please guide.

[no name] 14-Jan-12 9:08am

Of course you need to include the database. Do you think it happens by magic?

Furqan Sehgal 16-Jan-12 2:03am

good answer.... Thanks. Though it is a taunt, but cleared my concept