ms sql server 2005 not seen in server explorer - can't see any SQL Servers

[ray well]

i had just posted the following:
---------------------------------
i have ms sql server 2005 installed on my system (installed when i installed
2005) and it is running(i can see it is running as a service), but it does
not show up in server explorer. i never had a need to use it till now so i
never paid any attention to this till now.

how do i get it to show up so i can start using it?
----------------------------------

i then opened vs 2003, and lo and behold in the server explorer i CAN see
the ms sql 2005 server listed as SQLEXPRESS (i can also see the old vs 2003
msde server VSDOTNET).

in vs 2005's server explorer there isn't even SQL Servers NODE, and i can't
see either sql server.

i tried right clicking the server name and choosing refresh, and still no
SQL Servers NODE even comes up.


how can i get the SQL Servers node to activate so i can access the sql
server 2005

thanks

ray

 

[Gabriel Lozano-Morán]

Now that you mention it, I don't see it either in my Server Explorer. I will
try to figure out why in the meanwhile if you find out why it doesn't show
in the Server Explorer let me know.

Gabriel Lozano-Morán
The .NET Aficionado
http://www.pointerx.net

 

[Gabriel Lozano-Morán]

I have looked this up in the book Professional Visual Studio 2005, which I
can recommend by the way, and here is an excerption of page 508, chapter 38:

"Contrary to Microsoft's own current set of documentation, the Servers node
does not display a child node containing SQL Servers running on each server.
Instead you are forced to create a direct connection to the database and
server you need through the Data Connections node".

So apparently this node has been replaced by the Data Connections node.

Professional Visual Studio 2005:
http://www.amazon.com/Professional-..._bbs_sr_1/102-8342892-8045742?ie=UTF8&s=books

Cheers

Gabriel Lozano-Morán
The .NET Aficionado
http://www.pointerx.net

 

[ray well]

i tried using the data connections, i get an error telling me 'the default
server settings doesn't allow remote connections'. my server is running on
my own machine, so i don't understand why it is remote, also how do i set
the server to allow remote connections? is doesn't come with a management
package.

are u able to connect to a database on the sql server 2005?

ray

 

[Gabriel Lozano-Morán]

so i don't understand why it is remote, also how do i set

Neither do I, when run from the same machine it is a local connection.

also how do i set the server to allow remote connections?

Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools ->
SQL Server Surface Area Configuration

Then click on "Surface Area Configuration for Services and Connections".
Under the MSSQLSERVER -> Database Engine there is a "Remote Connections"
node where you can switch to local and remote connections.

Gabriel Lozano-Morán

 

[ray well]

i did the following, but i still get the same error. did it work for u?

ray

Then click on "Surface Area Configuration for Services and Connections".

Under the MSSQLSERVER -> Database Engine there is a "Remote Connections"
node where you can switch to local and remote connections.

 

[Gabriel Lozano-Morán]

Yep it works here with a local connection, i don't have to enable remote
connections. If you still get an error try to look in the event log for
related events.

Gabriel

 

[RobinS]

Try typing exactly the error message into MSDN search. I had the
exact same problem, and tried that, and much to my surprise, it
came up with an article that fixed my problem.

In my case, I think I needed to enable both Piped and Tcp/Ip
connections. To do that, I opened the SqlServer Surface Area
Configuration doohickey, and clicked on Remote Connections
under my database/DatabaseEngine. I selected "Local and
Remote Connections", and "Using both TCP/IP and named pipes".
And it magically fixed my problem. IIRC of course.
That was a while back.

Hope this helps.
Robin S.

 

[ray well]

in the following help location:

ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vdt01/html/fa400910-26c3-4df7-b9d1-115e688b4ea3.htm

help topic

Add/Modify Connection (Microsoft SQL Server)

Server name
Shows the name of the server for this connection. To choose a different
server, select one from the drop-down list or type the server name into the
text box.

Note
Local SQL Server Express instances are not listed in the listing of
available data sources.



perhaps that's why i can't see it. apparently yours is not set to
local, how would i do that?



i finally found that if i type in ".\SQLEXPRESS" as the server name,
then i get the tables in it.

all this is so sick, in vs 2003, u could see all that is in the sql
server, and drag the table u want directly into your form, and could get
going.

i still get errors for no reasons i know when i try to make a data
source from a table i see, it just tells u it can't do it, and doesn't tell
why



ray