Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0

|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks
|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent
sql

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can''t see named sets in Excel 2007

Hi there,

I am not able to see the named sets in the PivotTable Field List in Excel 2007. I created e.g. the simple named set

CREATE SET CURRENTCUBE.[Austria]
AS [CUSTOMER].[COUNTRY].&[Austria] ;

Then I changed the display folder to 'Special Countries' in the mask 'Calculation properties' without selecting an 'Associated Measure Group'. After building the cube I can even see that display folder in the left-side tree of the 'Browse' window.
But after connecting to the cube with Excel 2007 the named set is not available for selection.

It seems that I am missing an important point.

Best wishes from Austria,

nedvin

I'm using Excel 2007 against the Adventure Works DW database and the Adventure Works cube. In the Account dimension, I see the [Summary P&L] named set. It has a Display folder of Sets and an Associated Measure Group of Financial Reporting.

You may want to compare what you have to what is in Adventure Works.

B.

|||Hi Bryan,

it took some time to install the Adventure Works Cube (actually I have completely reinstalled my pc), sorry for the late reply.
But even with your example I am unable to find the named set in the PivotTable Field List in Excel 2007. There is simply no folder 'Sets' containing the named set [Summary P&L].
I do see the [Summary P&L] in the cube (in the specified folder) and it is well defined under the mask 'Calculation properties', but in Excel 2007 it is not listed.

Kind regards,

nedvin
|||

I can see [Summary P&L] under the Account dimension. I use the enterprise edition version of the Adventure Works cube project. Make sure that you see the whole cube and not only a perspective("Show related fields to" at the top of the dimension tool)

HTH

Thomas Ivarsson

|||
Hi Thomas,

thank you for your reply.
I am using the Aventure Works cube project entreprise edition as well.In Excel 2007 the dropdown list 'Show fields related to' is set to the property 'All', so I think that I am not restricted to a perspective.
I can browse the cube in the SQL Server Management Studio(as well as in the BI Development Studio) and see the named sets as defined, but with Excel 2007 the named sets are not listed (neither the [Summary P&L] under the Account dimension nor the folder 'Sets' with 'Core Product Group', 'Long Lead Products',.... under the Product dimension).
By the way, I have Excel 2007 (12.0.6024.5000) MSO(12.0.6017.5000). Maybe I have a different version of Excel 2007?

Kind regards,
nedvin

Can''t see named sets in Excel 2007

Hi there,

I am not able to see the named sets in the PivotTable Field List in Excel 2007. I created e.g. the simple named set

CREATE SET CURRENTCUBE.[Austria]
AS [CUSTOMER].[COUNTRY].&[Austria] ;

Then I changed the display folder to 'Special Countries' in the mask 'Calculation properties' without selecting an 'Associated Measure Group'. After building the cube I can even see that display folder in the left-side tree of the 'Browse' window.
But after connecting to the cube with Excel 2007 the named set is not available for selection.

It seems that I am missing an important point.

Best wishes from Austria,

nedvin

I'm using Excel 2007 against the Adventure Works DW database and the Adventure Works cube. In the Account dimension, I see the [Summary P&L] named set. It has a Display folder of Sets and an Associated Measure Group of Financial Reporting.

You may want to compare what you have to what is in Adventure Works.

B.

|||Hi Bryan,

it took some time to install the Adventure Works Cube (actually I have completely reinstalled my pc), sorry for the late reply.
But even with your example I am unable to find the named set in the PivotTable Field List in Excel 2007. There is simply no folder 'Sets' containing the named set [Summary P&L].
I do see the [Summary P&L] in the cube (in the specified folder) and it is well defined under the mask 'Calculation properties', but in Excel 2007 it is not listed.

Kind regards,

nedvin
|||

I can see [Summary P&L] under the Account dimension. I use the enterprise edition version of the Adventure Works cube project. Make sure that you see the whole cube and not only a perspective("Show related fields to" at the top of the dimension tool)

HTH

Thomas Ivarsson

|||
Hi Thomas,

