asked on

no server connection, you are not connected to a server

I get this error when starting sql server 2005 enterprise management studio

I am using windows server 2008.

this was working before, and then I restarted windows

the connect button is greyed out
I try
windows connection
sql server connection

guvera

Hi,

Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode
The server must be stopped and re-started before this will take effect..."

Hope it will helpful to you

Thanks
Guvera

rgb192

ASKER

i cant right click server name
because I can not connect to a server so there are no servers/databases listed
my problem is one step before that

Norman Maina

Go to services >START>RUN>services.msc

And then Start the SQL Server services

rgb192

ASKER

all sql server services
are started automatically and running
except for
sql server active directory helper

sql server is working because I am connecting through php
I can not connect through sql server mangement studio enterprise

Norman Maina

Is the management Studio you are trying to access local or in a network pc?

Norman Maina

you can check on:
1.Are the sql server protocols enabled?check on TCP/IP and Shared memory
2.Is your anti virus blocking ssms?
3.When you disconnect from accessing teh database using PHP -are you able to connect using ssms?

rgb192

ASKER

I am attempting to connect on ssmse using local pc
it was working before I did windows update and restart computer
I am attempting to connect using windows connection or sql server connection

anything I type in
the connect button is greyed out

Norman Maina

looks like windows update messed up your ssms.
try re-installing it.(un-install first)
Do not uninstall the database - just uninstall ssms.

If you are unconfortable doing that - try installing the latest service packs of your sql server version and see if it fixes the prblem for you.

rgb192

ASKER

how to uninstall/install just ssms

i am using sp3 is this the latest sevice pack

ASKER CERTIFIED SOLUTION

Norman Maina

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rgb192

ASKER

TITLE: Microsoft SQL Server Setup
------------------------------

None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108

------------------------------
BUTTONS:

OK
------------------------------

rgb192

ASKER

the un-install works