Posted: 02 Sep 2003 09:18 PM
My wife started my computer and was prompted to change the password(win 2K Prof) and she did. Grrrrrrrrrr.
After logging in under the new password, I changed it back to the origional.
Ever since, I can not connect or start the database(sql 2k). I receive the error:
SQL Server does not exist or access denied.
Please help me.
Thanks
Gregdo u have Enterprise Manager to see if Database Exists,if does,try to change your TCP/IP port under EnterPrise Manage to 1442 maybe works I've got this problem before but It's doesn't seem to be for Changing password,
I hope it helps|||can you see your db's through the SQL server xplorer. ..|||Thank You for the Ideas.
I dont know what the sql xplorer is, but when I try to access the database through the enterprise manager, I get the error: (Connection failed, check SQL Server Registration Properties.)
Another thing that happened after the changing password incident, is that I must login to these forums and they wont let me automatically login.
this leads me to believe that it has something to do with the users on my computer.
Greg|||check your log files under
C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder.
if you see any files try opening one of the files with a note pad. your registration prbly expired.
HTH.|||I checked that file:
2003-09-01 15:23:03.84 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.0 (Build 2195: Service Pack 4)
2003-09-01 15:23:03.95 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-09-01 15:23:03.95 server All rights reserved.
2003-09-01 15:23:03.95 server Server Process ID is 764.
2003-09-01 15:23:03.95 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-09-01 15:23:04.36 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-09-01 15:23:05.72 server SQL Server configured for thread mode processing.
2003-09-01 15:23:05.86 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-09-01 15:23:07.85 spid3 Starting up database 'master'.
2003-09-01 15:23:12.49 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-09-01 15:23:12.49 spid5 Starting up database 'model'.
2003-09-01 15:23:12.69 spid3 Server name is 'VAIO'.
2003-09-01 15:23:12.69 spid3 Skipping startup of clean database id 4
2003-09-01 15:23:15.10 spid5 Clearing tempdb database.
2003-09-01 15:23:23.00 spid5 Starting up database 'tempdb'.
2003-09-01 15:23:25.04 spid3 Recovery complete.
2003-09-01 15:23:25.05 spid3 SQL global counter collection task is created.
2003-09-01 15:23:34.13 server SQL server listening on Shared Memory.
2003-09-01 15:23:34.13 server SQL Server is ready for client connections
2003-09-02 01:20:10.93 server SQL Server terminating because of system shutdown.
I dont really know what this means.
greg|||your sql server seems to be working fine. can you still not connect through enterprise manager ? start - programs - Microsoft Sql server - enterprise manager.
do you see your server ?|||Yes, I can see the server but it won't refresh or start.
Greg|||I just noticed that the above file refers to the server VAIO which is an MSDE that is running. The server that is not working is VAIO\SUNS. None of the six log files mention that server.
Also, it was the service manager that I can not refresh or start VAIO\SUNS. When I checked in the enterprise manager, I also found the server not running and when I click on it i get an error:(Connection failed, check SQL Server Registration Properties)
Thank you so far for all your help on this!
Greg|||under administrative tools, if you double click on services, you will see a list of all the services in your system. scroll down and find MSSQLSERVER. you can see a 'status' column. wat does it say ? started/stopped? see if you can start the sqlserver frm here.|||if nothing works, may be you can make a copy of the data folder under c:\program files\MS Sql Server\Data and reinstall the SQL Server. and copy the files frm the Data folder back to to the new Data folder.|||MSSQLSERVER is started, but MSSQL$SUNS is not(we already knew this though)
I tried to start MSSQL$SUNS and got the following error:
Could not start the MSSQL$SUNS on Local Computer.
The service did not return an error. This could be an internal Windows error or an internal service error.
If the problem persists, contact your system administrator.
I then tried to login under different user accounts and got the same error.|||are you logged in as admin? or atleast a user with admin privileges ?
also, can you access your sql through query analyzer ?|||I took your advice and reinstalled SQL server. I transfered the data file and everything is running. I can see the old tables in the newly installed server.
The only problem now is that when i try to open my application at http://localhost/default.aspx, I get this error:
---------------
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
---------------
Would it help if I post: C:\Program Files\Microsoft SQL Server\MSSQL$SUNS\LOG
Greg|||(1) can you make out if your webserver is running fine? just write a small test.html and try opening it frm localhost and see if its wrking.
(2) can you see your old files ? i think you need to 'attach' your old databases.
on the enterprise manager ( which i call sql server explorer), when you expand 'databases'
do you see your db ? right click on the 'databases' and 'attach database'. browse to the data folder of the ms sql server and select the db.
(3) is your sql server name the same as the old one ? or did you name it differently ?
No comments:
Post a Comment