thank you for your reply.
I am using the Aventure Works cube project entreprise edition as well.In Excel 2007 the dropdown list 'Show fields related to' is set to the property 'All', so I think that I am not restricted to a perspective.
I can browse the cube in the SQL Server Management Studio(as well as in the BI Development Studio) and see the named sets as defined, but with Excel 2007 the named sets are not listed (neither the [Summary P&L] under the Account dimension nor the folder 'Sets' with 'Core Product Group', 'Long Lead Products',.... under the Product dimension).
By the way, I have Excel 2007 (12.0.6024.5000) MSO(12.0.6017.5000). Maybe I have a different version of Excel 2007?

Kind regards,
nedvin

Can''t see named sets in Excel 2007

Hi there,

I am not able to see the named sets in the PivotTable Field List in Excel 2007. I created e.g. the simple named set

CREATE SET CURRENTCUBE.[Austria]
AS [CUSTOMER].[COUNTRY].&[Austria] ;

Then I changed the display folder to 'Special Countries' in the mask 'Calculation properties' without selecting an 'Associated Measure Group'. After building the cube I can even see that display folder in the left-side tree of the 'Browse' window.
But after connecting to the cube with Excel 2007 the named set is not available for selection.

It seems that I am missing an important point.

Best wishes from Austria,

nedvin

I'm using Excel 2007 against the Adventure Works DW database and the Adventure Works cube. In the Account dimension, I see the [Summary P&L] named set. It has a Display folder of Sets and an Associated Measure Group of Financial Reporting.

You may want to compare what you have to what is in Adventure Works.

B.

|||Hi Bryan,

it took some time to install the Adventure Works Cube (actually I have completely reinstalled my pc), sorry for the late reply.
But even with your example I am unable to find the named set in the PivotTable Field List in Excel 2007. There is simply no folder 'Sets' containing the named set [Summary P&L].
I do see the [Summary P&L] in the cube (in the specified folder) and it is well defined under the mask 'Calculation properties', but in Excel 2007 it is not listed.

Kind regards,

nedvin
|||

I can see [Summary P&L] under the Account dimension. I use the enterprise edition version of the Adventure Works cube project. Make sure that you see the whole cube and not only a perspective("Show related fields to" at the top of the dimension tool)

HTH

Thomas Ivarsson

|||
Hi Thomas,

thank you for your reply.
I am using the Aventure Works cube project entreprise edition as well.In Excel 2007 the dropdown list 'Show fields related to' is set to the property 'All', so I think that I am not restricted to a perspective.
I can browse the cube in the SQL Server Management Studio(as well as in the BI Development Studio) and see the named sets as defined, but with Excel 2007 the named sets are not listed (neither the [Summary P&L] under the Account dimension nor the folder 'Sets' with 'Core Product Group', 'Long Lead Products',.... under the Product dimension).
By the way, I have Excel 2007 (12.0.6024.5000) MSO(12.0.6017.5000). Maybe I have a different version of Excel 2007?

Kind regards,
nedvin
sql

Can''t see named sets in Excel 2007

Hi there,

I am not able to see the named sets in the PivotTable Field List in Excel 2007. I created e.g. the simple named set

CREATE SET CURRENTCUBE.[Austria]
AS [CUSTOMER].[COUNTRY].&[Austria] ;

Then I changed the display folder to 'Special Countries' in the mask 'Calculation properties' without selecting an 'Associated Measure Group'. After building the cube I can even see that display folder in the left-side tree of the 'Browse' window.
But after connecting to the cube with Excel 2007 the named set is not available for selection.

It seems that I am missing an important point.

Best wishes from Austria,

nedvin

I'm using Excel 2007 against the Adventure Works DW database and the Adventure Works cube. In the Account dimension, I see the [Summary P&L] named set. It has a Display folder of Sets and an Associated Measure Group of Financial Reporting.

You may want to compare what you have to what is in Adventure Works.

B.

|||Hi Bryan,

it took some time to install the Adventure Works Cube (actually I have completely reinstalled my pc), sorry for the late reply.
But even with your example I am unable to find the named set in the PivotTable Field List in Excel 2007. There is simply no folder 'Sets' containing the named set [Summary P&L].
I do see the [Summary P&L] in the cube (in the specified folder) and it is well defined under the mask 'Calculation properties', but in Excel 2007 it is not listed.

Kind regards,

nedvin
|||

I can see [Summary P&L] under the Account dimension. I use the enterprise edition version of the Adventure Works cube project. Make sure that you see the whole cube and not only a perspective("Show related fields to" at the top of the dimension tool)

HTH

Thomas Ivarsson

|||
Hi Thomas,

thank you for your reply.
I am using the Aventure Works cube project entreprise edition as well.In Excel 2007 the dropdown list 'Show fields related to' is set to the property 'All', so I think that I am not restricted to a perspective.
I can browse the cube in the SQL Server Management Studio(as well as in the BI Development Studio) and see the named sets as defined, but with Excel 2007 the named sets are not listed (neither the [Summary P&L] under the Account dimension nor the folder 'Sets' with 'Core Product Group', 'Long Lead Products',.... under the Product dimension).
By the way, I have Excel 2007 (12.0.6024.5000) MSO(12.0.6017.5000). Maybe I have a different version of Excel 2007?

Kind regards,
nedvin

Can''t see named sets in Excel 2007

Hi there,

I am not able to see the named sets in the PivotTable Field List in Excel 2007. I created e.g. the simple named set

CREATE SET CURRENTCUBE.[Austria]
AS [CUSTOMER].[COUNTRY].&[Austria] ;

Then I changed the display folder to 'Special Countries' in the mask 'Calculation properties' without selecting an 'Associated Measure Group'. After building the cube I can even see that display folder in the left-side tree of the 'Browse' window.
But after connecting to the cube with Excel 2007 the named set is not available for selection.

It seems that I am missing an important point.

Best wishes from Austria,

nedvin

I'm using Excel 2007 against the Adventure Works DW database and the Adventure Works cube. In the Account dimension, I see the [Summary P&L] named set. It has a Display folder of Sets and an Associated Measure Group of Financial Reporting.

You may want to compare what you have to what is in Adventure Works.

B.

|||Hi Bryan,

it took some time to install the Adventure Works Cube (actually I have completely reinstalled my pc), sorry for the late reply.
But even with your example I am unable to find the named set in the PivotTable Field List in Excel 2007. There is simply no folder 'Sets' containing the named set [Summary P&L].
I do see the [Summary P&L] in the cube (in the specified folder) and it is well defined under the mask 'Calculation properties', but in Excel 2007 it is not listed.

Kind regards,

nedvin
|||

I can see [Summary P&L] under the Account dimension. I use the enterprise edition version of the Adventure Works cube project. Make sure that you see the whole cube and not only a perspective("Show related fields to" at the top of the dimension tool)

HTH

Thomas Ivarsson

|||
Hi Thomas,

thank you for your reply.
I am using the Aventure Works cube project entreprise edition as well.In Excel 2007 the dropdown list 'Show fields related to' is set to the property 'All', so I think that I am not restricted to a perspective.
I can browse the cube in the SQL Server Management Studio(as well as in the BI Development Studio) and see the named sets as defined, but with Excel 2007 the named sets are not listed (neither the [Summary P&L] under the Account dimension nor the folder 'Sets' with 'Core Product Group', 'Long Lead Products',.... under the Product dimension).
By the way, I have Excel 2007 (12.0.6024.5000) MSO(12.0.6017.5000). Maybe I have a different version of Excel 2007?

Kind regards,
nedvin

Can't see named instance

I have a client running NT 4.0 on one of his workstations. For some reason f
rom that machine he can't see the named Instance on the Server (MyServer\MyI
nstance) and therefore can't connect to the database. If I pull up a list of
available servers, the Ser
ver comes up on the list, just not the named instance. ANy ideas on what mig
ht be causing this?Old version of MDAC. Apply the latest supported MDAC for NT 4.0 and the
client can connect. Alternatively, you can create an alias on the client
that includes the port number and connect via it.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean" <anonymous@.discussions.microsoft.com> wrote in message
news:2E49EBDD-9A7E-4772-9241-FA5A3EFA50C1@.microsoft.com...
> I have a client running NT 4.0 on one of his workstations. For some reason
from that machine he can't see the named Instance on the Server
(MyServer\MyInstance) and therefore can't connect to the database. If I pull
up a list of available servers, the Server comes up on the list, just not
the named instance. ANy ideas on what might be causing this?|||Yeah, thanks, that was it. Was getting burned by the user rights. The instal
l is supposed to load version 2.7 but I don't think the user had enough righ
ts on the box to do it.

Can't see named instance

I have a client running NT 4.0 on one of his workstations. For some reason from that machine he can't see the named Instance on the Server (MyServer\MyInstance) and therefore can't connect to the database. If I pull up a list of available servers, the Server comes up on the list, just not the named instance. ANy ideas on what might be causing this?Old version of MDAC. Apply the latest supported MDAC for NT 4.0 and the
client can connect. Alternatively, you can create an alias on the client
that includes the port number and connect via it.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean" <anonymous@.discussions.microsoft.com> wrote in message
news:2E49EBDD-9A7E-4772-9241-FA5A3EFA50C1@.microsoft.com...
> I have a client running NT 4.0 on one of his workstations. For some reason
from that machine he can't see the named Instance on the Server
(MyServer\MyInstance) and therefore can't connect to the database. If I pull
up a list of available servers, the Server comes up on the list, just not
the named instance. ANy ideas on what might be causing this?

Can't Run any DM Until Delete Lost Cube?

I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of:

Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the MSR TRANCHES ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml'. 0 0

I can't find any cube anywhere, nor do I find this missing file. How does Visual Studio know to look and how do I clear this up.

Thank you very much,

I obtain the same error when I try to develop a mining structure. Anybody know the solution?

Thanks in advance.

|||The error you're seeing indicates that the database is corrupt (internal files associated with certain system objects are missing). If you don't have any other database/objects you need to save on the server, the workaround would be to shut down the AS2005 service (SQL Server Analysis Service (<instancename>)), delete the "\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Data" folder and restart the service.

Can't remotely access SQL 2005 named instance

SuHi,
I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
server. I installed a default instance, and then a named instance called
"DEV".
Initially, I could not access either instance from a remote machine. I went
into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
under the Remote Access portion of the dialog for BOTH instances.
I can access the default instance from a remote machine. I still cannot
access the named instance from a remote machine. I have triple checked all
my settings. They are exactly the same for both instances.
The error message I receive is:
26 - Error locating server/instance specified
I can't see the DEV instance in the SQL Server browse list either.
Can anyone help?
Is the SQL Server Browser service started on the server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I went
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked all
> my settings. They are exactly the same for both instances.
> The error message I receive is:
> 26 - Error locating server/instance specified
> I can't see the DEV instance in the SQL Server browse list either.
> Can anyone help?
|||Thanks! That fixed the issue. You have helped me before, Tibor, and I thank
you again for your expertise. I may be a MCDBA, but I'm still a 2005 novice

I read a blurb somewhere that enabling the Browser service opens security
holes in SQL Server. Is this true, and if it is how does it indeed open
security holes?
- Anthony
"Tibor Karaszi" wrote:

> Is the SQL Server Browser service started on the server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
> news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
>
|||You're welcome Anthony. :-)

> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
Every surface you open opens increases the threat area. I don't know of any particular issues with
the SQL Browser. The same functionality existed in 2000, but it was built-in to the database engine.
To be more specific I guess we would have to see that comment.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:B18F79B4-C704-4903-A98C-FC3D5F25323D@.microsoft.com...[vbcol=seagreen]
> Thanks! That fixed the issue. You have helped me before, Tibor, and I thank
> you again for your expertise. I may be a MCDBA, but I'm still a 2005 novice
>
> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
> - Anthony
> "Tibor Karaszi" wrote:
|||"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I
> went
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named
> Pipes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked
> all
> my settings. They are exactly the same for both instances.
Have you tried the SQL Server Configuration Manager on the W2K machine.
This iw wher you open up the IP/Named pipes.

Can't remotely access SQL 2005 named instance

SuHi,
I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
server. I installed a default instance, and then a named instance called
"DEV".
Initially, I could not access either instance from a remote machine. I went
into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipe
s
under the Remote Access portion of the dialog for BOTH instances.
I can access the default instance from a remote machine. I still cannot
access the named instance from a remote machine. I have triple checked all
my settings. They are exactly the same for both instances.
The error message I receive is:
26 - Error locating server/instance specified
I can't see the DEV instance in the SQL Server browse list either.
Can anyone help?Is the SQL Server Browser service started on the server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I we
nt
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pi
pes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked al
l
> my settings. They are exactly the same for both instances.
> The error message I receive is:
> 26 - Error locating server/instance specified
> I can't see the DEV instance in the SQL Server browse list either.
> Can anyone help?|||Thanks! That fixed the issue. You have helped me before, Tibor, and I than
k
you again for your expertise. I may be a MCDBA, but I'm still a 2005 novice

I read a blurb somewhere that enabling the Browser service opens security
holes in SQL Server. Is this true, and if it is how does it indeed open
security holes?
- Anthony
"Tibor Karaszi" wrote:

> Is the SQL Server Browser service started on the server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
> news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
>|||You're welcome Anthony. :-)

> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
Every surface you open opens increases the threat area. I don't know of any
particular issues with
the SQL Browser. The same functionality existed in 2000, but it was built-in
to the database engine.
To be more specific I guess we would have to see that comment.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:B18F79B4-C704-4903-A98C-FC3D5F25323D@.microsoft.com...[vbcol=seagreen]
> Thanks! That fixed the issue. You have helped me before, Tibor, and I th
ank
> you again for your expertise. I may be a MCDBA, but I'm still a 2005 novi
ce
>
> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
> - Anthony
> "Tibor Karaszi" wrote:
>|||"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I
> went
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named
> Pipes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked
> all
> my settings. They are exactly the same for both instances.
Have you tried the SQL Server Configuration Manager on the W2K machine.
This iw wher you open up the IP/Named pipes.

Can't remotely access SQL 2005 named instance

SuHi,
I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
server. I installed a default instance, and then a named instance called
"DEV".
Initially, I could not access either instance from a remote machine. I went
into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
under the Remote Access portion of the dialog for BOTH instances.
I can access the default instance from a remote machine. I still cannot
access the named instance from a remote machine. I have triple checked all
my settings. They are exactly the same for both instances.
The error message I receive is:
26 - Error locating server/instance specified
I can't see the DEV instance in the SQL Server browse list either.
Can anyone help?Is the SQL Server Browser service started on the server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I went
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked all
> my settings. They are exactly the same for both instances.
> The error message I receive is:
> 26 - Error locating server/instance specified
> I can't see the DEV instance in the SQL Server browse list either.
> Can anyone help?|||Thanks! That fixed the issue. You have helped me before, Tibor, and I thank
you again for your expertise. I may be a MCDBA, but I'm still a 2005 novice
:)
I read a blurb somewhere that enabling the Browser service opens security
holes in SQL Server. Is this true, and if it is how does it indeed open
security holes?
- Anthony
"Tibor Karaszi" wrote:
> Is the SQL Server Browser service started on the server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
> news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> > SuHi,
> >
> > I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> > server. I installed a default instance, and then a named instance called
> > "DEV".
> >
> > Initially, I could not access either instance from a remote machine. I went
> > into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
> > under the Remote Access portion of the dialog for BOTH instances.
> >
> > I can access the default instance from a remote machine. I still cannot
> > access the named instance from a remote machine. I have triple checked all
> > my settings. They are exactly the same for both instances.
> >
> > The error message I receive is:
> >
> > 26 - Error locating server/instance specified
> >
> > I can't see the DEV instance in the SQL Server browse list either.
> >
> > Can anyone help?
>|||You're welcome Anthony. :-)
> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
Every surface you open opens increases the threat area. I don't know of any particular issues with
the SQL Browser. The same functionality existed in 2000, but it was built-in to the database engine.
To be more specific I guess we would have to see that comment.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:B18F79B4-C704-4903-A98C-FC3D5F25323D@.microsoft.com...
> Thanks! That fixed the issue. You have helped me before, Tibor, and I thank
> you again for your expertise. I may be a MCDBA, but I'm still a 2005 novice
> :)
> I read a blurb somewhere that enabling the Browser service opens security
> holes in SQL Server. Is this true, and if it is how does it indeed open
> security holes?
> - Anthony
> "Tibor Karaszi" wrote:
>> Is the SQL Server Browser service started on the server?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
>> news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
>> > SuHi,
>> >
>> > I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
>> > server. I installed a default instance, and then a named instance called
>> > "DEV".
>> >
>> > Initially, I could not access either instance from a remote machine. I went
>> > into SQL Server Surface Area Configuration and enabled TCP/IP and Named Pipes
>> > under the Remote Access portion of the dialog for BOTH instances.
>> >
>> > I can access the default instance from a remote machine. I still cannot
>> > access the named instance from a remote machine. I have triple checked all
>> > my settings. They are exactly the same for both instances.
>> >
>> > The error message I receive is:
>> >
>> > 26 - Error locating server/instance specified
>> >
>> > I can't see the DEV instance in the SQL Server browse list either.
>> >
>> > Can anyone help?
>>|||"Ant-nee" <Antnee@.discussions.microsoft.com> wrote in message
news:2B8ED4DB-E631-4C73-9C06-072557EC7FAA@.microsoft.com...
> SuHi,
> I just installed SQL 2005 Developer Edition on a brand new W2K3 w/ SP1
> server. I installed a default instance, and then a named instance called
> "DEV".
> Initially, I could not access either instance from a remote machine. I
> went
> into SQL Server Surface Area Configuration and enabled TCP/IP and Named
> Pipes
> under the Remote Access portion of the dialog for BOTH instances.
> I can access the default instance from a remote machine. I still cannot
> access the named instance from a remote machine. I have triple checked
> all
> my settings. They are exactly the same for both instances.
Have you tried the SQL Server Configuration Manager on the W2K machine.
This iw wher you open up the IP/Named pipes.

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
Message posted via http://www.sqlmonster.com
Hive you seen
http://msdn.microsoft.com/library/de...eInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>
|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>
|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this?
Message posted via http://www.sqlmonster.com
|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
Message posted via http://www.sqlmonster.com
|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
--
Message posted via http://www.sqlmonster.comHive you seen
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/MultipleInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this'
--
Message posted via http://www.sqlmonster.com|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
--
Message posted via http://www.sqlmonster.com|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
Message posted via http://www.droptable.comHive you seen
http://msdn.microsoft.com/library/d...leInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this'
Message posted via http://www.droptable.com|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
Message posted via http://www.droptable.com|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>

