error: copy database wizard

SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
ACCOUNT.
YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.
Hi,
Yes, The copy database wizard requires the write permissions in destination
server folder. So you should start the SQL Server in both the servers using
domain user which got write access to the destination server folder.
How to change the startup SQL server account:-
1. Go to Control Panel -- Admin tools -- Services
2, Double click MSSQL server services
3. Go to Log on option and change the start up account and password to a
domain user.
4. Do the same for both servers
5. restart both sql servers.
(I feel like you are starting SQL server in Local system account.)
Thanks
Hari
MCDBA
"new" <anonymous@.discussions.microsoft.com> wrote in message
news:a8ce01c4368d$098b76c0$a401280a@.phx.gbl...
> SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
> ACCOUNT.
> YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
> HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.

error: 0 - No process is on the other end of the pipe

I can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknji\sqlexpress.

I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code

string myConnectString = "Data Source=BKFNJI\\SQLEXPRESS;" +

"Initial Catalog=cmiCompatibilityDataBase" +

"Integrated Security=True;Pooling=False";

// specify SQL Server Specific Connection string

SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);

cmiDBCompConnection.Open();

when I attempt to run the apps, I get the

"System.Data.SqlClient.SqlException was unhandled
Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....

any idea what I am doing wrong, given that the connection string works using other means? I am using Windows authentication.

To add, the error in my log shows:

2007-03-17 21:10:55.82 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

Thanks,

Klaus

Seems although the server is expecting Windows Authentication, either no username was passed to the server internally or you are using a different connectionstring than the one posted above. Could you descrive your environment ? Are you in a domain, is the machine you are connecting from the same machine as the development machine ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error While DTS Execution from ASP

I ahve created a DTS package & was able to execute it
from backend but while trying to execute DTS Package
created in local Packages in sql client gets error.
Error Number 2147287038T
Error Description :The system cannot find the file
specified.
package Name :FSPETLISASUpload_DevServer1
Code used
set objDTSPackage = Server.CreateObject("DTS.Package")
on error resume next
objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
,
DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
rver1"
Response.Write err.number & err.Description
Thanks in advance
As a test you may want to try the script (change the obvious variables),
contained at the following link:
http://support.microsoft.com/default...b;en-us;252987
Steve
"Aparna" <nandi_aparna@.yahoo.com> wrote in message
news:02d201c49aa1$d1cef530$a401280a@.phx.gbl...
> I ahve created a DTS package & was able to execute it
> from backend but while trying to execute DTS Package
> created in local Packages in sql client gets error.
>
> Error Number 2147287038T
> Error Description :The system cannot find the file
> specified.
> package Name :FSPETLISASUpload_DevServer1
> Code used
> set objDTSPackage = Server.CreateObject("DTS.Package")
> on error resume next
> objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
> ,
> DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
> rver1"
> Response.Write err.number & err.Description
>
> Thanks in advance
>