SQL Server Registration Error Messages.....help?
-
I am fairly new to SQL, but I believe that I have my head around the general product. I am trying to install an Enterprise product on a SQL Server on 4 different machines. 2 of the 4 are working correctly. (Each machine has SQL Server 2000 installed from the MSDN DVD).
The other 2 machines are rejecting the SQL Server installation. I can look at the services and notice that the SQL agent is not running, however, when I attempt to manually start it, I get an error saying that unless the SQL service has work to do, it will not start.
Secondly, in the Enterprise Manager, I can see the SQL Server, with the little white server icon with the green arrow within (assuming this is a success icon). When I expand the Server, I can see (LOCAL) (Windows NT), even though its a Windows 2000 machine. (Not a server, just 2000 Pro). When I expand that server, there is another error message, "CONNECTION FAILED, CHECK SQL SERVER REGISTRATION PROPERTIES.
I have tried to edit the existing registration, but Im getting User Log In Failed, when I try. I have tried both Windows Auth (which I am a domain admin), as well as local admin. All options are failing.
Can anyone help me out or point me in a direction of success?
Much appreciated!
-
Chris -
When you register a SQL Server in Enterprise Manager, you have the choice of using your domain login or a SQL login. Try editing the registration and using your SA account and password, to see if Enterprise manager is communicating with the SQL Service.
If you use the default install of SQL and use the default registration in Enterprise Manager, and you are using Enterprise Manager on that box, it will always show Local, Windows NT, even if it is a 2000 box. You can delete this and add an entry using the machine or instance name if you want so it isn't so confusing.
SQL Agent won't run without the MSSQLServer Service running first. Check to make sure it is working.
Hope this helps,
Michelle
Michelle -
Michelle,
Thanks for the response.
Quick question, and forgive me for being a novice at SQL....(self taught) - how do I assign a SA pass? Would that be the local user/pass for the Administrator or something else?
-
SA is the default system admin account in SQL. SQL can use Windows NT authentication(domain) or SQL Authentication, or both.
In BOL (Books Online)(My life-saver), I used the Index tab and entered the keyword = sa then I chose the password category and received the following page:
How to assign the sa password on a newly installed server (Enterprise Manager)
Here is another good page for you:
System Administrator (sa) Login
If you set an SA password when you installed SQL Server, and you don't remember it, you might have to uninstall-reinstall to get everything working.
Michelle
Michelle -
Thanks again Michelle.
Quick question now....where can I find Books Online and make it MY life saver? 😉
-
Start-->Programs-->Microsoft SQL Server-->Books Online
If you run the install on your personal workstation, and just choose the client tools, you can have BOL handy on your machine.
Michelle -
Michelle,
I am new to SQL Server, I have the same problem as described. SQL Server Registration Error. When I login SQL Server Enterprise Manager, and try to expand Server, it says Connection failed, check SQL Server Registration Properties...
I have Windows authentication for connection to SQL Server. And I logged into this machine using Local Administrator account. This machine is standalone (Not in any domain)
Can you please suggest do I need to configure user to have access to SQL Server authentication.
Waiting for early response,
Thanks,
Sandeep.
-
Sandeep -
When you installed SQL Server, it prompted you to enter a password for the SA account. Use SA and that password to register the server in Enterprise Manager. Also, check out the previously mentioned Books OnLine articles.
Michelle -
I am afraid I dont remember the password, i think it should be blank. What is the default password provided by SQL Server? (Like in oracle the default password for sa is manager) Is there anything in SQL Server?
If i use Windows authentication will it not accept Local Administration authentication. Do I need to add local adminsitration in sql authentication?
I am trying to install BOL from MSDN C.D
Thanks,
Sandeep.
-
I had this problem for an entire day last week and decided the best way to troubleshoot would be to spend the entire day if necessary and fix it.
So, my technique, uninstall SQL server. Re-install. Select a different method of access when installing and name sure to give the SQL instance a UNIQUE name. The next step SHOULD be to create a SA password.
Next, open Enterprise Manager and try to open the SQL server. If you get the rejection again, right click on the server and select Edit Registration. When you begin to search for SQL servers, you should find that UNIQUE instance. Select that one and use the SA user/pass you put in during the install.
Also, the SQL server icon in the task bar should be running. If not, select Start | Programs | SQL Server | Services Manager. It will probably reject you starting up with the same SQL server problem as before. Click the drop down list and look for your server. Looks something like, \\SERVER\SQLInstance.
Selecting that instance will give you the Green Light.
Good luck.
Chris
-
Hi,
I have a different situation, while installing SQL Server on Windows 2000 O.S.
In the Enterprise Manager, I can see the SQL Server, has(machine name) (Windows 2000) and the green arrow instead of the LOCAL. Which setting does this so that i get default LOCAL.
1. Should I register this again?
2. How configure while installing SQL server, so that it takes LOCAL insteam of th e local name.
Any pointers? This is happening only on Win2000 and I tried in Win2003 OS I did not get the same problem?
Should any patch upgrade on SQL Server help?
Thanks
Sunder
-
Hi
In the Enterprise Manager, I can see the SQL Server, with the little white server icon with the green arrow within (assuming this is a success icon). When I expand the Server, I can see (LOCAL) (Windows NT), even though its a Windows 2000 compaq server. When I expand that server, there is a same error "CONNECTION FAILED, CHECK SQL SERVER REGISTRATION PROPERTIES.
I have tried to edit the existing registration, but Im getting User Log In Failed, when I try. I have tried both Windows Auth (which I am a domain admin), as well as local admin. All options are failing.
when i registered again then the message shows the server is already exist also when I run the services from service manager the services of distributed transaction coordinator, sql server, Mssql ServarOLAPService are run but when i run the sql server agent then it is not running. and when i run only sql server agent the service run but when i start the sql server the service of agent is stop.
Can anyone help me out or point me in a direction of success?
Much appreciated!
sudhir
-
I would try to uninstall SQL (as bad as that sucks) and re-install. When prompted, make sure you give SQL a valid SA password.
I had the same problem. It took me installing and re-installing about 5 times before I could have a valid SQL server running from Enterprise Manager.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply