SQL Server 2008 Management Studio on a Vista Desktop

Question

I haved installed SQL Server 2008 Management Studio on a Vista(64 bit) desktop for learning purposes.  When I start Mgmt Studio and try to connect I get a "(Could not open connection to SQL Server - Microsoft SQL Server, Error:2)" message. 

While instaling the Managment Studio I was not asked to set up a SQL Admiin Usr Id and Password.  Windows just 'breezed' thru till the end and displayed a completed sucessfully message.  I found out that I needed to start SQL Server Services, but coudl not find this on the system anywhere.  Was something missing in the installattion process?  Or how do I resolve this issue.  Any assistance would be greatly appreciated.

Thanks.

Man Amart

Answer 1

Very common issue in sql server 2005... Check if Pinal's blog entry helps
http://blog.sqlauthority.com/2008/08/09/sql-server-fix-error-1326-cannot-connect-to-database-server-error-40-could-not-open-a-connection-to-sql-server/

also check this
http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx


Madhu

---

MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/

Answer 2

Hello Madhu

Thanks for the posting, however, this did not resolve the issue.  Please keep in mind that I am running SQL Server 2008, and on Vista.  Also, as mentioned in my original posting, the SQL Management Install did not request for me to enter an Administrator Id and Password.  I therefore have two questions.

1)  Is this a normal trend for SQL 2008 - no Admin Usr Id and no Password?  Vista checked for the required components on the computer and confirmed it was OK to just install, so I went ahead and did it.

I have an XP Laptop running SQL 2005 and I see SQLSERVER running under Task Manager -->Processes but the Vista machine running SQL 2008 does not have an entry for SQLSERVER under Task Manager -->Processes.

2)  Is it OK to install using just the SQL 200 Server Management Studio, or I was supposed to install SQL Server 2008 or SQL Server 2008 Express before installing the Management Studio?

Many thanks in advance.

Man

 

 

Answer 3

Which edition of SQL 2008 you have installed on which edition of vista?
Have you checked whether SQL 2008 services exists under SQL configuration manager? If it's there then make sure the service is started and running fine.

---

Vidhya Sagar. Mark as Answer if it helps!

Answer 4

You said you installed SQL Server 2008 Management Studio. So you just installed client tools only? Have you installed DB engine together in your installation?

Answer 5

I guess that was not installed.  When I clicked the setup on Management Studio, it just went through to the end and indicated that the installation ended successfully.  Also as indicated earlier I do not see the SQL Services listed in the list of services so I will have to redo it.

I will download and install SQL Server Express and see how it goes. 

Thanks and regards.

Man
 

Answer 6

Hi Titi,

What's going on about the problem? Any questions, please feel free to let us know.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 7

Hello All

Sorry for the delay in getting back.  I was away for a few days.

I am still facing the issue with the connection.  I have installed the Database engine and it is running.

If there is a way to send you screen shots please let me know and I wll do so.

Thanks and regards.

Man

Answer 8

Hi,

You can upload these screen shots on Flickr(http://www.flickr.com/), and share us the links.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 9

Hello

I had some issues doing the Flickr posting.

I think this shuold work now - http://www.flickr.com/photos/13554293@N02/sets/72157622733823282/

There are two pictures.  The first is the error message and the second is a shot of the Services screen under Administrative Tools and MSConfig.  Please let me know if you need something else.

Please let me know if you need something else.

Thanks and regards.

Man

Answer 10

Hi,

Thanks for your effort. From the second image, SQL Express is a named instance (SQLEXPRESS), so the Server Name should be FADMA\SQLEXPRESS, try that in the Connect to Server dialogue, it should be succeeded.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 11

Thanks a lot ChunSong and everybody else.

This resolved the issue.  I look forward to trying things out now and I will keep you all posted if I run into any issues.

Thanks and regards.

Man

BTW. - When I clicked on the button to vote the n umber 1 automatically populated the field.