Petri IT Knowledgebase Forums
 

Petri.co.il forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Databases > Database Basics
Petri.co.il is happy to award auglan the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read

Notices

Cannot Connect to SQL Express 2008 DB

Cannot Connect to SQL Express 2008 DB

this thread has 0 replies and has been viewed 1289 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 25th May 2012, 12:58
jim72 jim72 is offline
Casual
Casual
 
 Join Date: Aug 2007
  6 month star 12 month star
 Posts: 45
 Reputation: jim72 is on a distinguished road (10)
Default Cannot Connect to SQL Express 2008 DB

Hi all,

I am a bit of a DB novice but I have created a new Database on a SQL Express 2008 and when trying to connect to it from SQL Server Mgmt Studio from another machine I can browse the name of the PC it is on but not the name of the instance. I have a number of other SQL DB's dotted around where I do not have this issue.

Using SQL Server Mgmt Studio locally I can see the name and the instance.

I have done the following yet still having no joy:-

1. Started the SQL Server Browser
2. Ensured the Shared Memory and TCP/IP Network Configs are enabled under Protocols for SQLEXPRESS
3. Ensured the Shared Memory, TCP/IP and Named Pipes are enabled under Native Client Protocols
4. Turned off the Firewall
5. Disabled AV
6. Ensured 'Allow Remote Connections to this Server' is ticked.

Any other ideas?

Thanks

Jim
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run SQL2000 DB on Express 2008 swkent SQL Server 2008 / R2 1 3rd February 2012 13:39
how to connect Server 2003 R2 to SBS 2008 with http://connect? carboncow SBS 2008 / 2011 5 14th November 2010 13:05
Win 2008 and Sql Express kevinguerreiro Misc 23 22nd June 2009 03:20
Search Server 2008 Express ballysingh Windows Server 2000 / 2003 1 5th June 2009 14:53
Configure Outlook and Outlook Express to Connect to Exchange senthilkumaar2020 Exchange 2000 / 2003 2 12th March 2009 17:58


All times are GMT +3. The time now is 23:52.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri