Anyone please,

I installed SQL Server 2008 Developer Edition on my Vista machine. But I
have not been able to connect to the database server using Object Explorer
although I have no problem connecting to a db in query. This is frustrating
for I would want to be able to do things like create table and other chores
without writing queries. Thanks.

--
bic

bic (bic (AT) discussions (DOT) microsoft.com) writes:
So if you in a query window right-click and select "Open in Object
Explorer", what happens?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I can connect in the query, but I also want to connect in object explorer.
For it is much easier to create table and add columns in the manager than in
t-sql code. I get "Failed to retrieve data for this request" when trying to
connect to my local sql server. I went through and verified
client and server tcp enabled and port 1433.
services started include server, agent and browser
firewall exception tcp port 1433 added.
Please advise,

--
bic


"Erland Sommarskog" wrote:

bic (bic (AT) discussions (DOT) microsoft.com) writes:
I asked in my previous post, what happens if you are in a query window
and select "Open in Object Explorer?"

Is it then you get "Failed to retrieve data for this request"?

By the way, for creating tables, stay away from the Table Designer, it's
a piece of crap. Stick to T-SQL. That is a lot easier. Believe me.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I have the same problem so would love to hear if anyone has a solution.
Else roll back to SQL 2005 and use ALT F8 as I know that works

Paul D



bic wrote:

I can connect in the query, but I also want to connect in object explorer.
02-Mar-10

I can connect in the query, but I also want to connect in object explorer.
For it is much easier to create table and add columns in the manager than in
t-sql code. I get "Failed to retrieve data for this request" when trying to
connect to my local sql server. I went through and verified
client and server tcp enabled and port 1433.
services started include server, agent and browser
firewall exception tcp port 1433 added.
Please advise,

--
bic


"Erland Sommarskog" wrote:

Previous Posts In This Thread:

On Monday, March 01, 2010 12:56 PM
bic wrote:

How do I get Object Explorer to connect
Anyone please,

I installed SQL Server 2008 Developer Edition on my Vista machine. But I
have not been able to connect to the database server using Object Explorer
although I have no problem connecting to a db in query. This is frustrating
for I would want to be able to do things like create table and other chores
without writing queries. Thanks.

--
bic

On Tuesday, March 02, 2010 4:30 PM
bic wrote:

I can connect in the query, but I also want to connect in object explorer.
I can connect in the query, but I also want to connect in object explorer.
For it is much easier to create table and add columns in the manager than in
t-sql code. I get "Failed to retrieve data for this request" when trying to
connect to my local sql server. I went through and verified
client and server tcp enabled and port 1433.
services started include server, agent and browser
firewall exception tcp port 1433 added.
Please advise,

--
bic


"Erland Sommarskog" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorials...or-for-ne.aspx

Bic
I found a work around
Pass in the paramaters for the SQL connection in your Desktop shortcut -S server -U User - P password
In SQL Server Managemnent Studio do Tools >> Customize.

Select Query from the Categories list
Select Open Server in Object Explorer from the Commands list and drag that up onto any toolbar.

Now you can open the Object Explorer without having to log on.

If you are using SQL 2005 the ALT F8 still works

Paul




Paul D wrote:

Connect to Object Browser in SQL 2008
18-May-10

I have the same problem so would love to hear if anyone has a solution.
Else roll back to SQL 2005 and use ALT F8 as I know that works

Paul D

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Binding Beyond the Limitation of Name Scopes
http://www.eggheadcafe.com/tutorials...nd-the-li.aspx