Last post Apr 13, 2014 10:50 PM by Ashim Chatterjee
Apr 12, 2014 09:18 AM|kingofspades80|LINK
I'm having trouble using the CreateUserWizard. In my SQL Serverv 2012 Express, aspnetdb is created by running aspnet_regsql utility, but Website Administration Tool gives this error:
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.
Please guide me what I'm doing wrong here. Thanks!
Apr 13, 2014 12:24 PM|mike4u|LINK
Apr 13, 2014 12:41 PM|Ashim Chatterjee|LINK
It means the connection string is not able to connect to the sql server.Can you share your connection strings here ?
Apr 13, 2014 10:43 PM|kingofspades80|LINK
Here's my connection string:
<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=aspnet-AspLoginControls-20140412201453;Integrated Security=SSPI" />
Apr 13, 2014 10:50 PM|Ashim Chatterjee|LINK
try to use sql server user logins rather than integrated security in connection string. and then check whether it work or not..