|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ms sql server 2005 not seen in server explorer - can't see any SQL Servers--------------------------------- 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 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 Show quote "ray well" <nospam@nospam.com> wrote in message news:e$YHkVgHHHA.1188@TK2MSFTNGP06.phx.gbl... >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 > > > > > 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-Visual-Studio-Andrew-Parsons/dp/0764598465/sr=1-1/qid=1165941714/ref=pd_bbs_sr_1/102-8342892-8045742?ie=UTF8&s=books Cheers Gabriel Lozano-Morán The .NET Aficionado http://www.pointerx.net Show quote "ray well" <nospam@nospam.com> wrote in message news:e$YHkVgHHHA.1188@TK2MSFTNGP06.phx.gbl... >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 > > > > > 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 > 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 Show quote "ray well" <nospam@nospam.com> wrote in message news:ukBe3chHHHA.1064@TK2MSFTNGP04.phx.gbl... >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 > > 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. 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 Show quote "ray well" <nospam@nospam.com> wrote in message news:%23BT1DijHHHA.4056@TK2MSFTNGP03.phx.gbl... >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. > > 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 [attached file: note.gif] 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. -------------------------- Show quote "ray well" <nospam@nospam.com> wrote in message news:ukBe3chHHHA.1064@TK2MSFTNGP04.phx.gbl... >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 > >  |
|||||||||||||||||||||||
Other interesting topics