March 2, 2005 at 10:10 am
I'm trying to learn ms sql 2000. I have installed the trial cd and did a full install. I opened up the Sevice Manager and tried to start the server that i installed with a named instance.
Server name: Kamcomp\APG
Services: SQL server
when i hit start i recieved a 1069 error stating "The service did not start due to a logon failure"
Whats going on? THX!
March 2, 2005 at 10:17 am
I just tried to register the server and im being told it doesn't exist??
March 3, 2005 at 3:39 am
Reboot the server. Have a look in Control Panel and see if the SQL Services exist and under what account they are running under. Start them if they aren't started.
March 6, 2005 at 4:42 pm
Usually this is because the service password is incorrect.
Under services and for the MSSQLServer service check the service account, It should be set to a local administrator account for the server, not local system. Just create an account such as 'MSSQL Server Account" and add it to the local administrators group, then use this account and password for both the MSSQLServer service and the SQLServerAgent service. They should then start correctly and give you access to administer them effectively.
When you install an instance, you will likely need to change the port number for the instance from default 1433 that is reserved for a Default instance. Enterprise manager does not necessarily find the sqlserver if you do not have a default instance installed. You will need to use the SQL Server Client network Utility and set up an alias which will allow you to resolve the SQL server instance in Enterprise Manager.
When the instance was installed it will have asked you what port number you want to use, Using the port number you specified, you need to create a TCP/IP alias "Kamcomp\APG" with the server name "Kamcomp" and the port number you chose. Then you can register the server in Enterprise Manager as "Kamcomp\APG".
Hope that helps.
Nick K
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply