mathieu_cupryk
asked on
DOTNETDUKE SQL error 26
How should I setup the Database string and the database in sql 2005.
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integr ated Security=True;User Instance=True;AttachDBFile name=|Data Directory| Database.m df;" providerName="System.Data. SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=( local);Dat abase=DotN etNuke;uid =;pwd=;"
providerName="System.Data. SqlClient" />
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integr ated Security=True;User Instance=True;AttachDBFile name=|Data Directory| Database.m df;" />
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Data base=DotNe tNuke;uid= ;pwd=;"/>
-->
I am not sure how to attached the database the SQL server 2005 Database.mdf. It is also giving me issues.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -
As well as this?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
My Server is Quincy.
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integr
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(
providerName="System.Data.
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integr
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Data
-->
I am not sure how to attached the database the SQL server 2005 Database.mdf. It is also giving me issues.
--------------------------
As well as this?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
My Server is Quincy.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
--------------------------
Cannot open database "DotNetNuke" requested by the login. The login failed.
Login failed for user 'Administrator'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlE
Login failed for user 'Administrator'.
Source Error:
Now how can I get the DotNetDuke database and set it up?
I cannot find it on asp.net.