Hello, I'm trying to install BugNET on a test computer at work, and get the error message below. Basically, it's a repeat of 'user is not associated with a trusted SQL Server connection'. Below is what I've done to troubleshoot so far, anyone have any idea what might be the problem?
I've tried the following to troubleshoot this:
1. Make sure SQL Server Express 2005 Surface Area Configuration allows both local and remote connections, using both TCP/IP and Named Pipes.
2. Tried 3 different SQL Server users - the BugNET user (BugNET), the SQL Server sa (sa), and my own Windows Network SA account. All get the same error.
3. Tried the following connection string variations (local server name = AWCFMG164B):
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=BugNET;pwd=3ugN3T"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=BugNET;pwd=3ugN3T"
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=AWCFMG164B\BugNET;pwd=3ugN3T"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=localhost\BugNET;pwd=3ugN3T"
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=sa;pwd=sapass"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=sa;pwd=sapass"
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=AWCFMG164B\sa;pwd=sapass"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=localhost\sa;pwd=sapass"
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=WinSA;pwd=pass"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=WinSA;pwd=pass"
connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=NETWORKNAME\WinSA;pwd=pass"
connectionString="server=localhost\SQLEXPRESS;database=BugNET;uid=NETWORKNAME\WinSA;pwd=pass"
I got that format from the BugNET readme.htm, however the original connection string in the web.config file was of a different format:
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"
But I wasn't sure how to modify that, so just commented out and replaced with the readme.html version:
<connectionStrings>
<clear />
<!--<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="" />-->
<add name="LocalSqlServer" connectionString="server=AWCFMG164B\SQLEXPRESS;database=BugNET;uid=sa;pwd=sapass" providerName="" />
</connectionStrings>
The full error message:
-----
Installing BugNET
Version: 0.7.921.0
Installation Status Report
Installing Version: 0.7.921.0
Installing Membership Provider... - 00:00:00.0156251
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\InstallCommon.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\InstallMembership.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\InstallProfile.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\InstallRoles.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Installing BugNET Database... - 00:00:00.0312502
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Installing BugNET Default Data... - 00:00:00.0312502
Error!
Error in file:C:\Inetpub\BugNET\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Creating Administrator Account... - 00:00:00.0312502
-----