Looking for some help with my database connectivity. My website is developed in Visual Studio 2008 and I have a few databases set up which were based on SQL server 2008 express. However, I have just updated this to version R2 and since doing this I can
no longer access the database and get the dreaded 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.
Why does it do this when all I did was update to the latest version? More importantly is anyone able to tell me how to correct this. Please could you explain in dummy terms!
No, I've downloaded the R2 version of SQL 2008 Express. The whole reason why I downloaded it in the first place is that I am incorporating a piece of software into my website that uses a database that was created with a later version of SQL 2008 than I
had. When I looked on the internet at the original error message I had, it suggested that I needed the updated version which is R2.
From the error message you post, if you need to connect this instance remotely, please make sure you have enabled Named Pipes, TCP/IP, protocols, have set the Windows Firewall to allow SQL Server Access, and then try to connect again.
If those methods don't help you, please post the the information in the brackets, provider, error number etc. Thanks a lot.
Best Regards,
Please mark the replies as answers if they help or unmark if not.
Feedback to us
I have actually since restored my computer back to before I installed R2 and tried the software with an Access database instead which I've now got working. My original sql databases are back working now as well.
When I've got more time I will reinstall the latest sql server and bear in mind what you've both said as ultimately I do want to use SQL.
Anyway, thanks for now
Steven
Marked as answer by Stark8352 on Feb 03, 2013 05:59 PM
Stark8352
Member
38 Points
50 Posts
No longer able to access databse after SQL Server 2008 R2 update
Jan 28, 2013 07:07 PM|LINK
Hi guys,
Looking for some help with my database connectivity. My website is developed in Visual Studio 2008 and I have a few databases set up which were based on SQL server 2008 express. However, I have just updated this to version R2 and since doing this I can no longer access the database and get the dreaded 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.
Why does it do this when all I did was update to the latest version? More importantly is anyone able to tell me how to correct this. Please could you explain in dummy terms!
Thanks
Steven
RichardY
Star
8376 Points
1573 Posts
Re: No longer able to access databse after SQL Server 2008 R2 update
Jan 28, 2013 07:15 PM|LINK
Are you saying that you have updated sql server express to a full version of sql server?
Stark8352
Member
38 Points
50 Posts
Re: No longer able to access databse after SQL Server 2008 R2 update
Jan 28, 2013 07:29 PM|LINK
Richard,
No, I've downloaded the R2 version of SQL 2008 Express. The whole reason why I downloaded it in the first place is that I am incorporating a piece of software into my website that uses a database that was created with a later version of SQL 2008 than I had. When I looked on the internet at the original error message I had, it suggested that I needed the updated version which is R2.
Steven
oned_gk
All-Star
36078 Points
7363 Posts
Re: No longer able to access databse after SQL Server 2008 R2 update
Jan 28, 2013 10:05 PM|LINK
Suwandi - Non Graduate Programmer
Chen Yu - MS...
All-Star
21829 Points
2513 Posts
Microsoft
Re: No longer able to access databse after SQL Server 2008 R2 update
Jan 29, 2013 08:29 AM|LINK
Hi,
From the error message you post, if you need to connect this instance remotely, please make sure you have enabled Named Pipes, TCP/IP, protocols, have set the Windows Firewall to allow SQL Server Access, and then try to connect again.
If those methods don't help you, please post the the information in the brackets, provider, error number etc. Thanks a lot.
Best Regards,
Feedback to us
Develop and promote your apps in Windows Store
Stark8352
Member
38 Points
50 Posts
Re: No longer able to access databse after SQL Server 2008 R2 update
Jan 30, 2013 05:13 PM|LINK
Chen-Yu/Oned_gk,
Thank you both for your responses.
I have actually since restored my computer back to before I installed R2 and tried the software with an Access database instead which I've now got working. My original sql databases are back working now as well.
When I've got more time I will reinstall the latest sql server and bear in mind what you've both said as ultimately I do want to use SQL.
Anyway, thanks for now
Steven