How to start SQL server - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

How to start SQL server

Author

Topic

satimis
Starting Member

6 Posts

Posted - 2010-07-03 : 01:12:05

Hi folks,

Win Server 2008 64 bit
SQL Server 2008 64 bit

This is a newly installed SQL Server. During installation I haven't created Server name resulting in unable to start it after installation completed.

Start -> MS SQL Server 2008 R2 -> SQL Server Management Studio

Connect so Server
SQL Server 2008 R2

Server type: Database Engine
Server name: ?
Authentication: SQL Server Authentication
Login: Administrator
Password: ******

Please advise how to add the Server name to start SQL Server? TIA

B.R.
satimis

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-03 : 03:33:12

Did you install the database engine or just the management tools? If you installed the DB engine and didn't make it a named instance, the name of the SQL Server will be the name of the machine that its installed on.

--
Gail Shaw
SQL Server MVP

satimis
Starting Member

6 Posts

Posted - 2010-07-03 : 10:38:37

quote:
Originally posted by GilaMonster

Did you install the database engine or just the management tools? If you installed the DB engine and didn't make it a named instance, the name of the SQL Server will be the name of the machine that its installed on.

Hi Gail,

Thanks for your advice.

This is my first installation on SQL Server.
(Version 2008)

I followed;
How to Install SQL Server 2008 - A Step by Step Guide - Part 1 and Part 2
http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

to proceed.

Instance ID = MSSQLSERVER
Login = Administrator

Cannot connect to SQL Server


Additional information:

A network-related or instance-specific error occurred while 
establishting a connection to SQL Server.  The server was not found 
or was not accessible.  Verify that the instace name is correct and
that SQL Server is configured to allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL 
Server)(Microsoft SQL Server, Error: 67)

Performed following steps;

On "Sql Server Configuration Manager"
-> Expand "SQL Server Network Configuration
-> Protocols for MSSQLSERVER

Named Pipes Change Disable -> Enable

Restart SQL Server
On Command Prompt
>net stop MSSQLSERVER
(SQL Server Agent <MSSQLSERVER> stop)

>net start MSSQLSERVER

On "Sql Server Configuration Manager"
-> SQL Server Server

SQL Server (MSSQLSERVER) Running
SQL Server Browser Running
SQL Server Agent (MSSQLSERVER) - stop Running

Restart "SQL Server Agent"

Still unable to connect to server, same warning.

Edit:
====

Finally I made "SQL Server Management Studio" to work with following steps;

Start -> SQL Server Management Studio

Connect to Server
Server type: Database Engine
Server Name: WIN-V24Q6F10HCL
Athentication: Window Authentication
(remark: I can't select "SQL Server Authentication" here)

User name: WIN-V24Q6F10HCL\Administrator (Greyout)
Password: blank (also greyout)

-> Connect

"Microsoft SQL Server Management Studio" starts

Connect -> SQL Server Agent
Jobs
Job Activity Monitor

But I can't find "New Query" there. Any advice? TIA

B.R.
satimis

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources