Showing posts with label enable. Show all posts
Showing posts with label enable. Show all posts

Tuesday, March 27, 2012

Cannot enable xp_cmdshell using DMO and VBScript

Hi,

I am trying to enable xp_cmdshell using VBScript and DMO in SQL Server 2005 Express.
But I get errror "Item cannot be found in collection corrosponding to the requested name or ordinal"

Following is the script:

Dim excmd: Set excmd = CreateObject("ADODB.Command")
Set excmd.ActiveConnection = connx ' This is connected to master database using sa account

excmd.CommandType = 4
excmd.CommandText = "sys.sp_configure"
excmd.Parameters.Refresh
excmd.Parameters(1).Value = "show advanced options"
excmd.Parameters(2).Value = 1
excmd.Parameters(3).Value = Null
excmd.Execute () ' This line fails
If (Err.Number <> 0) Then
LogText "Unable to execute stored procedure. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "RECONFIGURE WITH OVERRIDE"
excmd.Parameters.Refresh
excmd.Execute ()
If (Err.Number <> 0) Then
LogText "Unable to Refresh. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "sys.sp_configure"
excmd.Parameters.Refresh
excmd.Parameters(1).Value = "xp_cmdshell"
excmd.Parameters(2).Value = 1
excmd.Parameters(3).Value = Null
excmd.Execute ()

If (Err.Number <> 0) Then
LogText "Unable to execute sp xp_cmdshell. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "RECONFIGURE"
excmd.Parameters.Refresh
excmd.Execute ()
If (Err.Number <> 0) Then
LogText "Unable to Refresh after running sp. " & Err.Number & " " & Err.Description
Exit Sub
End If

Could any body tell me what I am missing here.

Thanks in advance
Amit

Please do not multipost, answered in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1989334&SiteID=1

Jens K. Suessmeyer

http://www.sqlserver2005.de

Cannot enable the Service Broker

When I try to enable the Service Broker I receive the following error message:
Cannot enable the Service Broker in database "msdb" because the Service
Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does not
match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
So as far as I can understand in the MSDB database the Service Broker GUID
is different from the one in the table sys.databases.
Is there a possibility to correct this so I will be able to enable the
Service Broker?
I want to enable it so I can configure the email part on this SQL server.
If the GUID itself can not be changed is there a way to rebuild the MSDB
database?
Thanks for the info,
Limmer
Try:
ALTER DATABASE MSDB SET NEW_BROKER
If SQL Agent is running, you will have to shut it down or this will hang.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Limmer" <Limmer@.discussions.microsoft.com> wrote in message
news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
> When I try to enable the Service Broker I receive the following error
> message:
> Cannot enable the Service Broker in database "msdb" because the Service
> Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does
> not
> match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
> ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
> So as far as I can understand in the MSDB database the Service Broker GUID
> is different from the one in the table sys.databases.
> Is there a possibility to correct this so I will be able to enable the
> Service Broker?
> I want to enable it so I can configure the email part on this SQL server.
> If the GUID itself can not be changed is there a way to rebuild the MSDB
> database?
> Thanks for the info,
> Limmer
>
|||Thanks Roger,
This did the trick.
Limmer
"Roger Wolter[MSFT]" wrote:

> Try:
> ALTER DATABASE MSDB SET NEW_BROKER
> If SQL Agent is running, you will have to shut it down or this will hang.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Limmer" <Limmer@.discussions.microsoft.com> wrote in message
> news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
>
>

Cannot enable the Service Broker

When I try to enable the Service Broker I receive the following error messag
e:
Cannot enable the Service Broker in database "msdb" because the Service
Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does not
match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
So as far as I can understand in the MSDB database the Service Broker GUID
is different from the one in the table sys.databases.
Is there a possibility to correct this so I will be able to enable the
Service Broker?
I want to enable it so I can configure the email part on this SQL server.
If the GUID itself can not be changed is there a way to rebuild the MSDB
database?
Thanks for the info,
LimmerTry:
ALTER DATABASE MSDB SET NEW_BROKER
If SQL Agent is running, you will have to shut it down or this will hang.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Limmer" <Limmer@.discussions.microsoft.com> wrote in message
news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
> When I try to enable the Service Broker I receive the following error
> message:
> Cannot enable the Service Broker in database "msdb" because the Service
> Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does
> not
> match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
> ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
> So as far as I can understand in the MSDB database the Service Broker GUID
> is different from the one in the table sys.databases.
> Is there a possibility to correct this so I will be able to enable the
> Service Broker?
> I want to enable it so I can configure the email part on this SQL server.
> If the GUID itself can not be changed is there a way to rebuild the MSDB
> database?
> Thanks for the info,
> Limmer
>|||Thanks Roger,
This did the trick.
Limmer
"Roger Wolter[MSFT]" wrote:

