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 |
|
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 and2) SQLEXPRWT_x86_ENU.exeAfter installing these two I have a number of programs but nothing that says "Administration Tools" I've got MS SQLServer 2005 and some sub menusMS SQLServer 2008 and sub menusMS Sqlserver 2008 R2 and sub menusBut no Administration side at all..There must me more I have to download and installThis 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 Tool2) SQLEXPRWT_x86_ENU.exe : SQL 2008 (or 2008 R2) Engine + ToolSince 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 Tool2) SQLEXPRWT_x86_ENU.exe : SQL 2008 (or 2008 R2) Engine + ToolSince 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 StartThese 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 WorkstationThe command completed successfully. Cnielsen |
|
|
|