February 16, 2005 at 11:08 am
Good Morning Everyone. I just installed MSDE for Crystal Enterprise 10. But I can't seem to get it to work. The SQL Server Service is up and running. All three services are green. My LoginMode value is 2 for MixedMode. My Firewall is not active. But when I go to the SQL WebAdmin screen, I can't login either with Windows or SQL authentication.
My errorlog is:
2005-02-16 09:36:41.31 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-02-16 09:36:42.82 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-02-16 09:36:42.82 server All rights reserved.
2005-02-16 09:36:42.82 server Server Process ID is 932.
2005-02-16 09:36:42.82 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-02-16 09:36:43.03 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-02-16 09:36:45.03 server SQL Server configured for thread mode processing.
2005-02-16 09:36:45.09 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-02-16 09:36:45.65 spid3 Starting up database 'master'.
2005-02-16 09:36:47.57 spid3 Server name is 'P4'.
2005-02-16 09:36:47.57 spid3 Skipping startup of clean database id 4
2005-02-16 09:36:47.57 spid3 Starting up database 'CE10'.
2005-02-16 09:36:47.59 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-02-16 09:36:47.59 spid5 Starting up database 'model'.
2005-02-16 09:36:48.06 server SQL server listening on 192.168.1.100: 1433.
2005-02-16 09:36:48.06 server SQL server listening on 127.0.0.1: 1433.
2005-02-16 09:36:48.21 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-02-16 09:36:48.21 server SQL Server is ready for client connections
2005-02-16 09:36:48.73 spid5 Clearing tempdb database.
2005-02-16 09:36:51.43 spid5 Starting up database 'tempdb'.
2005-02-16 09:36:51.85 spid3 Recovery complete.
2005-02-16 09:36:51.85 spid3 SQL global counter collection task is created.
2005-02-16 09:36:57.31 spid51 Starting up database 'msdb'.
2005-02-16 09:37:08.67 spid51 Using 'xpsqlbot.dll' version '2000.80.760' to execute extended stored procedure 'xp_qv'.
The sqlagent.out file is:
2005-02-16 09:37:08 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID
2005-02-16 09:37:08 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 1648
2005-02-16 09:37:08 - ? [101] SQL Server P4 version 8.00.760 (0 connection limit)
2005-02-16 09:37:08 - ? [102] SQL Server ODBC driver version 3.85.1117
2005-02-16 09:37:08 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2005-02-16 09:37:08 - ? [310] 1 processor(s) and 511 MB RAM detected
2005-02-16 09:37:08 - ? [339] Local computer is P4 running Windows NT 5.1 (2600) Service Pack 2
2005-02-16 09:37:09 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2005-02-16 09:37:09 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2005-02-16 09:37:09 - + [260] Unable to start mail session (reason: No mail profile defined)
2005-02-16 09:37:09 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Any help will be greatly appreciated.
Thank you,
Sharon
February 16, 2005 at 11:23 am
Maybe the webadmin is not using your login and that this login doesn't have access (I never used it so I'm just guesssing here).
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply