ACCESS SQL SERVER TO USE NORTHWIND DB (continuation)

I went to Start>programs>sqlserver2005>configuration tools>surface area configuration.

Next, I selected local and remote connections.Further, under this selection there is:

Using TCP/IP only (SELECTED)

Using named pipes only; and

Using both TCP/IP and named pipes.

Again, I received a message saying SQL server does not allow remote connection.

Any suggestions?

Thanks!!

I would make sure that you have followed all of the instructions in the following kb http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

Thanks for the link on how to configure the SQL server to allow remote connections!

In step 3 for creating exceptions in Windows Firewall, the Instance ID is located and is showing as MSSQL.1.Even though MSSQL.1 is showing in the Instance ID, it is not active, meaning the text is lightly showing, not boldly showing.Should the text for MSSQL.1 be active?

ACCESS SQL SERVER TO USE NORTHWIND DB (continuation)

I went to Start>programs>sqlserver2005>configuration tools>surface area configuration.

Next, I selected local and remote connections.Further, under this selection there is:

Using TCP/IP only (SELECTED)

Using named pipes only; and

Using both TCP/IP and named pipes.

Again, I received a message saying SQL server does not allow remote connection.

Any suggestions?

Thanks!!

I would make sure that you have followed all of the instructions in the following kb http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

Thanks for the link on how to configure the SQL server to allow remote connections!

In step 3 for creating exceptions in Windows Firewall, the Instance ID is located and is showing as MSSQL.1.Even though MSSQL.1 is showing in the Instance ID, it is not active, meaning the text is lightly showing, not boldly showing.Should the text for MSSQL.1 be active?

Access rights for surface configuration and managing sql services

If I need access rights to manage sql services(surface area config) in a
cluster server.
What kind rughts do I need? local admin?
Thanks
A SQL cluster and a regular SQL install require the same permissions and act
alike
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uNPSKbBtHHA.508@.TK2MSFTNGP02.phx.gbl...
> If I need access rights to manage sql services(surface area config) in a
> cluster server.
> What kind rughts do I need? local admin?
> Thanks
>

Access otehr sql server ina domain w/ Query Analyzer

Hi everybody,

I do not know if this is the correct area to post this topic? So, How to access
different sql server with query analyzer? Usually, when to install sql server, it
access the database server locally installed, now I like to access other sql server
within a domain using query analyzer. How to configure this in order I could use
query analyzer to access other sql server within a domain? Thanks in advanced.

den2005

Simply choose Connect from the menu and connect to a different server. If you want to you another server in your query you can setup a linked server whereas you can query across different servers in one query.

HTH, jens Suessmeyer.