SQL Help

I am installing SQL 2008 server for the first time under Win 7. The installation says it goes through just fine, but when I go to launch management studio, the login screen flashes and then disappears. It does not give me the option to select a database, etc. This is causing an issue with another program that needs to be installed that uses SQL. If anyone knows of a way to stop the screen, so I can actually log into the DB, I would appreciate it.

Find more posts tagged with

Save $250 on 2025 certification boot camps from Infosec!

Book now with code EOY2025

Button

Comments

RobertKaucher

Have you installed any service packs?

I get that the login prompt goes away, but are you then left with empty management studio? If so can you click Connect => Database Engine under Object Explorer?

blargoe

I've never seen this exact issue before... if I had to guess I'd say maybe either your .Net framework is jacked up, or your client security software is interfering

Bokeh

I can hit connect>database engine> and then I can see how to login. I deleted the credentials and created new ones. I can log into sql then.

However, when I go to try and install the program that runs on top of it I get the following error:

Sqlstate=08001, NativeError=17, Description = [DBNetLib] (Connect()). Server does not exist or access denied.

RobertKaucher

Have you configured the instance to allow access via TCP?

blargoe

Is it looking for the \INSTANCENAME after the hostname.. and that part is maybe being omitted in the application install?