> Try:
> ALTER DATABASE MSDB SET NEW_BROKER
> If SQL Agent is running, you will have to shut it down or this will hang.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Limmer" <Limmer@.discussions.microsoft.com> wrote in message
> news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
>
>

Cannot enable the Service Broker

When I try to enable the Service Broker I receive the following error message:
Cannot enable the Service Broker in database "msdb" because the Service
Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does not
match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
So as far as I can understand in the MSDB database the Service Broker GUID
is different from the one in the table sys.databases.
Is there a possibility to correct this so I will be able to enable the
Service Broker?
I want to enable it so I can configure the email part on this SQL server.
If the GUID itself can not be changed is there a way to rebuild the MSDB
database?
Thanks for the info,
LimmerTry:
ALTER DATABASE MSDB SET NEW_BROKER
If SQL Agent is running, you will have to shut it down or this will hang.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Limmer" <Limmer@.discussions.microsoft.com> wrote in message
news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
> When I try to enable the Service Broker I receive the following error
> message:
> Cannot enable the Service Broker in database "msdb" because the Service
> Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does
> not
> match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
> ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
> So as far as I can understand in the MSDB database the Service Broker GUID
> is different from the one in the table sys.databases.
> Is there a possibility to correct this so I will be able to enable the
> Service Broker?
> I want to enable it so I can configure the email part on this SQL server.
> If the GUID itself can not be changed is there a way to rebuild the MSDB
> database?
> Thanks for the info,
> Limmer
>|||Thanks Roger,
This did the trick.
Limmer
"Roger Wolter[MSFT]" wrote:
> Try:
> ALTER DATABASE MSDB SET NEW_BROKER
> If SQL Agent is running, you will have to shut it down or this will hang.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Limmer" <Limmer@.discussions.microsoft.com> wrote in message
> news:71240018-A03C-4F0D-830A-537F95BBB662@.microsoft.com...
> > When I try to enable the Service Broker I receive the following error
> > message:
> >
> > Cannot enable the Service Broker in database "msdb" because the Service
> > Broker GUID in the database (01F9916A-21C0-4EA1-A555-A9C7A020C718) does
> > not
> > match the one in sys.databases (A7B475E6-5781-4FC2-B1E0-B0EF17FFE942).
> > ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9776)
> >
> > So as far as I can understand in the MSDB database the Service Broker GUID
> > is different from the one in the table sys.databases.
> > Is there a possibility to correct this so I will be able to enable the
> > Service Broker?
> > I want to enable it so I can configure the email part on this SQL server.
> >
> > If the GUID itself can not be changed is there a way to rebuild the MSDB
> > database?
> >
> > Thanks for the info,
> > Limmer
> >
>
>sql

Cannot enable SQL Broker

Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
Option 'ENABLE_BROKER' cannot be set in database 'master'.?
USE [master];
GO
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE WITH OVERRIDE;
GO
ALTER DATABASE [master] SET ENABLE_BROKER
I am running SQL 2005 Developer Edition (SP1) with everything
installed.
Thank you,
Michael
Because Service Broker cannot run in master. What use case causes you to
want to run Service Broker in the master DB? In general master should
contain only fairly static data and not highly dynamics data such as
messages on a queue.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161384930.975976.134060@.m73g2000cwd.googlegr oups.com...
> Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
> Option 'ENABLE_BROKER' cannot be set in database 'master'.?
> USE [master];
> GO
> EXEC sp_configure 'clr enabled', 1;
> RECONFIGURE WITH OVERRIDE;
> GO
> ALTER DATABASE [master] SET ENABLE_BROKER
>
> I am running SQL 2005 Developer Edition (SP1) with everything
> installed.
> Thank you,
> Michael
>
|||Thank you. I was reading various internet articles that do this so I
was wondering. I will stick to using specific databases for using the
broker.
- Michael
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Because Service Broker cannot run in master. What use case causes you to
> want to run Service Broker in the master DB? In general master should
> contain only fairly static data and not highly dynamics data such as
> messages on a queue.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <mpaine@.htxml.com> wrote in message
> news:1161384930.975976.134060@.m73g2000cwd.googlegr oups.com...
|||If you remember where any of those articles are let me know because they're
obviously wrong and should be fixed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161387628.283147.90060@.h48g2000cwc.googlegro ups.com...
> Thank you. I was reading various internet articles that do this so I
> was wondering. I will stick to using specific databases for using the
> broker.
> - Michael
> Roger Wolter[MSFT] wrote:
>

