Can't get it to listen on TCP port 1433

Been having SQL Server 2000 running for some time now, but recently it stopped listening on TCP port 1433, the log reports its listening on shared memory, Named pipes and Rpc, but no sign of 127.0.0.1 port 1433 or any errors to say why it won't listen.

I've done a netstat -na and nothing else is listening on that port, tried restarting using the enterprise manager, gonna try restarting the entire Server when everyone has gone home, but I'm pretty sure its been restarted recently.

All the other archive logs going back a few days show its not listening.

Yes, I have used the Server network utility to make sure TCP/IP is enabled and set to 1433, even added a comma and 1434 to see if it will listen on multiple ports, no go.

Any help?
What service pack do you have installed?|||Have you told your firewall to allow connections to Microsoft SQL Server?|||SQL Server 2000 - 8.00.194 build 3790 Service pack 1

Mmmm, isn't SP3 out?
Lets hope it doesn't break it even more, as after the restart of the entire server last night, its now not responding to TCP connections locally 127.0.0.1

Not sure about the firewall, I'll have to check, its been fine with it for the past few years.

|||

SP4 has been out for quite some time. Here is a handy web site which lists all of the hot fix and service packs which have been released http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx.

Start by upgrading to SQL 2000 SP4. Odds are a Windows 2000 hot fix shuts down SQL from talking over the net if prior to SP3 as there is a major security flaw prior to SP3 which the SQL Slammer worm expliots.

Can't find properties

This is the first time I've used SSRS. I've created a report and in preparation for deploying it I am trying to find where I set the properties. In Visual Studio 2005, in the Solution Explorer I right click on my .rdl file and select properties. The only properties listed are File Name (which is changeable) and File Path (which is not changeable). The property pages icon in the same dialog box is greyed out. Am I missing someghing? Any help would be greatly appreciated.

Thanks.

Go to the layout tab and try clicking on an area outside of the white area where you place your report objects. This should give you the report properties. Is that what you're looking for?

There is also a report properties dialog that will let you set most of the report properties. Go to the Report menu and select Report Properties. You have to have a report open in the designer for the Report menu to even be there.

|||

Thank you very much for the tip, I can see a number of properties of the report. However I still cannot find where to set the following properties

OverWriteDataSources:

TargetDataSourceFolder:

TargetRootFolder:

TargetServerURL:

I couldn't see these deployment properties where you pointed. Am I still missing something? Sorry if I seem kind of slow.

|||

These are properties of the report solution:

After you opened a report project, go to the VS Solution Explorer window. Right-click your report solution and select "Properties". The popup-dialog will contain the four properties you are looking for.

-- Robert

|||

Robert,

Thank you for the feed back. I've tried this many times now and I keep getting the same thing i.e. Open my project report, go to the VS Solution Explorer window under Reports I highlight the name of my report (Report1.rdl) right click on that report and I get a property window which only has two properties File Name: (which is editable) and File Path: (which is uneditable).

Do I possibly not have SSRS installed properly? This seems a simple thing but it is driving me crazy. Thanks for your help.

Bill

|||

Right-click on the root of the tree shown in the VS Solution Explorer. The root of the tree represents the entire report project - do not select a particular report.

-- Robert

|||

Robert,

Thank you so very much, I tried every level in the VS Solution Explorer BUT the root. Who would have thought! All of the documentation and tutorials were not as clear as your last note. Thank you again.

Bill

Can't Edit Table

Hello, I'm an undergrad who is using SQL Server 2005 for the first time. I have a table Components where there are three columns, ID, Name and Value, where ID and name are the composite key.

I have entered some data into it from the user interface and it is entered just fine. But when I try to edit data in Value column it can't be done. This error message comes...

"No Row was updated
The Data in Row 7 was not committed
Error source: Microsoft.VisualStudio.DataTools
Error Message: The Row value(s) updated or deleted either do not make the row unique or they alter multiple rows(3 rows).
Correct the errors and retry or press Esc to cancel change(s)."

The way I get it, does it say that it is being bound to VS.NET environment? I use it in my VB . NET programme. But I close every time that I open a connection. I'm positive about that. Then I tried, restarting the application, nothing happened! And then I closed Visual Studio .Net and even then nothing happened. And I'm getting very frustrated....

The funny thing is that, when I write a query using the SQL Pane of the SQL Server 2005 then, everything works perfectly. And I don't understand what this is...

I really appreciate if anyone can shed some light into me.
Thank You,
Prasad.

hi,

It seems that you are violation a primary key constraints,

If your using visual studio.net 2003 and later

a schema of the table is stored in the dataset for 2003

or other sqlclient objects of vsnet 2005.

A primary key constraints can be implemeted on these data layers(dataset.. and the likes)

And on the database.

what you can do.

1. Refresh the dataset schema (datatables.. etc) and other ado.net implementation

2. verify that your data is not violting pk on the database tables

hope it helps

|||

I am also getting the same message. I have been using 2000 for some time and this error does not make sense.

My table has no primary key or any relationship to another table. I created the table in the SSMSE and added records using ADO in VB6. I can not delete records and get the following message: "A Problem occurred attempting to delete row X. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(Y rows). Correct the errors and attempt to delete the row again or press ESC to cancel the changes(s)."

SQL will give me a very similar message if I try to edit a field in any of these rows.

Some rows SQL will allow me to edit or delete.

Any Ideas?

Peter

|||

Apparently this only effects SSMSE as a DELETE query issued from inside VB6 using an ODBC connection works flawlessly. This is the same DELETE query I issued using the Query designer in SSMSE.

Seems like a bug in SSMSE.

Peter

|||Suppose you have two identical rows in your table, where column X has the value 7. The query DELETE FROM yourTable WHERE X = 7 will delete both of these rows, and there will be no error. Now suppose you open the table in SSMS and try to delete just one of these rows (or edit just one of them). You will get an error, because there no DELETE (or update) statement is possible to modify just one of two identical rows.

Even without identical rows you may get this error when there is no primary key on the table. The position of a row in the visual editor is not an intrinsic property of the data in the table, and the only modifications you can make to a table are those that can be written as queries with conditions that depend on the column values in the table. A task like "delete the third row" does not correspond to a delete query unless some set of column values unambiguously describes the third row (in other words, unless there is a key). The row number as the table appears in the visual editor is not a table column, so it can't be the sole property used to identify the row to be deleted.

Steve Kass
Drew University|||

I did write a query:

DELETE FROM SalesData WHERE Sequence = 5;

This should have deleted any rows where the Sequence Column is equal to 5. This query did not work in SSMSE when the rows where the Sequence was equal to 5 are identical. My understanding is any rows with a Sequence of 5 should be deleted. This works from VB6 and will not work in the query designer under SSMSE.

Maybe there is some interpretation going on when I select the 7th row in the SSMSE GUI and it tries to delete the rows one at a time and cannot do this since the rows are not unique. The SSMSE query designer should work the same as a Query from VB6 shouldn't it?

SalesData:
Seq Name ID
5 Tom A
5 Tom A
6 Bob B
6 Bob C

These do not work from within SSMSE using wither the GUI or the Query designer and DO work from VB6:

DELETE FROM SalesData WHERE Seq = 5;
DELETE FROM SalesData WHERE Seq = 5 AND ID = 'A';
DELETE FROM SalesData;

These work as expected:

DELETE FROM SalesData WHERE Seq = 6;
DELETE FROM SalesData WHERE Seq = 6 AND ID = 'B';

Peter House

|||

Hi there

got the same problem. Did you manage to solve it?

regards

Michael J

|||

Michael,

I did solve the problem - sort of. Apparently this is an issue with the SQL Management Studio environment. I could do the same exact query from within a VB program or MS Access Query and they would work correctly while the query would not work in the Management Studio.

I have not experienced this problem in a while and use the Management Studio Interface a lot with both the Express and Standard versions.

Peter

|||

Peter

I first experienced it now and I have had ss05 for 5 month and used the feature a lot. But as you say. One can do without it and hope that it resolves.....

Thanks for your reply!

Michael

sql

Can't Edit Table

Hello, I'm an undergrad who is using SQL Server 2005 for the first time. I have a table Components where there are three columns, ID, Name and Value, where ID and name are the composite key.

I have entered some data into it from the user interface and it is entered just fine. But when I try to edit data in Value column it can't be done. This error message comes...

"No Row was updated
The Data in Row 7 was not committed
Error source: Microsoft.VisualStudio.DataTools
Error Message: The Row value(s) updated or deleted either do not make the row unique or they alter multiple rows(3 rows).
Correct the errors and retry or press Esc to cancel change(s)."

The way I get it, does it say that it is being bound to VS.NET environment? I use it in my VB . NET programme. But I close every time that I open a connection. I'm positive about that. Then I tried, restarting the application, nothing happened! And then I closed Visual Studio .Net and even then nothing happened. And I'm getting very frustrated....

The funny thing is that, when I write a query using the SQL Pane of the SQL Server 2005 then, everything works perfectly. And I don't understand what this is...

I really appreciate if anyone can shed some light into me.
Thank You,
Prasad.

hi,

It seems that you are violation a primary key constraints,

If your using visual studio.net 2003 and later

a schema of the table is stored in the dataset for 2003

or other sqlclient objects of vsnet 2005.

A primary key constraints can be implemeted on these data layers(dataset.. and the likes)

And on the database.

what you can do.

1. Refresh the dataset schema (datatables.. etc) and other ado.net implementation

2. verify that your data is not violting pk on the database tables

hope it helps

|||

I am also getting the same message. I have been using 2000 for some time and this error does not make sense.

My table has no primary key or any relationship to another table. I created the table in the SSMSE and added records using ADO in VB6. I can not delete records and get the following message: "A Problem occurred attempting to delete row X. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(Y rows). Correct the errors and attempt to delete the row again or press ESC to cancel the changes(s)."

SQL will give me a very similar message if I try to edit a field in any of these rows.

Some rows SQL will allow me to edit or delete.

Any Ideas?

Peter

|||

Apparently this only effects SSMSE as a DELETE query issued from inside VB6 using an ODBC connection works flawlessly. This is the same DELETE query I issued using the Query designer in SSMSE.

Seems like a bug in SSMSE.

Peter

|||Suppose you have two identical rows in your table, where column X has the value 7. The query DELETE FROM yourTable WHERE X = 7 will delete both of these rows, and there will be no error. Now suppose you open the table in SSMS and try to delete just one of these rows (or edit just one of them). You will get an error, because there no DELETE (or update) statement is possible to modify just one of two identical rows.

Even without identical rows you may get this error when there is no primary key on the table. The position of a row in the visual editor is not an intrinsic property of the data in the table, and the only modifications you can make to a table are those that can be written as queries with conditions that depend on the column values in the table. A task like "delete the third row" does not correspond to a delete query unless some set of column values unambiguously describes the third row (in other words, unless there is a key). The row number as the table appears in the visual editor is not a table column, so it can't be the sole property used to identify the row to be deleted.

Steve Kass
Drew University
|||

I did write a query:

DELETE FROM SalesData WHERE Sequence = 5;

This should have deleted any rows where the Sequence Column is equal to 5. This query did not work in SSMSE when the rows where the Sequence was equal to 5 are identical. My understanding is any rows with a Sequence of 5 should be deleted. This works from VB6 and will not work in the query designer under SSMSE.

Maybe there is some interpretation going on when I select the 7th row in the SSMSE GUI and it tries to delete the rows one at a time and cannot do this since the rows are not unique. The SSMSE query designer should work the same as a Query from VB6 shouldn't it?

SalesData:
Seq Name ID
5 Tom A
5 Tom A
6 Bob B
6 Bob C

These do not work from within SSMSE using wither the GUI or the Query designer and DO work from VB6:

DELETE FROM SalesData WHERE Seq = 5;
DELETE FROM SalesData WHERE Seq = 5 AND ID = 'A';
DELETE FROM SalesData;

These work as expected:

DELETE FROM SalesData WHERE Seq = 6;
DELETE FROM SalesData WHERE Seq = 6 AND ID = 'B';

Peter House

|||

Hi there

got the same problem. Did you manage to solve it?

regards

Michael J

|||

Michael,

I did solve the problem - sort of. Apparently this is an issue with the SQL Management Studio environment. I could do the same exact query from within a VB program or MS Access Query and they would work correctly while the query would not work in the Management Studio.

I have not experienced this problem in a while and use the Management Studio Interface a lot with both the Express and Standard versions.

Peter

|||

Peter

I first experienced it now and I have had ss05 for 5 month and used the feature a lot. But as you say. One can do without it and hope that it resolves.....

Thanks for your reply!

Michael

can't drop user, owns objects

I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ...
"the user owns objects in the database and cannot be dropped."
then a list of the objects (EG TMP_SYSA_1234) is displayed.
How can I delete these objects? I assume then I will be able to delete the
user and recreate him.
On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> I migrated copies of a database to a test server, but I cannot log on. My
> admin account needs to be dropped and readded but every time I run
> sp_dropuser in query analyzer I get the error :
> Msg 15183, level 16, state 1, ...
> "the user owns objects in the database and cannot be dropped."
> then a list of the objects (EG TMP_SYSA_1234) is displayed.
> How can I delete these objects? I assume then I will be able to delete the
> user and recreate him.
Hi,
You're perfectly right... This error means that some objects are still
owned by this user.
In order to drop each object, you will first need to know what kind of
objects are owned by the user you would like to delete. Then, you'll
be able to run the correct drop commands in the query analyser...
As an example, here are some usual drop commands :
DROP TABLE [schema].[Table name]
DROP VIEW [schema].[View name]
DROP PROCEDURE [schema].[Procedure name]
...
Whenever all the objects owned will be dropped, you'll be able to use
the sp_dropuser procedure.
Hope this helps,
Cdric Del Nibbio
MCTS SQL Server 2005
MCSD .NET
MCT
http://cedric-delnibbio-sql.blogspot.com
|||thank you, Cedric
"Cédric Del Nibbio" wrote:

> On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> Hi,
> You're perfectly right... This error means that some objects are still
> owned by this user.
> In order to drop each object, you will first need to know what kind of
> objects are owned by the user you would like to delete. Then, you'll
> be able to run the correct drop commands in the query analyser...
> As an example, here are some usual drop commands :
> DROP TABLE [schema].[Table name]
> DROP VIEW [schema].[View name]
> DROP PROCEDURE [schema].[Procedure name]
> ...
> Whenever all the objects owned will be dropped, you'll be able to use
> the sp_dropuser procedure.
> Hope this helps,
> Cédric Del Nibbio
> MCTS SQL Server 2005
> MCSD .NET
> MCT
> http://cedric-delnibbio-sql.blogspot.com
>

can't drop user, owns objects

I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ...
"the user owns objects in the database and cannot be dropped."
then a list of the objects (EG TMP_SYSA_1234) is displayed.
How can I delete these objects? I assume then I will be able to delete the
user and recreate him.On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> I migrated copies of a database to a test server, but I cannot log on. My
> admin account needs to be dropped and readded but every time I run
> sp_dropuser in query analyzer I get the error :
> Msg 15183, level 16, state 1, ...
> "the user owns objects in the database and cannot be dropped."
> then a list of the objects (EG TMP_SYSA_1234) is displayed.
> How can I delete these objects? I assume then I will be able to delete the
> user and recreate him.
Hi,
You're perfectly right... This error means that some objects are still
owned by this user.
In order to drop each object, you will first need to know what kind of
objects are owned by the user you would like to delete. Then, you'll
be able to run the correct drop commands in the query analyser...
As an example, here are some usual drop commands :
DROP TABLE [schema].[Table name]
DROP VIEW [schema].[View name]
DROP PROCEDURE [schema].[Procedure name]
.=2E.
Whenever all the objects owned will be dropped, you'll be able to use
the sp_dropuser procedure.
Hope this helps,
C=E9dric Del Nibbio
MCTS SQL Server 2005
MCSD .NET
MCT
http://cedric-delnibbio-sql.blogspot.com|||thank you, Cedric
"Cédric Del Nibbio" wrote:

> On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> Hi,
> You're perfectly right... This error means that some objects are still
> owned by this user.
> In order to drop each object, you will first need to know what kind of
> objects are owned by the user you would like to delete. Then, you'll
> be able to run the correct drop commands in the query analyser...
> As an example, here are some usual drop commands :
> DROP TABLE [schema].[Table name]
> DROP VIEW [schema].[View name]
> DROP PROCEDURE [schema].[Procedure name]
> ...
> Whenever all the objects owned will be dropped, you'll be able to use
> the sp_dropuser procedure.
> Hope this helps,
> Cédric Del Nibbio
> MCTS SQL Server 2005
> MCSD .NET
> MCT
> http://cedric-delnibbio-sql.blogspot.com
>sql

Can't create Merge Publication

I have been trying for some time to create a Merge publication in SQL Server. I'm running SQL Server 2000 Standard Edition with the latest service pack on a Win2k3 Server. It doesn't seem to matter what replication-enabled database or which table I select
, I always get the same error at the end of the create publication wizard in Enterprise Mgr: "Error 2758 RAISERROR could not locate entry for error 21423 in sysmessages. Object 'pubs' (note: or whatever db I select) does not exist or is not a valid object
for this operation."
Any ideas here?
Corey - possibly this is an incomplete service pack install as some messages
in sysmessages are missing. You could have a look at sqlsp.log file from the
c:\windows directory which might shed some light on any failed actions
during the sp installation. Even if there isn't anything enlightening there
I'd reapply the sp3a.
HTH,
Paul Ibison
|||Thanks, Paul, but so far no luck. I dug through the log and didn't find anything all that revealing. I also re-applied SP3a, but that didn't help either. Still searching...
"Paul Ibison" wrote:

> Corey - possibly this is an incomplete service pack install as some messages
> in sysmessages are missing. You could have a look at sqlsp.log file from the
> c:\windows directory which might shed some light on any failed actions
> during the sp installation. Even if there isn't anything enlightening there
> I'd reapply the sp3a.
> HTH,
> Paul Ibison
>
>
|||Corey,
in htis case you could rebuild the master database or alternatively just add
the missing messages. To do the latter you'll need to create a linked server
to another server that has a complete master database and join to that table
(left outer join) to find the missing messages in sysmessages.
HTH,
Paul Ibison

Can't create a once existed database with its name

