not able to connect to sql 2005 on windows 7 !!!

Question

not able to connect to sql 2005 on windows 7 !!!

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
June 11, 2011 at 10:15 pm

#237721

i have installed sql 2005 + SP 4 32 bit dev edition on windows 7. Installation went smooth , however i am not able to connect. I keep getting an error login failed. In the sql error log i could system databases are being started but say cant connect with the login. I have checked all possible configuration and every thing looks to be right. Can someone pleaseeeeee help. Mentioned below is the error message
2011-06-11 22:43:13.00 Logon Error: 18456, Severity: 14, State: 11.
2011-06-11 22:43:13.00 Logon Login failed for user 'my-DESKTOP\username'. [CLIENT: <local machine>]
connections are set to tcp/ip and named pipes...

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

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

Did you set an sa password? Did you add your account as an admin during setup?

Also, you aren't necessarily running as administrator on the local machine. Shift right click the management studio entry and select "run as administrator". Once you connect, then add your regular user account as a login

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 2

Are you trying to connect on the physical server, or from a remote pc?

Did you try to connect using the IP,port or dnsname,port?

How about your Windows Firewall settings? Is Windows firewall on?

You may need to open the Inbound local port UDP 1434 for Management Studio.

Steve

Sailor SSCertifiable Points: 5246 More actions · Answer 3

I had same problem. Only solution seemed to be to install SSMS 2008.

http://www.sqlservercentral.com/Forums/Topic1120593-149-1.aspx

Lowell SSC Guru Points: 323518 More actions · Answer 4

on windows 7 machines, security is tighter...local users are not automatically added as SQL administrators unless you specifically add them;

easiest way,since you said SQL 2005, is to use the surface area configuration:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 5

Steve Jones - SSC Editor (6/12/2011)
Did you set an sa password? Did you add your account as an admin during setup?
Also, you aren't necessarily running as administrator on the local machine. Shift right click the management studio entry and select "run as administrator". Once you connect, then add your regular user account as a login

Thanks Steve . It works now, had to right click the management studio entry and select "run as administrator" 🙂

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 6

Yeah, Win7 is funny like that. Even when you're an admin, you're not always an admin 😉

Sailor SSCertifiable Points: 5246 More actions · Answer 7

I had tried both surface area config and run as administrator. The only thing I noticed was signing on one domain worked, while the other did not work. The guy has to sign on the domain that does not work, so they only solution according to the domain admin was to install SQL 2008.