riporto da precedente forun su asp.net 2
dunque,
da visual web developer developer express edition,viene installato un'istanza sqlexpress qaaieme al prodotto si scaricano dei file .mdf di esempio e altro che nn so bene a cosa servano(sempre archivi.mdf)x es aspnetdb.mdf e altro,io ho disistallato il motore e l'istanza sqlexpress e installato sql standard su istanza predefinita, ora nn riesco a utilizzare + gli oggetti che non creo direttamente da mvwdee o dalla consolle managemant studio,se tento di fare un attack il risultato del query è questo e poi viene interrotta.
USE [master]
GO
CREATE DATABASE [FileSystemSQL] ON
( FILENAME = N'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\FileSystemSQL.mdf' ),
( FILENAME = N'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\FileSystemSQL_log.LDF' )
FOR ATTACH
GO
if not exists (select name from master.sys.databases sd where name = N'FileSystemSQL' and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [FileSystemSQL].dbo.sp_changedbowner @loginame=N'LOR-XP2200\Loris', @map=false
GO
permessi.. mi ricordo poco ci capite qualche cosa?
grazie ciao.
mi è stato consigliato di postare qui, e di allegare il report di errore:mi rendo conto sia lunghissimo ma ad un occhio esperto penso basti un'occhiata, io sono rimasto al framework 1.1 e sql server 2000.grazie se potete darmi una mano a configurare asp.net2 e relativi.
Data,Origine,Gravità,ID log,Messaggio,ID processo,ID elemento di posta,ID account,Data ultima modifica,Autore ultima modifica,
01/31/2007 15:28:46,spid52,Sconosciuta,,The file "C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MultiCat.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.,,,,,,
01/31/2007 15:28:46,spid52,Sconosciuta,,Errore: 5118<c/> gravità: 16<c/> stato: 1.,,,,,,
01/31/2007 15:28:46,spid52,Sconosciuta,,Starting up database 'MultiCat'.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,The file "C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\aspnetdb.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,Errore: 5118<c/> gravità: 16<c/> stato: 1.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,FCB::RemoveAlternateStreams: Operating system error (null) occurred while creating or opening file 'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\aspnetdb.mdf'. Diagnose and correct the operating system error<c/> and retry the operation.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,Errore: 17207<c/> gravità: 16<c/> stato: 1.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,Starting up database 'aspnetdb'.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,FCB::RemoveAlternateStreams: Operating system error (null) occurred while creating or opening file 'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data\aspnetdb.mdf'. Diagnose and correct the operating system error<c/> and retry the operation.,,,,,,
01/31/2007 15:27:42,spid52,Sconosciuta,,Errore: 17207<c/> gravità: 16<c/> stato: 1.,,,,,,
01/31/2007 15:14:48,spid52,Sconosciuta,,Starting up database 'D:\DOCUMENTI LORIS\VISUAL STUDIO 2005\WEBSITES\LORISPERSONAL\APP_DATA\PERSONAL.MDF'.,,,,,,
01/31/2007 15:14:16,spid52,Sconosciuta,,Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.,,,,,,
01/31/2007 14:46:49,spid12s,Sconosciuta,,Service Broker manager has started.,,,,,,
01/31/2007 14:46:49,spid12s,Sconosciuta,,The Database Mirroring protocol transport is disabled or not configured.,,,,,,
01/31/2007 14:46:49,spid12s,Sconosciuta,,The Service Broker protocol transport is disabled or not configured.,,,,,,
01/31/2007 14:46:49,spid5s,Sconosciuta,,Recovery is complete. This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:49,spid9s,Sconosciuta,,Starting up database 'tempdb'.,,,,,,
01/31/2007 14:46:47,spid9s,Sconosciuta,,Clearing tempdb database.,,,,,,
01/31/2007 14:46:47,spid5s,Sconosciuta,,Starting up database 'msdb'.,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,SQL Server is now ready for client connections. This is an informational message; no user action is required.,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,Dedicated admin connection support was established for listening locally on port 1434.,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,Server is listening on [ 127.0.0.1 <ipv4> 1434].,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].,,,,,,
01/31/2007 14:46:47,Server,Sconosciuta,,Server is listening on [ 'any' <ipv4> 1433].,,,,,,
01/31/2007 14:46:46,Server,Sconosciuta,,A self-generated certificate was successfully loaded for encryption.,,,,,,
01/31/2007 14:46:46,spid5s,Sconosciuta,,Server name is 'LOR-XP2200'. This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:46,spid9s,Sconosciuta,,Starting up database 'model'.,,,,,,
01/31/2007 14:46:46,spid5s,Sconosciuta,,Starting up database 'mssqlsystemresource'.,,,,,,
01/31/2007 14:46:46,spid5s,Sconosciuta,,SQL Trace ID 1 was started by login "sa".,,,,,,
01/31/2007 14:46:46,spid5s,Sconosciuta,,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:45,spid5s,Sconosciuta,,Starting up database 'master'.,,,,,,
01/31/2007 14:46:45,Server,Sconosciuta,,Database Mirroring Transport is disabled in the endpoint configuration.,,,,,,
01/31/2007 14:46:45,Server,Sconosciuta,,The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality<c/> please start this service.,,,,,,
01/31/2007 14:46:42,Server,Sconosciuta,,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:42,Server,Sconosciuta,,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:42,Server,Sconosciuta,,Detected 1 CPUs. This is an informational message; no user action is required.,,,,,,
01/31/2007 14:46:42,Server,Sconosciuta,,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,-l C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,-e C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,-d C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,Registry startup parameters:,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,This instance of SQL Server last reported using a process ID of 584 at 31/01/2007 10.39.06 (local) 31/01/2007 9.39.06 (UTC). This is an informational message only; no user action is required.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,Logging SQL Server messages in file 'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,Server process ID is 1164.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,All rights reserved.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,(c) 2005 Microsoft Corporation.,,,,,,
01/31/2007 14:46:41,Server,Sconosciuta,,Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) <nl/>Oct 14 2005 00:33:37 <nl/>Copyright (c) 1988-2005 Microsoft Corporation<nl/>Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2),,,,,,
01/31/2007 10:39:10,Server,Sconosciuta,,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.,,,,,,
01/31/2007 10:39:10,spid5s,Sconosciuta,,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.,,,,,,
01/31/2007 10:39:08,spid12s,Sconosciuta,,The current event was not reported to the Windows Events log. Operating system error = 31(Una periferica collegata al sistema non è in funzione.). You may need to clear the Windows Events log if it is full.,,,,,,
01/31/2007 10:39:08,spid12s,Sconosciuta,,Error: 17054<c/> Severity: 16<c/> State: 1.,,,,,,
01/31/2007 10:39:07,spid12s,Sconosciuta,,Service Broker manager has shut down.,,,,,,
01/31/2007 10:39:06,Server,Sconosciuta,,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:58,spid12s,Sconosciuta,,Service Broker manager has started.,,,,,,
01/31/2007 10:06:58,spid12s,Sconosciuta,,The Database Mirroring protocol transport is disabled or not configured.,,,,,,
01/31/2007 10:06:58,spid12s,Sconosciuta,,The Service Broker protocol transport is disabled or not configured.,,,,,,
01/31/2007 10:06:58,spid5s,Sconosciuta,,Recovery is complete. This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:58,spid9s,Sconosciuta,,Starting up database 'tempdb'.,,,,,,
01/31/2007 10:06:56,spid9s,Sconosciuta,,Clearing tempdb database.,,,,,,
01/31/2007 10:06:56,spid5s,Sconosciuta,,Starting up database 'msdb'.,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,SQL Server is now ready for client connections. This is an informational message; no user action is required.,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,Dedicated admin connection support was established for listening locally on port 1434.,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,Server is listening on [ 127.0.0.1 <ipv4> 1434].,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,Server is listening on [ 'any' <ipv4> 1433].,,,,,,
01/31/2007 10:06:56,Server,Sconosciuta,,A self-generated certificate was successfully loaded for encryption.,,,,,,
01/31/2007 10:06:56,spid9s,Sconosciuta,,Starting up database 'model'.,,,,,,
01/31/2007 10:06:56,spid5s,Sconosciuta,,Server name is 'LOR-XP2200'. This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:56,spid5s,Sconosciuta,,Starting up database 'mssqlsystemresource'.,,,,,,
01/31/2007 10:06:56,spid5s,Sconosciuta,,SQL Trace ID 1 was started by login "sa".,,,,,,
01/31/2007 10:06:55,spid5s,Sconosciuta,,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:55,spid5s,Sconosciuta,,Starting up database 'master'.,,,,,,
01/31/2007 10:06:54,Server,Sconosciuta,,Database Mirroring Transport is disabled in the endpoint configuration.,,,,,,
01/31/2007 10:06:54,Server,Sconosciuta,,The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality<c/> please start this service.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Detected 1 CPUs. This is an informational message; no user action is required.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,-l C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,-e C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,-d C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Registry startup parameters:,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,This instance of SQL Server last reported using a process ID of 1112 at 31/01/2007 5.05.44 (local) 31/01/2007 4.05.44 (UTC). This is an informational message only; no user action is required.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Logging SQL Server messages in file 'C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Server process ID is 584.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,All rights reserved.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,(c) 2005 Microsoft Corporation.,,,,,,
01/31/2007 10:06:51,Server,Sconosciuta,,Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) <nl/>Oct 14 2005 00:33:37 <nl/>Copyright (c) 1988-2005 Microsoft Corporation<nl/>Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2),,,,,,
01/31/2007 05:05:49,Server,Sconosciuta,,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.,,,,,,
01/31/2007 05:05:49,spid5s,Sconosciuta,,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.,,,,,,
01/31/2007 05:05:46,spid12s,Sconosciuta,,The current event was not reported to the Windows Events log. Operating system error = 1717(Interfaccia sconosciuta.). You may need to clear the Windows Events log if it is full.,,,,,,
01/31/2007 05:05:46,spid12s,Sconosciuta,,Error: 17054<c/> Severity: 16<c/> State: 1.,,,,,,
01/31/2007 05:05:46,spid12s,Sconosciuta,,Service Broker manager has shut down.,,,,,,
01/31/2007 05:05:44,Server,Sconosciuta,,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.,,,,,,
01/31/2007 00:00:47,spid13s,Sconosciuta,,This instance of SQL Server has been using a process ID of 1112 since 30/01/2007 14.13.24 (local) 30/01/2007 13.13.24 (UTC). This is an informational message only; no user action is required.,,,,,,
01/30/2007 14:13:24,spid12s,Sconosciuta,,Service Broker manager has started.,,,,,,
01/30/2007 14:13:24,spid12s,Sconosciuta,,The Database Mirroring protocol transport is disabled or not configured.,,,,,,
01/30/2007 14:13:24,spid12s,Sconosciuta,,The Service Broker protocol transport is disabled or not configured.,,,,,,
01/30/2007 14:13:24,spid5s,Sconosciuta,,Recovery is complete. This is an informational message only. No user action is required.,,,,,,
01/30/2007 14:13:23,spid9s,Sconosciuta,,Starting up database 'tempdb'.,,,,,,
01/30/2007 14:13:19,spid9s,Sconosciuta,,Clearing tempdb database.,,,,,,
01/30/2007 14:13:19,spid5s,Sconosciuta,,Starting up database 'msdb'.,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,SQL Server is now ready for client connections. This is an informational message; no user action is required.,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,Dedicated admin connection support was established for listening locally on port 1434.,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,Server is listening on [ 127.0.0.1 <ipv4> 1434].,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,Server is listening on [ 'any' <ipv4> 1433].,,,,,,
01/30/2007 14:13:18,Server,Sconosciuta,,A self-generated certificate was successfully loaded for encryption.,,,,,,
01/30/2007 14:13:18,spid5s,Sconosciuta,,Server name is 'LOR-XP2200'. This is an informational message only. No user action is required.,,,,,,
01/30/2007 14:13:18,spid9s,Sconosciuta,,Starting up database 'model'.,,,,,,