Can't register remote SQL

When I try to register a remote SQL Server from a local desktop XP Pro PC, I
get the error:
"Client unable to establish connection. Named Pipes Provider: the network
path was not found. Timeout expired."
I checked and this is not a firewall problem because SQL ports are open. We
normally don't have a problem registering SQL servers like this; just this
one server. Any clues?
Thanks!!!
Is that particular server using Named Pipes, or is it set for TCP/IP? Check
the Server Network Utility to ensure Named Pipes is turned on on the server,
since your client appears to be using Named Pipes instead of TCP/IP.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
> When I try to register a remote SQL Server from a local desktop XP Pro PC,
> I
> get the error:
> "Client unable to establish connection. Named Pipes Provider: the network
> path was not found. Timeout expired."
> I checked and this is not a firewall problem because SQL ports are open.
> We
> normally don't have a problem registering SQL servers like this; just this
> one server. Any clues?
> Thanks!!!
>
|||Hello,
Yes, I thought of that before, but I just checked again and the Server
Network Util says enabled protocols:
Named Pipes
TCP/IP
We are trying to register the SQL server remotely using the server's IP addr
which has always worked in the past. Anyone know what is wrong?
Thanks!!!
"Michael C#" <xyz@.yomomma.com> wrote in message
news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Is that particular server using Named Pipes, or is it set for TCP/IP?
Check
> the Server Network Utility to ensure Named Pipes is turned on on the
server,[vbcol=seagreen]
> since your client appears to be using Named Pipes instead of TCP/IP.
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:e4otsANKFHA.904@.tk2msftngp13.phx.gbl...
PC,[vbcol=seagreen]
network[vbcol=seagreen]
this
>
|||Interesting. You're using the TCP/IP address, but it's trying to connect
via Named Pipes? Have you checked the Client Network Utility on your client
box to see if TCP/IP is enabled locally? Also have you established
connectivity to the remote server? i.e., can you Ping the remote box? It
sounds like you're trying to connect via TCP/IP, but it's falling back to
Named Pipes. I'd check the network settings on the server and make sure
it's reachable from the local box. There's a utility called SQLPing at
http://sqlsecurity.com/DesktopDefault.aspx (w/ source code) that can help
determine if you can see the other server from the local box.
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:OYoG%236NKFHA.2812@.TK2MSFTNGP15.phx.gbl...
> Hello,
> Yes, I thought of that before, but I just checked again and the Server
> Network Util says enabled protocols:
> Named Pipes
> TCP/IP
> We are trying to register the SQL server remotely using the server's IP
> addr
> which has always worked in the past. Anyone know what is wrong?
> Thanks!!!
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:#HM9QONKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Check
> server,
> PC,
> network
> this
>