Hey Everybody,
I have fought with this all day. Another guy I know had this thing running in 5 minutes after downloading it and I just can't seem to make it work.
I get to the "Configure Database Connection" part of the Install Wizard and I select the "file" option.. When I test the connection, I get these 3 errors:
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4064
Message: Cannot open user default database. Login failed.
Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'DESIGN\ASPNET'.
Index #: 2
Source: .Net SqlClient Data Provider
Class: 0
Number: 5111
Message: File activation failure. The physical file name "C:\buffer\sandbox\App_Data\Database_log.ldf" may be incorrect.
Here are my connection strings.
For the record, permissions are correct.
I'm about to give up. The guy next door didn't have to touch a damn thing.
What am I missing?
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />
-->
</connectionStrings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
If I try to start from scratch, database.mdf is "in use" and I have to manually kill sql related processes in order to delete everything and start over again...so something has opened the file.