Cannot enable SQL Broker

Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
Option 'ENABLE_BROKER' cannot be set in database 'master'.?
USE [master];
GO
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE WITH OVERRIDE;
GO
ALTER DATABASE [master] SET ENABLE_BROKER
I am running SQL 2005 Developer Edition (SP1) with everything
installed.
Thank you,
MichaelBecause Service Broker cannot run in master. What use case causes you to
want to run Service Broker in the master DB? In general master should
contain only fairly static data and not highly dynamics data such as
messages on a queue.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161384930.975976.134060@.m73g2000cwd.googlegroups.com...
> Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
> Option 'ENABLE_BROKER' cannot be set in database 'master'.?
> USE [master];
> GO
> EXEC sp_configure 'clr enabled', 1;
> RECONFIGURE WITH OVERRIDE;
> GO
> ALTER DATABASE [master] SET ENABLE_BROKER
>
> I am running SQL 2005 Developer Edition (SP1) with everything
> installed.
> Thank you,
> Michael
>|||Thank you. I was reading various internet articles that do this so I
was wondering. I will stick to using specific databases for using the
broker.
- Michael
Roger Wolter[MSFT] wrote:
> Because Service Broker cannot run in master. What use case causes you to
> want to run Service Broker in the master DB? In general master should
> contain only fairly static data and not highly dynamics data such as
> messages on a queue.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <mpaine@.htxml.com> wrote in message
> news:1161384930.975976.134060@.m73g2000cwd.googlegroups.com...
> > Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
> > Option 'ENABLE_BROKER' cannot be set in database 'master'.?
> >
> > USE [master];
> > GO
> >
> > EXEC sp_configure 'clr enabled', 1;
> > RECONFIGURE WITH OVERRIDE;
> > GO
> >
> > ALTER DATABASE [master] SET ENABLE_BROKER
> >
> >
> > I am running SQL 2005 Developer Edition (SP1) with everything
> > installed.
> >
> > Thank you,
> > Michael
> >|||If you remember where any of those articles are let me know because they're
obviously wrong and should be fixed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161387628.283147.90060@.h48g2000cwc.googlegroups.com...
> Thank you. I was reading various internet articles that do this so I
> was wondering. I will stick to using specific databases for using the
> broker.
> - Michael
> Roger Wolter[MSFT] wrote:
>> Because Service Broker cannot run in master. What use case causes you to
>> want to run Service Broker in the master DB? In general master should
>> contain only fairly static data and not highly dynamics data such as
>> messages on a queue.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> <mpaine@.htxml.com> wrote in message
>> news:1161384930.975976.134060@.m73g2000cwd.googlegroups.com...
>> > Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
>> > Option 'ENABLE_BROKER' cannot be set in database 'master'.?
>> >
>> > USE [master];
>> > GO
>> >
>> > EXEC sp_configure 'clr enabled', 1;
>> > RECONFIGURE WITH OVERRIDE;
>> > GO
>> >
>> > ALTER DATABASE [master] SET ENABLE_BROKER
>> >
>> >
>> > I am running SQL 2005 Developer Edition (SP1) with everything
>> > installed.
>> >
>> > Thank you,
>> > Michael
>> >
>

Cannot enable SQL Broker

Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
Option 'ENABLE_BROKER' cannot be set in database 'master'.?
USE [master];
GO
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE WITH OVERRIDE;
GO
ALTER DATABASE [master] SET ENABLE_BROKER
I am running SQL 2005 Developer Edition (SP1) with everything
installed.
Thank you,
MichaelBecause Service Broker cannot run in master. What use case causes you to
want to run Service Broker in the master DB? In general master should
contain only fairly static data and not highly dynamics data such as
messages on a queue.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161384930.975976.134060@.m73g2000cwd.googlegroups.com...
> Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2,
> Option 'ENABLE_BROKER' cannot be set in database 'master'.?
> USE [master];
> GO
> EXEC sp_configure 'clr enabled', 1;
> RECONFIGURE WITH OVERRIDE;
> GO
> ALTER DATABASE [master] SET ENABLE_BROKER
>
> I am running SQL 2005 Developer Edition (SP1) with everything
> installed.
> Thank you,
> Michael
>|||Thank you. I was reading various internet articles that do this so I
was wondering. I will stick to using specific databases for using the
broker.
- Michael
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Because Service Broker cannot run in master. What use case causes you to
> want to run Service Broker in the master DB? In general master should
> contain only fairly static data and not highly dynamics data such as
> messages on a queue.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <mpaine@.htxml.com> wrote in message
> news:1161384930.975976.134060@.m73g2000cwd.googlegroups.com...|||If you remember where any of those articles are let me know because they're
obviously wrong and should be fixed.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<mpaine@.htxml.com> wrote in message
news:1161387628.283147.90060@.h48g2000cwc.googlegroups.com...
> Thank you. I was reading various internet articles that do this so I
> was wondering. I will stick to using specific databases for using the
> broker.
> - Michael
> Roger Wolter[MSFT] wrote:
>

