When trying to carry out the tutorial
http://www.asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-7 , I encounter the error below when I access security tab on the website administration tool , I think this may be down to windows 8, has anyone else had this issue or know how to fix
it ?
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to
a page where you can choose a new data store. The following message may help in diagnosing the problem:
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)
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected
to a page where you can choose a new data store.
The following message may help in diagnosing the problem:
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 am running windows 8 with sql server and VS 2010, also I can't open the database file in visual studio but my friend's works fine on windows 7 with the same code.
ace 87
0 Points
3 Posts
tutorial issues
Dec 27, 2012 04:22 PM|LINK
Hi,
When trying to carry out the tutorial http://www.asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-7 , I encounter the error below when I access security tab on the website administration tool , I think this may be down to windows 8, has anyone else had this issue or know how to fix it ?
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: 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)
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: tutorial issues
Dec 27, 2012 06:27 PM|LINK
That error message had some pretty good suggestions. Did you follow them?
ace 87
0 Points
3 Posts
Re: tutorial issues
Dec 27, 2012 07:37 PM|LINK
Its a sql server compact file on disk and I changed the route to be absolute but im still getting the error
ignatandrei
All-Star
134491 Points
21566 Posts
Moderator
MVP
Re: tutorial issues
Dec 27, 2012 07:38 PM|LINK
show the code with error. also connectionstring from web.config
ace 87
0 Points
3 Posts
Re: tutorial issues
Dec 28, 2012 05:12 PM|LINK
Hi thanks for reply,
The connectionstring code in the web.config :
<connectionStrings>
<add name="MusicStoreEntities"
connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf"
providerName="System.Data.SqlServerCe.4.0"/>
</connectionStrings>
The error I get when run asp.net configuration is
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: 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 am running windows 8 with sql server and VS 2010, also I can't open the database file in visual studio but my friend's works fine on windows 7 with the same code.
Thanks
ignatandrei
All-Star
134491 Points
21566 Posts
Moderator
MVP
Re: tutorial issues
Dec 28, 2012 06:53 PM|LINK
1. I doubt
runs with SqlServer CE2.
Not relevant. Please replace your connection with a SqlServer one, not SqlServer CE
3.
Maybe he installed SqlServerCE and you not.
comanighttra...
Member
9 Points
10 Posts
Re: tutorial issues
Dec 28, 2012 08:19 PM|LINK
Hi ignatandrei,
Thanks for the reply - I'm the other person in the scenario with the working code.
It seems to be the database with the logins in it which is causing the issues instead of the one mentioned in the connection string
It's definetely a Windows 8 issue - another dev tried it on his win8 box and got the same issue.
I think we will switch to a sql server 2008 db for membership unless we find another solution...
Thanks
Dave
ignatandrei
All-Star
134491 Points
21566 Posts
Moderator
MVP
Re: tutorial issues
Dec 28, 2012 08:38 PM|LINK
Make a clean install of Windows 7 . It won't work - why ? because SqlServerCE driver is not installed.
comanighttra...
Member
9 Points
10 Posts
Re: tutorial issues
Dec 28, 2012 10:49 PM|LINK
Yeah but it is also not working on Windows 8 with SqlServerCE installed?
We have only got it working on Windows 7 with SqlServerCe installed?
Give it a go ignatandrei - I'm happy to be proved wrong
Tutorial code is here http://mvcmusicstore.codeplex.com/
ignatandrei
All-Star
134491 Points
21566 Posts
Moderator
MVP
Re: tutorial issues
Dec 29, 2012 04:29 AM|LINK
I will test- after new year.