Hello, there,
Some time ago, there was a database with a name sts_servername_1.
God knows what I did, but it's now gone. I most probably have deleted it, or
maybe detached and never reatached. The fact is, I don't care about it and
its data anymore. I want it gone. There are no files of it anywhere. I just
want to create a new blank database with a same name.
And I can't. It says "database already exists". But running sp_databases
doesn't show it. Also if I try to "drop database" it says there's no such
database in the system catalogue. Could you please help me do something?
Thanks,
Mantvydas
hi Mantvydas,
Mantvydas wrote:
> Hello, there,
> Some time ago, there was a database with a name sts_servername_1.
> God knows what I did, but it's now gone. I most probably have deleted
> it, or maybe detached and never reatached. The fact is, I don't care
> about it and its data anymore. I want it gone. There are no files of
> it anywhere. I just want to create a new blank database with a same
> name.
> And I can't. It says "database already exists". But running
> sp_databases doesn't show it. Also if I try to "drop database" it
> says there's no such database in the system catalogue. Could you
> please help me do something?
> Thanks,
> Mantvydas
it sometimes happens that db names become '', thats' to say the relative
column [name] have been cleared... o not ask why.. I do not know...
try executing
SELECT * FROM master..sysdatabases
and see if you have an entry with [name] = ''
if this is the case, verify qhet the [filename] colum reports... that's the
physical data file to which the '' db points to..
rename the database accordingly and verify everithings ok
(http://msdn.microsoft.com/library/de..._dbcc_00gy.asp)
eventually drop the db
(http://msdn.microsoft.com/library/de...de-dz_82lh.asp)
if this is a viable solution...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

can't connect to SQLCMD

dear sirits my first time to work with SQL server 2005

i've installed it and tried to connect to sqlcmd by :

run sqlcmd

i got errors

after that i logged to the database engine normally and created new database and tried again to relogin to the database engine but i failed and faced error:4064

i have three points needed to be answered :

1- SQLCMD loin problem

2- database engine error:4064

3- i need to import .mdb file to my new database

regards

1. See your post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=671937&SiteID=1&mode=1
2. The user you are currently trying to login with does not have the appropiate permissions to the assigned default database or the database does not exist anymore. To solve this issue you can login with a priviledged account and change the default database of the user to a valid / granted one via the GUI or the proc sp_defaultdb.
3. Attach the database to your server and use the import wizrad to transfer the objects to the new database. You can also access the objects using the three part name notation like

SELECT * FROM DatabaseName.SchemaName.ObjectName

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Cant connect SQL2K named instance using OLE DB

Hi,

I am having a hard time trying to connect to a remote SQL Server 2000 named
instance using an OLE DB connection, the computer I am trying to connect
from has SQL Server 7 installed, but MDAC 2.6 SP1 (which should be
sufficient?). Errormsg below:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/asp/test.asp, line 5

The remote server is listening on TCP/IP, port 1434

I am using a sql-login. The remote server is in mixed mode.

I've tried connect using Query Analyzer in order to troubleshoot the
problem, and came to the following conclusion:

- If i add an alias for the server in Client Network Configuration,
and configure the connection to use TCP/IP, 1434, then I'm able to
connect to the remote server using Query Analyzer. However,
my asp-page still won't work.

- If i don't add an alias, but run Client Network Utility and add
TCP/IP (port 1434) as first protocol, and Named Pipes second
protocol... then I am not able to connect using Query Analyzer or
the asp-page. How come?

The code in test.asp looks like this:
<%
dim objC
dim rs
Set objC = Server.CreateObject("ADODB.Connection")
objC.Open "Provider='SQLOLEDB.1';" & _
"Persist Security Info=True;" & _
"User ID='myusername';" & _
"Password='mypassword';" & _
"Initial Catalog=mydatabase;" & _
"Server=REMOTESERVER\INSTANCE;" & _
"Data source=REMOTE SERVER\INSTANCE"
objC.Execute "SELECT * FROM [dbo].[EverybodyListens_Employee] WHERE CGid =
'aviklund'"
%>

Some rows of the code above are wrapped.
REMOTESERVER is the remote server,
and INSTANCE is the instance name.

Thanks!

// BjrnThis http://msdn.microsoft.com/isapi/gosupport.asp?Target=/support/kb/articles/Q169/3/77.asp (KB Article) gives much insight to resolve the issue.

HTH

can't connect server

I'm using light free version of SQL server 2005 and

Express Manager , until this time everything was OK. But now I cant using it , I cant connect the server (using windows connection) .

That is error alert:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Does anybody know where is problem?

Have a look in the screencast section on my site, especially the Screencast "enable remote connections"

That should help, feel free to comment about that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanx for link, but things don't changed(

I'm programming on C#, then compiler get on conn.Open() it shows an exeption:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Where is the problem?

|||OK, first make sure that the service is started properly on the machine which is named in the connectionstring. Could it be that there are any firewalls blocking the communication ? YOu will have to open port 1433 and 1434 for a proper established communiation if you have choosen the default port. If you did not choose the above mentioned default ports you will have to open them in the firewall and if you don′t have SQL Browser started as a service on your machine (which is a sort of discovery mechanism for the clients connecting to SQL Server) name the port after the Servername\instanceName combination. Thats the next part which will lead me to the question if you have a default instance or a named instance. default instances are normally only represented by the machinename they are running on, named instances have the instance name appended in the following format Servname\InstanceName. If you additionally don′t have browser started (as mentioned above the name combination would be something like ServerName\InstanceName,Portnumber)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de