I just installed SQl Server 2005 on my Windows XP Pro system. But I can't figure out how to start the Database Engine. In the MS SQL Server Management Studio I see one Database Engine, but not SQL Servers. If I do "Update Local Server Registration" nothing happens. If I do right-click "New Server Registration" I get a databse icon with a white open circle. If I the try "right-click, Connect, Object Explorer" I get "An error has occurred while establishing a connection to the server...". All this time the right Summary pane is showing "No Server Connection."
The tutorials are no help and do not function as they describe.
Sample databases install but do not show up in program list as they are supposed to.
How do I start up my SQL Server Database Engine with a new database
Why do none of the tutorials show you what to do
Assistance would be greatly appreciated.
How Do I Start New SQL Server 2005 Database?
Morten_73
"Sample databases install but do not show up in program list as they are supposed to."
They will not be shown in the program list as they are only droped in the program folder, leaving it up to you to either attach them or execute the script which will populate the database.
"How do I start up my SQL Server Database Engine with a new database "
Is there a service installed, should be named something like SQLServer (MSSQLSERVER) Is it started successfully and running Then you should be able to connect to the instance. Is it a default one Then you have to put in the servername, if its a named instance you have to provide "Servername\InstanceName", if you are using another port than 1433 you also have to provide the port number "Servername\InstanceName,portnumber" or start the SQL Browser which will idenitfy the port on its own for the mentioned "Servername\InstanceName". If you can successfully connect you can either execute the scripts or right click on the server --> Attach database and select the appropiate MDF files in the program folder.
"How do I start up my SQL Server Database Engine with a new database "
If you want to create a ew database, you have to right click the server and select "New database"
If you have any issues left don't hesitate to come back.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
NicksterFL
No, the are no services listed that start with SQL... or MSSQL...
I don't see a New Database choice. How do I start a new database
How do I get the SQL services to run if they are not listed
Why doesn't the Documentation and Tutorial information show clearly how to start the SQL Server Database Engine
Martin McNally
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---
panagorafredrik
If there are no services shown up you don’t have the SQL Server 2005 (service) installed, you probably only installed the client tools. Which edition of SQL Server did you try to install, no all editions are applicable for Windows XP.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
maclessi
Try to install again and you might see.
VBnerd
I installed the Full SQL Server 2005 Enterprise Edition from the MSDN Universal CD. I told it to insall everything.
Stephen Hauck
My Control Panel Add/Remove Programs shows the following installed:
Microsoft SQL Server 2005
Microsoft SQL Server Backward Compatibility
Microsoft SQL Server 2005 Bokks Online
Microsoft SQL Server 2005 Native Client
Microsoft SQL Server 2005 Support Files (English)
What more do I need and how do I get it
Pete Loveall
I could not find a server to connect to when firing up "SQL Server Management Studio Express" from the Start->Programs menu.
I suspect this is because I downloaded the toolkit...
Microsoft SQL Server 2005 Express Edition Toolkit SP1 (more...)
Download (213 MB)
I think Microsoft really needs to make this more idiot proof! I spent ages firing up this "SQL Server Management Studio Express" with the IDE I was expecting only to discover there's no server installed.
Can we have some sort of warning when these components require dependencies which are not installed
PIEBALD
Why does the Enterprise Editition go through all of the installation actions and does not notify me that the Installation will not install the SQL Server Database Engine