Hi,

ive been trying to install DNN on my web server. I am installing a v5.1.0 on a server 2003 OS and .Net 1.1

The virtual directory is created on the Web Server, and the Sql server 2008 is on another Server .

I have altered the Connection Strings in the web config file so that it can connect to the database that was created on the other server.

Data Source=Servername;Initial Catalog=DotNetNuke;uid=Domain\dotnetnuke;pwd=Password;" providerName="System.Data.SqlClient"/>
And also
Data Source=Servername;Initial Catalog=DotNetNuke;uid=Domain\dotnetnuke;pwd=Password;">

But for some reason i am unable to make the connection to the database that resides on another server than the web server.

The error that i intially got was that Login Failed, and that Microsoft Authentication doesnt work (i dont have the exact error)

i have followed the guide on this website http://www.bestwebsites.co.nz/dotnetnuke/easy-dotnetnuke-installation-guide/

i realise that they are using Express Sql , but i did work around that, but am still facing issues during installation for the Configure Database Connection Part. 

Okay,

im sorry i just talked to my admin, and he notified me that we do have Asp2.0, i was thinking about another test server that had 1.1 I got my information wrong on that.

But i am still getting this issue, which is saying that Mirosoft authentication has failed, and login failed.

i am just wondering whether, if i have to provide the full location of the server with the databse. I can ping from server to server. But in some cases i use the format ServerName.Domain.local (eg in Setting up Office Communicator)

The exact error i am getting is

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18452
Message: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I am trying to also enable the TCP/IP in the SQL Surface Area, But do not now how to use it in SQL Server 2008. I found it is in Facet, but cannot not find any option regarding enabling this. I have also clicked and made sure that both SQL and Windows Authentication is Enabled. Please help, very critical for me