Cannot Enable Remote Connections for AS 2005 on clustered instance

Hello SQL pros -

I am having a problem with enabling the remote connections for Analysis
Services 2005, Here's the gist....

--Error Information--
"To configure Analysis Services for Remote Connections, you must be an
adminsitrator for Analysis Services Windows Service (SQLSAC).

Additonal Info
A connection cannot be made. Ensure that service is running
(Microsoft.AnalysisServices)
No connection could be made because the target machine actively refused
it (System)."

--Actions Taken--
1) Analysis Services Windows Service was confirmed to be running.
2) Analysis Services Windows Service was stopped and restarted.
3) Analysis Services Windows Service (and SQL Accounts) confirmed to be
running under domain account with administrator priviledges.
4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)

--OS/System Information--
Windows 2000 Service Pack 5

--Clustering Roles--
Primary node for 1 SQL 2000 SP4 instance
Secondary node 1 SQL 2000 SP4 instance
Primary node for 1 Analysis Services 2000 instance
Primary node for 1 SQL 2005 instance, and primary
Primary node for 1 SQL 2005 Analysis Services Instance

I didn't find anything of relevance in the Windows logs or SQL logs.
So I am not sure where else to look. Is this a bug with 2005?

Any Suggestions to help troubleshoot are greatly appreciated!

thanks in advance.

ben

First.

Here some fresh blog post on how to troubleshoot connectivity problems with Analysis Services:

http://www.sqljunkies.com/WebLog/edwardm/

Second.
You saying
"4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)"

Analysis Services support only Windows Authentication when connecing through TCP/IP.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Please also note when connecting to clustered Analysis Server you only need to specify "VirtualServer" as a server name , not "VirtualServer\Instace".

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

ANTIVIRUS PROBLEM

uninstall your antivirus and try again

Cannot enable full text indexing

I also have the 'greyed-out' menu problem for full-text indexing and have
researched every post and article available.
The MSSEARCH service is running, and the SQL Server 2000 is upgraded through
SP3a. The Security tab for the server is set for "SQL Server and Windows"
authentication and the Startup Service Account is "System account". The EM
will not allow a change to "This account ... LocalSystem"--it changes back to
"System account" when the change is made.
I have also tried executing sp_fulltext_database in Query Analyzer and
receive this error:
"Full-Text Search is not installed, or a full-text component cannot be
loaded."
There are no icons for full-text indexing under Support Services in EM and I
am wondering if SQL Server itself needs to be re-installed. I have
re-installed SP3, but have not done a complete SQL Server re-install.
I am running this server under XP Professional on a local machine.
What is missing here?
seeker
can you run this script on your problem machine? Post the results back here.
save this script as a vbs file and run it from the command prompt
You many need to do a cscript.exe //H:CScript if you get a lot of dialog
boxes.
Set objSearchAdmin=CreateObject("MSSearch.Admin")
Set infoNT=CreateObject("WinNTSystemInfo")
wscript.echo"Host Name: "& objSearchAdmin.HostName
objSearchAdmin.HostName =InfoNT.ComputerName
Set objApplications=objSearchAdmin.Applications
wscript.echo "Number of Search Applications serviced by this Build Server: "
& objApplications.Count
for each application in objApplications
wscript.echo "Application Name: " & application.name
next
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"seeker" <seeker@.discussions.microsoft.com> wrote in message
news:75D2062B-0704-4847-9388-0D16866D9AF0@.microsoft.com...
> I also have the 'greyed-out' menu problem for full-text indexing and have
> researched every post and article available.
> The MSSEARCH service is running, and the SQL Server 2000 is upgraded
through
> SP3a. The Security tab for the server is set for "SQL Server and Windows"
> authentication and the Startup Service Account is "System account". The
EM
> will not allow a change to "This account ... LocalSystem"--it changes back
to
> "System account" when the change is made.
> I have also tried executing sp_fulltext_database in Query Analyzer and
> receive this error:
> "Full-Text Search is not installed, or a full-text component cannot be
> loaded."
> There are no icons for full-text indexing under Support Services in EM and
I
> am wondering if SQL Server itself needs to be re-installed. I have
> re-installed SP3, but have not done a complete SQL Server re-install.
> I am running this server under XP Professional on a local machine.
> What is missing here?
> --
> seeker
|||Thank you for your note, Hilary.
I resolved this problem with a re-install of SQL Server (Developer). When I
put in the CD, I discovered that it had been installed with Full Text
Indexing unchecked, which is the default.
I took it all the way through the SP3 update, and at the point the Full Text
Indexing selection was enabled.
"Hilary Cotter" wrote:

