'Unable to connect to SQL Server database' Error when using website administration tool
Posted on 2007-07-20
I am using ASP.NET 2.0 on windows vista with sql server 2005 and am having problems setting up user/role information using Project / Asp.net Configuration / Security Tab. The message i get 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: Unable to connect to SQL Server database. "
I have used aspnet_regsql.exe to setup the required tables in my sql 2005 database. This is the same database used by my web application which runs fine. So why cant asp.net configuration connect to the same database?
When i go into the provider tab and select 'use single provider...' option i can see aspnetprovider shown and selected, but when i click the 'test' link i get the message...
"Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "
Sql server is install on the same machine im using for development and is setup for both windows and sql server logon. If you need more information let me know.