can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?
Have a look at
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default...b;en-us;811889
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>
|||Also don't forget to look at the hosts and lmhosts files in your system32
folder.
You need the correct hosts configuration in there. There are a variety of
problems that can cause the SSPI error and a change of hosts file config
sorted mine out on most client machines but I still have the problem on two
of them where it drops off after 45 mins for no apparent rhyme or reason.
The hosts file that works for me looks like this (bar the IBM manufactured
PC's)
127.0.0.1 localhost.uk-resources.net
127.0.0.1 mypc.uk-resources.net
192.168.16.2 ourserver.uk-resources.net
Don't forget to backup the original hosts and lmhost file before changing
anything.
There is some issue I recall seeing when researching the problem a few
months ago about the way the DNS resolves when using vpn and it may be
router related.
Regards,
Paul
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>

can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?Try switching the protocol using the Client Network Utility to Named Pipes.
See if the problem goes away.
Instead of using your vb app, you can test with the following command line
tool.
-To test Named Pipes
ISQL -Snp:ServerNameHere -E -Q"select @.@.version"
-To test TCP/IP
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hello
i don't want to use name pipes because i want to supply an access over
internet.
My connectionstring look likes
.Properties("Network address").value = "MyPublicIPAdress"
.Provider = "sqloledb"
.ConnectionTimeout = 15
.CommandTimeout = 300
.CursorLocation = adUseClient
.Properties("Application Name") = "MyApp"
.Properties("Network Library").value = "DBMSSOCN"
.Properties("Integrated Security").value = "SSPI"
I made a few others Test:
*I try to configure (via cliconfg.exe) the SQL access from my client: I set
"Enabled protocols" only to TCP/IP
I didn't sove my problems.
* I make a Rollback of MDAC 2.8 (dasetup -u), It rollbacks to MDAC 2.7 (the
one supplies with XP) -> It RUNS again;
Is there any know bugs in the MDAC 2.8 when accessing a SQL Server with
TCP/IP and in a Trusted Mode ?!?
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:qaI9eeCPEHA.304@.cpmsftngxa10.phx.gbl...
> Try switching the protocol using the Client Network Utility to Named
Pipes.
> See if the problem goes away.
> Instead of using your vb app, you can test with the following command line
> tool.
> -To test Named Pipes
> ISQL -Snp:ServerNameHere -E -Q"select @.@.version"
> -To test TCP/IP
> ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||One of the goals of MDAC 2.8 was to tighten security .
SSPI (Security Support Provider Interface ) is used when you are using
Windows Authentication to connect to the SQL server. That is to say the
domain account of the interactive user trying to connect to SQL server is
used.
Sounds like the authentication token is lost or corrupted or something over
the VPN and SQL Server does not see the user as a valid domain account.
Here are some links that I hope help:
http://support.microsoft.com/defaul...kb;en-us;820761
http://support.microsoft.com/defaul...kb;en-us;814401
http://support.microsoft.com/defaul...kb;en-us;821373
Good luck,
Mike
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:ez6RRaBPEHA.3476@.tk2msftngp13.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>
>

can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?Have a look at
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/defaul...kb;en-us;811889
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>|||Also don't forget to look at the hosts and lmhosts files in your system32
folder.
You need the correct hosts configuration in there. There are a variety of
problems that can cause the SSPI error and a change of hosts file config
sorted mine out on most client machines but I still have the problem on two
of them where it drops off after 45 mins for no apparent rhyme or reason.
The hosts file that works for me looks like this (bar the IBM manufactured
PC's)
127.0.0.1 localhost.uk-resources.net
127.0.0.1 mypc.uk-resources.net
192.168.16.2 ourserver.uk-resources.net
Don't forget to backup the original hosts and lmhost file before changing
anything.
There is some issue I recall seeing when researching the problem a few
months ago about the way the DNS resolves when using vpn and it may be
router related.
Regards,
Paul
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>sql

Can not Depoloy Report

Hi,
I am having a problem to deploy reports; every time I try to deploy a
report the build stage is finishing and I get this Error:
A connection could not be made to report server http://
localhost/reports/ pages/folder.aspx
However, when I try entering http:// localhost/reports/
pages/folder.aspx from the browser I can see the report manager
without any problem ( and without my reports...).
Does anyone knows has a solution?
Thank you.
Avi.You may not have permissions, can you use the Report Manager web interface
to show details on the folder and reports from there?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>|||The report Manager is still empty, this is the first time I use it on
my home comuter.
How can I give myself permissions?
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> You may not have permissions, can you use the Report Manager web interface
> to show details on the folder and reports from there?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > Hi,
> > I am having a problem to deploy reports; every time I try to deploy a
> > report the build stage is finishing and I get this Error:
> >
> > A connection could not be made to report server http://
> > localhost/reports/ pages/folder.aspx
> >
> > However, when I try entering http:// localhost/reports/
> > pages/folder.aspx from the browser I can see the report manager
> > without any problem ( and without my reports...).
> >
> > Does anyone knows has a solution?
> >
> >
> > Thank you.
> >
> > Avi.
> >|||.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB =D7=9B=D7=AA=D7=91:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> > You may not have permissions, can you use the Report Manager web interf=ace
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||You need to be logged into you computer as a local admin to the machine.
This will automatically make you part of the RS admin role. Also, if you
have by any chance messed around with IIS and turned anonymous access on
then you will be considered anonymous and hence not have the rights to
deploy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160640060.505189.232900@.b28g2000cwb.googlegroups.com...
.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB ?:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw ?:
> > You may not have permissions, can you use the Report Manager web
> > interface
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||Make sure you do not have anonymous enabled in IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>

can not deploy a report to ReportServer sub folders

I am trying to deploy my report to somthing like https://SERVERNAME/ReportServer/BrianHome/

but i keep getting an error saying

"A connection could not be made to the reportserver https://SERVERNAME/ReportServer/BrianHome/"

Then under aditional information i get:

"Client found response content type of " , but expected text/xml

The request failed with an empty responce. ( system.web.services)

Try setting your TargetServerURL to: https://SERVERNAME/ReportServer

and your TargetReportFolder to: /MainFolder/SubFolder

This works for me.

|||

That works !!!!

I can not thank you enough!!!!

sql

Can not create connection to data source

Hi there,
I've got Reporting services is installed on server 1 and sql server &
analysis services installed on server2. I've published my reports on server1.
When i try to view my reports from report manager i get error msg "Can not
create connection to data source". I've got four reports. Three are based on
cubes and one on sql databases. The one with sql database works fine but any
reports with olap db just doesn't work.
Can anyone help please? I'm trying to fix this for a while but can't get it
working.
Your help is appreciated..
--
Regards,
VivekHi there,
Just to add some more info..i'm using sql2000.
--
Regards,
Vivek
"Vivek" wrote:
> Hi there,
> I've got Reporting services is installed on server 1 and sql server &
> analysis services installed on server2. I've published my reports on server1.
> When i try to view my reports from report manager i get error msg "Can not
> create connection to data source". I've got four reports. Three are based on
> cubes and one on sql databases. The one with sql database works fine but any
> reports with olap db just doesn't work.
> Can anyone help please? I'm trying to fix this for a while but can't get it
> working.
> Your help is appreciated..
> --
> Regards,
> Vivek|||I have a simular setup as you and am running into the same issues. ServerA
SSRS 2005, ServerB SQL Server 2000 with Analysis Services. Reports built
from SQL Server databases are able to be displayed, reports built from AS
give error 'Cannot create a connection to data source <InventoryCube>'. I've
tried changing security settings on the data souce with in report manager
with out any luck. Data source is currently set to 'Windows Integrated
Security'
"Vivek" wrote:
> Hi there,
> Just to add some more info..i'm using sql2000.
> --
> Regards,
> Vivek
>
> "Vivek" wrote:
> > Hi there,
> >
> > I've got Reporting services is installed on server 1 and sql server &
> > analysis services installed on server2. I've published my reports on server1.
> > When i try to view my reports from report manager i get error msg "Can not
> > create connection to data source". I've got four reports. Three are based on
> > cubes and one on sql databases. The one with sql database works fine but any
> > reports with olap db just doesn't work.
> >
> > Can anyone help please? I'm trying to fix this for a while but can't get it
> > working.
> >
> > Your help is appreciated..
> >
> > --
> > Regards,
> >
> > Vivek

Can not create a connection to Oracle data source when report is processing

hello,

I am getting following error message when I try to view a report from reporting services. The report runs fine but after while i get the following error message. The error message will go away if i open the report manage from the server and run the report once. The report will run fine for a while from anywhere but afterwhile i get following error message.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'OracleConnProc'. (rsErrorOpeningConnection)

Error while trying to retrieve text for error ORA-12154

can someone please help me.

Most likely there is a problem with the file system permissions of your Oracle client installation on the report server machine. The file system permissions probably prevent the account configured to run the RS Web Service to load certain Oracle client configuration files.

Have you looked at the following KB article? http://support.microsoft.com/default.aspx?scid=kb;en-us;870668

-- Robert

|||

Hello Robert,

I followed steps from your suggested article. I am still having same problem, but at the same time I could not verify my changes as suggested in the article.

Note To verify the configured account for the Reporting Services Web Service, you can open the RSReportServer.config file. You will find informaiton that is similar to the following:

<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>

I was thinking to reinstall oracle client on my reporting server, but please let me know if you have any other suggestion.

Thanks,

Vimal

Can not connect to SQL Server

A user who has been connected to our server for several years can not longer
connect.
The error through ODBC shows the following :
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server not
found.
No one else in the firm is having troubles connecting to the server. The
server has SP4 applied.Can he ping the server by hostname? Check to his ODBC connection to ensure
that it is correct. It sounds like a name resolution problem.
--
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
"Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>A user who has been connected to our server for several years can not
>longer
> connect.
> The error through ODBC shows the following :
> Connection failed:
> SQLState: '01000'
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> not
> found.
> No one else in the firm is having troubles connecting to the server. The
> server has SP4 applied.|||They can ping and connect to other named instances on the server.
I have since found if they put "SERVERNAME\PortNumber" instead of
"SERVERNAME\INSTANCENAME" in their definition it all works.
Why is that ?
"Hilary Cotter" wrote:
> Can he ping the server by hostname? Check to his ODBC connection to ensure
> that it is correct. It sounds like a name resolution problem.
> --
> 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
> "Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
> news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
> >A user who has been connected to our server for several years can not
> >longer
> > connect.
> >
> > The error through ODBC shows the following :
> > Connection failed:
> > SQLState: '01000'
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> > (Connect()).
> > Connection failed:
> > SQLState: '08001'
> > SQL Server Error: 6
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> > not
> > found.
> >
> > No one else in the firm is having troubles connecting to the server. The
> > server has SP4 applied.
>
>

Can not connect to SQL Server

A user who has been connected to our server for several years can not longer
connect.
The error through ODBC shows the following :
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Op
en
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL
Server not
found.
No one else in the firm is having troubles connecting to the server. The
server has SP4 applied.Can he ping the server by hostname? Check to his ODBC connection to ensure
that it is correct. It sounds like a name resolution problem.
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
"Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>A user who has been connected to our server for several years can not
>longer
> connect.
> The error through ODBC shows the following :
> Connection failed:
> SQLState: '01000'
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection
Open
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified S
QL Server
> not
> found.
> No one else in the firm is having troubles connecting to the server. The
> server has SP4 applied.|||They can ping and connect to other named instances on the server.
I have since found if they put "SERVERNAME\PortNumber" instead of
"SERVERNAME\INSTANCENAME" in their definition it all works.
Why is that ?
"Hilary Cotter" wrote:

> Can he ping the server by hostname? Check to his ODBC connection to ensure
> that it is correct. It sounds like a name resolution problem.
> --
> 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
> "Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
> news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>
>sql

Can not connect to SQL Server

A user who has been connected to our server for several years can not longer
connect.
The error through ODBC shows the following :
Connection failed:
SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server not
found.
No one else in the firm is having troubles connecting to the server. The
server has SP4 applied.
Can he ping the server by hostname? Check to his ODBC connection to ensure
that it is correct. It sounds like a name resolution problem.
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
"Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>A user who has been connected to our server for several years can not
>longer
> connect.
> The error through ODBC shows the following :
> Connection failed:
> SQLState: '01000'
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server
> not
> found.
> No one else in the firm is having troubles connecting to the server. The
> server has SP4 applied.
|||They can ping and connect to other named instances on the server.
I have since found if they put "SERVERNAME\PortNumber" instead of
"SERVERNAME\INSTANCENAME" in their definition it all works.
Why is that ?
"Hilary Cotter" wrote:

> Can he ping the server by hostname? Check to his ODBC connection to ensure
> that it is correct. It sounds like a name resolution problem.
> --
> 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
> "Snoopstah" <Snoopstah@.discussions.microsoft.com> wrote in message
> news:84167888-D06E-4E37-8030-103ABF66F29D@.microsoft.com...
>
>

Can not connect to SQL from Client VB UI

The error message that i get is: PROVIDER CANNOT BE
FOUND. IT MAY NOT BE PROPERLY INSTALLED.
When i run the same connection from the server to the
application installed on the server it works fine.
Any ideas would be helpful
Thanks
Tom
It could be do to an MDAC issue. You want to check the
version of MDAC and make sure it is installed correctly. You
can just try reinstalling the latest MDAC version on the
clients or use the component checker to check the MDAC
installation. You can download component checker and MDAC
versions from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Mon, 10 Jan 2005 12:43:03 -0800, "TOM"
<TOM@.discussions.microsoft.com> wrote:

>The error message that i get is: PROVIDER CANNOT BE
>FOUND. IT MAY NOT BE PROPERLY INSTALLED.
>When i run the same connection from the server to the
>application installed on the server it works fine.
>Any ideas would be helpful
>Thanks
>Tom

Can not connect to SQL from Client VB UI

The error message that i get is: PROVIDER CANNOT BE
FOUND. IT MAY NOT BE PROPERLY INSTALLED.
When i run the same connection from the server to the
application installed on the server it works fine.
Any ideas would be helpful
Thanks
TomIt could be do to an MDAC issue. You want to check the
version of MDAC and make sure it is installed correctly. You
can just try reinstalling the latest MDAC version on the
clients or use the component checker to check the MDAC
installation. You can download component checker and MDAC
versions from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Mon, 10 Jan 2005 12:43:03 -0800, "TOM"
<TOM@.discussions.microsoft.com> wrote:

>The error message that i get is: PROVIDER CANNOT BE
>FOUND. IT MAY NOT BE PROPERLY INSTALLED.
>When i run the same connection from the server to the
>application installed on the server it works fine.
>Any ideas would be helpful
>Thanks
>Tomsql

Can not connect to MSDE 2000 through my PDA application

Hi, I am new to MSDE and am having a problem connecting to it through my PDA
application. Everytime i try to open the connection i get a exception of
PlatformNotSupportedException.
I have checked this problem for many times and fail to find an ideal
solution. My question is whether it was caused by an low version of MSDE? I
have tried to update the MSDE with SP4, but it failed. The error message is
:The instance name specified is invalid.
Anyone can help me ? Thanks!
hi,
phil wrote:
> Hi, I am new to MSDE and am having a problem connecting to it through
> my PDA application. Everytime i try to open the connection i get a
> exception of PlatformNotSupportedException.
> I have checked this problem for many times and fail to find an ideal
> solution. My question is whether it was caused by an low version of
> MSDE? I have tried to update the MSDE with SP4, but it failed. The
> error message is
> Anyone can help me ? Thanks!
I recently wote a little 300k PocketPC app using Vb.Net and the Compact
Framework for our inhouse order entry management... it is a connected app,
as it works connected via wi-fi with the main SQL Server engine... and it
works great :D
I think you've better ask in the specific compiler/language ng for better
luck...
as regard the MSDE upgrade to sp4, I've found that the instance name is
better understood by the setup.exe boostrap installer if provided without
quotes, in the form
c:\...\>setup.exe /upgradesp SQLRUN INSTANCENAME=whatever ..(other params)
/L*v "c:\MsdeSP4.txt"
but this is my own experience...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Andrea Montanari, thanks for ur reply. As to the installation of SP4, i
have solved the problem with ur great suggestion. Thanks again.
But i still sufferd the problem with my pda app to connect with a MSDE
DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
application, I get an error message - PlatformNotSupportedException. I've
tryed it on Windows CE Emulator and my PDA Device, but the result was the
same.
There is my code snippet:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim cn As New System.Data.SqlClient.SqlConnection("User
ID=sa;password=sa;database=Test;server=192.168.1.5 ")
cn.Open()
Catch exSQL As SqlException
Dim errSQL As SqlError
For Each errSQL In exSQL.Errors
MessageBox.Show(errSQL.Message)
Next
Catch ex1 As Exception
MessageBox.Show(ex1.Message)
Finally
MessageBox.Show("test fail")
End Sub
When i try to build a windows application project with this code, it works
well, Can anybody give me a tip, how can i solve the problem?
Thank's in advance.
Operating system: Windows XP professional + sp2
Development Tool: Visual Studion 2003
Database: MSDE 2000 Release A
PDA device: iPaq H3870, Windows CE 4.1
|||hi,
phil wrote:
> hi Andrea Montanari, thanks for ur reply. As to the installation of
> SP4, i have solved the problem with ur great suggestion. Thanks again.


> But i still sufferd the problem with my pda app to connect with a MSDE
> DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
> application, I get an error message - PlatformNotSupportedException.
> I've tryed it on Windows CE Emulator and my PDA Device, but the
> result was the same.
>
> There is my code snippet:
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> Dim cn As New System.Data.SqlClient.SqlConnection("User
> ID=sa;password=sa;database=Test;server=192.168.1.5 ")
>
it seems fine, to me... but unfortunately have no further hints.. try in the
DotNet compact framework ngs...
sorry..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You need to use the System.Data.SqlServerCe namespace and make sure you are
not referencing anything in then 1.1 framework. All references need to be
to the compact framework
http://msdn.microsoft.com/library/de...qlserverce.asp
In c#
SqlCeConnection conn = new SqlCeConnection( connString );
conn.Open();
"phil" <phil@.discussions.microsoft.com> wrote in message
news:02E40A6C-48C3-4DAD-9EDB-3F7B76CFA027@.microsoft.com...
> hi Andrea Montanari, thanks for ur reply. As to the installation of SP4, i
> have solved the problem with ur great suggestion. Thanks again.
> But i still sufferd the problem with my pda app to connect with a MSDE
> DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
> application, I get an error message - PlatformNotSupportedException. I've
> tryed it on Windows CE Emulator and my PDA Device, but the result was the
> same.
>
> There is my code snippet:
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> Dim cn As New System.Data.SqlClient.SqlConnection("User
> ID=sa;password=sa;database=Test;server=192.168.1.5 ")
> cn.Open()
> Catch exSQL As SqlException
> Dim errSQL As SqlError
> For Each errSQL In exSQL.Errors
> MessageBox.Show(errSQL.Message)
> Next
> Catch ex1 As Exception
> MessageBox.Show(ex1.Message)
> Finally
> MessageBox.Show("test fail")
> End Sub
> When i try to build a windows application project with this code, it
works
> well, Can anybody give me a tip, how can i solve the problem?
> Thank's in advance.
>
> Operating system: Windows XP professional + sp2
> Development Tool: Visual Studion 2003
> Database: MSDE 2000 Release A
> PDA device: iPaq H3870, Windows CE 4.1
>
|||hi Darren
Darren wrote:
> You need to use the System.Data.SqlServerCe namespace and make sure
> you are not referencing anything in then 1.1 framework. All
> references need to be to the compact framework
> http://msdn.microsoft.com/library/de...qlserverce.asp
> In c#
> SqlCeConnection conn = new SqlCeConnection( connString );
> conn.Open();
>
this is true for a SQLCe connection, but not for a connection to a
"standard" SQL Server/MSDE remote instance via wi-fi..
in this case, the System.Data.SqlClient reference is needed as already
indicated by Phil...
and the compact framework includes SqlClient component...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the info.
I didn't realize that namespace was available in the CF.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3k2698Fs76uvU1@.individual.net...[vbcol=seagreen]
> hi Darren
> Darren wrote:
http://msdn.microsoft.com/library/de...qlserverce.asp
> this is true for a SQLCe connection, but not for a connection to a
> "standard" SQL Server/MSDE remote instance via wi-fi..
> in this case, the System.Data.SqlClient reference is needed as already
> indicated by Phil...
> and the compact framework includes SqlClient component...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Can not connect to Database

I recently uninstalled SQL Server due to connection issues I started having. I could start the DB and connect/edit tables in Ent Mgr etc, but all the sudden, none of my code could make DB connections.

So, after reinstalling now nothing works. I cannot even connect in Ent. Manager. I went to Administrative Tools->Services to make sure it was running, and SQLSERVER isn't even listed under services. What happened? Is there another step after installing SQL Server I missed to get the service up and going. Do I need to do something in ODBC connections?

I am on Windows XP with SP2.

TimWell see if SQL Server Manager is running in the system tray. Maybe you didn't set it to start SQL Server on windows startup. Also if you did reinstall I would think your sa password is blank unless you set it during install.|||It is not running in the system tray, and I cannot start SQL Server, because the service does not exist. Setting it to start on windows startup doesn't do anything.

For some reason when I install it, the service component does not get installed.

I get the following error when I try to start SQL Server

--------
Service Control Failure
"An Error 1060 - (The specified service does not exist as an installed service) occured while performing this operation on the MSSQL service"|||Try reinstall with the repair option and make SQL Server Service Auto start, SQL Server will start anytime you start the OS. Hope this helps.

Kind regards,
Gift Peddie|||I do not see where I can install with "repair" mode. That option never comes up.

However, this happens every time I try to install. I get an error window that pops up at the start that say this:

"Microsoft SQL Server Standard Edition server component is not supported on this operating system. Only client components will be available for installation."

I am on Windows XP Service Pack 2. I don't understand though, because I installed it fine on this computer before. But maybe it was before I installed SP 2, I dont know.

Anyone know why this is happening or what I should do?|||Use the original cd you used when installing on that box. And don't try to say that you used that exact cd when you first installed because it's not supported on client operating systems.|||We have the exact same problem
We have the original cd's of the Standard, Developer & Personal editions.
After installing the developers edition on WindowsXP, the service manager app shows in the taskbar, but it will not connect to the sql server|||try installing service pack 3|||hi all

I installing service pack 3 and NO fix't|||XGBoomer, yours is NOT the exact same problem as you actually do have SQL Server installed and it is running.

What exactly do you mean by "it" in "it will not connect to the sql server"? And, are you receiving any error messages?

Terri|||You can only install the developer or MSDE versions on XP. You can't put Enterprise or Standard on the OS. Install developer and you should be good to go. I'm not sure what you've done to your DB's now though. YOu may want to look in the data folder and copy your files to another location, if they are still there. Then if it hoses your data directory at least you will still be able to attach the databases back to the new install.

hth Bruce|||Not quiet the same problem but I have Developer edition on XP Pro/SP2 running for a while now. Out of the blue it won't run ie it starts and then stops straight away. There is another edition of MSDE on the same box that runs fine, and I don't think its the firewall.

Any ideas?

Regards|||Update - I tried the repair function (using the SQL installer) which did the trick. I can't figure out why it happened though.

Regards

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

Hi

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

Hi

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

Hi

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Forch

|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.

Can not Backups on SQL2005

Can not Backups.No Error!

The Code:

Code Snippet

static void Main(string[] args)
{
try
{
SqlConnection Connection = new SqlConnection(@."Data Source=SUPER-9ZT4OE2OQ;Initial Catalog=DataBase;Persist Security Info=True;User ID=tj;password=tj");
Server server = new Server(new ServerConnection(Connection));
Backup bak = new Backup();
bak.Action = BackupActionType.Database;
bak.Database = "DataBase";

BackupDevice backupDevice = new BackupDevice(server, "Full_Backup");
backupDevice.PhysicalLocation = @."\\192.168.2.13\DatabaseBak\over.remoteBak";
backupDevice.BackupDeviceType = BackupDeviceType.Disk;

bak.Devices.AddDevice("Full_Backup", DeviceType.File);
bak.Incremental = false;
bak.SqlBackup(server);

}
catch (Exception)
{

throw;
}
}

Any help is highly appreciated

Thanks.

Try changing the line

bak.Devices.AddDevice(xxx)

to

bak.Devices.Add(xxx)

Here's the example (in VB.Net) from BOL:

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'Define a Backup object variable.
Dim bk As New Backup
'Specify the type of backup, the description, the name, and the database to be backed up.
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks"
'Declare a BackupDeviceItem by supplying the backup device file name in the constructor, and the type of device is a file.
Dim bdi As BackupDeviceItem
bdi = New BackupDeviceItem("Test_Full_Backup1", DeviceType.File)
'Add the device to the Backup object.
bk.Devices.Add(bdi)
'Run SqlBackup to perform the full database backup on the instance of SQL Server.
bk.SqlBackup(srv)

Can not Backups on SQL2005

Can not Backups.No Error!

The Code:

Code Snippet

static void Main(string[] args)
{
try
{
SqlConnection Connection = new SqlConnection(@."Data Source=SUPER-9ZT4OE2OQ;Initial Catalog=DataBase;Persist Security Info=True;User ID=tj;password=tj");
Server server = new Server(new ServerConnection(Connection));
Backup bak = new Backup();
bak.Action = BackupActionType.Database;
bak.Database = "DataBase";

BackupDevice backupDevice = new BackupDevice(server, "Full_Backup");
backupDevice.PhysicalLocation = @."\\192.168.2.13\DatabaseBak\over.remoteBak";
backupDevice.BackupDeviceType = BackupDeviceType.Disk;

bak.Devices.AddDevice("Full_Backup", DeviceType.File);
bak.Incremental = false;
bak.SqlBackup(server);

}
catch (Exception)
{

throw;
}
}

Any help is highly appreciated

Thanks.

Try changing the line

bak.Devices.AddDevice(xxx)

to

bak.Devices.Add(xxx)

Here's the example (in VB.Net) from BOL:

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'Define a Backup object variable.
Dim bk As New Backup
'Specify the type of backup, the description, the name, and the database to be backed up.
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks"
'Declare a BackupDeviceItem by supplying the backup device file name in the constructor, and the type of device is a file.
Dim bdi As BackupDeviceItem
bdi = New BackupDeviceItem("Test_Full_Backup1", DeviceType.File)
'Add the device to the Backup object.
bk.Devices.Add(bdi)
'Run SqlBackup to perform the full database backup on the instance of SQL Server.
bk.SqlBackup(srv)