Cannot Connect to SQL SRV1\ACT7 in EM or Query

Question

Cannot Connect to SQL SRV1\ACT7 in EM or Query

William DeLaney

SSC Enthusiast

Points: 171
More actions
April 26, 2006 at 6:24 pm

#93965

Hello,
I am a newbie to SQL (just want to get that out there first). I have been given the responsibility of the upkeep of a small business server. The Admin that was here is now gone and with him went who knows what.
The server is running SQL:
SRV01\ACT7 (Windows NT)
SRV01\WEBAPP (Windows NT)
When I try to connect to the ACT7 in EM I get the following error:
A connection could not be established to SRV01/ACT7
Reason: Login Failed for user xxxx\administrator.
Please verify SQL Server is running and check your SQL Server registration properties.
I only get the message when I try to connect to the SRV01\ACT7. The connection to SRV01\WEBAPP works fine.
I checked with SQL server manager and both services are running and no one has reported any problems connecting to either one of them.
The way it acts, its as if SQL server has lost the ability to authorize a connection via the windows account. As if it has lost its associatoin to the administrator account. So while the service still runs and is functional, I just can't connect to it and manage it.
I have connected via remote desktop from a WinXP machine with admin account and at the server console. Both end up with the same error.
I have tried to connect using Windows logon and SQL logon both with no luck.
I need to be able to manage this database, Can Someone give me step by step instructions on how to correct this?
Any help please!!!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

By default, members of the local administrators group for the server get admin access to SQL Server through the SQL Server "login" called "BUILTIN\Administrators". Does this login exist on the instance called srv1\act7 ?

If it does, check that the account you are using is a member of the the windows group called "Administrators" on the server.

William DeLaney SSC Enthusiast Points: 171 More actions · Answer 2

I don't want to sound stupid, but How do I verify if the builtin\Admin exist on the instance when I cant connect with EM or Query and windows logon or SQL logon.

Any help is apperciated.

happycat59 One Orange Chip Points: 29389 More actions · Answer 3

Can you login to the server as a local administrator (not a domain administrator) ?

Do you know the password for the sa login ?

William DeLaney SSC Enthusiast Points: 171 More actions · Answer 4

Yes I can log into the server as a local administrator. and no I do not know the sa password, I wish i did.

I'm sure the guy before me does but he is gone and not comming back.

happycat59 One Orange Chip Points: 29389 More actions · Answer 5

Have you tried to connect to this instance using the local administrator account ?

And, have you tried using the old DBA's windows account ?

Jim Dillon-291542 Hall of Fame Points: 3344 More actions · Answer 6

I'd suggets physically going to the SQL server box and setting yourself up an administrator account for the SQL Server. Next, find out what the password is for sa. If you are to manage this SQL server instance you will need to be able to login with an account that has administrative permissions.

Good Luck,

jim

Abbie Mashaal SSC Rookie Points: 45 More actions · Answer 7

You need to contact Sage Software (curreny makers of Act!) and request the sa password from them.

-am