Unable to connect to sql server 2005

Question

Post reply

Unable to connect to sql server 2005

KHI

Valued Member

Points: 68
More actions
October 29, 2007 at 5:03 am

#376542

Hi All
I Installed Sql server2005 with the latest service pack, I am ubable to connect ?
I have included the error message,if you have any suggestion ?, please help.
Thanks.

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

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

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

Before applying the patch, are you able to connect to the instance?

--Ramesh

KHI Valued Member Points: 68 More actions · Answer 2

Hi Ramesh

Thanks for the reply,Iet me explain to you whats the going on.

Last week 1 of my assistant dba deleted the built in admin group,so I was unable to login,

I did not have the sa account enabled.

so I decided to uninstall and re-install sql server2005 with the latest pack.

I thought this migth work with no luck.Or am I experincing network issues ?

Thanks

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 3

After installed, do the following way:

Start -> Program -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration

and also see the attached document file.

🙂

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 4

check this i think this might be helpful 2 u.

http://blogs.msdn.com/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx

http://www.developerfood.com/re-unable-to-connect-to-sql-express-db-without-using-user-instanc/microsoft-public-sqlserver-connect/52bc9b09-66e8-4088-8da0-d4efc317b201/article.aspx

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 5

KHI,

You need to allow remote connections to connect to the instance...

...just follow the steps that Kishor has suggested...

Last week 1 of my assistant dba deleted the built in admin group,so I was unable to login,
I did not have the sa account enabled

Even in this situation, you can still add new accounts/roles. All you've to do is to start your instance in single user mode by activating -m switch and then you can add logins/users through sqlcmd utility.

--Ramesh

KHI Valued Member Points: 68 More actions · Answer 6

KHI

Valued Member

Points: 68

October 29, 2007 at 5:53 am

#746195

Hi All

Thanks for all your help !!!