Re: How to trick your computer to run a domain locally, and why - Video #257

It's nice to learn there is a way to work around. However, it is stuck when I come to "Configure Database Connection" of www.mysite.com/Install/InstallWizard.aspx.

The errors shown as below:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed

Actually, the first step "DotNetNuke Installation Wizard - Version 06.00.01" of your video clip also shown the connection problem as below.

"The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database.
You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step."

When I change back to the former way "localhost with directory", there is no such connection problem.

Actually, I really want to setup as the video shown. Is there a way to solve this problem? Thank you!

Re: How to trick your computer to run a domain locally, and why - Video #257

Aderson,

As always... great videos. My question is this. Have you ever seen a "script" or "applet" that will allow a user to switch back and forth between two versions of "Host" files so you can turn off the redirection of your local url? I want to be able to decide if I am looking at my local site or at the actual hosted version when using the URL.

Thanks
Ben

Re: How to trick your computer to run a domain locally, and why - Video #257

Hi Anderson,
I am getting the following error while installation

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
Message:

The interesting thing is that I have installed DNN yesterday without any errors. Today it again starts from the installation process. I dont know why ?

Re: How to trick your computer to run a domain locally, and why - Video #257

Oi Aderson,

Great article! Could this work in some manner with my DNN development site running on a different server within a network (IIS and SQL) rather than locally on my machine?

Mark

Re: How to trick your computer to run a domain locally, and why - Video #257

Hi
As noted in previous post here:

It's nice to learn there is a way to work around. However, it is stuck when I come to "Configure Database Connection" of www.mysite.com/Install/InstallWizard.aspx.

The errors shown as below:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed

Actually, the first step "DotNetNuke Installation Wizard - Version 06.00.01" of your video clip also shown the connection problem as below.

"The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database.
You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step."

When I change back to the former way "localhost with directory", there is no such connection problem.

Actually, I really want to setup as the video shown. Is there a way to solve this problem? Thank you!


Really, really struggling at this...

the Server Login needs to match with the Security Login. If Sql Server Authentication is used, both need to be set in the same format.

I have limited (near zero) experience working in SQL, I just create the sites.. if I can get them running on my local host - like on my laptop - but trying to get this to run on another computer has been the death of me.

Do you have a video on finding the logins - server/security to find out where those are and how to view them, or how to change them...
I dont even think i have sql authentication set, I believe it is Windows authentication.... but I'm getting the same Class 14 number 18456 msg. SQL login failed, as noted above..
At this point I have no idea... So lost and confused...
Any suggestions or recommendations are greatly appreciated.

About to throw up my hands and just head back to the laptop... can't seem to get anything on the other computer to work at this point.

Re: How to trick your computer to run a domain locally, and why - Video #257

Hi,

I have same problem with DB connection. Here is my settings
Windows 7 Home Premium, IIS 7.5, SQL Server 2008 R2 Express.
I acknowledge that I have Server and Windows Authentication mode enabled and can logging with the User I have created(user name is mycms).

I created a database called myDotnetnuke. I mapped the database to the mycms user I have created and assigned db_owner to that.

Now in DB connection page I am stuck for 3 days!
If I choose SQL Server Express (file) and server name as . (dot). Then uncheck integrated mode and enter username(mycms) and password but I get the following error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
Message:

and if I write server name as {my computer name}\sqlexpress I get the following error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15364
Message:

Now I have told that I have to choose SQL Server and not Express. If I do so it goes to next step but then I get the following error.

Installing Database - Version 06.00.00...FAILURE ERROR: See D:\dotnetnuke\Providers\DataProviders\SqlDataProvider\06.00.00.log.resources for more information.

and there is no error file as such, that I can look into!!!!
I am website developer and I can assure you my DB is fine and I am actually developing web app without any problem. But I cannot see where I am doing wrong here.

Any help will be appreciated

Re: How to trick your computer to run a domain locally, and why - Video #257

Hi Anderson,

Thank you for your reply.
I have done all these 3 suggestions you have told me for so many times even before I post it here, but no result!
One thing is strange is why it does not create any error log? If it was permission issue then it was showing that during installation. Also it change my web.config file in connection string section.

Another weird thing is it creates some tables under my database even when it fails. I really cannot understand then why it stops working!

Have you ever come across this type of error?
Also every time it fails I create new database and assign the db_owner to that so every thing is fresh but still I have this error again and again!

If you have any idea help me please.
Thanks.

Re: How to trick your computer to run a domain locally, and why - Video #257

I have created that tread!
It is ME on that DNN link that asking the same question and banging my head to get the answer from them. And then I came across this site and thought ask here also so get answer in one or the other and still nothing!