April 6, 2018 at 8:03 am
Attention: SQL Server 2017 - Administration forum members:
I posted the information, below, to other forums, but have not had any success in receiving assistance. I have tried registering at "https://www.hmailserver.com/forum/," but have repeatedly been denied registration there, because I have somehow been flagged as a spammer, which I am not. Yesterday, I posted to the Microsoft Developer Network Forefront Identity Manager 2010 forum, but it was suggested that I post somewhere else. I am hoping that someone in this forum can provide some assistance. Please read the information below:
"Attention: Forefront Identity Manager 2010 forum members:
I posted the message below to the Microsoft Developer Network forum recently, and was told to post to an appropriate forum. I have tried to register as a user at the hMailServer forum website, but have repeatedly been refused registration because of an errant claim that I am a spammer, which I am not. Is there anything that this forum can do to solve my problem?
'Attention: Microsoft Developer Network staff:
I have recently created an hMailServer database in Microsoft Visual Studio 2017. However, I am unable to successfully configure hMailServer 5.6.6 - B2383. Using the hMailServer Database Setup wizard, I click on the "'Next'" button on the "'Welcome'" dialog box. Then, I leave the "'Create a new hMailServer database'" radio button selected, and click the "'Next'" button on the "'Select option'" dialog box. Then, I leave the "'Microsoft SQL Server'" radio button selected, and click on the "'Next'" button on the "'Select database server type'" dialog box. Then, I enter "'192.168.0.2'" in the "'Database server address'" field, "'hMailServer'" in the "'Database name'" field, leave the "'Use server authentication'" radio button selected, enter a user name in the "'Username'" field, and a password in the "'Password'" field, and click on the "'Next'" button on the "'Enter server connection information'" dialog box. Then, I select the "'Apache2.4 (Apache2.4)'" service dependency, and click on the "'Next'" button on the "'Set hMailServer service dependency'" dialog box. Then, I click the "'Next'" button on the "'Finish'" dialog box. Then, I receive the following error message:
"'Starting task...
Please wait while creating database...
ADO: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied'"
Can anyone help me figure out what I am doing wrong? When I click on the "'View'" drop down menu in Microsoft Visual Studio 2017, then click on the "'Server Explorer'" menu item, then click next to the database icon, then right-click next to the database icon ( with the following database name associated with it: "'russell1-pc\sqlexpress.hMailServer.dbo'" ), then click on the "'Browse in SQL Server Object Explorer'" menu item, an hMailServer database icon is clearly visible, which can be expanded to show a list of other items. Why am I receiving the above-given error message? Thank you ( see Colossians 3:15, for example ) for your help. Keep in touch.
Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23.'
Also, as of today, after having launched the Microsoft Management Console ( MMC ) in Microsoft Windows 10 ( Home ) edition, and snapping in SQL Server Configuration Manager ( Local ), expanding it, expanding the 'SQL Server Network Configuration' option, and clicking on the 'Protocols for SQLEXPRESS' option, the center pane of MMC shows that TCP/IP is enabled. I have found through online research that there are two possible reasons for the hMailServer database setup error message given above: (1) the data source connection string includes 'localhost' and (2) TCP/IP is disabled for the SQL Server service. For reason '(1),' the data source connection string given in Microsoft Visual Studio 2017 is as follows: 'Data Source=RUSSELL1-PC\SQLEXPRESS;Initial Catalog=hMailServer;Integrated Security=True.' In this connection string, 'RUSSELL1-PC' is used, rather than 'localhost' ( although 'RUSSELL1-PC' is the local host ), so this connection string should be correct ( hopefully ). With regard to reason '(2),' it has already been demonstrated that TCP/IP is enabled for the SQL Server service. Why am I still receiving the above-given error message? Do you have any suggestions? Thank you ( see Colossians 3:15, for example ) for your help. Keep in touch.
Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23."
Also, included below are nine screen capture files for your consideration. Thank you ( see Colossians 3:15, for example ) for your help. Keep in touch.
Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23.
April 9, 2018 at 5:45 am
is the ip address you supplied the correct address for your sql server?
is the port correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2018 at 6:59 am
Attention: Mr. Whittle:
In response to your first question, I am assuming that since the same computer is used for both my web server and SQL Server 2017, that the IP Address of my computer is the correct one, which is supplied in my initial post, above. With regard to your second question, I found some information online regarding creating an inbound rule in my firewall for connecting to a remote SQL server ( it involved creating a new inbound rule and a custom rule ). I used port 1434 for one of those rules, as suggested. I have not yet used either of those rules, since I have not been able to figure out how to start SQL Server 2017 ( not the server service, though ). I still receive the error message, given in my initial post, when using the hMailServer Database Setupu wizard. Saturday morning, I downloaded SQL Server Management Studio ( SSMS - version 17.6, if I remember correctly ), but have not been able to successfully install it - I receive error messages during that process. Thank you ( see Colossians 3:15, for example ) for any assistance you can provide. Keep in touch.
Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23.
April 9, 2018 at 9:37 am
rewillis1_1 - Monday, April 9, 2018 6:59 AMsee Colossians 3:15, for example ) for any assistance you can provide.
what is this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2018 at 10:45 am
Attention: Mr. Whittle:
Colossians 3:15 ( RSV ) reads as follows: "15 And let the peace of Christ rule in your hearts, to which indeed you were called in the one body. And be thankful." As a Christian ( see Acts, chapter 11 ( especially verse 26, for example ), for example ), I am expressing my thanks for your assistance. Since my previous posting, I have done some additional online research, and learned that SQL Express is not supported in SQL Server 2017 Database Engine Tuning Advisor. I had previously downloaded SQL Express and then, this morning, I clicked on the "SQL Server 2017 Database Engine Tuning Advisor" menu item under the Start menu ( The Windows icon on the taskbar ), launched SQL Server, "RUSSELL1-PC\SQLEXPRESS" appeared in the "Server name:" field of the "Connect to Server" dialog box, I then clicked the "Connect" button on the "Connect to Server" dialog box, and received an error message ( as indicated in the screen capture file included below ). After that, I downloaded and installed SQL Server 2017 Developer Edition. I suppose I need to do some further online research in order to figure out how to successfully connect to SQL Server. I appreciate any assistance you can provide. Keep in touch.
Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23.
April 9, 2018 at 10:57 am
rewillis1_1 - Monday, April 9, 2018 10:45 AMAttention: Mr. Whittle:
Colossians 3:15 ( RSV ) reads as follows: "15 And let the peace of Christ rule in your hearts, to which indeed you were called in the one body. And be thankful." As a Christian ( see Acts, chapter 11 ( especially verse 26, for example ), for example ), I am expressing my thanks for your assistance. Since my previous posting, I have done some additional online research, and learned that SQL Express is not supported in SQL Server 2017 Database Engine Tuning Advisor. I had previously downloaded SQL Express and then, this morning, I clicked on the "SQL Server 2017 Database Engine Tuning Advisor" menu item under the Start menu ( The Windows icon on the taskbar ), launched SQL Server, "RUSSELL1-PC\SQLEXPRESS" appeared in the "Server name:" field of the "Connect to Server" dialog box, I then clicked the "Connect" button on the "Connect to Server" dialog box, and received an error message ( as indicated in the screen capture file included below ). After that, I downloaded and installed SQL Server 2017 Developer Edition. I suppose I need to do some further online research in order to figure out how to successfully connect to SQL Server. I appreciate any assistance you can provide. Keep in touch.Sincerely in Christ,
Russell E. Willis
P.S. - Please read Proverbs 23:23.
and you wonder why you're banned from other sites, preaching to the wrong person i'm afraid
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply