Can't seem to get the newly created entry's identity field :(

Hi there,

I have a stored procedure that executes a transaction which updates/inserts into a table on a remote server and should then use that new entry's autogenerated primary key to update another table.
I try to store that key into a variable called @.NewlyCreatedPastelDClinkNumber but to no avail

I have used the @.@.Identity approach and now try to manually get that key to from other information but still no go..My thinking is: since i am using transactions, maybe the entry cant be found until the transaction has been committed...but surely it should find it after the commit statement? Here is my code: I have marked the interesting bit with blue for simplicity.

ALTER procedure [dbo].[inv_SynchronizeClientsWithPastel]
as
BEGIN
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
SET XACT_ABORT ON

DECLARE @.PastelDCLinkNumber int
DECLARE @.ClientID int
DECLARE @.Name varchar(25)
DECLARE @.Surname nvarchar(25)
DECLARE @.POBoxAddr1 varchar(40)
DECLARE @.POBoxAddr2 varchar(40)
DECLARE @.PostalCode varchar(5)
DECLARE @.ClientCreditCardNumber nvarchar(50)
DECLARE @.NewlyCreatedPastelDClinkNumber int
DECLARE PastelClientPortCursor CURSOR FOR

SELECT id, [Name], Surname, POBoxAddr1, POBoxAddr2, PostalCode, PastelDCLinkNumber ,CreditCardNumber
FROM inc_Client
WHERE HasSynchronizedWithPastel = 0

OPEN PastelClientPortCursor;
FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber,@.ClientCreditCardNumber
WHILE @.@.FETCH_STATUS = 0
BEGIN

--Step2 insert/update the client information into the Synergy invoice and client table
BEGIN TRANSACTION T1
IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET
Name = (@.Name + ' ' + @.Surname),
Account = (@.Name + ' ' + @.Surname),
Post1 = @.POBoxAddr1,
Post2 = @.POBoxAddr2,
PostPC = @.PostalCode,
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber
WHERE DCLink = @.PastelDCLinkNumber
End

ELSE
Begin
--Insert into the Pastel Client table
INSERT INTO [server].[Satra Corporate (Pty) Ltd].dbo.Client
(Account, Name, Post1, Post2, PostPC, AccountTerms, CT, Credit_Limit,
RepID, Interest_Rate, Discount, On_Hold, BFOpenType, BankLink,
AutoDisc,
DiscMtrxRow, CashDebtor, DCBalance, CheckTerms, UseEmail,
iCountryID, cAccDescription, iCurrencyID, bStatPrint,
bStatEmail, bForCurAcc,
fForeignBalance, bTaxPrompt, iARPriceListNameID)
VALUES
(
SUBSTRING(@.Name, 1,19), --Account
(@.Name + ' ' + @.Surname), --Name
@.POBoxAddr1, --Post1
@.POBoxAddr2, --Post2
@.PostalCode, --PostPC
0, --Account_Terms
1, --CT
0,--Credit_Limit
0, --Rep_ID
0, --interest_Rate
0, --Discount
0, --On_Hold
0, --BFOpenType
0, --BankLink
0, --AutoDisc
0, --DiscMatrix
0, --CashDebtor
0, --DCBalance
1, --CheckTerms
0, --UseEmail
0, --iCountryID
'Credit Card Number: ' + @.ClientCreditCardNumber,
0, --iCurrencyID
1, --StatPrint
0, --StatEmail
0, --bForCurAcc
0, --ForeignBal
1, --bTaxPrompt
1 --iARPriceListNameID
)
End

--If the rowcount is 0, an error has occured
IF @.@.ROWCOUNT <> 0
Begin
COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Begin
Update inc_Client SET
HasSynchronizedWithPastel = 1 ,
PastelDCLinkNumber = @.NewlyCreatedPastelDClinkNumber
WHERE id = @.ClientID
End
End

--Rollback transaction
IF @.@.TRANCOUNT > 0
Begin
ROLLBACK TRANSACTION T1
execute sec_LogSQLTransactionError 'inv_SynchronizeClientsWithPastel','inc_Client_id',@.ClientID,'System'
End

FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber, @.ClientCreditCardNumber
END
CLOSE PastelClientPortCursor;
DEALLOCATE PastelClientPortCursor;

END

SET XACT_ABORT OFF
Go

Instead of:

COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Try:

COMMIT TRANSACTION T1

SET @.NewlyCreatedPastelDClinkNumber = scope_identity()

execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

|||

Problem 1)

IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET

Don't check for the data and then do the update. Simply DO the update first. If you update 0 rows, then you do the insert. This cuts exection in half when there is an update to be performed.

Problem 2)

IMMEDIATELY after the INSERT, put the @.@.ERROR and @.@.ROWCOUNT AND scope_identity() values into a variable. Then act on those three in appropriate order.

Problem 3)

You should use a remote sproc to do the update/insert stuff on the remote server. MUCH more efficient. Pass parameters in and then local stuff does work with a cached query plan and only one network trip.

|||Thanks for all your support. I'm going to give this a try|||Thank you for all your help. It worked.

I looked at your suggestions in your steps(problems) and immediately saw the advantages of your suggestions.

I will now adapt future stored procedure's templates to include those good practices. Thanks once more.

Regards
Mike

Can't seem to get the newly created entry's identity field :(

Hi there,

I have a stored procedure that executes a transaction which updates/inserts into a table on a remote server and should then use that new entry's autogenerated primary key to update another table.
I try to store that key into a variable called @.NewlyCreatedPastelDClinkNumber but to no avail

I have used the @.@.Identity approach and now try to manually get that key to from other information but still no go..My thinking is: since i am using transactions, maybe the entry cant be found until the transaction has been committed...but surely it should find it after the commit statement? Here is my code: I have marked the interesting bit with blue for simplicity.

ALTER procedure [dbo].[inv_SynchronizeClientsWithPastel]
as
BEGIN
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
SET XACT_ABORT ON

DECLARE @.PastelDCLinkNumber int
DECLARE @.ClientID int
DECLARE @.Name varchar(25)
DECLARE @.Surname nvarchar(25)
DECLARE @.POBoxAddr1 varchar(40)
DECLARE @.POBoxAddr2 varchar(40)
DECLARE @.PostalCode varchar(5)
DECLARE @.ClientCreditCardNumber nvarchar(50)
DECLARE @.NewlyCreatedPastelDClinkNumber int
DECLARE PastelClientPortCursor CURSOR FOR

SELECT id, [Name], Surname, POBoxAddr1, POBoxAddr2, PostalCode, PastelDCLinkNumber ,CreditCardNumber
FROM inc_Client
WHERE HasSynchronizedWithPastel = 0

OPEN PastelClientPortCursor;
FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber,@.ClientCreditCardNumber
WHILE @.@.FETCH_STATUS = 0
BEGIN

--Step2 insert/update the client information into the Synergy invoice and client table
BEGIN TRANSACTION T1
IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET
Name = (@.Name + ' ' + @.Surname),
Account = (@.Name + ' ' + @.Surname),
Post1 = @.POBoxAddr1,
Post2 = @.POBoxAddr2,
PostPC = @.PostalCode,
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber
WHERE DCLink = @.PastelDCLinkNumber
End

ELSE
Begin
--Insert into the Pastel Client table
INSERT INTO [server].[Satra Corporate (Pty) Ltd].dbo.Client
(Account, Name, Post1, Post2, PostPC, AccountTerms, CT, Credit_Limit,
RepID, Interest_Rate, Discount, On_Hold, BFOpenType, BankLink,
AutoDisc,
DiscMtrxRow, CashDebtor, DCBalance, CheckTerms, UseEmail,
iCountryID, cAccDescription, iCurrencyID, bStatPrint,
bStatEmail, bForCurAcc,
fForeignBalance, bTaxPrompt, iARPriceListNameID)
VALUES
(
SUBSTRING(@.Name, 1,19), --Account
(@.Name + ' ' + @.Surname), --Name
@.POBoxAddr1, --Post1
@.POBoxAddr2, --Post2
@.PostalCode, --PostPC
0, --Account_Terms
1, --CT
0,--Credit_Limit
0, --Rep_ID
0, --interest_Rate
0, --Discount
0, --On_Hold
0, --BFOpenType
0, --BankLink
0, --AutoDisc
0, --DiscMatrix
0, --CashDebtor
0, --DCBalance
1, --CheckTerms
0, --UseEmail
0, --iCountryID
'Credit Card Number: ' + @.ClientCreditCardNumber,
0, --iCurrencyID
1, --StatPrint
0, --StatEmail
0, --bForCurAcc
0, --ForeignBal
1, --bTaxPrompt
1 --iARPriceListNameID
)
End

--If the rowcount is 0, an error has occured
IF @.@.ROWCOUNT <> 0
Begin
COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Begin
Update inc_Client SET
HasSynchronizedWithPastel = 1 ,
PastelDCLinkNumber = @.NewlyCreatedPastelDClinkNumber
WHERE id = @.ClientID
End
End

--Rollback transaction
IF @.@.TRANCOUNT > 0
Begin
ROLLBACK TRANSACTION T1
execute sec_LogSQLTransactionError 'inv_SynchronizeClientsWithPastel','inc_Client_id',@.ClientID,'System'
End

FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber, @.ClientCreditCardNumber
END
CLOSE PastelClientPortCursor;
DEALLOCATE PastelClientPortCursor;

END

SET XACT_ABORT OFF
Go

Instead of:

COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Try:

COMMIT TRANSACTION T1

SET @.NewlyCreatedPastelDClinkNumber = scope_identity()

execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

|||

Problem 1)

IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET

Don't check for the data and then do the update. Simply DO the update first. If you update 0 rows, then you do the insert. This cuts exection in half when there is an update to be performed.

Problem 2)

IMMEDIATELY after the INSERT, put the @.@.ERROR and @.@.ROWCOUNT AND scope_identity() values into a variable. Then act on those three in appropriate order.

Problem 3)

You should use a remote sproc to do the update/insert stuff on the remote server. MUCH more efficient. Pass parameters in and then local stuff does work with a cached query plan and only one network trip.

|||Thanks for all your support. I'm going to give this a try|||Thank you for all your help. It worked.

I looked at your suggestions in your steps(problems) and immediately saw the advantages of your suggestions.

I will now adapt future stored procedure's templates to include those good practices. Thanks once more.

Regards
Mikesql

Can''t seem to get the newly created entry''s identity field :(

Hi there,

I have a stored procedure that executes a transaction which updates/inserts into a table on a remote server and should then use that new entry's autogenerated primary key to update another table.
I try to store that key into a variable called @.NewlyCreatedPastelDClinkNumber but to no avail

I have used the @.@.Identity approach and now try to manually get that key to from other information but still no go..My thinking is: since i am using transactions, maybe the entry cant be found until the transaction has been committed...but surely it should find it after the commit statement? Here is my code: I have marked the interesting bit with blue for simplicity.

ALTER procedure [dbo].[inv_SynchronizeClientsWithPastel]
as
BEGIN
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
SET XACT_ABORT ON

DECLARE @.PastelDCLinkNumber int
DECLARE @.ClientID int
DECLARE @.Name varchar(25)
DECLARE @.Surname nvarchar(25)
DECLARE @.POBoxAddr1 varchar(40)
DECLARE @.POBoxAddr2 varchar(40)
DECLARE @.PostalCode varchar(5)
DECLARE @.ClientCreditCardNumber nvarchar(50)
DECLARE @.NewlyCreatedPastelDClinkNumber int
DECLARE PastelClientPortCursor CURSOR FOR

SELECT id, [Name], Surname, POBoxAddr1, POBoxAddr2, PostalCode, PastelDCLinkNumber ,CreditCardNumber
FROM inc_Client
WHERE HasSynchronizedWithPastel = 0

OPEN PastelClientPortCursor;
FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber,@.ClientCreditCardNumber
WHILE @.@.FETCH_STATUS = 0
BEGIN

--Step2 insert/update the client information into the Synergy invoice and client table
BEGIN TRANSACTION T1
IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET
Name = (@.Name + ' ' + @.Surname),
Account = (@.Name + ' ' + @.Surname),
Post1 = @.POBoxAddr1,
Post2 = @.POBoxAddr2,
PostPC = @.PostalCode,
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber
WHERE DCLink = @.PastelDCLinkNumber
End

ELSE
Begin
--Insert into the Pastel Client table
INSERT INTO [server].[Satra Corporate (Pty) Ltd].dbo.Client
(Account, Name, Post1, Post2, PostPC, AccountTerms, CT, Credit_Limit,
RepID, Interest_Rate, Discount, On_Hold, BFOpenType, BankLink,
AutoDisc,
DiscMtrxRow, CashDebtor, DCBalance, CheckTerms, UseEmail,
iCountryID, cAccDescription, iCurrencyID, bStatPrint,
bStatEmail, bForCurAcc,
fForeignBalance, bTaxPrompt, iARPriceListNameID)
VALUES
(
SUBSTRING(@.Name, 1,19), --Account
(@.Name + ' ' + @.Surname), --Name
@.POBoxAddr1, --Post1
@.POBoxAddr2, --Post2
@.PostalCode, --PostPC
0, --Account_Terms
1, --CT
0,--Credit_Limit
0, --Rep_ID
0, --interest_Rate
0, --Discount
0, --On_Hold
0, --BFOpenType
0, --BankLink
0, --AutoDisc
0, --DiscMatrix
0, --CashDebtor
0, --DCBalance
1, --CheckTerms
0, --UseEmail
0, --iCountryID
'Credit Card Number: ' + @.ClientCreditCardNumber,
0, --iCurrencyID
1, --StatPrint
0, --StatEmail
0, --bForCurAcc
0, --ForeignBal
1, --bTaxPrompt
1 --iARPriceListNameID
)
End

--If the rowcount is 0, an error has occured
IF @.@.ROWCOUNT <> 0
Begin
COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Begin
Update inc_Client SET
HasSynchronizedWithPastel = 1 ,
PastelDCLinkNumber = @.NewlyCreatedPastelDClinkNumber
WHERE id = @.ClientID
End
End

--Rollback transaction
IF @.@.TRANCOUNT > 0
Begin
ROLLBACK TRANSACTION T1
execute sec_LogSQLTransactionError 'inv_SynchronizeClientsWithPastel','inc_Client_id',@.ClientID,'System'
End

FETCH NEXT FROM PastelClientPortCursor
INTO @.ClientID,@.Name,@.Surname,@.POBoxAddr1,@.POBoxAddr2,@.PostalCode,@.PastelDCLinkNumber, @.ClientCreditCardNumber
END
CLOSE PastelClientPortCursor;
DEALLOCATE PastelClientPortCursor;

END

SET XACT_ABORT OFF
Go

Instead of:

COMMIT TRANSACTION T1
execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

Begin
SET @.NewlyCreatedPastelDClinkNumber = (SELECT DCLink From [server].[Satra Corporate (Pty) Ltd].dbo.Client
WHERE Name = (@.Name + ' ' + @.Surname)AND
Account = (@.Name + ' ' + @.Surname)AND
Post1 = @.POBoxAddr1 AND
Post2 = @.POBoxAddr2 AND
PostPC = @.PostalCode AND
cAccDescription = 'Credit Card Number: ' + @.ClientCreditCardNumber)
End

Try:

COMMIT TRANSACTION T1

SET @.NewlyCreatedPastelDClinkNumber = scope_identity()

execute sec_LogSQLTransaction 'inv_SynchronizeClientsWithPastel' ,'inc_Client_id',@.ClientID,'System'
-- Step 3Update the HasSynchronizedWithPastel Flag

|||

Problem 1)

IF Exists(SELECT DCLink from [server].[Satra Corporate (Pty) Ltd].dbo.Client WHERE DCLink = @.PastelDCLinkNumber)

--Update the Pastel Client table

Begin
Update [server].[Satra Corporate (Pty) Ltd].dbo.Client SET

Don't check for the data and then do the update. Simply DO the update first. If you update 0 rows, then you do the insert. This cuts exection in half when there is an update to be performed.

Problem 2)

IMMEDIATELY after the INSERT, put the @.@.ERROR and @.@.ROWCOUNT AND scope_identity() values into a variable. Then act on those three in appropriate order.

Problem 3)

You should use a remote sproc to do the update/insert stuff on the remote server. MUCH more efficient. Pass parameters in and then local stuff does work with a cached query plan and only one network trip.

|||Thanks for all your support. I'm going to give this a try|||Thank you for all your help. It worked.

I looked at your suggestions in your steps(problems) and immediately saw the advantages of your suggestions.

I will now adapt future stored procedure's templates to include those good practices. Thanks once more.

Regards
Mike

Can't see the SQL Server Express Instance on SQL Browser

Hi All,

I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following..

a.) Enabled the remote connections for the Express Instance and rebooted the machine.

b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity.

c.) Yes, SQL Browser Service is running.

d.) Firewall is not turned on, so I do not have to configure any exceptions.

Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on the SQL Express Instance showing up on the browser list. I even changed the default instance name to "machinename\MACHINE1" on one of the reinstalls. However, I can connect to other SQL Instances from it. But, I cannot connect to it from other machines since its not registered on the network. I have been working on this for the past few days by looking for a solution via this and other forumns. Is there some setting somewhere that I am missing that prevents this instance from not showing up on the browser list. This issue with SQL Express Edition is baffling as well as frustrating and any ideas that can resolve this issue is very much appreciated.

when you say you cant see it on the list, do you mean in the ODBC dialog list? or some other list? if its involves the ODBC dialog, ive had to actually type in the whole machinename \SQLExpress since it didnt show up initially for it to work.|||I am talking about the SQL Server Browser list, that one can see all of the live SQL Server database Instances. Not the dialog list...|||I have several of them that refuse to show up in any browser list. But, I can connect to just about all of them even though they don't show up in the browser list by just typing in the instance name. Is there a particular error that you are getting? Can you give us more detail on your configuration and exactly what steps you are doing?|||

After installing SQL Server Express Edition on a new HP laptop with WIN 2K sp2, I went to see if it was registered on the Network as "machinename/SQLEXPRESS", and what I can see on the Network is just the "machinename", with the instance name missing. So I reinstalled it with a new instance name "machinename/Machine1", and again it was missing the instance name "Machine1", but I can see the machinename. I tried to connect with the instance name only "Machine1" and believe me I have tried it every which way but I always get the infamous error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"

Now here is the odd part, I had installed SQL Server Express Edition on a older (1 year) IBM laptop with WIN 2K sp2, about 1 month back and was able to see the complete instance name on the network and can connect just fine. The only difference in these two machines is the age, but they both have the same OS Software installed. I have been pulling my hair in trying to figure out what is going on with SQL Server Express Edition on this new HP laptop with WIN 2K sp2 installed. It just refuses to register itself correctly on the network.

|||I have several that the browser only sees the machine name. That still doesn't mean that is what you use for the connection string. If you are using a default instance of Express Edition, then you still need to connect to machinename\SQLExpress even if browsing only shows you just the machine name. Now, that doesn't mean that you aren't having issues similar to mine on one of my clients which refuses to allow me to connect, we just need to make sure there isn't something else wrong first.|||As I have mentioned before, I tried using "machinename\MACHINE1" as the complete instance name and it throws out the error as I posted before. I can connect other instances from this HP Laptop but cannot connect to it from other machines. Perhaps we are having the same issue. I have been asking our Network Admin, System Admin and Security Admin and they are all puzzled by this SQL Express behavior on this HP laptop. I am wondering if it has anything to do with particular PC machines as the IBM pc works fine, but not the HP, this is just a guess. But I am running out of ideas and my users are running out of patience as I try to find a solution to this big problem....|||

Not sure if this has anything to do with your issue, but you mentioned that you were using Win2000 SP2, that is not a supported platform for SQL 2005, you need to be running SP4. I'm surprised that install didn't block.

Mike

|||

Yes, it looks like you are having exactly the same issue as I'm having on one of my machines. I have everything configured correctly with all of the access configured the way it needs to be. I can quite literally do anything I want to on the client when I'm RDPed into the server including remotely launching applications, remotely stopping start services, etc. The only that that it refuses to do is recognize and connect to the SQL Server Express Edition instance. I'm having problem doing further troubleshooting and opening a support case is rather difficult since the problem machine is in CA and I'm in TX without any direct ability to get hands on with the machine. I thought I had another one exhibiting this behavior, but when I plugged the laptop into my network, it magically started working and it hasn't thrown the error since. Yes, I'm rather baffled. My only saving grace is that I don't have any more hair to pull out at this point. :)

I have several more machines to work through and I'm hoping that I can get at least one of them to exhibit this behavior.

|||

I'm getting a bit closer on my side and now have 2 machines that are having issues. So, I want to try something and see if your results duplicate mine.

Log on to the machine that is having problems using your accouunt. Once it is up and running, go over to another instance and login to the Express instance from the other machine using your Windows credentials. Let me know if that magically makes it work.

|||

Hi Michael,

Nope, I tried as you suggested and I keep getting that same error, from the other machine when I try to connect to the problem machine. However, I can connect from the problem machine to any other SQL Server 2005 instance...Do not know what to do at this point. Perhaps Microsoft needs to help out...I hope they are reading this Message.

|||I am wondering if this issue has anything to do with having 2 NIC cards in a Laptop machine, one for the Local Network and the other for the Wireless Network...That is the only difference I see with the 2 different Laptops I am working with. The IBM machine does not have a Wireless Network NIC and it works...The other newer HP has a Wireless NIC and it does not work..Is Microsoft listening.....|||I can rule that one out. I have machines that connect just fine with multiple NICs and a couple that don't that also have multiple NICs.|||Have you tried opening a support case with Microsoft. I am not sure how this particular Software is supported since it is freely distributed..|||

SQL Server Express Edition is fully supported. Just like you can call in and get support on Internet Explorer.

I found a couple of other things when I was doing additional configuration. Verify that your WINS scopes are set properly. Also verify that the machine is actually getting its IP address correctly registered into DNS. These two items fixed 100% of the connectivity issues that I was having within SQL Server.

Can't see or access tables through linked server

Apparently I am doing something wrong and I don't know what!

I am needing to link a remote Oracle Server to SQL Server 2005.

I have (I think) followed the steps precisely to create the linked

server both by code or through the SQL Server Management Studio and I

get the same results eith way. I can see the linked server and there are no apparent errors but I can't see or access the tables from Oracle.

If I try a Select statement on a table from the linked server I get the

error "Msg 208, Level 16, Stat 1, Server {servername}, Line 1 Invalid

object name"

I am assuming this is a permissions issue but I don't see it. I

am an admin on both the SQL Server DB and the Oracle DB with full

access and I am using windows authentication.

I have mapped local logons to the remote logon and tried almost every

possible combination of security contexts and other users on the local

and linked server but I always get the same result. The Oracle server shows it is linked but I can't get to any table on the linked server.

Any help on this would be really appreciated. I have already spent two days on this.

Thanks in advance.

This kb should help.

support.microsoft.com/kb/280106

|||

I don't think this applies. This KB article only covers up to Windows 2000 and Oracle 8.i.

We have either 2003 server or XP (happening on two machines) and Oracle 10g.

Also, I am not getting any error messages as the article discusses, I just can't see the tables.

Thanks for the help.

sql

Can't run LDAP Query From Remote Machine

Hi all,
I have a SQL 2005 server with a linked server which points to our
active directory. I am able to query the active directory from the
local machine when RDC'ed into the server, but when I run the query
from a remote machine using Management Studio, I get this error:
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT *
FROM 'LDAP://prudc/DC=<domain>,DC=com'
" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
The query is:
SELECT *
FROM OPENQUERY( ADSI,
'SELECT *
FROM ''LDAP://prudc/DC=<domain>,DC=com''
'
)
(note I replaced our domain name with <domain> in the above query and
error message)
This issue isn't specific to the above query as I've tried many ldap
queries and they have all worked on the local machine but failed on the
remote machine.
I'm completely stomped on this and would greatly appreciate any help I
can get.
ThanksHi Jim
This was a previous post when someone had the same error
http://tinyurl.com/pjg7s I am not sure how much use it will be!
If the query works on the server then I would expect it to be ok, which
probably leaves permission/access as the main issue. Can you use VB script to
query the AD e.g. using the scripts from http://www.rlmueller.net/?
John
"Jim" wrote:
> Hi all,
> I have a SQL 2005 server with a linked server which points to our
> active directory. I am able to query the active directory from the
> local machine when RDC'ed into the server, but when I run the query
> from a remote machine using Management Studio, I get this error:
>
> Msg 7320, Level 16, State 2, Line 1
> Cannot execute the query "SELECT *
> FROM 'LDAP://prudc/DC=<domain>,DC=com'
> " against OLE DB provider "ADSDSOObject" for linked server "ADSI".
>
> The query is:
> SELECT *
> FROM OPENQUERY( ADSI,
> 'SELECT *
> FROM ''LDAP://prudc/DC=<domain>,DC=com''
> '
> )
> (note I replaced our domain name with <domain> in the above query and
> error message)
>
> This issue isn't specific to the above query as I've tried many ldap
> queries and they have all worked on the local machine but failed on the
> remote machine.
> I'm completely stomped on this and would greatly appreciate any help I
> can get.
> Thanks
>|||Thanks for the help but unfortunately, I've already looked at that post
and the issue is a bit different.
The issue I'm having seems to have something to do with running a query
from a remote machine. So if I run a query on our SQL Server box from
my local desktop machine, I get the error. Running the query directly
on the SQL Server box while RDCed into the machine works flawlessly.
I did try to run a .vbs script from my machine which was able to query
the active directory...thanks for the link =). This leads me to
believe that it has something to do with SQL server security
restricting queries run from remote machines. I ran the surface area
configuration utility and didn't really see anything that jumped out at
me...
Anyone have any ideas?|||Alright, I've figured out a fix..
The AD linked server that I originally created was set to login to AD
with the credentials of the current security context. I changed this
to log in with a specified login and it worked fine. Whats strange is
that I set it to my own login account which I was using to run the
query remotely anyways. I guess SQL server queries ran remotely are
not run under the logged in users' security context after all?
Thanks for your help John =).

Can't run LDAP Query From Remote Machine

