Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Monday, March 26, 2012

How to Connect to my Web-SiteSqlServer through Enterprise Manager?

Hi all,

I have Sql Server 2000 installed in my home and also i have a website that works with Sql Server2000 and .Net FrameWork v1.1 ,now i want to know is it possible to connect from
my home SqlServer to Host SqlServer( where my Website resides ) through Enterprise manager or Query Analizer to do some data-manipulation And how?

Thanks in advance.
Regards.

You have to ask for Enterprise Manager access from the hosting company if not they will not offer it. Then you can use the backup and restore wizard to move your databases between servers. Hope this helps.

How to connect to msde on an other server?

I tried to connect to a msde on an other server via the enterprise manager.
This wasn't possible!
Unable to establish connection. Server unknown or access denied!
What can i do?
thx
Hi,
Can you enable the TCPIP protocol using the utility svrnetcn.exe from SQL
server machine. Run the
svrnetcn.exe from command prompt and after enabling the protocol stop and
start the MSSQL server Service .
After starting the service try connecting remotely
Thanks
Hari
SQL Server MVP
"Raupes" <Raupes@.discussions.microsoft.com> wrote in message
news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
>I tried to connect to a msde on an other server via the enterprise manager.
> This wasn't possible!
> Unable to establish connection. Server unknown or access denied!
> What can i do?
> thx
|||Hi,
I have exactly the same problem. I have tried your
suggestion but without success.
Anyone have another suggestion?
Tks, Rui

>--Original Message--
>Hi,
>Can you enable the TCPIP protocol using the utility
svrnetcn.exe from SQL
>server machine. Run the
>svrnetcn.exe from command prompt and after enabling the
protocol stop and
>start the MSSQL server Service .
>After starting the service try connecting remotely
>
>--
>Thanks
>Hari
>SQL Server MVP
>
>"Raupes" <Raupes@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
enterprise manager.[vbcol=seagreen]
access denied!
>
>.
>
|||I had the same problem.
If you telnet to port 1433 on the machine running msde do you get a
connection failed message? If it fails it could be firewall settings.
I fixed the problem here by removing all protocols and then re-adding only
tcp/ip.
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:495b01c4c748$732788c0$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
|||At first I had to configure the port at which the msde is listening.
After that I had to open the UDP 1434 port vor all wizzards of the
enterprise manager. Only god knows why the enterprise manager uses 1433 tcp
only and all other wizzards use 1434 udp.
hm.
hope that i could help you
cu
Raupes
"Rui Oliveira" wrote:

> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
>

Friday, March 23, 2012

How to connect remote DB

If I already know that:

Domain: DM1

Server: SV1

Database: DB

user: u1

password: p1

How to connect to DB by Enterprise Manager ?

Take a look at your other post. I answered it there.

http://forums.asp.net/1153624/ShowPost.aspx

sql

Wednesday, March 21, 2012

How to connect from Sql Manager to a sql server 2000 database at an ISP

To use the front end tools in SQL Manager on the database at my ISP I want to connect directly. I have enabled TCP/IP and Named Pipes without succes.

My installation is based on SQL Server Developer Edition and VS 2005. With my previos installation based on Express versions of the product this worked fine.

To be more specific:

In VS 2005 I select Tools -> Connect to database and fill inn the dialog window with the serveraddress (sql01.active24.com), username and password. I then get the following message:

