Hi.
I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
connect to database from remote machines with Windows 98Se, but i can't
connect from machines with Windows XP.
ChrisI think that it is a problem with not having the 'correct' client network
utilities installed.
On the Start menu, select [All Programs], [Microsoft SQL Server], th
en
[Client Network Utility].
In the [Enabled Protocols] window, you should have both TCP/IP and Named
Pipes.
If one is missing, select the missing protocol from the list on the left
side, and click the [Enable] button.
Hopefully, if my memory is correct, that will take care of the problem.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>|||Have you tried temporarily disabling the firewall on the XP machines?
John Opincar
john.opincar@.sundesksoftware.com
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>
Showing posts with label pro. Show all posts
Showing posts with label pro. Show all posts
Tuesday, March 27, 2012
Thursday, March 22, 2012
connection pooling
We have Windows XP pro running on a laptop. I can connect
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanksNormally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/defaul...kb;en-us;169470 or
_connection_pooling.asp." target="_blank">http://msdn.microsoft.com/library/d...on_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have Windows XP pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded[vbcol=seagreen]
>the
>.
>
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanksNormally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/defaul...kb;en-us;169470 or
_connection_pooling.asp." target="_blank">http://msdn.microsoft.com/library/d...on_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have Windows XP pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded[vbcol=seagreen]
>the
>.
>
connection pooling
We have windows xp pro running on a laptop. I can connect
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanks
Normally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/default...b;en-us;169470 or
http://msdn.microsoft.com/library/de...n_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have windows xp pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>
|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect[vbcol=seagreen]
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the
>
>.
>
|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it[vbcol=seagreen]
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded
>the
>.
>
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is happening. I downloaded the
mdac 2.7 sp1 and installed it. Still the same issue.
thanks
Normally this would happen when an application is written to ask the user
for his db credentials every time it needs to log on to the database, and at
the same time has connection pooling enabled. Those two options are
incompatible.
If the app in questions opens & closes many connections throughout it's
lifetime, you'll definitely want to have connection pooling enabled. You
might want to refer to online info such as
http://support.microsoft.com/default...b;en-us;169470 or
http://msdn.microsoft.com/library/de...n_pooling.asp.
SQL_DRIVER_NOPROMPT should be specified to your call to SQLDriverConnect
when connection pooling is enabled.
Hope that helps.
- Dave
"Steve" <sr@.vincentinc.com> wrote in message
news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
> We have windows xp pro running on a laptop. I can connect
> to the server and our databases but when I try to open a
> table I get the following message
>
> "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
> is allowed when connection pooling is enabled"
> Does anybody know why this is happening. I downloaded the
> mdac 2.7 sp1 and installed it. Still the same issue.
> thanks
>
|||Thanks for your help. upon further investigation it was
only happening when the added SQL enterprise manager to a
mmc console. We dreleted the MMC console and recreated it
and the problem has since gone away.
Again thank you.
Steve
>--Original Message--
>Normally this would happen when an application is written
to ask the user
>for his db credentials every time it needs to log on to
the database, and at
>the same time has connection pooling enabled. Those two
options are
>incompatible.
>If the app in questions opens & closes many connections
throughout it's
>lifetime, you'll definitely want to have connection
pooling enabled. You
>might want to refer to online info such as
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;169470 or
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQL_DRIVER_NOPROMPT should be specified to your call to
SQLDriverConnect[vbcol=seagreen]
>when connection pooling is enabled.
>Hope that helps.
>- Dave
>
>"Steve" <sr@.vincentinc.com> wrote in message
>news:f17101c43d9d$1ca5e350$a101280a@.phx.gbl...
connect[vbcol=seagreen]
SQL_DRIVER_NOPROMPT[vbcol=seagreen]
the
>
>.
>
|||Ok its back.
The Enterprise manager snap when used in a customized MMC
window... Very odd the default console that launches
with the Enterprise Manager icon works fine and only
fails intermittently with MMC. It is odd because it only
happens when I try reviewing all rows in a table. I can
change the structure of a table just not view the data?
>--Original Message--
>Thanks for your help. upon further investigation it was
>only happening when the added SQL enterprise manager to
a
>mmc console. We dreleted the MMC console and recreated
it[vbcol=seagreen]
>and the problem has since gone away.
>Again thank you.
>Steve
written[vbcol=seagreen]
>to ask the user
>the database, and at
>options are
>throughout it's
>pooling enabled. You
>us;169470 or
>url=/library/en-
>us/odbc/htm/odbcodbc_connection_pooling.asp.
>SQLDriverConnect
>connect
open a[vbcol=seagreen]
>SQL_DRIVER_NOPROMPT
downloaded
>the
>.
>
Monday, March 19, 2012
Connection Manager - No available servers
Hi
Windows XP Pro, SQL Server 2005 (Developer) & Visual Studio 2005 (Pro)
New SSIS project (Visual Studio)
New OLE DB/SQL Native client connection.
There's no servers available in the drop down box.
All the services that need to be running are running.
Guess I've missed the obvious here 
Cheers
Dave
Hi,
did you try to enter the nae manually ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes I did. Will re-try and then post the error.|||Just tried entering the name manually and it worked...
Any ideas why I can't browse to the instance/server?
|||Do you use another port than the default one 1433 ? If so, you will have to make sure that SQL Server browser is started. What for ? See the link here for more information about the SQL Browser.http://msdn2.microsoft.com/en-us/library/ms181087.aspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Thursday, March 8, 2012
Connection fails for SQL Server 2005
I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
in getting any of the instances to start. Within Computer Management, the SQL
Server Configuration Manager reports "Cannot connect to WMI provider. You do
not have permission or the server is unreachable. etc, etc. Access is
denied.[0x80070005]".
I have been tearing my hair out all day trying to work out why I cannot get
this to start. Can anyone here give me some pointers as to what to do?
--
--
Chris JonesTry:
http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
--
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> in getting any of the instances to start. Within Computer Management, the
> SQL
> Server Configuration Manager reports "Cannot connect to WMI provider. You
> do
> not have permission or the server is unreachable. etc, etc. Access is
> denied.[0x80070005]".
> I have been tearing my hair out all day trying to work out why I cannot
> get
> this to start. Can anyone here give me some pointers as to what to do?
> --
> --
> Chris Jones
>|||oj
I already tried that. The response from the command was:-
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while opening the namespace for object 1 defined on lines
4 - 7:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
Lines 4-7 read:
Instance of __Namespace
{
Name = "Microsoft";
};
Any ideas, anyone?
--
--
Chris Jones
"oj" wrote:
> Try:
> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> > in getting any of the instances to start. Within Computer Management, the
> > SQL
> > Server Configuration Manager reports "Cannot connect to WMI provider. You
> > do
> > not have permission or the server is unreachable. etc, etc. Access is
> > denied.[0x80070005]".
> >
> > I have been tearing my hair out all day trying to work out why I cannot
> > get
> > this to start. Can anyone here give me some pointers as to what to do?
> > --
> > --
> > Chris Jones
> >
>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_001E_01C6A381.F5475800
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Chris,
WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> =right click on my computer to access the properties page) and make sure =that distributed com is on, plus, the access and launch permission is =set correctly for your system.
"
a.. Under Default Access Permissions click Edit Default. Make sure =SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication =credentials will be used to access the COM application all have Local =and Remote Access permissions.
a.. Under Default Access Permissions click Edit Limits. Service Pack 2 =comes with the following default values: ANONYMOUS LOGON (Local Access) =and Everyone (Local and Remote Access). Make sure these values are =listed, and then add the user whose authentication credentials will be =used to access the COM application. Allow this user to have Local and =Remote Access permissions.
a.. Under Default Launch Permissions click Edit Default. Make sure =SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication =credentials will be used to access the COM application all have Local =and Remote Launch permissions, as well as Local and Remote Activation =permissions.
a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 =comes with the following default values: MACHINE\Administrators (Local =and Remote Launch, Local and Remote Activation) and Everyone (Local =Launch and Local Activation). Make sure these values are listed, and =then add the user whose authentication credentials will be used to =access the COM application. Allow this user to have Local and Remote =Launch permissions, as well as Local and Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.m=
spx
-- -oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message =news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
> oj
> > I already tried that. The response from the command was:-
> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> Parsing MOF file: sqlmgmprovider.mof
> MOF file has been successfully parsed
> Storing data in the repository...
> An error occurred while opening the namespace for object 1 defined on =lines > 4 - 7:
> Error Number: 0x80070005, Facility: Win32
> Description: Access is denied.
> > Compiler returned error 0x80070005
> > Lines 4-7 read:
> > Instance of __Namespace
> {
> Name =3D "Microsoft";
> };
> > Any ideas, anyone?
> -- > -- > Chris Jones
> > > > "oj" wrote:
> >> Try:
>> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
>> >> -- >> -oj
>> >> >> >> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message =
>> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary =difficulty
>> > in getting any of the instances to start. Within Computer =Management, the >> > SQL
>> > Server Configuration Manager reports "Cannot connect to WMI =provider. You >> > do
>> > not have permission or the server is unreachable. etc, etc. Access =is
>> > denied.[0x80070005]".
>> >
>> > I have been tearing my hair out all day trying to work out why I =cannot >> > get
>> > this to start. Can anyone here give me some pointers as to what to =do?
>> > -- >> > -- >> > Chris Jones
>> > >> >> --=_NextPart_000_001E_01C6A381.F5475800
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Chris,WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers =-> right click on my computer to access the properties page) and make sure =that distributed com is on, plus, the access and launch permission is set =correctly for your system."
Under Default Access Permissions click Edit Default. =Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application =all have Local and Remote Access permissions. Under Default Access Permissions click Edit Limits. =Service Pack 2 comes with the following default values: ANONYMOUS LOGON =(Local Access) and Everyone (Local and Remote Access). Make sure these =values are listed, and then add the user whose authentication credentials will =be used to access the COM application. Allow this user to have Local and =Remote Access permissions. Under Default Launch Permissions click Edit Default. =Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application =all have Local and Remote Launch permissions, as well as Local and =Remote Activation permissions. Under Default Launch Permissions click Edit Limits. =Service Pack 2 comes with the following default values: =MACHINE\Administrators (Local and Remote Launch, Local and Remote Activation) and =Everyone (Local Launch and Local Activation). Make sure these values are listed, =and then add the user whose authentication credentials will be used to access the =COM application. Allow this user to have Local and Remote Launch =permissions, as well as Local and Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/prodtechnol/winxppro/mainta=in/sp2netwk.mspx
-- -oj"Chris Jones" wrote in message news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...> =oj> > I already tried that. The response from the command =was:-> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180> =Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.> Parsing MOF =file: sqlmgmprovider.mof> MOF file has been successfully parsed> =Storing data in the repository...> An error occurred while opening the =namespace for object 1 defined on lines > 4 - 7:> Error Number: =0x80070005, Facility: Win32> Description: Access is denied.> > =Compiler returned error 0x80070005> > Lines 4-7 read:> => Instance of __Namespace> {> Name =3D ="Microsoft";> };> > Any ideas, anyone?> -- > -- > =Chris Jones> > > > "oj" wrote:> => Try:> =">http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx>= > -- > -oj> > > > "Chris Jones" =wrote in message > news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...> =>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty> > in getting any of the instances to start. =Within Computer Management, the > > SQL> > Server Configuration Manager reports "Cannot connect to WMI provider. You => > do> > not have permission or the server is =unreachable. etc, etc. Access is> > denied.[0x80070005]".> >> > I have been tearing my hair out all day trying to =work out why I cannot > > get> > this to start. Can =anyone here give me some pointers as to what to do?> > -- => > -- > > Chris Jones> > > => >
--=_NextPart_000_001E_01C6A381.F5475800--|||Oj
Thanks for the response. Unfortunately, this was too late to prevent me
re-installing XP. The original install of XP was an upgrade from Win2k Pro
and clearly had significant issues with all sorts of things that effectively
STOPPED SQL Server (and one or two other applications) from working.
I will bear your response in mind if I get any issues with SQL Server 2k5
when I install it later.
Thanks
--
--
Chris Jones
"oj" wrote:
> Chris,
> WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> right click on my computer to access the properties page) and make sure that distributed com is on, plus, the access and launch permission is set correctly for your system.
> "
> a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application all have Local and Remote Access permissions.
> a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes with the following default values: ANONYMOUS LOGON (Local Access) and Everyone (Local and Remote Access). Make sure these values are listed, and then add the user whose authentication credentials will be used to access the COM application. Allow this user to have Local and Remote Access permissions.
> a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application all have Local and Remote Launch permissions, as well as Local and Remote Activation permissions.
> a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes with the following default values: MACHINE\Administrators (Local and Remote Launch, Local and Remote Activation) and Everyone (Local Launch and Local Activation). Make sure these values are listed, and then add the user whose authentication credentials will be used to access the COM application. Allow this user to have Local and Remote Launch permissions, as well as Local and Remote Activation permissions.
> "
> Additional info on dcom vs winxp firewall setting can be found here:
> http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx
>
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
> > oj
> >
> > I already tried that. The response from the command was:-
> > Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> > Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> > Parsing MOF file: sqlmgmprovider.mof
> > MOF file has been successfully parsed
> > Storing data in the repository...
> > An error occurred while opening the namespace for object 1 defined on lines
> > 4 - 7:
> > Error Number: 0x80070005, Facility: Win32
> > Description: Access is denied.
> >
> > Compiler returned error 0x80070005
> >
> > Lines 4-7 read:
> >
> > Instance of __Namespace
> > {
> > Name = "Microsoft";
> > };
> >
> > Any ideas, anyone?
> > --
> > --
> > Chris Jones
> >
> >
> >
> > "oj" wrote:
> >
> >> Try:
> >> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
> >>
> >> --
> >> -oj
> >>
> >>
> >>
> >> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> >> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
> >> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> >> > in getting any of the instances to start. Within Computer Management, the
> >> > SQL
> >> > Server Configuration Manager reports "Cannot connect to WMI provider. You
> >> > do
> >> > not have permission or the server is unreachable. etc, etc. Access is
> >> > denied.[0x80070005]".
> >> >
> >> > I have been tearing my hair out all day trying to work out why I cannot
> >> > get
> >> > this to start. Can anyone here give me some pointers as to what to do?
> >> > --
> >> > --
> >> > Chris Jones
> >> >
> >>
> >>
> >>
in getting any of the instances to start. Within Computer Management, the SQL
Server Configuration Manager reports "Cannot connect to WMI provider. You do
not have permission or the server is unreachable. etc, etc. Access is
denied.[0x80070005]".
I have been tearing my hair out all day trying to work out why I cannot get
this to start. Can anyone here give me some pointers as to what to do?
--
--
Chris JonesTry:
http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
--
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> in getting any of the instances to start. Within Computer Management, the
> SQL
> Server Configuration Manager reports "Cannot connect to WMI provider. You
> do
> not have permission or the server is unreachable. etc, etc. Access is
> denied.[0x80070005]".
> I have been tearing my hair out all day trying to work out why I cannot
> get
> this to start. Can anyone here give me some pointers as to what to do?
> --
> --
> Chris Jones
>|||oj
I already tried that. The response from the command was:-
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while opening the namespace for object 1 defined on lines
4 - 7:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
Lines 4-7 read:
Instance of __Namespace
{
Name = "Microsoft";
};
Any ideas, anyone?
--
--
Chris Jones
"oj" wrote:
> Try:
> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> > in getting any of the instances to start. Within Computer Management, the
> > SQL
> > Server Configuration Manager reports "Cannot connect to WMI provider. You
> > do
> > not have permission or the server is unreachable. etc, etc. Access is
> > denied.[0x80070005]".
> >
> > I have been tearing my hair out all day trying to work out why I cannot
> > get
> > this to start. Can anyone here give me some pointers as to what to do?
> > --
> > --
> > Chris Jones
> >
>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_001E_01C6A381.F5475800
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Chris,
WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> =right click on my computer to access the properties page) and make sure =that distributed com is on, plus, the access and launch permission is =set correctly for your system.
"
a.. Under Default Access Permissions click Edit Default. Make sure =SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication =credentials will be used to access the COM application all have Local =and Remote Access permissions.
a.. Under Default Access Permissions click Edit Limits. Service Pack 2 =comes with the following default values: ANONYMOUS LOGON (Local Access) =and Everyone (Local and Remote Access). Make sure these values are =listed, and then add the user whose authentication credentials will be =used to access the COM application. Allow this user to have Local and =Remote Access permissions.
a.. Under Default Launch Permissions click Edit Default. Make sure =SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication =credentials will be used to access the COM application all have Local =and Remote Launch permissions, as well as Local and Remote Activation =permissions.
a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 =comes with the following default values: MACHINE\Administrators (Local =and Remote Launch, Local and Remote Activation) and Everyone (Local =Launch and Local Activation). Make sure these values are listed, and =then add the user whose authentication credentials will be used to =access the COM application. Allow this user to have Local and Remote =Launch permissions, as well as Local and Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.m=
spx
-- -oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message =news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
> oj
> > I already tried that. The response from the command was:-
> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> Parsing MOF file: sqlmgmprovider.mof
> MOF file has been successfully parsed
> Storing data in the repository...
> An error occurred while opening the namespace for object 1 defined on =lines > 4 - 7:
> Error Number: 0x80070005, Facility: Win32
> Description: Access is denied.
> > Compiler returned error 0x80070005
> > Lines 4-7 read:
> > Instance of __Namespace
> {
> Name =3D "Microsoft";
> };
> > Any ideas, anyone?
> -- > -- > Chris Jones
> > > > "oj" wrote:
> >> Try:
>> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
>> >> -- >> -oj
>> >> >> >> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message =
>> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary =difficulty
>> > in getting any of the instances to start. Within Computer =Management, the >> > SQL
>> > Server Configuration Manager reports "Cannot connect to WMI =provider. You >> > do
>> > not have permission or the server is unreachable. etc, etc. Access =is
>> > denied.[0x80070005]".
>> >
>> > I have been tearing my hair out all day trying to work out why I =cannot >> > get
>> > this to start. Can anyone here give me some pointers as to what to =do?
>> > -- >> > -- >> > Chris Jones
>> > >> >> --=_NextPart_000_001E_01C6A381.F5475800
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Chris,WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers =-> right click on my computer to access the properties page) and make sure =that distributed com is on, plus, the access and launch permission is set =correctly for your system."
Under Default Access Permissions click Edit Default. =Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application =all have Local and Remote Access permissions. Under Default Access Permissions click Edit Limits. =Service Pack 2 comes with the following default values: ANONYMOUS LOGON =(Local Access) and Everyone (Local and Remote Access). Make sure these =values are listed, and then add the user whose authentication credentials will =be used to access the COM application. Allow this user to have Local and =Remote Access permissions. Under Default Launch Permissions click Edit Default. =Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application =all have Local and Remote Launch permissions, as well as Local and =Remote Activation permissions. Under Default Launch Permissions click Edit Limits. =Service Pack 2 comes with the following default values: =MACHINE\Administrators (Local and Remote Launch, Local and Remote Activation) and =Everyone (Local Launch and Local Activation). Make sure these values are listed, =and then add the user whose authentication credentials will be used to access the =COM application. Allow this user to have Local and Remote Launch =permissions, as well as Local and Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/prodtechnol/winxppro/mainta=in/sp2netwk.mspx
-- -oj"Chris Jones" wrote in message news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...> =oj> > I already tried that. The response from the command =was:-> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180> =Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.> Parsing MOF =file: sqlmgmprovider.mof> MOF file has been successfully parsed> =Storing data in the repository...> An error occurred while opening the =namespace for object 1 defined on lines > 4 - 7:> Error Number: =0x80070005, Facility: Win32> Description: Access is denied.> > =Compiler returned error 0x80070005> > Lines 4-7 read:> => Instance of __Namespace> {> Name =3D ="Microsoft";> };> > Any ideas, anyone?> -- > -- > =Chris Jones> > > > "oj" wrote:> => Try:> =">http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx>= > -- > -oj> > > > "Chris Jones" =wrote in message > news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...> =>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty> > in getting any of the instances to start. =Within Computer Management, the > > SQL> > Server Configuration Manager reports "Cannot connect to WMI provider. You => > do> > not have permission or the server is =unreachable. etc, etc. Access is> > denied.[0x80070005]".> >> > I have been tearing my hair out all day trying to =work out why I cannot > > get> > this to start. Can =anyone here give me some pointers as to what to do?> > -- => > -- > > Chris Jones> > > => >
--=_NextPart_000_001E_01C6A381.F5475800--|||Oj
Thanks for the response. Unfortunately, this was too late to prevent me
re-installing XP. The original install of XP was an upgrade from Win2k Pro
and clearly had significant issues with all sorts of things that effectively
STOPPED SQL Server (and one or two other applications) from working.
I will bear your response in mind if I get any issues with SQL Server 2k5
when I install it later.
Thanks
--
--
Chris Jones
"oj" wrote:
> Chris,
> WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> right click on my computer to access the properties page) and make sure that distributed com is on, plus, the access and launch permission is set correctly for your system.
> "
> a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application all have Local and Remote Access permissions.
> a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes with the following default values: ANONYMOUS LOGON (Local Access) and Everyone (Local and Remote Access). Make sure these values are listed, and then add the user whose authentication credentials will be used to access the COM application. Allow this user to have Local and Remote Access permissions.
> a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, INTERACTIVE, NETWORK, and the user whose authentication credentials will be used to access the COM application all have Local and Remote Launch permissions, as well as Local and Remote Activation permissions.
> a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes with the following default values: MACHINE\Administrators (Local and Remote Launch, Local and Remote Activation) and Everyone (Local Launch and Local Activation). Make sure these values are listed, and then add the user whose authentication credentials will be used to access the COM application. Allow this user to have Local and Remote Launch permissions, as well as Local and Remote Activation permissions.
> "
> Additional info on dcom vs winxp firewall setting can be found here:
> http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx
>
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
> > oj
> >
> > I already tried that. The response from the command was:-
> > Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> > Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> > Parsing MOF file: sqlmgmprovider.mof
> > MOF file has been successfully parsed
> > Storing data in the repository...
> > An error occurred while opening the namespace for object 1 defined on lines
> > 4 - 7:
> > Error Number: 0x80070005, Facility: Win32
> > Description: Access is denied.
> >
> > Compiler returned error 0x80070005
> >
> > Lines 4-7 read:
> >
> > Instance of __Namespace
> > {
> > Name = "Microsoft";
> > };
> >
> > Any ideas, anyone?
> > --
> > --
> > Chris Jones
> >
> >
> >
> > "oj" wrote:
> >
> >> Try:
> >> http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
> >>
> >> --
> >> -oj
> >>
> >>
> >>
> >> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> >> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
> >> >I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> >> > in getting any of the instances to start. Within Computer Management, the
> >> > SQL
> >> > Server Configuration Manager reports "Cannot connect to WMI provider. You
> >> > do
> >> > not have permission or the server is unreachable. etc, etc. Access is
> >> > denied.[0x80070005]".
> >> >
> >> > I have been tearing my hair out all day trying to work out why I cannot
> >> > get
> >> > this to start. Can anyone here give me some pointers as to what to do?
> >> > --
> >> > --
> >> > Chris Jones
> >> >
> >>
> >>
> >>
Connection fails for SQL Server 2005
I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
in getting any of the instances to start. Within Computer Management, the SQ
L
Server Configuration Manager reports "Cannot connect to WMI provider. You do
not have permission or the server is unreachable. etc, etc. Access is
denied.[0x80070005]".
I have been tearing my hair out all day trying to work out why I cannot get
this to start. Can anyone here give me some pointers as to what to do?
--
--
Chris JonesTry:
http://blogs.msdn.com/echarran/arch.../03/509061.aspx
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> in getting any of the instances to start. Within Computer Management, the
> SQL
> Server Configuration Manager reports "Cannot connect to WMI provider. You
> do
> not have permission or the server is unreachable. etc, etc. Access is
> denied.[0x80070005]".
> I have been tearing my hair out all day trying to work out why I cannot
> get
> this to start. Can anyone here give me some pointers as to what to do?
> --
> --
> Chris Jones
>|||oj
I already tried that. The response from the command was:-
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while opening the namespace for object 1 defined on lines
4 - 7:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
Lines 4-7 read:
Instance of __Namespace
{
Name = "Microsoft";
};
Any ideas, anyone?
--
--
Chris Jones
"oj" wrote:
> Try:
> http://blogs.msdn.com/echarran/arch.../03/509061.aspx
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>
>|||Chris,
WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> righ
t click on my computer to access the properties page) and make sure that dis
tributed com is on, plus, the access and launch permission is set correctly
for your system.
"
a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM, I
NTERACTIVE, NETWORK, and the user whose authentication credentials will be u
sed to access the COM application all have Local and Remote Access permissio
ns.
a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes
with the following default values: ANONYMOUS LOGON (Local Access) and Every
one (Local and Remote Access). Make sure these values are listed, and then a
dd the user whose authentication credentials will be used to access the COM
application. Allow this user to have Local and Remote Access permissions.
a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, I
NTERACTIVE, NETWORK, and the user whose authentication credentials will be u
sed to access the COM application all have Local and Remote Launch permissio
ns, as well as Local and Remote Activation permissions.
a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes
with the following default values: MACHINE\Administrators (Local and Remote
Launch, Local and Remote Activation) and Everyone (Local Launch and Local A
ctivation). Make sure these values are listed, and then add the user whose a
uthentication credentials will be used to access the COM application. Allow
this user to have Local and Remote Launch permissions, as well as Local and
Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/pr...n/sp2netwk.mspx
--
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news:D8F5C485-6131-4B4
6-A637-86643F23D32F@.microsoft.com...[vbcol=seagreen]
> oj
>
> I already tried that. The response from the command was:-
> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> Parsing MOF file: sqlmgmprovider.mof
> MOF file has been successfully parsed
> Storing data in the repository...
> An error occurred while opening the namespace for object 1 defined on line
s
> 4 - 7:
> Error Number: 0x80070005, Facility: Win32
> Description: Access is denied.
>
> Compiler returned error 0x80070005
>
> Lines 4-7 read:
>
> Instance of __Namespace
> {
> Name = "Microsoft";
> };
>
> Any ideas, anyone?
> --
> --
> Chris Jones
>
>
>
> "oj" wrote:
>|||Oj
Thanks for the response. Unfortunately, this was too late to prevent me
re-installing XP. The original install of XP was an upgrade from Win2k Pro
and clearly had significant issues with all sorts of things that effectively
STOPPED SQL Server (and one or two other applications) from working.
I will bear your response in mind if I get any issues with SQL Server 2k5
when I install it later.
Thanks
--
--
Chris Jones
"oj" wrote:
> Chris,
> WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> ri
ght click on my computer to access the properties page) and make sure that d
istributed com is on, plus, the access and launch permission is set correctl
y for your system.
> "
> a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM,
INTERACTIVE, NETWORK, and the user whose authentication credentials will be
used to access the COM application all have Local and Remote Access permiss
ions.
> a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes with
the following default values: ANONYMOUS LOGON (Local Access) and Everyone (Local and
Remote Access). Make sure these values are listed, and then add the user whose auth
ent
ication credentials will be used to access the COM application. Allow this user to have Loca
l and Remote Access permissions.
> a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, INTERAC
TIVE, NETWORK, and the user whose authentication credentials will be used to access
the COM application all have Local and Remote Launch permissions, as well as Local a
nd
Remote Activation permissions.
> a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes with
the following default values: MACHINE\Administrators (Local and Remote Launch, Local
and Remote Activation) and Everyone (Local Launch and Local Activation). Make sure
the
se values are listed, and then add the user whose authentication credentials will be used to
access the COM application. Allow this user to have Local and Remote Launch permissions, as
well as Local and Remote Activation permissions.[vbcol=seagreen]
> "
> Additional info on dcom vs winxp firewall setting can be found here:
> [url]http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx[/ur
l]
>
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news
:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
in getting any of the instances to start. Within Computer Management, the SQ
L
Server Configuration Manager reports "Cannot connect to WMI provider. You do
not have permission or the server is unreachable. etc, etc. Access is
denied.[0x80070005]".
I have been tearing my hair out all day trying to work out why I cannot get
this to start. Can anyone here give me some pointers as to what to do?
--
--
Chris JonesTry:
http://blogs.msdn.com/echarran/arch.../03/509061.aspx
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty
> in getting any of the instances to start. Within Computer Management, the
> SQL
> Server Configuration Manager reports "Cannot connect to WMI provider. You
> do
> not have permission or the server is unreachable. etc, etc. Access is
> denied.[0x80070005]".
> I have been tearing my hair out all day trying to work out why I cannot
> get
> this to start. Can anyone here give me some pointers as to what to do?
> --
> --
> Chris Jones
>|||oj
I already tried that. The response from the command was:-
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while opening the namespace for object 1 defined on lines
4 - 7:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
Lines 4-7 read:
Instance of __Namespace
{
Name = "Microsoft";
};
Any ideas, anyone?
--
--
Chris Jones
"oj" wrote:
> Try:
> http://blogs.msdn.com/echarran/arch.../03/509061.aspx
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message
> news:01E31AE4-A7E3-4DE9-8EF9-154E2B214AC4@.microsoft.com...
>
>|||Chris,
WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> righ
t click on my computer to access the properties page) and make sure that dis
tributed com is on, plus, the access and launch permission is set correctly
for your system.
"
a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM, I
NTERACTIVE, NETWORK, and the user whose authentication credentials will be u
sed to access the COM application all have Local and Remote Access permissio
ns.
a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes
with the following default values: ANONYMOUS LOGON (Local Access) and Every
one (Local and Remote Access). Make sure these values are listed, and then a
dd the user whose authentication credentials will be used to access the COM
application. Allow this user to have Local and Remote Access permissions.
a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, I
NTERACTIVE, NETWORK, and the user whose authentication credentials will be u
sed to access the COM application all have Local and Remote Launch permissio
ns, as well as Local and Remote Activation permissions.
a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes
with the following default values: MACHINE\Administrators (Local and Remote
Launch, Local and Remote Activation) and Everyone (Local Launch and Local A
ctivation). Make sure these values are listed, and then add the user whose a
uthentication credentials will be used to access the COM application. Allow
this user to have Local and Remote Launch permissions, as well as Local and
Remote Activation permissions.
"
Additional info on dcom vs winxp firewall setting can be found here:
http://www.microsoft.com/technet/pr...n/sp2netwk.mspx
--
-oj
"Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news:D8F5C485-6131-4B4
6-A637-86643F23D32F@.microsoft.com...[vbcol=seagreen]
> oj
>
> I already tried that. The response from the command was:-
> Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
> Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
> Parsing MOF file: sqlmgmprovider.mof
> MOF file has been successfully parsed
> Storing data in the repository...
> An error occurred while opening the namespace for object 1 defined on line
s
> 4 - 7:
> Error Number: 0x80070005, Facility: Win32
> Description: Access is denied.
>
> Compiler returned error 0x80070005
>
> Lines 4-7 read:
>
> Instance of __Namespace
> {
> Name = "Microsoft";
> };
>
> Any ideas, anyone?
> --
> --
> Chris Jones
>
>
>
> "oj" wrote:
>|||Oj
Thanks for the response. Unfortunately, this was too late to prevent me
re-installing XP. The original install of XP was an upgrade from Win2k Pro
and clearly had significant issues with all sorts of things that effectively
STOPPED SQL Server (and one or two other applications) from working.
I will bear your response in mind if I get any issues with SQL Server 2k5
when I install it later.
Thanks
--
--
Chris Jones
"oj" wrote:
> Chris,
> WMI works over dcom. Run "Dcomcnfg" (component sercies -> computers -> ri
ght click on my computer to access the properties page) and make sure that d
istributed com is on, plus, the access and launch permission is set correctl
y for your system.
> "
> a.. Under Default Access Permissions click Edit Default. Make sure SYSTEM,
INTERACTIVE, NETWORK, and the user whose authentication credentials will be
used to access the COM application all have Local and Remote Access permiss
ions.
> a.. Under Default Access Permissions click Edit Limits. Service Pack 2 comes with
the following default values: ANONYMOUS LOGON (Local Access) and Everyone (Local and
Remote Access). Make sure these values are listed, and then add the user whose auth
ent
ication credentials will be used to access the COM application. Allow this user to have Loca
l and Remote Access permissions.
> a.. Under Default Launch Permissions click Edit Default. Make sure SYSTEM, INTERAC
TIVE, NETWORK, and the user whose authentication credentials will be used to access
the COM application all have Local and Remote Launch permissions, as well as Local a
nd
Remote Activation permissions.
> a.. Under Default Launch Permissions click Edit Limits. Service Pack 2 comes with
the following default values: MACHINE\Administrators (Local and Remote Launch, Local
and Remote Activation) and Everyone (Local Launch and Local Activation). Make sure
the
se values are listed, and then add the user whose authentication credentials will be used to
access the COM application. Allow this user to have Local and Remote Launch permissions, as
well as Local and Remote Activation permissions.[vbcol=seagreen]
> "
> Additional info on dcom vs winxp firewall setting can be found here:
> [url]http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx[/ur
l]
>
> --
> -oj
>
> "Chris Jones" <ChrisJones@.discussions.microsoft.com> wrote in message news
:D8F5C485-6131-4B46-A637-86643F23D32F@.microsoft.com...
Saturday, February 25, 2012
Connection error - please help
I'm setting up a development environment on XP Pro. I'm working with classi
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
Connection error - please help
I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob
>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Sunday, February 12, 2012
Connecting to SQL SERVER over the Internet comes up with access denied error
I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:
SQL server does not exist or access denied. ConnectionOpen (Connect())
Some background:
I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.
Any help would be most gratefully received.
Are you using an aliased connection name for the server like DBServer or something instead of the IP? If so, make sure it is in DNS or your web servers host file.
Nick|||
Hi
Sorry for the delay... Had to shoot off elsewhere... Does this mean I have to have web services up and running on the PC that is hosting the SQL Database?
Thanks
Paul
|||It Depends. How are your web pages connecting to your sql server? Do you have 2 seperate boxes, one for web site other for sql server, or is it all on one server? Can you show your connection string to your server (remove the user name password info)?
Nick
|||Currently done have a web server at all! I am just trying to connect to the SQL database using an internet connection. I can use either a direct IP or NO-IP.com to connect to the PC. Its once I'm on the PC that I get kicked out by the SQL server.
Thanks
Paul
|||It sounds like you can make a connection to the server, but cant get authorization into the server? Try this:
Start>Control Panel>Admin Tools>Data Sources(ODBC)>System DSN>Add>SQL Server.
In the name, enter anything you want. For the server, enter the IP address and click next. Depending on how you connect (either with windows NT or SQL Server info into the machine, you will need to check the corresponding radio button. If you use NT and a different user name for SQL, uncheck the checkbox and enter your credentials and click next. If something is incorrect, it will tell you here. If not, you can make a good connection to your server. Let me know what it returns.
Nick
Hi! i'm having the same issue as Paul. I added the new datasource and it came up with this error:
Microsoft SQL Server ODBC Driver Version 03.85.1025
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
TESTS FAILED
i'm doing everything through NT auth and i'm on 2 servers. My work won't allow me to have an IIS and a SQL server on the same machine.
Any help would be great! thanks
Joel
Subscribe to:
Posts (Atom)