Opening existing project

[BD5]

HEllo all,

I got a project sent to me, and I want to open it, it is delivered with a .mdf file. I downloaded VS 2008 and SQL server 2005, and i opened the project with VS2008.
But when i want to open a page that required data the page says:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)


Now I really don't know what to do to make sure the .mdf info will work, how should I do this? I open Microsoft SQL 2005 server, but what should I do then??
(Sometimes people talk about 'attaching', but I don't have a clue what that means, or how to do it..)

Cheers and thanks

[Purple]

Hi BD5 and welcome to TSDN

did you get a database_name.ldf file too ?

copy both the .mdf and .ldf files into the data directory of

program files / microsoft sql server / mssql / data

the path should look something like above, you will see other .mdf and .ldf files in there.

then use microsoft sql server management studio to connect to your sql server. Right click on the database folder and select attach, follow the wizard..

hope that helps

Regards Purple

[BD5]

did you get a database_name.ldf file too ?



Regards Purple

Thanks for the help!

I did not get a .ldf file with it... is it necessary?? By the way, that manager program you are talking about.. is it this program:
http://users.pandora.be/vipers/screenn.jpg


Because I right clicked those items, but I can't find attach..

[BD5]

Can anyone help me please? :) I am really stucking here..

[Shashi Sadasivan]

Can anyone help me please? :) I am really stucking here..

Hi BD5,
open SQL Sever, and connect to the sever...(it should connect on startup)
wight click on databases -> Attach

click add and choose the .mdf file u got.

Now on the window just below that, select the .ldf file, and remove it.

And then click OK.

Cheers

[BD5]

Thank you!

I could attach it!

But when I want to open a page, I still get this error:


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:


Line 97: private void LoadAndBindQuery(Query query)
Line 98: {
Line 99: EventsRepeater.DataSource = query.ExecuteReader();
Line 100: EventsRepeater.DataBind();
Line 101: }


How can I fix this?Thank you guys!

[ck9663]

Thank you!

I could attach it!

But when I want to open a page, I still get this error:


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:


Line 97: private void LoadAndBindQuery(Query query)
Line 98: {
Line 99: EventsRepeater.DataSource = query.ExecuteReader();
Line 100: EventsRepeater.DataBind();
Line 101: }


How can I fix this?Thank you guys!

check the way your program/application is connecting to your db. there are tons of ways you can connect into db so depending on the way your application connects, you can start from there.

[BD5]

I currently use this connectionstring:
The database file was Project.mdf

<connectionStrings>
<add name="ProjectConnectionString" connectionString="Data Source=.;Initial Catalog=Project;Integrated Security=True;"/>
</connectionStrings>

<SubSonicService defaultProvider="SqlDataProvider" fixPluralClassNames="true">
<providers>
<add name="SqlDataProvider" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="ProjectConnectionString"/>
</providers>
</SubSonicService>



Is this wrong?

[ck9663]

I currently use this connectionstring:
The database file was Project.mdf

<connectionStrings>
<add name="ProjectConnectionString" connectionString="Data Source=.;Initial Catalog=Project;Integrated Security=True;"/>
</connectionStrings>

<SubSonicService defaultProvider="SqlDataProvider" fixPluralClassNames="true">
<providers>
<add name="SqlDataProvider" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="ProjectConnectionString"/>
</providers>
</SubSonicService>



Is this wrong?

http://www.connectionstrings.com/