An errror has occurd while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the fefault settings SQL Server does not allow remote connections. (provider: Named pipes, errror: 40 - Could not opeen a connection to SQL Server

In the network configuration I have now disabled Named Pipes and enabled TCP/IP.

Thanks in advance!

Andreassql

Monday, March 19, 2012

how to configure RS2000 to use .Net framework 1.1 from 2.0?

Good morning,
This is a continuation post about a problem I am having where I can't open
Report Manager. Here is my scenario - win2003 server running Sql Server 2000
Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year to
.Net framework 2.0 so we could use Visual Studio 2005. We still have Visual
Studio 2003 so that we can use RS2000 designer. I can deploy reports OK, but
I can't open Report manager - keep gettting varoius HTTP errors, 401, 403. I
got one error that said the Webpage (for Report Manager) was looking for .Net
Framework 1.1 and couldn't find it).
I looked at IIS at the Reports Virtual Dir and the VirtualDir
tabl/Configuration dialog - the application extensions window has all the
extensions looing at .Net Framwork 1.1 which I presume is why I can still
deploy reports. But on the ReportServer virtual dir in the configuration
dialog - the application extensions window is empty, but the Wildcard
Application Extension window has this path:
C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
In the Reports virtual dir/configuration/application extensions window, the
.aspx extension points to the same path as above. Do I need to add an
extension as above to the the application Extensions window in the
configuration dialog for the ReportServer virtual dir so that Report Manger
page can run correctly?
Thanks,
RichHere is something interesting:
On the server I typed http://localhost/reportserver
and I got a directory listing of all the dirs on the report server and was
able to invoke reports directly from here. But when I type
http://localhost/reports
I get the message that the website declined to show this webpage - http
error 403 - IE can connect to the website but doesn't have permission to view
the page. Does anyone know what the difference is between the ReportServer
virtual dir and the Reports Virtual dir?
"Rich" wrote:
> Good morning,
> This is a continuation post about a problem I am having where I can't open
> Report Manager. Here is my scenario - win2003 server running Sql Server 2000
> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year to
> .Net framework 2.0 so we could use Visual Studio 2005. We still have Visual
> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK, but
> I can't open Report manager - keep gettting varoius HTTP errors, 401, 403. I
> got one error that said the Webpage (for Report Manager) was looking for .Net
> Framework 1.1 and couldn't find it).
> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> tabl/Configuration dialog - the application extensions window has all the
> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> deploy reports. But on the ReportServer virtual dir in the configuration
> dialog - the application extensions window is empty, but the Wildcard
> Application Extension window has this path:
> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> In the Reports virtual dir/configuration/application extensions window, the
> .aspx extension points to the same path as above. Do I need to add an
> extension as above to the the application Extensions window in the
> configuration dialog for the ReportServer virtual dir so that Report Manger
> page can run correctly?
> Thanks,
> Rich
>|||As I mentioned in one of my last postings to you, I thought it was weird
that you could deploy. My thought being that reportserver website might be
at 1.1 and reports being at 2.0 framework.
Report Manager (reports website) is a portal to Reporting Services. It is
just an asp.net application that integrates with ReportServer website/app.
Some people do their own front ends and do not even use Report Manager. In
RS 2000 Report Manager integrates using URL integration with ReportServer.
In RS 2005 it uses webservices to integrate.
On your server open up IIS Manager. Click on each website, right mouse
click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
and ReportServer are 1.1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> Here is something interesting:
> On the server I typed http://localhost/reportserver
> and I got a directory listing of all the dirs on the report server and was
> able to invoke reports directly from here. But when I type
> http://localhost/reports
> I get the message that the website declined to show this webpage - http
> error 403 - IE can connect to the website but doesn't have permission to
> view
> the page. Does anyone know what the difference is between the
> ReportServer
> virtual dir and the Reports Virtual dir?
> "Rich" wrote:
>> Good morning,
>> This is a continuation post about a problem I am having where I can't
>> open
>> Report Manager. Here is my scenario - win2003 server running Sql Server
>> 2000
>> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
>> to
>> .Net framework 2.0 so we could use Visual Studio 2005. We still have
>> Visual
>> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
>> but
>> I can't open Report manager - keep gettting varoius HTTP errors, 401,
>> 403. I
>> got one error that said the Webpage (for Report Manager) was looking for
>> .Net
>> Framework 1.1 and couldn't find it).
>> I looked at IIS at the Reports Virtual Dir and the VirtualDir
>> tabl/Configuration dialog - the application extensions window has all the
>> extensions looing at .Net Framwork 1.1 which I presume is why I can still
>> deploy reports. But on the ReportServer virtual dir in the configuration
>> dialog - the application extensions window is empty, but the Wildcard
>> Application Extension window has this path:
>> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
>> In the Reports virtual dir/configuration/application extensions window,
>> the
>> .aspx extension points to the same path as above. Do I need to add an
>> extension as above to the the application Extensions window in the
>> configuration dialog for the ReportServer virtual dir so that Report
>> Manger
>> page can run correctly?
>> Thanks,
>> Rich|||Hi Bruce,
Thank you again for getting back to me on this (and I appologize in advance
for being a bonehead, but unfortunately I am one - right now). When I open
up IIS Manager I go to Websites/Default Website/Reports. I right click on
Reports/select properties. In this dialog I have 5 tabs - Virtual Directory,
Documents, Directory Security, HTTP Headers, Custom Errors. I clicked around
looking for a tab/button for ASP.Net, but did not locate anything.
Quick note: from my workstation if I type http://myserver/reportserver --
I can get a directory listing of all the dirs on the report server, I can
even run reports directly from that page. But if I type
http://myserver/Reports -- now I get a message that content listing is not
permitted from this site. It must be a configuration thing. What I lack in
braincells I compenste for with perseverence. What to configure?
Thank you for your patience and helping me out.
Rich
"Bruce L-C [MVP]" wrote:
> As I mentioned in one of my last postings to you, I thought it was weird
> that you could deploy. My thought being that reportserver website might be
> at 1.1 and reports being at 2.0 framework.
> Report Manager (reports website) is a portal to Reporting Services. It is
> just an asp.net application that integrates with ReportServer website/app.
> Some people do their own front ends and do not even use Report Manager. In
> RS 2000 Report Manager integrates using URL integration with ReportServer.
> In RS 2005 it uses webservices to integrate.
> On your server open up IIS Manager. Click on each website, right mouse
> click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
> and ReportServer are 1.1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> > Here is something interesting:
> >
> > On the server I typed http://localhost/reportserver
> >
> > and I got a directory listing of all the dirs on the report server and was
> > able to invoke reports directly from here. But when I type
> > http://localhost/reports
> >
> > I get the message that the website declined to show this webpage - http
> > error 403 - IE can connect to the website but doesn't have permission to
> > view
> > the page. Does anyone know what the difference is between the
> > ReportServer
> > virtual dir and the Reports Virtual dir?
> >
> > "Rich" wrote:
> >
> >> Good morning,
> >>
> >> This is a continuation post about a problem I am having where I can't
> >> open
> >> Report Manager. Here is my scenario - win2003 server running Sql Server
> >> 2000
> >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
> >> to
> >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> >> Visual
> >> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
> >> but
> >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> >> 403. I
> >> got one error that said the Webpage (for Report Manager) was looking for
> >> .Net
> >> Framework 1.1 and couldn't find it).
> >>
> >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> >> tabl/Configuration dialog - the application extensions window has all the
> >> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> >> deploy reports. But on the ReportServer virtual dir in the configuration
> >> dialog - the application extensions window is empty, but the Wildcard
> >> Application Extension window has this path:
> >>
> >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> >>
> >> In the Reports virtual dir/configuration/application extensions window,
> >> the
> >> .aspx extension points to the same path as above. Do I need to add an
> >> extension as above to the the application Extensions window in the
> >> configuration dialog for the ReportServer virtual dir so that Report
> >> Manger
> >> page can run correctly?
> >>
> >> Thanks,
> >> Rich
> >>
>
>|||Don't know if this is of any consequence, but I was looking at Global.asax,
web.config... for each of the directories - Reports and ReportServer from
IIS. I was able to browse all the config files in ReportServer dir, but I
was not able to browse any of the config files or home.aspx from the Reports
dir. Would this have any bearing on anthing?
"Rich" wrote:
> Hi Bruce,
> Thank you again for getting back to me on this (and I appologize in advance
> for being a bonehead, but unfortunately I am one - right now). When I open
> up IIS Manager I go to Websites/Default Website/Reports. I right click on
> Reports/select properties. In this dialog I have 5 tabs - Virtual Directory,
> Documents, Directory Security, HTTP Headers, Custom Errors. I clicked around
> looking for a tab/button for ASP.Net, but did not locate anything.
> Quick note: from my workstation if I type http://myserver/reportserver --
> I can get a directory listing of all the dirs on the report server, I can
> even run reports directly from that page. But if I type
> http://myserver/Reports -- now I get a message that content listing is not
> permitted from this site. It must be a configuration thing. What I lack in
> braincells I compenste for with perseverence. What to configure?
> Thank you for your patience and helping me out.
> Rich
> "Bruce L-C [MVP]" wrote:
> > As I mentioned in one of my last postings to you, I thought it was weird
> > that you could deploy. My thought being that reportserver website might be
> > at 1.1 and reports being at 2.0 framework.
> >
> > Report Manager (reports website) is a portal to Reporting Services. It is
> > just an asp.net application that integrates with ReportServer website/app.
> > Some people do their own front ends and do not even use Report Manager. In
> > RS 2000 Report Manager integrates using URL integration with ReportServer.
> > In RS 2005 it uses webservices to integrate.
> >
> > On your server open up IIS Manager. Click on each website, right mouse
> > click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
> > and ReportServer are 1.1
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Rich" <Rich@.discussions.microsoft.com> wrote in message
> > news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> > > Here is something interesting:
> > >
> > > On the server I typed http://localhost/reportserver
> > >
> > > and I got a directory listing of all the dirs on the report server and was
> > > able to invoke reports directly from here. But when I type
> > > http://localhost/reports
> > >
> > > I get the message that the website declined to show this webpage - http
> > > error 403 - IE can connect to the website but doesn't have permission to
> > > view
> > > the page. Does anyone know what the difference is between the
> > > ReportServer
> > > virtual dir and the Reports Virtual dir?
> > >
> > > "Rich" wrote:
> > >
> > >> Good morning,
> > >>
> > >> This is a continuation post about a problem I am having where I can't
> > >> open
> > >> Report Manager. Here is my scenario - win2003 server running Sql Server
> > >> 2000
> > >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
> > >> to
> > >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> > >> Visual
> > >> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
> > >> but
> > >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> > >> 403. I
> > >> got one error that said the Webpage (for Report Manager) was looking for
> > >> .Net
> > >> Framework 1.1 and couldn't find it).
> > >>
> > >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> > >> tabl/Configuration dialog - the application extensions window has all the
> > >> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> > >> deploy reports. But on the ReportServer virtual dir in the configuration
> > >> dialog - the application extensions window is empty, but the Wildcard
> > >> Application Extension window has this path:
> > >>
> > >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> > >>
> > >> In the Reports virtual dir/configuration/application extensions window,
> > >> the
> > >> .aspx extension points to the same path as above. Do I need to add an
> > >> extension as above to the the application Extensions window in the
> > >> configuration dialog for the ReportServer virtual dir so that Report
> > >> Manger
> > >> page can run correctly?
> > >>
> > >> Thanks,
> > >> Rich
> > >>
> >
> >
> >|||My stress factor has just increased a few points. From IIS
Manager/Help/About it says that I have version 6 also. But I only see 5 tabs
when I right-click on a virtual directory/properties. I guess I am on my
own. Something was obviously not configured during the install of this
server (win2003/IIS/RS...), and I am not quite at the network admin level at
this time to figure this stuff out. Hmmm :(
Well, I have learned a few things, about things that are wrong/incorrect
with my system. And I thank you for mentoring me. I will give this my best
shot and post back if I get any positive results.
Rich
"Bruce L-C [MVP]" wrote:
> I don't know what to tell you. I have 6 tabs, not 5. The 5 you mention and
> then asp.net. My IIS version is version 6.
> I'm afraid you might have more than one thing going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:351DE8CA-E510-4D78-A8DB-3950BD317190@.microsoft.com...
> > Hi Bruce,
> >
> > Thank you again for getting back to me on this (and I appologize in
> > advance
> > for being a bonehead, but unfortunately I am one - right now). When I
> > open
> > up IIS Manager I go to Websites/Default Website/Reports. I right click on
> > Reports/select properties. In this dialog I have 5 tabs - Virtual
> > Directory,
> > Documents, Directory Security, HTTP Headers, Custom Errors. I clicked
> > around
> > looking for a tab/button for ASP.Net, but did not locate anything.
> >
> > Quick note: from my workstation if I type
> > http://myserver/reportserver --
> > I can get a directory listing of all the dirs on the report server, I can
> > even run reports directly from that page. But if I type
> > http://myserver/Reports -- now I get a message that content listing is
> > not
> > permitted from this site. It must be a configuration thing. What I lack
> > in
> > braincells I compenste for with perseverence. What to configure?
> >
> > Thank you for your patience and helping me out.
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> As I mentioned in one of my last postings to you, I thought it was weird
> >> that you could deploy. My thought being that reportserver website might
> >> be
> >> at 1.1 and reports being at 2.0 framework.
> >>
> >> Report Manager (reports website) is a portal to Reporting Services. It is
> >> just an asp.net application that integrates with ReportServer
> >> website/app.
> >> Some people do their own front ends and do not even use Report Manager.
> >> In
> >> RS 2000 Report Manager integrates using URL integration with
> >> ReportServer.
> >> In RS 2005 it uses webservices to integrate.
> >>
> >> On your server open up IIS Manager. Click on each website, right mouse
> >> click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both
> >> Reports
> >> and ReportServer are 1.1
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> >> > Here is something interesting:
> >> >
> >> > On the server I typed http://localhost/reportserver
> >> >
> >> > and I got a directory listing of all the dirs on the report server and
> >> > was
> >> > able to invoke reports directly from here. But when I type
> >> > http://localhost/reports
> >> >
> >> > I get the message that the website declined to show this webpage - http
> >> > error 403 - IE can connect to the website but doesn't have permission
> >> > to
> >> > view
> >> > the page. Does anyone know what the difference is between the
> >> > ReportServer
> >> > virtual dir and the Reports Virtual dir?
> >> >
> >> > "Rich" wrote:
> >> >
> >> >> Good morning,
> >> >>
> >> >> This is a continuation post about a problem I am having where I can't
> >> >> open
> >> >> Report Manager. Here is my scenario - win2003 server running Sql
> >> >> Server
> >> >> 2000
> >> >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last
> >> >> year
> >> >> to
> >> >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> >> >> Visual
> >> >> Studio 2003 so that we can use RS2000 designer. I can deploy reports
> >> >> OK,
> >> >> but
> >> >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> >> >> 403. I
> >> >> got one error that said the Webpage (for Report Manager) was looking
> >> >> for
> >> >> .Net
> >> >> Framework 1.1 and couldn't find it).
> >> >>
> >> >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> >> >> tabl/Configuration dialog - the application extensions window has all
> >> >> the
> >> >> extensions looing at .Net Framwork 1.1 which I presume is why I can
> >> >> still
> >> >> deploy reports. But on the ReportServer virtual dir in the
> >> >> configuration
> >> >> dialog - the application extensions window is empty, but the Wildcard
> >> >> Application Extension window has this path:
> >> >>
> >> >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> >> >>
> >> >> In the Reports virtual dir/configuration/application extensions
> >> >> window,
> >> >> the
> >> >> .aspx extension points to the same path as above. Do I need to add an
> >> >> extension as above to the the application Extensions window in the
> >> >> configuration dialog for the ReportServer virtual dir so that Report
> >> >> Manger
> >> >> page can run correctly?
> >> >>
> >> >> Thanks,
> >> >> Rich
> >> >>
> >>
> >>
> >>
>
>

How to configure ports in SQL server configuration manager

Hi,
unfortunately I mixed up the ip settings in SQL server configuration manager
(I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
have an event in the application protocol (3), it says that configuration for
SQL instances "bkupexec" and "sqlexpress" are invalid.
I tried 100 different settings in SQL configuratin manager, but the events
are remaining. I cannot find out to configure this. Backup Exce for example
has nothing where I could configure a port address for communicating with its
SQL instance.
Can someone provide me with information about what to configure in SQL
Server Configuration Manager (and probably in Backup Exec - Symantec did not
answer until now) to avoid the error messages?
Thanx in advance,
Tim
Hi
"Tim Meltzer" wrote:

> Hi,
> unfortunately I mixed up the ip settings in SQL server configuration manager
> (I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
> have an event in the application protocol (3), it says that configuration for
> SQL instances "bkupexec" and "sqlexpress" are invalid.
> I tried 100 different settings in SQL configuratin manager, but the events
> are remaining. I cannot find out to configure this. Backup Exce for example
> has nothing where I could configure a port address for communicating with its
> SQL instance.
> Can someone provide me with information about what to configure in SQL
> Server Configuration Manager (and probably in Backup Exec - Symantec did not
> answer until now) to avoid the error messages?
> Thanx in advance,
> Tim
By default SQLExpress will not have remote connections enabled. If you are
using a database on the same server then you should not need to enabled
TCP/IP.
Have you checked these instances of SQL Server are running using the service
applet or typing NET START at a command prompt?
In the Network Protocols branch under SQL Server Configuration Manager, is
the protocol Enabled? If you double click the tcp/ip entry that you will get
the IP and port settings in the properties dialog.
John
|||Hi John,
thanks for input.

> In the Network Protocols branch under SQL Server Configuration Manager, is
> the protocol Enabled?
Which protocol? I tried them all, the error no. 3 remained.

> If you double click the tcp/ip entry that you will get
> the IP and port settings in the properties dialog.
Yes, but I don't no, wether these IP settings are the right ones for Backup
Exec, I don't know, what exactly it is what Windows is complaining about.
Finally I uninstalled BE and SQL Server and reinstalled it, but without
success.
You stated, that TCP is not needed if everything is running on one server.
So I think I'm going to ignore the message since everything seems to work.
Thanks again.
|||Hi Tim
"Tim Meltzer" wrote:

> Hi John,
> thanks for input.
>
> Which protocol? I tried them all, the error no. 3 remained.
>
> Yes, but I don't no, wether these IP settings are the right ones for Backup
> Exec, I don't know, what exactly it is what Windows is complaining about.
> Finally I uninstalled BE and SQL Server and reinstalled it, but without
> success.
> You stated, that TCP is not needed if everything is running on one server.
> So I think I'm going to ignore the message since everything seems to work.
> Thanks again.
It is not clear where exactly where the error message is being displayed! Is
this in Backup exec, SQL Server error log or the Windows Event log?
If after installing Backup Exec again what protocols are enabled?
John

How to configure ports in SQL server configuration manager

Hi,
unfortunately I mixed up the ip settings in SQL server configuration manager
(I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
have an event in the application protocol (3), it says that configuration fo
r
SQL instances "bkupexec" and "sqlexpress" are invalid.
I tried 100 different settings in SQL configuratin manager, but the events
are remaining. I cannot find out to configure this. Backup Exce for example
has nothing where I could configure a port address for communicating with it
s
SQL instance.
Can someone provide me with information about what to configure in SQL
Server Configuration Manager (and probably in Backup Exec - Symantec did not
answer until now) to avoid the error messages?
Thanx in advance,
TimHi
"Tim Meltzer" wrote:

> Hi,
> unfortunately I mixed up the ip settings in SQL server configuration manag
er
> (I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
> have an event in the application protocol (3), it says that configuration
for
> SQL instances "bkupexec" and "sqlexpress" are invalid.
> I tried 100 different settings in SQL configuratin manager, but the events
> are remaining. I cannot find out to configure this. Backup Exce for exampl
e
> has nothing where I could configure a port address for communicating with
its
> SQL instance.
> Can someone provide me with information about what to configure in SQL
> Server Configuration Manager (and probably in Backup Exec - Symantec did n
ot
> answer until now) to avoid the error messages?
> Thanx in advance,
> Tim
By default SQLExpress will not have remote connections enabled. If you are
using a database on the same server then you should not need to enabled
TCP/IP.
Have you checked these instances of SQL Server are running using the service
applet or typing NET START at a command prompt?
In the Network Protocols branch under SQL Server Configuration Manager, is
the protocol Enabled? If you double click the tcp/ip entry that you will get
the IP and port settings in the properties dialog.
John|||Hi John,
thanks for input.

> In the Network Protocols branch under SQL Server Configuration Manager, is
> the protocol Enabled?
Which protocol? I tried them all, the error no. 3 remained.

> If you double click the tcp/ip entry that you will get
> the IP and port settings in the properties dialog.
Yes, but I don't no, wether these IP settings are the right ones for Backup
Exec, I don't know, what exactly it is what Windows is complaining about.
Finally I uninstalled BE and SQL Server and reinstalled it, but without
success.
You stated, that TCP is not needed if everything is running on one server.
So I think I'm going to ignore the message since everything seems to work.
Thanks again.|||Hi Tim
"Tim Meltzer" wrote:

> Hi John,
> thanks for input.
>
> Which protocol? I tried them all, the error no. 3 remained.
>
> Yes, but I don't no, wether these IP settings are the right ones for Backu
p
> Exec, I don't know, what exactly it is what Windows is complaining about.
> Finally I uninstalled BE and SQL Server and reinstalled it, but without
> success.
> You stated, that TCP is not needed if everything is running on one server.
> So I think I'm going to ignore the message since everything seems to work.
> Thanks again.
It is not clear where exactly where the error message is being displayed! Is
this in Backup exec, SQL Server error log or the Windows Event log?
If after installing Backup Exec again what protocols are enabled?
John

How to configure ports in SQL server configuration manager

Hi,
unfortunately I mixed up the ip settings in SQL server configuration manager
(I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
have an event in the application protocol (3), it says that configuration for
SQL instances "bkupexec" and "sqlexpress" are invalid.
I tried 100 different settings in SQL configuratin manager, but the events
are remaining. I cannot find out to configure this. Backup Exce for example
has nothing where I could configure a port address for communicating with its
SQL instance.
Can someone provide me with information about what to configure in SQL
Server Configuration Manager (and probably in Backup Exec - Symantec did not
answer until now) to avoid the error messages?
Thanx in advance,
TimHi
"Tim Meltzer" wrote:
> Hi,
> unfortunately I mixed up the ip settings in SQL server configuration manager
> (I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I
> have an event in the application protocol (3), it says that configuration for
> SQL instances "bkupexec" and "sqlexpress" are invalid.
> I tried 100 different settings in SQL configuratin manager, but the events
> are remaining. I cannot find out to configure this. Backup Exce for example
> has nothing where I could configure a port address for communicating with its
> SQL instance.
> Can someone provide me with information about what to configure in SQL
> Server Configuration Manager (and probably in Backup Exec - Symantec did not
> answer until now) to avoid the error messages?
> Thanx in advance,
> Tim
By default SQLExpress will not have remote connections enabled. If you are
using a database on the same server then you should not need to enabled
TCP/IP.
Have you checked these instances of SQL Server are running using the service
applet or typing NET START at a command prompt?
In the Network Protocols branch under SQL Server Configuration Manager, is
the protocol Enabled? If you double click the tcp/ip entry that you will get
the IP and port settings in the properties dialog.
John|||Hi John,
thanks for input.
> In the Network Protocols branch under SQL Server Configuration Manager, is
> the protocol Enabled?
Which protocol? I tried them all, the error no. 3 remained.
> If you double click the tcp/ip entry that you will get
> the IP and port settings in the properties dialog.
Yes, but I don't no, wether these IP settings are the right ones for Backup
Exec, I don't know, what exactly it is what Windows is complaining about.
Finally I uninstalled BE and SQL Server and reinstalled it, but without
success.
You stated, that TCP is not needed if everything is running on one server.
So I think I'm going to ignore the message since everything seems to work.
Thanks again.|||Hi Tim
"Tim Meltzer" wrote:
> Hi John,
> thanks for input.
> > In the Network Protocols branch under SQL Server Configuration Manager, is
> > the protocol Enabled?
> Which protocol? I tried them all, the error no. 3 remained.
> > If you double click the tcp/ip entry that you will get
> > the IP and port settings in the properties dialog.
> Yes, but I don't no, wether these IP settings are the right ones for Backup
> Exec, I don't know, what exactly it is what Windows is complaining about.
> Finally I uninstalled BE and SQL Server and reinstalled it, but without
> success.
> You stated, that TCP is not needed if everything is running on one server.
> So I think I'm going to ignore the message since everything seems to work.
> Thanks again.
It is not clear where exactly where the error message is being displayed! Is
this in Backup exec, SQL Server error log or the Windows Event log?
If after installing Backup Exec again what protocols are enabled?
John

Monday, March 12, 2012

How to configure DataReader Source for DataFlow

Dear Friends,

I have to import dBASE files to SQL Server. For this I have created one ODBC connection manager for those dBASE files. This I have to set for DataReader Source. But I am unable to configure the DataReader Source.

So, Please tell me how to configure DataReader Source for ODBC connection Manager.

Eagerly waiting for your valuable reply............

Santosh

INDIA

Are you getting any error?

Once in the data reader; you should provide the query and the connection manager information.

|||

Hello Santosh

Instead of creating an ODBC Connection Manager, you should create a ADO.NET Connnection Manager that uses the OdbcClient provider, and configure it to use the DSN you've set up for dBASE. I haven't tried dBASE specifically, but as a general statement the DataReader Source works only with ADO.NET connections.

-David

How to configure DataReader Source for DataFlow

Dear Friends,

I have to import dBASE files to SQL Server. For this I have created one ODBC connection manager for those dBASE files. This I have to set for DataReader Source. But I am unable to configure the DataReader Source.

So, Please tell me how to configure DataReader Source for ODBC connection Manager.

Eagerly waiting for your valuable reply............

Santosh

INDIA

Are you getting any error?

Once in the data reader; you should provide the query and the connection manager information.

|||

Hello Santosh

Instead of creating an ODBC Connection Manager, you should create a ADO.NET Connnection Manager that uses the OdbcClient provider, and configure it to use the DSN you've set up for dBASE. I haven't tried dBASE specifically, but as a general statement the DataReader Source works only with ADO.NET connections.

-David

How to configure a PULL SUBSCRIPTION?

How do I configure a pull subscription with Enterprise Manager using SQL 2000?This might help.

Sunday, February 19, 2012

How to clean up transaction logs

Hello,
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
KitRefer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>

How to clean up transaction logs

Hello,
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
Kit
Refer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>