Wont Connect - 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 Programming

Wont Connect

Author

Topic

cnielsen4211
Starting Member

8 Posts

Posted - 2011-08-31 : 21:16:21

Hi,
I'm a new user to SQLserver, although I have used it before in other locations. I have just installed SQLServer on my XPPro PC and it appeared to install ok...

When I open the Server Management Studio it wont connect to the server on the same computer... I have turned off Apache to see if that was blocking it, but that didn't help.. The message I get is that the server is not accessable and to make sure that the server is configured for remote connections.. I looked up how to configure for remote connections and the required program SQL Server Surface Area Configuration is just not available in the menu...

can anyone help me get this server configured so that I can connect to it please??

Cnielsen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-31 : 22:51:13

Is the service started? Did you try with (local)\sqlexpress?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-08-31 : 23:05:01

What Edition of SQL Server are you installing ? You can only install Developer or Express edition on XP machine

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 01:04:08

quote:
Originally posted by khtan

What Edition of SQL Server are you installing ? You can only install Developer or Express edition on XP machine

KH
[spoiler]Time is always against us[/spoiler]

I have grean indicators in Server configuration manager and it shows as Sqlserver (Express)

Cnielsen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-01 : 02:21:31

as Tara advice, please check that the SQL Server services is started

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 02:53:56

quote:
Originally posted by khtan

as Tara advice, please check that the SQL Server services is started

KH
[spoiler]Time is always against us[/spoiler]

It would appear that that may be the problem.. i don't sem to have anything refering to "services" I checked the web and there's a suggestion that these ar installed seperately.. which seems odd because I just installed the SQL server install package and the management tools package.. Surely that would include eveything to get a basic system running, wouldn't it?

Cnielsen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-01 : 03:02:56

Go to Administrative Tools - Services. Look for SQL Server. Make sure it is started

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 03:06:56

quote:
Originally posted by khtan

as Tara advice, please check that the SQL Server services is started

KH
[spoiler]Time is always against us[/spoiler]

Another clue here is that I don't actually have a database as yet.. Just a bare install.. perhaps it's a chicken and egg problem... I don't have a database therefore it wont start to let me createa database ???

Cnielsen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-01 : 03:13:43

that is not an issue. If the installation and fine, you should be able to connect to it.

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 03:21:17

quote:
Originally posted by khtan

that is not an issue. If the installation and fine, you should be able to connect to it.

KH
[spoiler]Time is always against us[/spoiler]

I simply downloaded the files and installed them.. taking the defaults.. there were no errors.. I've stopped Apache, stopped my virus checker, stopped skype... what else could block it??

Cnielsen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-01 : 04:14:39

is the SQL Server services started ?

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 04:24:05

quote:
Originally posted by khtan

is the SQL Server services started ?

KH
[spoiler]Time is always against us[/spoiler]

I really don't know... I don't know how to check... Surely there must be some sort of diagnostic to tell where the problem is...

Cnielsen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-01 : 06:15:39

quote:
Originally posted by cnielsen4211

quote:
Originally posted by khtan

is the SQL Server services started ?

KH
[spoiler]Time is always against us[/spoiler]

I really don't know... I don't know how to check... Surely there must be some sort of diagnostic to tell where the problem is...

Cnielsen

quote:
Originally posted by khtan

Go to Administrative Tools - Services. Look for SQL Server. Make sure it is started

KH
[spoiler]Time is always against us[/spoiler]

KH
[spoiler]Time is always against us[/spoiler]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 07:37:51

quote:
Originally posted by khtan

quote:
Originally posted by cnielsen4211

quote:
Originally posted by khtan

is the SQL Server services started ?

KH
[spoiler]Time is always against us[/spoiler]

I really don't know... I don't know how to check... Surely there must be some sort of diagnostic to tell where the problem is...

Cnielsen

quote:
Originally posted by khtan

Go to Administrative Tools - Services. Look for SQL Server. Make sure it is started

KH
[spoiler]Time is always against us[/spoiler]

KH
[spoiler]Time is always against us[/spoiler]

Ok.. I think I'm starting to see whats wrong.. I haven't got all of the programs.