Hi all,
I have a SQL 2005 server with a linked server which points to our
active directory. I am able to query the active directory from the
local machine when RDC'ed into the server, but when I run the query
from a remote machine using Management Studio, I get this error:
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT *
FROM 'LDAP://prudc/DC=<domain>,DC=com'
" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
The query is:
SELECT *
FROM OPENQUERY( ADSI,
'SELECT *
FROM ''LDAP://prudc/DC=<domain>,DC=com''
'
)
(note I replaced our domain name with <domain> in the above query and
error message)
This issue isn't specific to the above query as I've tried many ldap
queries and they have all worked on the local machine but failed on the
remote machine.
I'm completely stomped on this and would greatly appreciate any help I
can get.
ThanksHi Jim
This was a previous post when someone had the same error
http://tinyurl.com/pjg7s I am not sure how much use it will be!
If the query works on the server then I would expect it to be ok, which
probably leaves permission/access as the main issue. Can you use VB script t
o
query the AD e.g. using the scripts from http://www.rlmueller.net/?
John
"Jim" wrote:

> Hi all,
> I have a SQL 2005 server with a linked server which points to our
> active directory. I am able to query the active directory from the
> local machine when RDC'ed into the server, but when I run the query
> from a remote machine using Management Studio, I get this error:
>
> Msg 7320, Level 16, State 2, Line 1
> Cannot execute the query "SELECT *
> FROM 'LDAP://prudc/DC=<domain>,DC=com'
> " against OLE DB provider "ADSDSOObject" for linked server "ADSI".
>
> The query is:
> SELECT *
> FROM OPENQUERY( ADSI,
> 'SELECT *
> FROM ''LDAP://prudc/DC=<domain>,DC=com''
> '
> )
> (note I replaced our domain name with <domain> in the above query and
> error message)
>
> This issue isn't specific to the above query as I've tried many ldap
> queries and they have all worked on the local machine but failed on the
> remote machine.
> I'm completely stomped on this and would greatly appreciate any help I
> can get.
> Thanks
>|||Thanks for the help but unfortunately, I've already looked at that post
and the issue is a bit different.
The issue I'm having seems to have something to do with running a query
from a remote machine. So if I run a query on our SQL Server box from
my local desktop machine, I get the error. Running the query directly
on the SQL Server box while RDCed into the machine works flawlessly.
I did try to run a .vbs script from my machine which was able to query
the active directory...thanks for the link =). This leads me to
believe that it has something to do with SQL server security
restricting queries run from remote machines. I ran the surface area
configuration utility and didn't really see anything that jumped out at
me...
Anyone have any ideas?|||Alright, I've figured out a fix..
The AD linked server that I originally created was set to login to AD
with the credentials of the current security context. I changed this
to log in with a specified login and it worked fine. Whats strange is
that I set it to my own login account which I was using to run the
query remotely anyways. I guess SQL server queries ran remotely are
not run under the logged in users' security context after all?
Thanks for your help John =).

Can't run LDAP Query From Remote Machine

Hi all,
I have a SQL 2005 server with a linked server which points to our
active directory. I am able to query the active directory from the
local machine when RDC'ed into the server, but when I run the query
from a remote machine using Management Studio, I get this error:
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT *
FROM 'LDAP://prudc/DC=<domain>,DC=com'
" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
The query is:
SELECT *
FROM OPENQUERY( ADSI,
'SELECT *
FROM ''LDAP://prudc/DC=<domain>,DC=com''
'
)
(note I replaced our domain name with <domain> in the above query and
error message)
This issue isn't specific to the above query as I've tried many ldap
queries and they have all worked on the local machine but failed on the
remote machine.
I'm completely stomped on this and would greatly appreciate any help I
can get.
Thanks
Hi Jim
This was a previous post when someone had the same error
http://tinyurl.com/pjg7s I am not sure how much use it will be!
If the query works on the server then I would expect it to be ok, which
probably leaves permission/access as the main issue. Can you use VB script to
query the AD e.g. using the scripts from http://www.rlmueller.net/?
John
"Jim" wrote:

> Hi all,
> I have a SQL 2005 server with a linked server which points to our
> active directory. I am able to query the active directory from the
> local machine when RDC'ed into the server, but when I run the query
> from a remote machine using Management Studio, I get this error:
>
> Msg 7320, Level 16, State 2, Line 1
> Cannot execute the query "SELECT *
> FROM 'LDAP://prudc/DC=<domain>,DC=com'
> " against OLE DB provider "ADSDSOObject" for linked server "ADSI".
>
> The query is:
> SELECT *
> FROM OPENQUERY( ADSI,
> 'SELECT *
> FROM ''LDAP://prudc/DC=<domain>,DC=com''
> '
> )
> (note I replaced our domain name with <domain> in the above query and
> error message)
>
> This issue isn't specific to the above query as I've tried many ldap
> queries and they have all worked on the local machine but failed on the
> remote machine.
> I'm completely stomped on this and would greatly appreciate any help I
> can get.
> Thanks
>
|||Thanks for the help but unfortunately, I've already looked at that post
and the issue is a bit different.
The issue I'm having seems to have something to do with running a query
from a remote machine. So if I run a query on our SQL Server box from
my local desktop machine, I get the error. Running the query directly
on the SQL Server box while RDCed into the machine works flawlessly.
I did try to run a .vbs script from my machine which was able to query
the active directory...thanks for the link =). This leads me to
believe that it has something to do with SQL server security
restricting queries run from remote machines. I ran the surface area
configuration utility and didn't really see anything that jumped out at
me...
Anyone have any ideas?
|||Alright, I've figured out a fix..
The AD linked server that I originally created was set to login to AD
with the credentials of the current security context. I changed this
to log in with a specified login and it worked fine. Whats strange is
that I set it to my own login account which I was using to run the
query remotely anyways. I guess SQL server queries ran remotely are
not run under the logged in users' security context after all?
Thanks for your help John =).

cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
TIA,
ChrisR
Did you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR
|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
TIA,
ChrisR
"Corey Bunch" wrote:

> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>
|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
|||Start\ Programs\ there is no Configuration Tools option.
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
|||And do what to the netlibs? I dont see anything like enable remote connections.
TIA,
ChrisR
"Tibor Karaszi" wrote:

> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>
|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:

cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
> > I have a local instance of sql2k5, as well as a remote one. From my local
> > Management Studio, I try to register the remote one, and I get the message...
> >
> > A connection was successfully established to the server, but then an error
> > occured during the login process. (provider: TCP Provider, error:0 - An
> > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > 10054)
> >
> > Any ideas?
> > --
> > TIA,
> > ChrisR
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
> > Did you enable TCP/IP connections from remote machines in SQL Surface
> > Area Configuration Tool? They're not turned on by default in 2005.
> >
> > ChrisR wrote:
> > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > Management Studio, I try to register the remote one, and I get the message...
> > >
> > > A connection was successfully established to the server, but then an error
> > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > 10054)
> > >
> > > Any ideas?
> > > --
> > > TIA,
> > > ChrisR
> >
> >|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
--
TIA,
ChrisR
"ChrisR" wrote:
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> > Configuration tool?
> >
> > "ChrisR" wrote:
> >
> > > I don't have a Configurations tab on the remote box... I just realized its
> > > Beta2. Could this have sometihng to do with it?
> > > --
> > > TIA,
> > > ChrisR
> > >
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > > Area Configuration Tool? They're not turned on by default in 2005.
> > > >
> > > > ChrisR wrote:
> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > > Management Studio, I try to register the remote one, and I get the message...
> > > > >
> > > > > A connection was successfully established to the server, but then an error
> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > > 10054)
> > > > >
> > > > > Any ideas?
> > > > > --
> > > > > TIA,
> > > > > ChrisR
> > > >
> > > >|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>> Start\ Programs\ there is no Configuration Tools option.
>> --
>> TIA,
>> ChrisR
>>
>> "burt_king" wrote:
>> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> > Configuration tool?
>> >
>> > "ChrisR" wrote:
>> >
>> > > I don't have a Configurations tab on the remote box... I just realized its
>> > > Beta2. Could this have sometihng to do with it?
>> > > --
>> > > TIA,
>> > > ChrisR
>> > >
>> > >
>> > > "Corey Bunch" wrote:
>> > >
>> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> > > >
>> > > > ChrisR wrote:
>> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> > > > > Management Studio, I try to register the remote one, and I get the message...
>> > > > >
>> > > > > A connection was successfully established to the server, but then an error
>> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> > > > > 10054)
>> > > > >
>> > > > > Any ideas?
>> > > > > --
>> > > > > TIA,
>> > > > > ChrisR
>> > > >
>> > > >|||And do what to the netlibs? I dont see anything like enable remote connections.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "ChrisR" wrote:
> >
> >> Start\ Programs\ there is no Configuration Tools option.
> >> --
> >> TIA,
> >> ChrisR
> >>
> >>
> >> "burt_king" wrote:
> >>
> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> > Configuration tool?
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> > > Beta2. Could this have sometihng to do with it?
> >> > > --
> >> > > TIA,
> >> > > ChrisR
> >> > >
> >> > >
> >> > > "Corey Bunch" wrote:
> >> > >
> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> > > >
> >> > > > ChrisR wrote:
> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> > > > >
> >> > > > > A connection was successfully established to the server, but then an error
> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> > > > > 10054)
> >> > > > >
> >> > > > > Any ideas?
> >> > > > > --
> >> > > > > TIA,
> >> > > > > ChrisR
> >> > > >
> >> > > >
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
>> Here
>> you can enable the netlibs.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
>> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
>> >
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "ChrisR" wrote:
>> >
>> >> Start\ Programs\ there is no Configuration Tools option.
>> >> --
>> >> TIA,
>> >> ChrisR
>> >>
>> >>
>> >> "burt_king" wrote:
>> >>
>> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> >> > Configuration tool?
>> >> >
>> >> > "ChrisR" wrote:
>> >> >
>> >> > > I don't have a Configurations tab on the remote box... I just realized its
>> >> > > Beta2. Could this have sometihng to do with it?
>> >> > > --
>> >> > > TIA,
>> >> > > ChrisR
>> >> > >
>> >> > >
>> >> > > "Corey Bunch" wrote:
>> >> > >
>> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> >> > > >
>> >> > > > ChrisR wrote:
>> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> >> > > > > Management Studio, I try to register the remote one, and I get the message...
>> >> > > > >
>> >> > > > > A connection was successfully established to the server, but then an error
>> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> >> > > > > 10054)
>> >> > > > >
>> >> > > > > Any ideas?
>> >> > > > > --
>> >> > > > > TIA,
>> >> > > > > ChrisR
>> >> > > >
>> >> > > >
>>|||Im going to reinstall with a more current version and see what happens.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
> the following folder structure:
> SQL Server Configuration Manager
> SQL Server 2005 Network Configuration
> Protocols for [instancename]
> In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> > And do what to the netlibs? I dont see anything like enable remote connections.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
> >> Here
> >> you can enable the netlibs.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> >> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> >> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >> >
> >> > --
> >> > TIA,
> >> > ChrisR
> >> >
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> >> Start\ Programs\ there is no Configuration Tools option.
> >> >> --
> >> >> TIA,
> >> >> ChrisR
> >> >>
> >> >>
> >> >> "burt_king" wrote:
> >> >>
> >> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> >> > Configuration tool?
> >> >> >
> >> >> > "ChrisR" wrote:
> >> >> >
> >> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> >> > > Beta2. Could this have sometihng to do with it?
> >> >> > > --
> >> >> > > TIA,
> >> >> > > ChrisR
> >> >> > >
> >> >> > >
> >> >> > > "Corey Bunch" wrote:
> >> >> > >
> >> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> >> > > >
> >> >> > > > ChrisR wrote:
> >> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> >> > > > >
> >> >> > > > > A connection was successfully established to the server, but then an error
> >> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> >> > > > > 10054)
> >> >> > > > >
> >> >> > > > > Any ideas?
> >> >> > > > > --
> >> >> > > > > TIA,
> >> >> > > > > ChrisR
> >> >> > > >
> >> >> > > >
> >>
> >>
>

cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message..
.
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message
..
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Erro
r:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:

> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
>|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
>|||How about Computer Manager, under Services, you should have some SQL Server
Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>|||And do what to the netlibs? I dont see anything like enable remote connectio
ns.
TIA,
ChrisR
"Tibor Karaszi" wrote:

> How about Computer Manager, under Services, you should have some SQL Serve
r Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections
/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
>|||Hard to know what your setup look like as you are on an older version (beta)
. On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable
it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connect
ions.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>

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
>

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,
> 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!!!
> >
> >
>|||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...
>> 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!!!
>> >
>> >
>>
>

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,
> 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[vbcol=seagreen]
>|||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
>

cant open databases folder

Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on???
Please email response to nkulshresh@.hotmail.com as well as posting to
group.

Thanks,
Navin[posted and mailed, please reply in news]

Navin Kulshreshtha (amador612@.hotmail.com) writes:
> Hello, I just installed SQL Server 2000 on my home computer and am
> connecting to a remote SQL server over the Internet. I can log into
> the server just fine and see 7 folders including the 'Databases'
> folder. I can open up all of the other 6 folders but for some crazy
> reason when I double click on the 'Databases' folder, I can't open it!
> The hourglass appears and Enterprise Manager basically locks up. Does
> anyone know what's going on???

It could be that autoclose is turned for one or more databasees. Connect
with Query Analyzer, and run an sp_help and check the options columns.

Also check that you have not enabled ODBC tracing on your machine.

> Please email response to nkulshresh@.hotmail.com as well as posting to
> group.

If you want replies to a certain address, please put it in the Reply-To
field of your posting.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can't manage a remote SQL Server

I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?
What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Can't manage a remote SQL Server

I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Can't manage a remote SQL Server

I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Can't make Remote Connection to SQL Cluster

Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.Hi Andy
Although I have never tried this I don't think there should be anything that
stops you doing it. How are you connecting to the Clustered instance
(connection string or SQLCMD command) ? Which protocol are you using/enabled
?
Which port is being used? Are there any firewalls? Is the name being
resolved/can you connect to the IP address?
John
"AndyT" wrote:

> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections ar
e
> enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>
>|||Have you tried connecting to one of the clustered instances from a node
within the cluster that currently does not currently own the SQL Server
instance (the so-called "passive") node? If that works, then I wonder if
there is a firewall rule between where you are and where the cluster is that
is preventing you from getting to the cluster. However, if you can't get to
SQL server from another node in the cluster, it suggests that SQL is not
listening for remote connections. Be sure to check the SQL Server error
log. It says what protocols it's actually listening on. Be sure to do a
tracert on the SQL Server virtual IP.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.|||Could be a firewall issue. When you connect to a cluster, it listens on the
virtual IP. Replies are sent from the regular IP address, according to the
packet headers. This drives some firewalls batty. See your network admin
about allowing the physical IP as well as the virtual one to have access
from the outside.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections
> are enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>

Can't make Remote Connection to SQL Cluster

Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.Hi Andy
Although I have never tried this I don't think there should be anything that
stops you doing it. How are you connecting to the Clustered instance
(connection string or SQLCMD command) ? Which protocol are you using/enabled?
Which port is being used? Are there any firewalls? Is the name being
resolved/can you connect to the IP address?
John
"AndyT" wrote:
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections are
> enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>
>|||Have you tried connecting to one of the clustered instances from a node
within the cluster that currently does not currently own the SQL Server
instance (the so-called "passive") node? If that works, then I wonder if
there is a firewall rule between where you are and where the cluster is that
is preventing you from getting to the cluster. However, if you can't get to
SQL server from another node in the cluster, it suggests that SQL is not
listening for remote connections. Be sure to check the SQL Server error
log. It says what protocols it's actually listening on. Be sure to do a
tracert on the SQL Server virtual IP.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.|||Could be a firewall issue. When you connect to a cluster, it listens on the
virtual IP. Replies are sent from the regular IP address, according to the
packet headers. This drives some firewalls batty. See your network admin
about allowing the physical IP as well as the virtual one to have access
from the outside.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections
> are enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>