> can you run this script on your problem machine? Post the results back here.
> save this script as a vbs file and run it from the command prompt
> You many need to do a cscript.exe //H:CScript if you get a lot of dialog
> boxes.
> Set objSearchAdmin=CreateObject("MSSearch.Admin")
> Set infoNT=CreateObject("WinNTSystemInfo")
> wscript.echo"Host Name: "& objSearchAdmin.HostName
> objSearchAdmin.HostName =InfoNT.ComputerName
> Set objApplications=objSearchAdmin.Applications
> wscript.echo "Number of Search Applications serviced by this Build Server: "
> & objApplications.Count
> for each application in objApplications
> wscript.echo "Application Name: " & application.name
> next
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "seeker" <seeker@.discussions.microsoft.com> wrote in message
> news:75D2062B-0704-4847-9388-0D16866D9AF0@.microsoft.com...
> through
> EM
> to
> I
>
>
sql

Friday, February 24, 2012

Cannot connect to SQL Server or MSDE when enable ICF

Hi,
I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I have installed both MSDE and SQL server on my machine, while I test my application from another machine my App cannot connect to my machine. Then I think the problem is because the I
CF.
Is there anyone know how to configure the port for SQL server or MSDE?
Cheer,
KPH
Hi,
when you look in the properties of your server there you can see the port,
the server is using.
I dont know if the icf can be configured so that a special port is open.
Perhaps you should use zonealarm for this or an other firewall which can be
more configured.
Or disable the icf, if possible.
I think the standardport is 1433.
Regards
Alexander
"KPH" <KPH@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2D296E26-38B1-48A4-8414-9D8C84A366C7@.microsoft.com...
> Hi,
> I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I
have installed both MSDE and SQL server on my machine, while I test my
application from another machine my App cannot connect to my machine. Then I
think the problem is because the ICF.
> Is there anyone know how to configure the port for SQL server or MSDE?
> Cheer,
> KPH

Cannot connect to SQL Server or MSDE when enable ICF

Hi,
I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I have installed both MSDE and SQL server on my machine, while I test my application from another machine my App cannot connect to my machine. Then I think the problem is because the ICF.
Is there anyone know how to configure the port for SQL server or MSDE?
Cheer,
KPHHi,
when you look in the properties of your server there you can see the port,
the server is using.
I don´t know if the icf can be configured so that a special port is open.
Perhaps you should use zonealarm for this or an other firewall which can be
more configured.
Or disable the icf, if possible.
I think the standardport is 1433.
Regards
Alexander
"KPH" <KPH@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2D296E26-38B1-48A4-8414-9D8C84A366C7@.microsoft.com...
> Hi,
> I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I
have installed both MSDE and SQL server on my machine, while I test my
application from another machine my App cannot connect to my machine. Then I
think the problem is because the ICF.
> Is there anyone know how to configure the port for SQL server or MSDE?
> Cheer,
> KPH

Cannot connect to SQL Server or MSDE when enable ICF

Hi,
I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I hav
e installed both MSDE and SQL server on my machine, while I test my applicat
ion from another machine my App cannot connect to my machine. Then I think t
he problem is because the I
CF.
Is there anyone know how to configure the port for SQL server or MSDE?
Cheer,
KPHHi,
when you look in the properties of your server there you can see the port,
the server is using.
I dont know if the icf can be configured so that a special port is open.
Perhaps you should use zonealarm for this or an other firewall which can be
more configured.
Or disable the icf, if possible.
I think the standardport is 1433.
Regards
Alexander
"KPH" <KPH@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2D296E26-38B1-48A4-8414-9D8C84A366C7@.microsoft.com...
> Hi,
> I enable Internet Connection Firewall (ICF) on my machine (WinXP SP1). I
have installed both MSDE and SQL server on my machine, while I test my
application from another machine my App cannot connect to my machine. Then I
think the problem is because the ICF.
> Is there anyone know how to configure the port for SQL server or MSDE?
> Cheer,
> KPH