Cannot see server name in the pick list.

Question

Post reply

Cannot see server name in the pick list.

John Smith-388527

SSC Journeyman

Points: 93
More actions
December 8, 2006 at 2:50 pm

#171217

I have installed the MS SQL Server (Developer Edition) that comes with Visual Studuo 2005 Professional Edition into my computer. Seems like install is OK and I can see both SQLEXPRESS and MSSQLSERVER in configuration manager. I can start/stop both of the servers OK. However, when I try to make a connection from Visual Studuo 2005, I can only see SQLEXPRESS in the pick list in "Add Connection" window. SQLSERVER is not in the list.
The very first task I wanted to do is to convert and Access database to SQL. For that reason, I also installed "Microsoft SQL Server Migration Assistant for Access". In that application I cannot even see any server name when the wizard asks which server to choose. I also tried to start/stop "Sql Server Browser" service. When I stop the service, the pick list becomes empty and when I start the service the pick list has only SQLEXPRESS.
So, how can I see or pick MSSQLSERVER to make a connection in either applications? Please note I am VERY NEW to SQL Server and I appreciate your answers with that consideration.
Thans in advance

Viewing 4 posts - 1 through 3 (of 3 total)

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

DiMac SSC Veteran Points: 215 More actions · Answer 1

Can you paste the servername into the "Add connection" window. I would try that.

If the services are off you won't see the Server Name in the pick list.

Cheers,

Diane

John Smith-388527 SSC Journeyman Points: 93 More actions · Answer 2

I already tried that and did not work. I also tried the following:

MSSQLSERVER service | SQLEXPRESS Service | Picklist shows

not running

John Smith-388527 SSC Journeyman Points: 93 More actions · Answer 3

Please disregard the above message the editor posted the message before I finalised the reply.

I tried pasting the name and it did not work. The list get populated if you run the "SQL Server Browser" service. Otherwise it is empty. It does not matter if you run the SQL Servers or not.