I downloaded
1) SQLServer2005_SSMSEE.msi and
2) SQLEXPRWT_x86_ENU.exe

After installing these two I have a number of programs but nothing that says "Administration Tools"

I've got MS SQLServer 2005 and some sub menus
MS SQLServer 2008 and sub menus
MS Sqlserver 2008 R2 and sub menus

But no Administration side at all..

There must me more I have to download and install

This is all a bit confusing, while I have worked in a SQLServer environment before I've never set one up from scratch before.. So I'm not sure what I'm supposed to have.

I do appreciate your help.. I'm sure that once I get it running, I'll build my small database and be off and away...

Cnielsen

alexylee
Starting Member

14 Posts

Posted - 2011-09-01 : 13:55:49

Here is what you have:

1) SQLServer2005_SSMSEE.msi : SQL 2005 EXPRESS Tool
2) SQLEXPRWT_x86_ENU.exe : SQL 2008 (or 2008 R2) Engine + Tool

Since your SQL Config Manager shows green light on SQLEXPRESS, you already have SQLEXPRESS running on your machine.

Please use SQL 2008/R2 Tool instead of SQL 2005 tool to connect to your SQL Server (connect to .\SQLEXPRESS)

Thanks,
Alex
[url]http://sqlbeyond.blogspot.com[/url]

cnielsen4211
Starting Member

8 Posts

Posted - 2011-09-01 : 21:20:37

quote:
Originally posted by alexylee

Here is what you have:

1) SQLServer2005_SSMSEE.msi : SQL 2005 EXPRESS Tool
2) SQLEXPRWT_x86_ENU.exe : SQL 2008 (or 2008 R2) Engine + Tool

Since your SQL Config Manager shows green light on SQLEXPRESS, you already have SQLEXPRESS running on your machine.

Please use SQL 2008/R2 Tool instead of SQL 2005 tool to connect to your SQL Server (connect to .\SQLEXPRESS)

Thanks,
Alex
[url]http://sqlbeyond.blogspot.com[/url]

I have SQL Server 2008 R2 and in that menu there is

Configuration Tools,Import and Export data, Intergration services, SQL Server Management Studio.

If I start SQL Server Management Studio it can't connect.. I get erro 40 - Could not open a connection to SQL Server (MS Sql server error 2)

I'm using Dbeaver as a database management tool and that can't connect either..

Net Start shows SQL Server (SQLExpress), SQL Server Browser, SQL Server VSS writer all runner... Also MySQL is running as well would that block the connection?

This is the report from NET Start

These Windows services are started:

##Id_String1.6844F930_1628_4223_B5CC_5BB94B879762##
.NET Runtime Optimization Service v4.0.20506_X86
Application Layer Gateway Service
Asset Management Daemon
Automatic Updates
Background Intelligent Transfer Service
COM+ Event System
Computer Browser
Cryptographic Services
DCOM Server Process Launcher
DHCP Client
Distributed Link Tracking Client
DNS Client
Error Reporting Service
Event Log
Fast User Switching Compatibility
FLEXnet Licensing Service
Help and Support
InCD Helper
IPSEC Services
Java Quick Starter
Logical Disk Manager
Machine Debug Manager
MBAMService
MySQL
Nero Registry InCD Service
Network Connections
Network Location Awareness (NLA)
NVIDIA Display Driver Service
Plug and Play
Pml Driver HPZ12
Portrait Displays Display Tune Service
Print Spooler
Protected Storage
Remote Access Connection Manager
Remote Procedure Call (RPC)
Secondary Logon
Security Accounts Manager
Security Center
Server
Shell Hardware Detection
SQL Server (SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer
SSDP Discovery Service
System Event Notification
System Restore Service
Task Scheduler
TCP/IP NetBIOS Helper
Telephony
Terminal Services
Themes
WebClient
Windows Audio
Windows Firewall/Internet Connection Sharing (ICS)
Windows Image Acquisition (WIA)
Windows Management Instrumentation
Windows Time
Windows User Mode Driver Framework
Wireless Zero Configuration
Workstation

The command completed successfully.

Cnielsen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources