BV Commerce Forum
»
BV Commerce Support
»
General Support
»
DB Connection-What am i missing? error: 40 - Could not open a connection to SQL Server
Rank: Member
Joined: 11/9/2008(UTC) Posts: 4
|
[3]Greetings,
Any help appreciated.I simply dont no what im missing. Got it running previously Followed the instructions to the letter. MSQL Management Studio Xpress can connect to DB so permissions not the problem. Ran the scripts manually as well /BVAdmin/Full/ it seems BV aint comunticating with Database. Really need to get this running.
-Enabled remote connections for SQL Server 2005. Express -Network Protocols Enabled Named pipes and tcp/ip port 1433 -Enabled the SQL Server Browser service - exempted port on firewall
<connectionStrings> <add name="Bvc5Database" connectionString="server=localhost;database=db_name;uid=userAccount;pwd=password;"/> </connectionStrings>
DB
Set permissions to userAccount Enabled Sql and Windows Authentication userAccount owner of DB
IIS 5.1configured and working properly. As im testing Able and Dash on the same system. Got them running no fuss. However really want to test this befor deciding on a solution.... [/3] Error Message.
Line 7: Protected Sub StartButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles StartButton.Click Line 8: If Utilities.VersionHelper.SqlPatchNeeded() Then Line 9: Utilities.VersionHelper.RunSqlPatch() Line 10: Line 11: 'Load all items
Source File: C:\projects\bvc5\www\SqlPatch.aspx.vb Line: 9
|
|
|
|
Rank: Member
Joined: 11/9/2008(UTC) Posts: 4
|
Ok guys,
Solved the problem.... I have changed the default port to another port number and had only exempt 1433 from the firewall. Knew it'll be something simple... lol (isn't it always) Thanx anyways
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.