661 users online

Upgrading to v1.80, will not load database

Posted: one year ago Quote
I upgraded to v1.60 just a few weeks ago, and is now trying to upgrade to v1.80...

I'm doing it locally at first, just to figure out the new features. When I try to upgrade my old database I get this error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


I understand it cannot find my database, but I can't figure out why. I have triple checked the name of the database and I've tried everything I can think of. I don't do anything differently than last time, but it isn't working...

Any suggestions?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: one year ago Quote
funkan wrote:
I upgraded to v1.60 just a few weeks ago, and is now trying to upgrade to v1.80...

I'm doing it locally at first, just to figure out the new features. When I try to upgrade my old database I get this error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


I understand it cannot find my database, but I can't figure out why. I have triple checked the name of the database and I've tried everything I can think of. I don't do anything differently than last time, but it isn't working...

Any suggestions?


This error is a connection problem as the code cannot find the database

Just to make sure if database exists or not, try to connect your database in Visual Studio or Sql management studio and see if database is located at the right place or not.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Please VOTE for the post if it helps you.

Thanks
Mike-nickname

If im not available here, post ur question on my site forum & I'll reply back there ASAP

www.strivingprogrammers.com
(Online Forums: ASP.NET, SQL, C#, AJAX, HTML, CSS, VB, C++, MS Office, Photoshop, Windows, Linux & more)
Posted: one year ago Quote
just double check if you are doing the same thing or not

i am assuming that your database is on default instance -> .\SQLEXPRESS

1) RUN yourwebsite or localhost\nopcommercestore\install\install.aspx

2) Choose "Upgrade from previous version"

3) Server Name->  .\SQLEXPRESS

4) Windows Authentication

5) Choose -> Existing database

Enter the name of the DATABASE (you can check from the webconfig of previous version connection string file so that you dont mis-spell the database name)

6) That;s it,,,you should be able to view your upgraded website on your local machine...
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Please VOTE for the post if it helps you.

Thanks
Mike-nickname

If im not available here, post ur question on my site forum & I'll reply back there ASAP

www.strivingprogrammers.com
(Online Forums: ASP.NET, SQL, C#, AJAX, HTML, CSS, VB, C++, MS Office, Photoshop, Windows, Linux & more)