Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jsdude99
Starting Member
8 Posts |
 Posted - 2006-12-08 : 17:29:17
|
| 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-09 : 17:10:37
|
| I'm confused. Did you install SQL Server Express or Developer Edition? I do not believe that developer edition comes with VS, I believe Express comes with VS. What services (check services applet in Admin Tools in Control Panel) do you have that start with MSSQL or SQL Server? Please list them all.Tara Kizer |
 |
|
|
pootle_flump
1064 Posts |
Posted - 2006-12-09 : 19:01:10
|
Tara - I am a regular reader but an occasional poster. Wonderful to see you back  SQLTeam is all the richer for it. |
|
|
|
jsdude99
Starting Member
8 Posts |
Posted - 2006-12-10 : 07:07:53
|
| I installed the DVD that come with VS2005 Pro. It reads when you place the DVD into the drive as "Developer Edition". I also though I would be getting the express edition.The services list is as follows:SQL Server (MSSQLSERVER)SQL Server (SQLEXPRESS)SQL Server Active Directory HelperSQL Server Agent (MSSQLSERVER)SQL Server Analysys Services (MSSQLSERVER)SQL Server BrowserSQL Server Full Text Search(MSSQLSERVER)SQL Server Integration ServicesSQL Server Reporting Services (MSSQLSERVER)SQL Server VSS WriterThere is no service that starts with MSSQL. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-10 : 13:37:16
|
| Developer Edition is just the version of Visual Studio that you installed. I believe you only have SQLEXPRESS version installed.Do you have the SQL client tools installed such as Management Studio? If so, try connecting to SQL Server using the following server names:YourHostnameYourHostname\SQLEXPRESS <-- I think this one will workYourHostname\MSSQLSERVERTo get the value of YourHostname, run hostname from a cmd window.Oh and by the way, SQL Express is SQL Server. It's just a trimmed down version of the full product.Tara Kizer |
|
|
|
jsdude99
Starting Member
8 Posts |
Posted - 2006-12-10 : 16:17:13
|
| I do not have Management Studio. I installed whatever is in the DVD that comes with the VS 2005 Pro.As I said before, I can see only SQLEXPRESS in the pick list in VS 2005 and nothing in "Microsoft SQL Server Migration Assistant for Access". When I check the services, I can see two servers and I can start or stop both of them ("SQL Server (MSSQLSERVER)", "SQL Server (SQLEXPRESS)"). Then I had the impression that I have for express and the std version installed. Why do I see two different servers with their unique default names?My immediate task is to convert an Access Database to SQL and for that reason, I installed "Microsoft SQL Server Migration Assistant for Access". If I have only express version on my computer, do I need a different migration assistant for SQL Express? |
|
|
|
jsdude99
Starting Member
8 Posts |
Posted - 2006-12-10 : 17:01:15
|
| Dear Tara,You are almost spot on! After I replied, I played around a bit with the conversion tool and managed to convert the Access to SQL after manually typing Hostname\SQLEXPRESS.One main question still confuses me is that why I have two SQL Servers with two different names?Also in the list I provided before, all of the services have (MSSQLSERVER) parts in their names. How do they work with Express version?Thanks for the help/reply.JS |
|
|
|
|
|
|
|
|
Cannot see server name in the pick list.