 |
|
|
|
Joined: 1/25/2006
Posts: 40
|
|
|
I am having trouble with my connection string... <add name="SiteSqlServer" connectionString="Data Source=69.90.236.44,1433;Integrated Security=True;User Instance=True;Database=DNN;uid=*******;Password=******;" providerName="System.Data.SqlClient" /> I am trying to use the above string to connect to a db created on a remote host (parcom.net)... here is the error i receive... Error Installing DotNetNukeCurrent Assembly Version: 04.00.02ERROR:
Could not connect to database specified in connectionString for
SqlDataProviderSystem.Data.SqlClient.SqlException: Login failed for
user 'NT AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
/************************************************************/
/***** Initialization Script *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and *****/
/***** *****/
/************************************************************/
if exists (select * from dbo.sysobjects where id =
object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1)
begin if '' <> '' begin EXECUTE sp_rename N'dbo.Version',
N'Version', 'OBJECT' EXECUTE sp_rename N'PK_Version', N'PK_Version',
'OBJECT' EXECUTE sp_rename N'IX_Version', N'IX_Version', 'INDEX' ALTER
TABLE dbo.Version ADD CONSTRAINT IX_Version UNIQUE NONCLUSTERED (
Major, Minor, Build ) ON [PRIMARY] end
end
else
begin if not exists (select * from dbo.sysobjects where id =
object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin
CREATE TABLE dbo.Version ( [VersionId] [int] IDENTITY (1, 1) NOT NULL ,
[Major] [int] NOT NULL , [Minor] [int] NOT NULL , [Build] [int] NOT
NULL , [CreatedDate] [datetime] NOT NULL ) ON [PRIMARY] ALTER TABLE
dbo.Version WITH NOCHECK ADD CONSTRAINT [PK_Version] PRIMARY KEY
CLUSTERED ( [VersionId] ) ON [PRIMARY] ALTER TABLE dbo.Version ADD
CONSTRAINT IX_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON
[PRIMARY] end
end
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
if exists (select * from dbo.sysobjects where id =
object_id(N'GetDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure')
= 1)
drop procedure dbo.GetDatabaseVersion
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
create procedure dbo.GetDatabaseVersion
as
select Major, Minor, Build
from Version where VersionId = ( select max(VersionId) from Version )
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
if exists (select * from dbo.sysobjects where id =
object_id(N'FindDatabaseVersion') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure dbo.FindDatabaseVersion
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
create procedure dbo.FindDatabaseVersion
@Major int,
@Minor int,
@Build int
as
select 1
from Version
where Major = @Major
and Minor = @Minor
and Build = @Build
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
if exists (select * from dbo.sysobjects where id =
object_id(N'UpdateDatabaseVersion') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure dbo.UpdateDatabaseVersion
System.Data.SqlClient.SqlException: Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String
connectionString, CommandType commandType, String commandText) at
DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean
UseTransactions)
create procedure dbo.UpdateDatabaseVersion
@Major int,
@Minor int,
@Build int
as
insert into Version ( Major, Minor, Build, CreatedDate
)
values ( @Major, @Minor, @Build, getdate()
)
|
| |
|
|
 | |
|
|
Joined: 1/1/0001
Posts: 0
|
| |
| |
|
|
|
Joined: 1/25/2006
Posts: 40
|
| |
| |
|
|
|
Joined: 1/25/2006
Posts: 40
|
|
|
Here is the newest error I'm receiving...Unauthorized Access ErrorError Details| File | C:\Domains\jarretteschule.com\wwwroot\Portals\_default\\Logs\LogFailures.xml.resources | | Error | Access
to the path
'C:\Domains\jarretteschule.com\wwwroot\Portals\_default\Logs\LogFailures.xml.resources'
is denied. The Windows User Account listed below must have Read/Write
Privileges to this path. |
|
| |
|
|
| |
|
|
 |
www.HilbertSolutions.com
Joined: 10/30/2003
Posts: 852
|
|
|
Makre sure your Network Service account has access to your DNN project files folder.
Stuart
|
| |
|
|
| |