I'm running SQL Server 2000 on a Windows Server 2003 machine. We have sp3 o
n
SQL. I am getting an error when I query against my views. The views use a
linked server that grabs data from FoxPro dbf files located on the same
machine.
In resolving a memory issue, we disabled the 'Allow InProcess' setting on
the OLE DB for ODBC Drivers provider. I don't think this has anything to do
w/ the access denied error because I enabled 'Allow InProcess' to test it an
d
then disabled again when I got the error.
The error message is:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface
returned 0x80070005: Access denied.].
The account is a domain account that is part of the administrators group on
the server. It is also a System Administrator role in SQL.
Any help is appreciated. Thanks, PhilPhil,
The obvious things to check are that the account running SQL Server
(which is likely not your Windows account) has the proper permissions
on the files in question, and that you are referring to them in a way that
is correct for that account (not using a drive letter defined at logon for
your own Windows account, for example)
Next, you could try a different way of accessing the linked server data.
Try an alternative among the 4-part name lnksrv.database.owner.table,
OpenQuery, OpenRowSet, or OpenDataSource. If there is another
provider besides MSDASQL, try it.
Beyond that, unfortunately, most newsgroup threads with this question
end with
no resolution. :( My best guess is to try adding this registry key,
though I'm not
certain this works for an arbitrary provider.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Providers\MSDASQL\Disallow
AdhocAccess
Make this a REG_DWORD with value 0.
Here is a link to a few dozen newsgroup threads on this issue - maybe
you'll find something.
http://groups-beta.google.com/group...rface+sqlserver
If you resolve this problem, please let us know!
Steve Kass
Drew University
phil wrote:
>I'm running SQL Server 2000 on a Windows Server 2003 machine. We have sp3
on
>SQL. I am getting an error when I query against my views. The views use a
>linked server that grabs data from FoxPro dbf files located on the same
>machine.
>In resolving a memory issue, we disabled the 'Allow InProcess' setting on
>the OLE DB for ODBC Drivers provider. I don't think this has anything to d
o
>w/ the access denied error because I enabled 'Allow InProcess' to test it a
nd
>then disabled again when I got the error.
>The error message is:
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDASQL' reported an error. Access denied.
>OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface
>returned 0x80070005: Access denied.].
>The account is a domain account that is part of the administrators group on
>the server. It is also a System Administrator role in SQL.
>Any help is appreciated. Thanks, Phil
>
>|||Well, I resolved this issue by selecting 'Allow InProcess' for the OLE DB
Provider for ODBC Drivers. However, I had deselected this setting to correc
t
a memory issue I am having. Now, I'm looking to resolve that a different
way. (argh.)
- Phil
"Steve Kass" wrote:
> Phil,
> The obvious things to check are that the account running SQL Server
> (which is likely not your Windows account) has the proper permissions
> on the files in question, and that you are referring to them in a way that
> is correct for that account (not using a drive letter defined at logon for
> your own Windows account, for example)
> Next, you could try a different way of accessing the linked server data.
> Try an alternative among the 4-part name lnksrv.database.owner.table,
> OpenQuery, OpenRowSet, or OpenDataSource. If there is another
> provider besides MSDASQL, try it.
> Beyond that, unfortunately, most newsgroup threads with this question
> end with
> no resolution. :( My best guess is to try adding this registry key,
> though I'm not
> certain this works for an arbitrary provider.
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Providers\MSDASQL\Disall
owAdhocAccess
> Make this a REG_DWORD with value 0.
> Here is a link to a few dozen newsgroup threads on this issue - maybe
> you'll find something.
> http://groups-beta.google.com/group...rface+sqlserver
> If you resolve this problem, please let us know!
> Steve Kass
> Drew University
> phil wrote:
>
>|||An alternative solution is to use the -g switch, which we may pursue. This
is explained in BOL. - Phil
"phil" wrote:
> Well, I resolved this issue by selecting 'Allow InProcess' for the OLE DB
> Provider for ODBC Drivers. However, I had deselected this setting to corr
ect
> a memory issue I am having. Now, I'm looking to resolve that a different
> way. (argh.)
> - Phil
>
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Access database from a different server
Hi,
i want to know, is it possible to access a database that is not on the local machine ?
what if i want to access a databse that resides on another of my websites (on a different server) ?
can any one help ?As long as the other server is set up as a linked server in sql:
select * from servername.database.dbo.table
i want to know, is it possible to access a database that is not on the local machine ?
what if i want to access a databse that resides on another of my websites (on a different server) ?
can any one help ?As long as the other server is set up as a linked server in sql:
select * from servername.database.dbo.table
Thursday, March 22, 2012
Access AS400 DB2 in SQL Server
Hi,
Im finding the way of connecting to DB 2 database which is exixst in the AS400
machine to do some data manupulation.Please attach the SQL cording.
Thanks
Pubudu
You can try any kind of odbc drivers, for example, RUMBA ODBC Drivers
http://www.netmanage.com/customers/stories/lear.asp
it works
sqlTuesday, March 20, 2012
Access 2003 / SQL Server 2005 linking.
I have an Access 2003 database that I have split, then upsized to SQL Server
2005. The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following 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.
Now I have done everything suggested by Microsoft's documentation
(http://support.microsoft.com/default.aspx/kb/914277), including setting the
SQL Server Surface Area Configuration tool and modifying the firewall
settings.
Does anyone have any other suggestions I can try?
(I think the problem may be in my dsn file, but I am not sure.)
Larry J. West, MCSD, MOUS, FLMI, ACS
Same error I was getting.
My problem was caused by an alias set up in client network utility to the
server.
I just deleted the alias and then Access connected fine.
Gary
"LarryWestMCSD" wrote:
> I have an Access 2003 database that I have split, then upsized to SQL Server
> 2005. The database works find on the machine that has the SQL Server 2005,
> but when I try to run the program from another machine on the network, I get
> the following 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.
> Now I have done everything suggested by Microsoft's documentation
> (http://support.microsoft.com/default.aspx/kb/914277), including setting the
> SQL Server Surface Area Configuration tool and modifying the firewall
> settings.
> Does anyone have any other suggestions I can try?
> (I think the problem may be in my dsn file, but I am not sure.)
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS
2005. The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following 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.
Now I have done everything suggested by Microsoft's documentation
(http://support.microsoft.com/default.aspx/kb/914277), including setting the
SQL Server Surface Area Configuration tool and modifying the firewall
settings.
Does anyone have any other suggestions I can try?
(I think the problem may be in my dsn file, but I am not sure.)
Larry J. West, MCSD, MOUS, FLMI, ACS
Same error I was getting.
My problem was caused by an alias set up in client network utility to the
server.
I just deleted the alias and then Access connected fine.
Gary
"LarryWestMCSD" wrote:
> I have an Access 2003 database that I have split, then upsized to SQL Server
> 2005. The database works find on the machine that has the SQL Server 2005,
> but when I try to run the program from another machine on the network, I get
> the following 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.
> Now I have done everything suggested by Microsoft's documentation
> (http://support.microsoft.com/default.aspx/kb/914277), including setting the
> SQL Server Surface Area Configuration tool and modifying the firewall
> settings.
> Does anyone have any other suggestions I can try?
> (I think the problem may be in my dsn file, but I am not sure.)
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS
Access 2003 / SQL Server 2005 linking.
I have an Access 2003 database that I have split, then upsized to SQL Server
2005. The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following 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.
Now I have done everything suggested by Microsoft's documentation
(http://support.microsoft.com/default.aspx/kb/914277), including setting the
SQL Server Surface Area Configuration tool and modifying the firewall
settings.
Does anyone have any other suggestions I can try?
(I think the problem may be in my dsn file, but I am not sure.)
--
Larry J. West, MCSD, MOUS, FLMI, ACSSame error I was getting.
My problem was caused by an alias set up in client network utility to the
server.
I just deleted the alias and then Access connected fine.
Gary
"LarryWestMCSD" wrote:
> I have an Access 2003 database that I have split, then upsized to SQL Serv
er
> 2005. The database works find on the machine that has the SQL Server 2005
,
> but when I try to run the program from another machine on the network, I g
et
> the following 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.
> Now I have done everything suggested by Microsoft's documentation
> (http://support.microsoft.com/default.aspx/kb/914277), including setting t
he
> SQL Server Surface Area Configuration tool and modifying the firewall
> settings.
> Does anyone have any other suggestions I can try?
> (I think the problem may be in my dsn file, but I am not sure.)
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS
2005. The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following 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.
Now I have done everything suggested by Microsoft's documentation
(http://support.microsoft.com/default.aspx/kb/914277), including setting the
SQL Server Surface Area Configuration tool and modifying the firewall
settings.
Does anyone have any other suggestions I can try?
(I think the problem may be in my dsn file, but I am not sure.)
--
Larry J. West, MCSD, MOUS, FLMI, ACSSame error I was getting.
My problem was caused by an alias set up in client network utility to the
server.
I just deleted the alias and then Access connected fine.
Gary
"LarryWestMCSD" wrote:
> I have an Access 2003 database that I have split, then upsized to SQL Serv
er
> 2005. The database works find on the machine that has the SQL Server 2005
,
> but when I try to run the program from another machine on the network, I g
et
> the following 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.
> Now I have done everything suggested by Microsoft's documentation
> (http://support.microsoft.com/default.aspx/kb/914277), including setting t
he
> SQL Server Surface Area Configuration tool and modifying the firewall
> settings.
> Does anyone have any other suggestions I can try?
> (I think the problem may be in my dsn file, but I am not sure.)
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS
Sunday, March 11, 2012
Accesing database after website deployment
Hi
I'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.
After web site deployment I get allways message : Failed to update database "c:\app\app.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.
I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".
TIA
Paul
To manipulate the database file, the account used to connect to the database must have read/write permission on the folder where the database file locates.|||Do you get other error message? I guess the problem is permission.|||
Hi
I think the problem is when I use SourceSafe, all folders in projects are maded read only.
Sometimes I get some error about NT Serveces does not have right on database, but that eror I have fised from SQL .
Paul
I agree with you.You should add NT Service to access some folders in security.Change your database file property not to readonly.
accent insensitive search and SPS
What about this?
http://www.cfgigolo.com/unsorted/fts..._sensitive.txt
I don't need to run SPS and SQL 2K on the same machine so it would be no
problem to overwrite MSSearch
Is it safe to do it?
Thanks
Matias
The binaries for the version of MSSearch which ships Sharepoint 2003 are
radically different from the ones which ship with SQL 2000 FTS. I would not
advise you to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Matias Woloski" <woloski@.NOSPAMsion.com> wrote in message
news:u%235VxECVFHA.3760@.TK2MSFTNGP15.phx.gbl...
> What about this?
> http://www.cfgigolo.com/unsorted/fts..._sensitive.txt
> I don't need to run SPS and SQL 2K on the same machine so it would be no
> problem to overwrite MSSearch
> Is it safe to do it?
> Thanks
> Matias
>
http://www.cfgigolo.com/unsorted/fts..._sensitive.txt
I don't need to run SPS and SQL 2K on the same machine so it would be no
problem to overwrite MSSearch
Is it safe to do it?
Thanks
Matias
The binaries for the version of MSSearch which ships Sharepoint 2003 are
radically different from the ones which ship with SQL 2000 FTS. I would not
advise you to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Matias Woloski" <woloski@.NOSPAMsion.com> wrote in message
news:u%235VxECVFHA.3760@.TK2MSFTNGP15.phx.gbl...
> What about this?
> http://www.cfgigolo.com/unsorted/fts..._sensitive.txt
> I don't need to run SPS and SQL 2K on the same machine so it would be no
> problem to overwrite MSSearch
> Is it safe to do it?
> Thanks
> Matias
>
Thursday, March 8, 2012
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.
I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.
|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>
|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.
I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.
|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>
|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> > Installed SQL2005 Advisor on a XP Professional machine.
> >
> > I get this message when I launch the program.
> >
> > Absolute path information is required. (mscorlib)
> >
> > Please help, I need to resolve it.
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
--
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>> I did a quick search and could not find that exact error msg but it looks
>> like a problem with the .net framework install. You might try
>> uninstalling
>> the .net framework and reinstalling it. Make sure you are using the
>> latest
>> version of the Advisor tool and the latest .net2.0 framework, not any
>> Betas.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in
>> message
>> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>> > Installed SQL2005 Advisor on a XP Professional machine.
>> >
>> > I get this message when I launch the program.
>> >
>> > Absolute path information is required. (mscorlib)
>> >
>> > Please help, I need to resolve it.
>>
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> > Installed SQL2005 Advisor on a XP Professional machine.
> >
> > I get this message when I launch the program.
> >
> > Absolute path information is required. (mscorlib)
> >
> > Please help, I need to resolve it.
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
--
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>> I did a quick search and could not find that exact error msg but it looks
>> like a problem with the .net framework install. You might try
>> uninstalling
>> the .net framework and reinstalling it. Make sure you are using the
>> latest
>> version of the Advisor tool and the latest .net2.0 framework, not any
>> Betas.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in
>> message
>> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>> > Installed SQL2005 Advisor on a XP Professional machine.
>> >
>> > I get this message when I launch the program.
>> >
>> > Absolute path information is required. (mscorlib)
>> >
>> > Please help, I need to resolve it.
>>
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the lates
t
> version of the Advisor tool and the latest .net2.0 framework, not any Beta
s.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in messag
e
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the lates
t
> version of the Advisor tool and the latest .net2.0 framework, not any Beta
s.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in messag
e
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>
Friday, February 24, 2012
about SQL mail
I want to try SQL mail function in my machine but I can't get it works.
information about my machine:
OS: windows 2000 as a workgroup
sql 2000
office 2000 (also tried office xp)
the mail was sent to my outlook
when I try parameter TYPE with IPC, I got it work but only once. later I
can't get it work. I don't know why.
I don't know how to set up TYPE.
THANKS,
TOMThank you Tony,
I downloaded that file but I don't know how to use it. Could you give me
more information about it?
thanks,
Tom Li
"Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> If you just want to send mails from SQL Server then forget about using
MAPI
> etc... and download the xp_smtp_sendmail extended stored procedure from
> sqldev.net, so long as you have an SMTP server then it will work and its
> really good!
> --
> Tony Rogerson
> SQL Server MVP
> http://www.sqlserverfaq.com?mbr=21
> (Create your own groups, Forum, FAQ's and a ton more)
>|||Hi
Usage is described with example on the download page.
http://www.sqldev.net/xp/xpsmtp.htm
What is your particular problem?
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> Thank you Tony,
> I downloaded that file but I don't know how to use it. Could you give me
> more information about it?
> thanks,
> Tom Li
> "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > If you just want to send mails from SQL Server then forget about using
> MAPI
> > etc... and download the xp_smtp_sendmail extended stored procedure from
> > sqldev.net, so long as you have an SMTP server then it will work and its
> > really good!
> >
> > --
> > Tony Rogerson
> > SQL Server MVP
> > http://www.sqlserverfaq.com?mbr=21
> > (Create your own groups, Forum, FAQ's and a ton more)
> >
> >
>|||Hi Tom,
Its best to read through the instructions supplied on the site - there are a
lot of examples - just follow them through.
Tony.
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)|||Sorry Sir,
I saw there are two procedure names in the code, xp_smtp_sendmail and
sp_smtp_sendmail. I have no experience of creating stored procedure. so that
may be a stupid question.
And we may be in different location with different time zone. Are you in the
States. I am in China.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uT7pfHNYDHA.2152@.TK2MSFTNGP09.phx.gbl...
> > I found out that the procedure has different name in the file. Please
see
> > attached file.
> I'm still not clear what the problem is. Also, can you please fix your
> system clock.
>|||Thanks John,
I don't know how to use it after I downloaded xp_smtp_sendmail procedure.
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> Hi
> Usage is described with example on the download page.
> http://www.sqldev.net/xp/xpsmtp.htm
> What is your particular problem?
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > Thank you Tony,
> >
> > I downloaded that file but I don't know how to use it. Could you give me
> > more information about it?
> >
> > thanks,
> >
> > Tom Li
> >
> > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > If you just want to send mails from SQL Server then forget about using
> > MAPI
> > > etc... and download the xp_smtp_sendmail extended stored procedure
from
> > > sqldev.net, so long as you have an SMTP server then it will work and
its
> > > really good!
> > >
> > > --
> > > Tony Rogerson
> > > SQL Server MVP
> > > http://www.sqlserverfaq.com?mbr=21
> > > (Create your own groups, Forum, FAQ's and a ton more)
> > >
> > >
> >
> >
>|||Hi
On http://www.sqldev.net/xp/xpsmtp.htm there is section called installation
which details how to install the extended stored procedure. The other
examples of how to call the extended stored procedure can be cut and pasted
into query analyser... but at a guess you have MSDE, in which case paste an
example into a text editor and save the file to run from osql. If you do
have MSDE then you may want to look at
http://www.aspfaq.com/show.asp?id=2442
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> Thanks John,
> I don't know how to use it after I downloaded xp_smtp_sendmail procedure.
> Tom
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > Hi
> >
> > Usage is described with example on the download page.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> > What is your particular problem?
> >
> > John
> >
> >
> > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > Thank you Tony,
> > >
> > > I downloaded that file but I don't know how to use it. Could you give
me
> > > more information about it?
> > >
> > > thanks,
> > >
> > > Tom Li
> > >
> > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > If you just want to send mails from SQL Server then forget about
using
> > > MAPI
> > > > etc... and download the xp_smtp_sendmail extended stored procedure
> from
> > > > sqldev.net, so long as you have an SMTP server then it will work and
> its
> > > > really good!
> > > >
> > > > --
> > > > Tony Rogerson
> > > > SQL Server MVP
> > > > http://www.sqlserverfaq.com?mbr=21
> > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi, John
It is a really great help. I have installed the procedure. But I can't send
mail. I guess something wrong with the SMTP server. My SMTP server is
"263commail.com" which I used in my outlook express. I try the PING command
with this server name and get the following message:
====================================================C:\>ping 263commail.com
Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Ping statistics for 211.150.100.11:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
======================================================I was told that some server stopped any message from a PING command. Also my
outgoing server requires authentication. Is that a problem?
thanks,
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> Hi
> On http://www.sqldev.net/xp/xpsmtp.htm there is section called
installation
> which details how to install the extended stored procedure. The other
> examples of how to call the extended stored procedure can be cut and
pasted
> into query analyser... but at a guess you have MSDE, in which case paste
an
> example into a text editor and save the file to run from osql. If you do
> have MSDE then you may want to look at
> http://www.aspfaq.com/show.asp?id=2442
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Thanks John,
> >
> > I don't know how to use it after I downloaded xp_smtp_sendmail
procedure.
> >
> > Tom
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > Hi
> > >
> > > Usage is described with example on the download page.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > > What is your particular problem?
> > >
> > > John
> > >
> > >
> > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > Thank you Tony,
> > > >
> > > > I downloaded that file but I don't know how to use it. Could you
give
> me
> > > > more information about it?
> > > >
> > > > thanks,
> > > >
> > > > Tom Li
> > > >
> > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > If you just want to send mails from SQL Server then forget about
> using
> > > > MAPI
> > > > > etc... and download the xp_smtp_sendmail extended stored procedure
> > from
> > > > > sqldev.net, so long as you have an SMTP server then it will work
and
> > its
> > > > > really good!
> > > > >
> > > > > --
> > > > > Tony Rogerson
> > > > > SQL Server MVP
> > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi
I can't say I am a SMTP expert so others might want to chip in!
I am not sure how you would handle authentication as the procedure doesn't
have these parameters. One way may be to have a local server that relays the
mails to the remote server. This would have to be set up so that others
could not hijack your SMTP server! Windows 2000/IIS comes with a SMTP
server.
Some Routers/Firewalls will not reply to PINGS to avoid DOS attacks. You may
want to try telnet, but there is also a @.Ping parameter to xp_smtp. Check
that you should be using the default port, if not may need to specify a
different port using the @.port parameter.
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:e9x9n%23XYDHA.1056@.TK2MSFTNGP10.phx.gbl...
> Hi, John
> It is a really great help. I have installed the procedure. But I can't
send
> mail. I guess something wrong with the SMTP server. My SMTP server is
> "263commail.com" which I used in my outlook express. I try the PING
command
> with this server name and get the following message:
> ====================================================> C:\>ping 263commail.com
> Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
> Request timed out.
> Request timed out.
> Request timed out.
> Request timed out.
> Ping statistics for 211.150.100.11:
> Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
> Approximate round trip times in milli-seconds:
> Minimum = 0ms, Maximum = 0ms, Average = 0ms
> ======================================================> I was told that some server stopped any message from a PING command. Also
my
> outgoing server requires authentication. Is that a problem?
> thanks,
> Tom
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> > Hi
> >
> > On http://www.sqldev.net/xp/xpsmtp.htm there is section called
> installation
> > which details how to install the extended stored procedure. The other
> > examples of how to call the extended stored procedure can be cut and
> pasted
> > into query analyser... but at a guess you have MSDE, in which case
paste
> an
> > example into a text editor and save the file to run from osql. If you do
> > have MSDE then you may want to look at
> > http://www.aspfaq.com/show.asp?id=2442
> >
> > John
> >
> >
> > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Thanks John,
> > >
> > > I don't know how to use it after I downloaded xp_smtp_sendmail
> procedure.
> > >
> > > Tom
> > >
> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > > Hi
> > > >
> > > > Usage is described with example on the download page.
> > > >
> > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > >
> > > > What is your particular problem?
> > > >
> > > > John
> > > >
> > > >
> > > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > > Thank you Tony,
> > > > >
> > > > > I downloaded that file but I don't know how to use it. Could you
> give
> > me
> > > > > more information about it?
> > > > >
> > > > > thanks,
> > > > >
> > > > > Tom Li
> > > > >
> > > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > > If you just want to send mails from SQL Server then forget about
> > using
> > > > > MAPI
> > > > > > etc... and download the xp_smtp_sendmail extended stored
procedure
> > > from
> > > > > > sqldev.net, so long as you have an SMTP server then it will work
> and
> > > its
> > > > > > really good!
> > > > > >
> > > > > > --
> > > > > > Tony Rogerson
> > > > > > SQL Server MVP
> > > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> I saw there are two procedure names in the code, xp_smtp_sendmail and
> sp_smtp_sendmail.
xp_smtp_sendmail is the extended stored procedure (a DLL file) that you
download from www.sqldev.net and register in SQL Server according to the
instructions on that site.
sp_smtp_sendmail is a wrapper for the call to this stored procedure... you
can simplify the number and/or order of parameters. I have a wrapper for
xp_smtp_sendmail called smtpmail which has only a few of the parameters
(because I don't use many of the functions that come with the xp).
> And we may be in different location with different time zone. Are you in
the
> States. I am in China.
The news server adjusts your posting time (according to your time zone) to
the reader's time zone settings. This is why *most* threads appear to occur
in chronological order; however, if my reply shows up 7 1/2 hours before
your initial post (what does *your* newsreader tell you are the times of my
previous reply, and your message that I replied to?), then either your clock
is fast, or your time zone is incorrect. For more information, see:
http://www.aspfaq.com/5005
http://www.aspfaq.com/2257|||Thanks for your explanation about the procedure name.
You are really a MVP. My time zone was not correct, which was: (GMT)
Casablanca, Monrovia. Now I correct it.
thanks,
Tom
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uAtAh5ZYDHA.2960@.tk2msftngp13.phx.gbl...
> > I saw there are two procedure names in the code, xp_smtp_sendmail and
> > sp_smtp_sendmail.
> xp_smtp_sendmail is the extended stored procedure (a DLL file) that you
> download from www.sqldev.net and register in SQL Server according to the
> instructions on that site.
> sp_smtp_sendmail is a wrapper for the call to this stored procedure... you
> can simplify the number and/or order of parameters. I have a wrapper for
> xp_smtp_sendmail called smtpmail which has only a few of the parameters
> (because I don't use many of the functions that come with the xp).
> > And we may be in different location with different time zone. Are you in
> the
> > States. I am in China.
> The news server adjusts your posting time (according to your time zone) to
> the reader's time zone settings. This is why *most* threads appear to
occur
> in chronological order; however, if my reply shows up 7 1/2 hours before
> your initial post (what does *your* newsreader tell you are the times of
my
> previous reply, and your message that I replied to?), then either your
clock
> is fast, or your time zone is incorrect. For more information, see:
> http://www.aspfaq.com/5005
> http://www.aspfaq.com/2257
>
>|||Hi,
Your thoughts is correct. I am thinking about to setup a local SMTP server.
Thanks
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f3a19ed$0$15041$ed9e5944@.reading.news.pipex.net...
> Hi
> I can't say I am a SMTP expert so others might want to chip in!
> I am not sure how you would handle authentication as the procedure doesn't
> have these parameters. One way may be to have a local server that relays
the
> mails to the remote server. This would have to be set up so that others
> could not hijack your SMTP server! Windows 2000/IIS comes with a SMTP
> server.
> Some Routers/Firewalls will not reply to PINGS to avoid DOS attacks. You
may
> want to try telnet, but there is also a @.Ping parameter to xp_smtp. Check
> that you should be using the default port, if not may need to specify a
> different port using the @.port parameter.
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:e9x9n%23XYDHA.1056@.TK2MSFTNGP10.phx.gbl...
> > Hi, John
> >
> > It is a really great help. I have installed the procedure. But I can't
> send
> > mail. I guess something wrong with the SMTP server. My SMTP server is
> > "263commail.com" which I used in my outlook express. I try the PING
> command
> > with this server name and get the following message:
> > ====================================================> > C:\>ping 263commail.com
> >
> > Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
> >
> > Request timed out.
> > Request timed out.
> > Request timed out.
> > Request timed out.
> >
> > Ping statistics for 211.150.100.11:
> > Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
> > Approximate round trip times in milli-seconds:
> > Minimum = 0ms, Maximum = 0ms, Average = 0ms
> > ======================================================> > I was told that some server stopped any message from a PING command.
Also
> my
> > outgoing server requires authentication. Is that a problem?
> >
> > thanks,
> >
> > Tom
> >
> >
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> > > Hi
> > >
> > > On http://www.sqldev.net/xp/xpsmtp.htm there is section called
> > installation
> > > which details how to install the extended stored procedure. The other
> > > examples of how to call the extended stored procedure can be cut and
> > pasted
> > > into query analyser... but at a guess you have MSDE, in which case
> paste
> > an
> > > example into a text editor and save the file to run from osql. If you
do
> > > have MSDE then you may want to look at
> > > http://www.aspfaq.com/show.asp?id=2442
> > >
> > > John
> > >
> > >
> > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Thanks John,
> > > >
> > > > I don't know how to use it after I downloaded xp_smtp_sendmail
> > procedure.
> > > >
> > > > Tom
> > > >
> > > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > > > Hi
> > > > >
> > > > > Usage is described with example on the download page.
> > > > >
> > > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > > >
> > > > > What is your particular problem?
> > > > >
> > > > > John
> > > > >
> > > > >
> > > > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > > > Thank you Tony,
> > > > > >
> > > > > > I downloaded that file but I don't know how to use it. Could you
> > give
> > > me
> > > > > > more information about it?
> > > > > >
> > > > > > thanks,
> > > > > >
> > > > > > Tom Li
> > > > > >
> > > > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > > > If you just want to send mails from SQL Server then forget
about
> > > using
> > > > > > MAPI
> > > > > > > etc... and download the xp_smtp_sendmail extended stored
> procedure
> > > > from
> > > > > > > sqldev.net, so long as you have an SMTP server then it will
work
> > and
> > > > its
> > > > > > > really good!
> > > > > > >
> > > > > > > --
> > > > > > > Tony Rogerson
> > > > > > > SQL Server MVP
> > > > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> But I recommend setting up an SMTP server (e.g. within your
> firewall) that doesn't require outgoing authentication.
I think that is a good way to me. But my current condition is not good
enough to do it so that I have to do it later. Anyway I appreciate your
great help and I do learn a lot from you.
Thank you very much
Tom
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23dKH$5ZYDHA.1480@.tk2msftngp13.phx.gbl...
> > Also my outgoing server requires authentication. Is that a problem?
> Yes, that is a problem. You will need another SMTP server, or you will
need
> to use a COM object which supports outgoing authentication (e.g.
> www.aspemail.com). You can instantiate such a COM object from within a
> stored procedure using the sp_OA* stored procedure calls. But I recommend
> setting up an SMTP server (e.g. within your firewall) that doesn't require
> outgoing authentication.
>
information about my machine:
OS: windows 2000 as a workgroup
sql 2000
office 2000 (also tried office xp)
the mail was sent to my outlook
when I try parameter TYPE with IPC, I got it work but only once. later I
can't get it work. I don't know why.
I don't know how to set up TYPE.
THANKS,
TOMThank you Tony,
I downloaded that file but I don't know how to use it. Could you give me
more information about it?
thanks,
Tom Li
"Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> If you just want to send mails from SQL Server then forget about using
MAPI
> etc... and download the xp_smtp_sendmail extended stored procedure from
> sqldev.net, so long as you have an SMTP server then it will work and its
> really good!
> --
> Tony Rogerson
> SQL Server MVP
> http://www.sqlserverfaq.com?mbr=21
> (Create your own groups, Forum, FAQ's and a ton more)
>|||Hi
Usage is described with example on the download page.
http://www.sqldev.net/xp/xpsmtp.htm
What is your particular problem?
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> Thank you Tony,
> I downloaded that file but I don't know how to use it. Could you give me
> more information about it?
> thanks,
> Tom Li
> "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > If you just want to send mails from SQL Server then forget about using
> MAPI
> > etc... and download the xp_smtp_sendmail extended stored procedure from
> > sqldev.net, so long as you have an SMTP server then it will work and its
> > really good!
> >
> > --
> > Tony Rogerson
> > SQL Server MVP
> > http://www.sqlserverfaq.com?mbr=21
> > (Create your own groups, Forum, FAQ's and a ton more)
> >
> >
>|||Hi Tom,
Its best to read through the instructions supplied on the site - there are a
lot of examples - just follow them through.
Tony.
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)|||Sorry Sir,
I saw there are two procedure names in the code, xp_smtp_sendmail and
sp_smtp_sendmail. I have no experience of creating stored procedure. so that
may be a stupid question.
And we may be in different location with different time zone. Are you in the
States. I am in China.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uT7pfHNYDHA.2152@.TK2MSFTNGP09.phx.gbl...
> > I found out that the procedure has different name in the file. Please
see
> > attached file.
> I'm still not clear what the problem is. Also, can you please fix your
> system clock.
>|||Thanks John,
I don't know how to use it after I downloaded xp_smtp_sendmail procedure.
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> Hi
> Usage is described with example on the download page.
> http://www.sqldev.net/xp/xpsmtp.htm
> What is your particular problem?
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > Thank you Tony,
> >
> > I downloaded that file but I don't know how to use it. Could you give me
> > more information about it?
> >
> > thanks,
> >
> > Tom Li
> >
> > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > If you just want to send mails from SQL Server then forget about using
> > MAPI
> > > etc... and download the xp_smtp_sendmail extended stored procedure
from
> > > sqldev.net, so long as you have an SMTP server then it will work and
its
> > > really good!
> > >
> > > --
> > > Tony Rogerson
> > > SQL Server MVP
> > > http://www.sqlserverfaq.com?mbr=21
> > > (Create your own groups, Forum, FAQ's and a ton more)
> > >
> > >
> >
> >
>|||Hi
On http://www.sqldev.net/xp/xpsmtp.htm there is section called installation
which details how to install the extended stored procedure. The other
examples of how to call the extended stored procedure can be cut and pasted
into query analyser... but at a guess you have MSDE, in which case paste an
example into a text editor and save the file to run from osql. If you do
have MSDE then you may want to look at
http://www.aspfaq.com/show.asp?id=2442
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> Thanks John,
> I don't know how to use it after I downloaded xp_smtp_sendmail procedure.
> Tom
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > Hi
> >
> > Usage is described with example on the download page.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> > What is your particular problem?
> >
> > John
> >
> >
> > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > Thank you Tony,
> > >
> > > I downloaded that file but I don't know how to use it. Could you give
me
> > > more information about it?
> > >
> > > thanks,
> > >
> > > Tom Li
> > >
> > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > If you just want to send mails from SQL Server then forget about
using
> > > MAPI
> > > > etc... and download the xp_smtp_sendmail extended stored procedure
> from
> > > > sqldev.net, so long as you have an SMTP server then it will work and
> its
> > > > really good!
> > > >
> > > > --
> > > > Tony Rogerson
> > > > SQL Server MVP
> > > > http://www.sqlserverfaq.com?mbr=21
> > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi, John
It is a really great help. I have installed the procedure. But I can't send
mail. I guess something wrong with the SMTP server. My SMTP server is
"263commail.com" which I used in my outlook express. I try the PING command
with this server name and get the following message:
====================================================C:\>ping 263commail.com
Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Ping statistics for 211.150.100.11:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
======================================================I was told that some server stopped any message from a PING command. Also my
outgoing server requires authentication. Is that a problem?
thanks,
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> Hi
> On http://www.sqldev.net/xp/xpsmtp.htm there is section called
installation
> which details how to install the extended stored procedure. The other
> examples of how to call the extended stored procedure can be cut and
pasted
> into query analyser... but at a guess you have MSDE, in which case paste
an
> example into a text editor and save the file to run from osql. If you do
> have MSDE then you may want to look at
> http://www.aspfaq.com/show.asp?id=2442
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Thanks John,
> >
> > I don't know how to use it after I downloaded xp_smtp_sendmail
procedure.
> >
> > Tom
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > Hi
> > >
> > > Usage is described with example on the download page.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > > What is your particular problem?
> > >
> > > John
> > >
> > >
> > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > Thank you Tony,
> > > >
> > > > I downloaded that file but I don't know how to use it. Could you
give
> me
> > > > more information about it?
> > > >
> > > > thanks,
> > > >
> > > > Tom Li
> > > >
> > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > If you just want to send mails from SQL Server then forget about
> using
> > > > MAPI
> > > > > etc... and download the xp_smtp_sendmail extended stored procedure
> > from
> > > > > sqldev.net, so long as you have an SMTP server then it will work
and
> > its
> > > > > really good!
> > > > >
> > > > > --
> > > > > Tony Rogerson
> > > > > SQL Server MVP
> > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi
I can't say I am a SMTP expert so others might want to chip in!
I am not sure how you would handle authentication as the procedure doesn't
have these parameters. One way may be to have a local server that relays the
mails to the remote server. This would have to be set up so that others
could not hijack your SMTP server! Windows 2000/IIS comes with a SMTP
server.
Some Routers/Firewalls will not reply to PINGS to avoid DOS attacks. You may
want to try telnet, but there is also a @.Ping parameter to xp_smtp. Check
that you should be using the default port, if not may need to specify a
different port using the @.port parameter.
John
"Tom Li" <mrpiiii@.sina.com> wrote in message
news:e9x9n%23XYDHA.1056@.TK2MSFTNGP10.phx.gbl...
> Hi, John
> It is a really great help. I have installed the procedure. But I can't
send
> mail. I guess something wrong with the SMTP server. My SMTP server is
> "263commail.com" which I used in my outlook express. I try the PING
command
> with this server name and get the following message:
> ====================================================> C:\>ping 263commail.com
> Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
> Request timed out.
> Request timed out.
> Request timed out.
> Request timed out.
> Ping statistics for 211.150.100.11:
> Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
> Approximate round trip times in milli-seconds:
> Minimum = 0ms, Maximum = 0ms, Average = 0ms
> ======================================================> I was told that some server stopped any message from a PING command. Also
my
> outgoing server requires authentication. Is that a problem?
> thanks,
> Tom
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> > Hi
> >
> > On http://www.sqldev.net/xp/xpsmtp.htm there is section called
> installation
> > which details how to install the extended stored procedure. The other
> > examples of how to call the extended stored procedure can be cut and
> pasted
> > into query analyser... but at a guess you have MSDE, in which case
paste
> an
> > example into a text editor and save the file to run from osql. If you do
> > have MSDE then you may want to look at
> > http://www.aspfaq.com/show.asp?id=2442
> >
> > John
> >
> >
> > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Thanks John,
> > >
> > > I don't know how to use it after I downloaded xp_smtp_sendmail
> procedure.
> > >
> > > Tom
> > >
> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > > Hi
> > > >
> > > > Usage is described with example on the download page.
> > > >
> > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > >
> > > > What is your particular problem?
> > > >
> > > > John
> > > >
> > > >
> > > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > > Thank you Tony,
> > > > >
> > > > > I downloaded that file but I don't know how to use it. Could you
> give
> > me
> > > > > more information about it?
> > > > >
> > > > > thanks,
> > > > >
> > > > > Tom Li
> > > > >
> > > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > > If you just want to send mails from SQL Server then forget about
> > using
> > > > > MAPI
> > > > > > etc... and download the xp_smtp_sendmail extended stored
procedure
> > > from
> > > > > > sqldev.net, so long as you have an SMTP server then it will work
> and
> > > its
> > > > > > really good!
> > > > > >
> > > > > > --
> > > > > > Tony Rogerson
> > > > > > SQL Server MVP
> > > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> I saw there are two procedure names in the code, xp_smtp_sendmail and
> sp_smtp_sendmail.
xp_smtp_sendmail is the extended stored procedure (a DLL file) that you
download from www.sqldev.net and register in SQL Server according to the
instructions on that site.
sp_smtp_sendmail is a wrapper for the call to this stored procedure... you
can simplify the number and/or order of parameters. I have a wrapper for
xp_smtp_sendmail called smtpmail which has only a few of the parameters
(because I don't use many of the functions that come with the xp).
> And we may be in different location with different time zone. Are you in
the
> States. I am in China.
The news server adjusts your posting time (according to your time zone) to
the reader's time zone settings. This is why *most* threads appear to occur
in chronological order; however, if my reply shows up 7 1/2 hours before
your initial post (what does *your* newsreader tell you are the times of my
previous reply, and your message that I replied to?), then either your clock
is fast, or your time zone is incorrect. For more information, see:
http://www.aspfaq.com/5005
http://www.aspfaq.com/2257|||Thanks for your explanation about the procedure name.
You are really a MVP. My time zone was not correct, which was: (GMT)
Casablanca, Monrovia. Now I correct it.
thanks,
Tom
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uAtAh5ZYDHA.2960@.tk2msftngp13.phx.gbl...
> > I saw there are two procedure names in the code, xp_smtp_sendmail and
> > sp_smtp_sendmail.
> xp_smtp_sendmail is the extended stored procedure (a DLL file) that you
> download from www.sqldev.net and register in SQL Server according to the
> instructions on that site.
> sp_smtp_sendmail is a wrapper for the call to this stored procedure... you
> can simplify the number and/or order of parameters. I have a wrapper for
> xp_smtp_sendmail called smtpmail which has only a few of the parameters
> (because I don't use many of the functions that come with the xp).
> > And we may be in different location with different time zone. Are you in
> the
> > States. I am in China.
> The news server adjusts your posting time (according to your time zone) to
> the reader's time zone settings. This is why *most* threads appear to
occur
> in chronological order; however, if my reply shows up 7 1/2 hours before
> your initial post (what does *your* newsreader tell you are the times of
my
> previous reply, and your message that I replied to?), then either your
clock
> is fast, or your time zone is incorrect. For more information, see:
> http://www.aspfaq.com/5005
> http://www.aspfaq.com/2257
>
>|||Hi,
Your thoughts is correct. I am thinking about to setup a local SMTP server.
Thanks
Tom
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3f3a19ed$0$15041$ed9e5944@.reading.news.pipex.net...
> Hi
> I can't say I am a SMTP expert so others might want to chip in!
> I am not sure how you would handle authentication as the procedure doesn't
> have these parameters. One way may be to have a local server that relays
the
> mails to the remote server. This would have to be set up so that others
> could not hijack your SMTP server! Windows 2000/IIS comes with a SMTP
> server.
> Some Routers/Firewalls will not reply to PINGS to avoid DOS attacks. You
may
> want to try telnet, but there is also a @.Ping parameter to xp_smtp. Check
> that you should be using the default port, if not may need to specify a
> different port using the @.port parameter.
> John
>
> "Tom Li" <mrpiiii@.sina.com> wrote in message
> news:e9x9n%23XYDHA.1056@.TK2MSFTNGP10.phx.gbl...
> > Hi, John
> >
> > It is a really great help. I have installed the procedure. But I can't
> send
> > mail. I guess something wrong with the SMTP server. My SMTP server is
> > "263commail.com" which I used in my outlook express. I try the PING
> command
> > with this server name and get the following message:
> > ====================================================> > C:\>ping 263commail.com
> >
> > Pinging 263commail.com [211.150.100.11] with 32 bytes of data:
> >
> > Request timed out.
> > Request timed out.
> > Request timed out.
> > Request timed out.
> >
> > Ping statistics for 211.150.100.11:
> > Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
> > Approximate round trip times in milli-seconds:
> > Minimum = 0ms, Maximum = 0ms, Average = 0ms
> > ======================================================> > I was told that some server stopped any message from a PING command.
Also
> my
> > outgoing server requires authentication. Is that a problem?
> >
> > thanks,
> >
> > Tom
> >
> >
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3f39e4de$0$15036$ed9e5944@.reading.news.pipex.net...
> > > Hi
> > >
> > > On http://www.sqldev.net/xp/xpsmtp.htm there is section called
> > installation
> > > which details how to install the extended stored procedure. The other
> > > examples of how to call the extended stored procedure can be cut and
> > pasted
> > > into query analyser... but at a guess you have MSDE, in which case
> paste
> > an
> > > example into a text editor and save the file to run from osql. If you
do
> > > have MSDE then you may want to look at
> > > http://www.aspfaq.com/show.asp?id=2442
> > >
> > > John
> > >
> > >
> > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > news:eyojRMWYDHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Thanks John,
> > > >
> > > > I don't know how to use it after I downloaded xp_smtp_sendmail
> > procedure.
> > > >
> > > > Tom
> > > >
> > > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > > news:3f38e335$0$18495$ed9e5944@.reading.news.pipex.net...
> > > > > Hi
> > > > >
> > > > > Usage is described with example on the download page.
> > > > >
> > > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > > >
> > > > > What is your particular problem?
> > > > >
> > > > > John
> > > > >
> > > > >
> > > > > "Tom Li" <mrpiiii@.sina.com> wrote in message
> > > > > news:Oqn30rMYDHA.652@.TK2MSFTNGP10.phx.gbl...
> > > > > > Thank you Tony,
> > > > > >
> > > > > > I downloaded that file but I don't know how to use it. Could you
> > give
> > > me
> > > > > > more information about it?
> > > > > >
> > > > > > thanks,
> > > > > >
> > > > > > Tom Li
> > > > > >
> > > > > > "Tony Rogerson" <tonyrogerson@.sqlserver.eu.com> wrote in message
> > > > > > news:eKZeQTKYDHA.2020@.TK2MSFTNGP10.phx.gbl...
> > > > > > > If you just want to send mails from SQL Server then forget
about
> > > using
> > > > > > MAPI
> > > > > > > etc... and download the xp_smtp_sendmail extended stored
> procedure
> > > > from
> > > > > > > sqldev.net, so long as you have an SMTP server then it will
work
> > and
> > > > its
> > > > > > > really good!
> > > > > > >
> > > > > > > --
> > > > > > > Tony Rogerson
> > > > > > > SQL Server MVP
> > > > > > > http://www.sqlserverfaq.com?mbr=21
> > > > > > > (Create your own groups, Forum, FAQ's and a ton more)
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> But I recommend setting up an SMTP server (e.g. within your
> firewall) that doesn't require outgoing authentication.
I think that is a good way to me. But my current condition is not good
enough to do it so that I have to do it later. Anyway I appreciate your
great help and I do learn a lot from you.
Thank you very much
Tom
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23dKH$5ZYDHA.1480@.tk2msftngp13.phx.gbl...
> > Also my outgoing server requires authentication. Is that a problem?
> Yes, that is a problem. You will need another SMTP server, or you will
need
> to use a COM object which supports outgoing authentication (e.g.
> www.aspemail.com). You can instantiate such a COM object from within a
> stored procedure using the sp_OA* stored procedure calls. But I recommend
> setting up an SMTP server (e.g. within your firewall) that doesn't require
> outgoing authentication.
>
Thursday, February 16, 2012
about MSSQLSERVER run as LocalSystem
Hi,it is fail when I try to open a namedpipe of another machine in sql2000's
extern storage procedure.
WNetAddConnection2() return 1312
CreateFile() return -1 and GetLastError() return 5
MSSQLSERVER is running as LocalSystem.
If MSSQLSERVER login using a user account, the extern storage procedure can
open the namedpipe of another machine.
Why? someone can give me a little explanation.
Thanks
RateIf you need a SQL Server to be able to access other network
resources, including other servers, SQL Server needs to be
running under a domain account. Local System doesn't have
access to network resources.
-Sue
On Tue, 14 Mar 2006 10:39:16 +0800, "rate"
<spring_pb@.21cn.com> wrote:
>Hi,it is fail when I try to open a namedpipe of another machine in sql2000'
s
>extern storage procedure.
>WNetAddConnection2() return 1312
>CreateFile() return -1 and GetLastError() return 5
>MSSQLSERVER is running as LocalSystem.
>If MSSQLSERVER login using a user account, the extern storage procedure can
>open the namedpipe of another machine.
>Why? someone can give me a little explanation.
>Thanks
>Rate
>
extern storage procedure.
WNetAddConnection2() return 1312
CreateFile() return -1 and GetLastError() return 5
MSSQLSERVER is running as LocalSystem.
If MSSQLSERVER login using a user account, the extern storage procedure can
open the namedpipe of another machine.
Why? someone can give me a little explanation.
Thanks
RateIf you need a SQL Server to be able to access other network
resources, including other servers, SQL Server needs to be
running under a domain account. Local System doesn't have
access to network resources.
-Sue
On Tue, 14 Mar 2006 10:39:16 +0800, "rate"
<spring_pb@.21cn.com> wrote:
>Hi,it is fail when I try to open a namedpipe of another machine in sql2000'
s
>extern storage procedure.
>WNetAddConnection2() return 1312
>CreateFile() return -1 and GetLastError() return 5
>MSSQLSERVER is running as LocalSystem.
>If MSSQLSERVER login using a user account, the extern storage procedure can
>open the namedpipe of another machine.
>Why? someone can give me a little explanation.
>Thanks
>Rate
>
about MSSQLSERVER run as LocalSystem
Hi,it is fail when I try to open a namedpipe of another machine in sql2000's
extern storage procedure.
WNetAddConnection2() return 1312
CreateFile() return -1 and GetLastError() return 5
MSSQLSERVER is running as LocalSystem.
If MSSQLSERVER login using a user account, the extern storage procedure can
open the namedpipe of another machine.
Why? someone can give me a little explanation.
Thanks
Ratehi,
localsystem account doesn't have network priviledges. this is a security
feature.
Peter.
"rate" <spring_pb@.21cn.com> wrote in message
news:O%23a2VHxRGHA.2536@.tk2msftngp13.phx.gbl...
> Hi,it is fail when I try to open a namedpipe of another machine in
> sql2000's
> extern storage procedure.
> WNetAddConnection2() return 1312
> CreateFile() return -1 and GetLastError() return 5
> MSSQLSERVER is running as LocalSystem.
> If MSSQLSERVER login using a user account, the extern storage procedure
> can
> open the namedpipe of another machine.
> Why? someone can give me a little explanation.
> Thanks
> Rate
>
>
extern storage procedure.
WNetAddConnection2() return 1312
CreateFile() return -1 and GetLastError() return 5
MSSQLSERVER is running as LocalSystem.
If MSSQLSERVER login using a user account, the extern storage procedure can
open the namedpipe of another machine.
Why? someone can give me a little explanation.
Thanks
Ratehi,
localsystem account doesn't have network priviledges. this is a security
feature.
Peter.
"rate" <spring_pb@.21cn.com> wrote in message
news:O%23a2VHxRGHA.2536@.tk2msftngp13.phx.gbl...
> Hi,it is fail when I try to open a namedpipe of another machine in
> sql2000's
> extern storage procedure.
> WNetAddConnection2() return 1312
> CreateFile() return -1 and GetLastError() return 5
> MSSQLSERVER is running as LocalSystem.
> If MSSQLSERVER login using a user account, the extern storage procedure
> can
> open the namedpipe of another machine.
> Why? someone can give me a little explanation.
> Thanks
> Rate
>
>
Thursday, February 9, 2012
about connections and Login
Hey guys,
I have created dtsx packages and i have one master package which would run couple of child packages.
1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...
2.what would be the best way in executing these packages.
the way it is set now is i had 3 connections set for each package.
a.Source connection
b.Destination Connection.
c.One more connection(which is used with in the process of execution)
Can i set connections in common for all the packages in one location.
3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.
How can i do that.
please let me know.
sureshv wrote:
1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...
What you mean, to edit them? just use VSS or place them in a shared location. To execute them, place them in a shared location and then set up a Job (SQl Agent) to run them.
2.what would be the best way in executing these packages.
Via SQL Agent job would be my preferred method
Can i set connections in common for all the packages in one location.
No, but you can use package configuration instead.
3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.
To schedule them, again, use a SQL Agent Job. For logging just enable package logging.
Subscribe to:
Posts (Atom)