sql server 2005 - new install of sql svr, cant log on "connect to DB" --->A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found o

this install is completely empty...its a new server..new sql download..empty completely empty...when I bring up the mng studio and it asks to log on there is nothing to log onto...so I click connect in the loginin prompt..

and I cant get in...
A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible


I have my sql script to create the db..but then it goes to that logon prompt and errors out...HELP!  I need this fast...
LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
 
Ady FootSharePoint ConsultantCommented:
Hmmm you might want to try reinstalling completely then if the services aren't even there.  Sounds like something went wrong during the install.

Ady
0
 
Ady FootSharePoint ConsultantCommented:
Have you typed 'localhost' into the server name field?

Regards,

Ady
0
 
GlobaLevelProgrammerAuthor Commented:
yes and I got the same error...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Ady FootSharePoint ConsultantCommented:
Try starting the 'SQLBrowser' service on your machine if it isn't already started.  While you're in services.msc, please also check  (for sanity's sake) that the SQLServer server is started too.

Regards,

Ady
0
 
GlobaLevelProgrammerAuthor Commented:
So I have :

SERVER TYPE: Database Engine
SERVER NAME: localhost
AUTHENTICATION: Windows
USER NAME: GL-3FE23xxxxx\Administrator
PASSWORD: _______
0
 
Ady FootSharePoint ConsultantCommented:
OK - it shouldn't allow you to enter anything into the password field because you're using windows authentication.  I take it you added that Administrator account to the SQLAdmins group during the installation process?

Regards,

Ady
0
 
Ady FootSharePoint ConsultantCommented:
You could try swapping out localhost for 127.0.0.1 but I'm not sure that would help.  
0
 
GlobaLevelProgrammerAuthor Commented:
I dont even see it in the services... I see "Server"...but I dont see SQL SERVER (MSSQL SERVER)...etc...
0
 
GlobaLevelProgrammerAuthor Commented:
heres a snap shot..dont even see it there....
sqlSERVICe.doc
0
 
Ady FootSharePoint ConsultantCommented:
Yeah you 100% definitely need to do a re-install my friend.  Sorry about that.

Ady
0
 
geek_vjCommented:
Which edition of SQL Server you are trying to install? Is it express/standard/enterprise 2005?
Hope the installation went successful till the end. Also, after the installation, have you rebooted the machine?
If not please reboot the machine and check for the services similar to 'SQL Server (MSSQLServer)'

If it is sql server 2005, go to Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Configuration Manager and check for the SQL Services there. If they are in stopped state, start them accordingly.

Please revert in case of any clarifications.
0
 
geek_vjCommented:
Please dont go for reinstallation right away. As mentioned, please proceed with the tasks and checks provided in the above post. Reinstallation is the final thing which we need to do, before which, lets try all other ways.
0
 
Ady FootSharePoint ConsultantCommented:
geek_vj - please clarify; if the services don't appear in services.msc (started or otherwise) a reboot will not help as won't searching for services in the SQL Server Configuration Manager.  Something's clearly gone wrong in the installation, in my opinion, and thus the installation should be attempted again.  

If you still think I'm wrong please could you explain further :-)
Regards,

Ady
0
 
geek_vjCommented:
Ady, as suggested by microsoft, rebooting the server is mandatory for any sql server installation or any service pack upgradation. Well, my suggestions are just an attempt to check if the process is being followed correctly. Also, I suspect that only the client components might have been installed on the server and the database services/any other services were not installed. So, as a DBA, we should check other things before we suggest to go for reinstallation.

Hope this clarifies.
0
 
Ady FootSharePoint ConsultantCommented:
"Also, I suspect that only the client components might have been installed on the server and the database services/any other services were not installed."

I share the same suspicions hence the decision to tell the author to reinstall.  Services not present = not properly installed, no matter how many times the server has or hasn't been restarted.  DBA or not I don't see how this will help - reinstallation is the only method to resolve this.

But thanks for the clarrification - hope you don't think I'm being purposely obtuse, just trying to clarify that I think I gave the correct guidance initially.

Regards,

Ady
0
 
Ady FootSharePoint ConsultantCommented:
Obtuse wasn't the correct word at all - facetious was the right word; it's been one of those good long days :-)
0
 
GlobaLevelProgrammerAuthor Commented:
I checked in the config manager:
If it is sql server 2005, go to Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Configuration Manager and check for the SQL Services there. If they are in stopped state, start them accordingly.

>>I did not find the services in there...all folders were empty...it listed 32 bit ..and I have 64, I think I downloaded the 32 bit version instead...
0
 
Ady FootSharePoint ConsultantCommented:
Hello again,

I'm not convinced you installed the database engine itself or, if you did select it, I don't think the installation ran properly.  I definitely think a re-install is required but first please make sure you remove this failed installation first using the Add/Remove programs wizard in Control Panel (remove all SQL references - if you need help please post back here with the available applications in the list presented).  

If you're running a 64-bit edition of Windows please ensure you're installing the 64-bit edition of SQL Server.  You might also like to try the latest 2008 version of SQL Server if you're using the Express edition and if it's compatible with any applications you wish to run on it.

Regards,

Ady
0
 
GlobaLevelProgrammerAuthor Commented:
Im using bizspark to download...do I need to install that on a disk or can I download straight to the server??
0
 
Ady FootSharePoint ConsultantCommented:
No - you will need to download the ISO file and then burn it to a disk.

Ady
0
 
cyberkiwiCommented:
Hi there,

As other experts have pointed out, you probably did not install SQL Server (engine) itself.
Since you are redoing it, might as well go to

http://www.microsoft.com/express/Database/  , click on x64 or x86 on the top right and follow the very brief instructions.  This is the minimal hassle install of 2008 R2 using mostly defaults and R2 supports up to 10GB per db. It is web installer that will even download for you.
0
 
DennisCACommented:
Do you see the SQL server service running. If you type service.msc from the Run... command line. If not then definitely the database service are not installed.

What happens if you try to log on to your instance with sqlcmd?

sqlcmd -S.\<Instancename> etc. ?
0
 
Ady FootSharePoint ConsultantCommented:
DennisCA - with respect please see the same question asked at http:#32055591 to which the author confirmed that the services don't exist.  Hence why we've told the author to do a re-install :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.