Accessing System Tables (books online)

I have taken this comment from the SQL Server 2005 Books Online documentation but am having problems accessing the system tables (elsewhere it is stated that there is NO modification of system views, etc)

"to privileged users that can either access system tables over the DAC port or directly access database files"

How does one access the system tables over the DAC port? I have no issues connecting to the DAC port in admin mode? Is this an error within the documentation?
you can simply query the system tables over DAC connection which is otherwise not allowed. Here is one example:

select * from sys.sysprivs this succeeds on DAC but fails on non-DAC connection as

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.sysprivs'.

Thanks

|||

But, I am still having problems accessing the obfuscated text of an encrypted stored procedure. Following comment is from Books Online for CREATE PROCEDURE statement:

“ENCRYPTION

Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server 2005. Users that have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files.”

How could one retrieve the obfuscated text over the DAC port? In which system table is the text of the stored procedures stored? Could you please provide a query?

Accessing System Tables (books online)

I have taken this comment from the SQL Server 2005 Books Online documentation but am having problems accessing the system tables (elsewhere it is stated that there is NO modification of system views, etc)

"to privileged users that can either access system tables over the DAC port or directly access database files"

How does one access the system tables over the DAC port? I have no issues connecting to the DAC port in admin mode? Is this an error within the documentation?you can simply query the system tables over DAC connection which is otherwise not allowed. Here is one example:

select * from sys.sysprivs this succeeds on DAC but fails on non-DAC connection as

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.sysprivs'.

Thanks

|||

But, I am still having problems accessing the obfuscated text of an encrypted stored procedure. Following comment is from Books Online for CREATE PROCEDURE statement:

“ENCRYPTION

Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server 2005. Users that have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files.”

How could one retrieve the obfuscated text over the DAC port? In which system table is the text of the stored procedures stored? Could you please provide a query?

Accessing SQL via http

Hello,
Apologies if this is in the wrong newsgroup...
I have followed the tutorial in Books Online that is called "Creating the
nwind Virtual Directory". Everything looks ok but I get an error that
says: -
"HTTP Error 404 - File or directory not found. Internet Information Services
(IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT * FROM
Employees FOR XML AUTO&root=root
I have looked all over trying to find out what I have done wrong :(
Is there anything else that needs to be set up?
Thanks in advance
Brian.Hi
You did change <IISServer> for the actual server name?
If all the properties look ok, then you may want to try restarting the web
server to see if that helps.
Make sure that you can ping the database server from the web server.
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f2057$0$30311$da0feed9@.news.zen.co.uk...
> Hello,
> Apologies if this is in the wrong newsgroup...
> I have followed the tutorial in Books Online that is called "Creating the
> nwind Virtual Directory". Everything looks ok but I get an error that
> says: -
> "HTTP Error 404 - File or directory not found. Internet Information
> Services
> (IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT *
> FROM
> Employees FOR XML AUTO&root=root
> I have looked all over trying to find out what I have done wrong :(
> Is there anything else that needs to be set up?
> Thanks in advance
> Brian.
>|||Hi John,
Yes, I amended "<IISServer>" to "myserv"
Excuse my ignorance but I'm not sure about restarting the web server. Do you
mean the 'World Wide Web Publishing Service' in 'Services'?
Thanks for replying
Brian.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Hi
> You did change <IISServer> for the actual server name?
> If all the properties look ok, then you may want to try restarting the web
> server to see if that helps.
> Make sure that you can ping the database server from the web server.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f2057$0$30311$da0feed9@.news.zen.co.uk...
>|||Sorry, I forgot to mention that I'm trying to set this up on our server.
The database is on 1 drive, the virtual directory has been set up and I'm
trying to retrieve the data using the same server.
So, no web hosting/external parties as everything is internal.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Hi
> You did change <IISServer> for the actual server name?
> If all the properties look ok, then you may want to try restarting the web
> server to see if that helps.
> Make sure that you can ping the database server from the web server.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f2057$0$30311$da0feed9@.news.zen.co.uk...
>|||Hi
That was the reboot/restart option! Could do stop/start IIS from Internet
Information Services on the Administrators menu.
If all directories/permissions exist and are correct, you may want to try
removing the directory and re-creating it. Check the IIS logs to see if
there is more information.
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f6810$0$3556$da0feed9@.news.zen.co.uk...
> Hi John,
> Yes, I amended "<IISServer>" to "myserv"
> Excuse my ignorance but I'm not sure about restarting the web server. Do
> you mean the 'World Wide Web Publishing Service' in 'Services'?
> Thanks for replying
> Brian.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
>|||Hi John,
I had also posted the problem in the sqlserver.xml newsgroup. One suggestion
was to add a web service extension called SQLXML.
http://support.microsoft.com/defaul...4&Product=sql2k
This worked perfectly :
Thanks for your help
Brian.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uZNNK2EtFHA.3236@.TK2MSFTNGP14.phx.gbl...
> Hi
> That was the reboot/restart option! Could do stop/start IIS from Internet
> Information Services on the Administrators menu.
> If all directories/permissions exist and are correct, you may want to try
> removing the directory and re-creating it. Check the IIS logs to see if
> there is more information.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f6810$0$3556$da0feed9@.news.zen.co.uk...
>|||Hi
Yes that is a pre-requisite!
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431ffdb2$0$306$da0feed9@.news.zen.co.uk...
> Hi John,
> I had also posted the problem in the sqlserver.xml newsgroup. One
> suggestion was to add a web service extension called SQLXML.
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;810784&Product=sql2k[/ur
l]
> This worked perfectly :
> Thanks for your help
> Brian.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uZNNK2EtFHA.3236@.TK2MSFTNGP14.phx.gbl...
>

Accessing SQL via http

Hello,
Apologies if this is in the wrong newsgroup...
I have followed the tutorial in Books Online that is called "Creating the
nwind Virtual Directory". Everything looks ok but I get an error that
says: -
"HTTP Error 404 - File or directory not found. Internet Information Services
(IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT * FROM
Employees FOR XML AUTO&root=root
I have looked all over trying to find out what I have done wrong :(
Is there anything else that needs to be set up?
Thanks in advance
Brian.Could you please disable "Show friendly HTTP error messages" option in
Advanced tab of IE Options? This should give you more precise error
messages.
In the mean time, please ensure that you enable sql queries on the virtual
directory settings.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
> Hello,
> Apologies if this is in the wrong newsgroup...
> I have followed the tutorial in Books Online that is called "Creating the
> nwind Virtual Directory". Everything looks ok but I get an error that
> says: -
> "HTTP Error 404 - File or directory not found. Internet Information
> Services (IIS) when I try to test it using
> http://<IISServer>/nwind?sql=SELECT * FROM Employees FOR XML
> AUTO&root=root
> I have looked all over trying to find out what I have done wrong :(
> Is there anything else that needs to be set up?
> Thanks in advance
> Brian.
>|||Hi,
Thanks for replying, I was beginning to despair ;)
I have disabled the friendly errors as you suggested but the 404 page still
doesn't show any more detail than before.
The sql queries were already enabled on the 'nwind
Properties/Settings/Options' tab
Do you have any other suggestions?
Thanks
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
> Could you please disable "Show friendly HTTP error messages" option in
> Advanced tab of IE Options? This should give you more precise error
> messages.
> In the mean time, please ensure that you enable sql queries on the virtual
> directory settings.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
>|||I am sorry but that's all I could say. It is strange that you cannot see
more detailed error message instead of 404.
Can you access the web server for different directories and pages?
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>|||I just remember.
If you are using IIS6, you should enable some options on iis configuration
for security reasons:
http://support.microsoft.com/defaul...4&Product=sql2k
If this doesn't work, follow the steps given in this article:
http://sqlxml.org/faqs.aspx?79
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>|||Fantastic :)
I followed the first link and added the SQLXML web service extension, which
cured the problem.
I have now unchecked the 'Allow URL queries'
Thanks for your help
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:uQxZ5AFtFHA.2792@.tk2msftngp13.phx.gbl...
>I just remember.
> If you are using IIS6, you should enable some options on iis configuration
> for security reasons:
> http://support.microsoft.com/defaul...rg/faqs.aspx?79
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
>

Accessing SQL via http

Hello,
Apologies if this is in the wrong newsgroup...
I have followed the tutorial in Books Online that is called "Creating the
nwind Virtual Directory". Everything looks ok but I get an error that
says: -
"HTTP Error 404 - File or directory not found. Internet Information Services
(IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT * FROM
Employees FOR XML AUTO&root=root
I have looked all over trying to find out what I have done wrong
Is there anything else that needs to be set up?
Thanks in advance
Brian.
Could you please disable "Show friendly HTTP error messages" option in
Advanced tab of IE Options? This should give you more precise error
messages.
In the mean time, please ensure that you enable sql queries on the virtual
directory settings.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
> Hello,
> Apologies if this is in the wrong newsgroup...
> I have followed the tutorial in Books Online that is called "Creating the
> nwind Virtual Directory". Everything looks ok but I get an error that
> says: -
> "HTTP Error 404 - File or directory not found. Internet Information
> Services (IIS) when I try to test it using
> http://<IISServer>/nwind?sql=SELECT * FROM Employees FOR XML
> AUTO&root=root
> I have looked all over trying to find out what I have done wrong
> Is there anything else that needs to be set up?
> Thanks in advance
> Brian.
>
|||Hi,
Thanks for replying, I was beginning to despair ;)
I have disabled the friendly errors as you suggested but the 404 page still
doesn't show any more detail than before.
The sql queries were already enabled on the 'nwind
Properties/Settings/Options' tab
Do you have any other suggestions?
Thanks
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
> Could you please disable "Show friendly HTTP error messages" option in
> Advanced tab of IE Options? This should give you more precise error
> messages.
> In the mean time, please ensure that you enable sql queries on the virtual
> directory settings.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
> news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
>
|||I am sorry but that's all I could say. It is strange that you cannot see
more detailed error message instead of 404.
Can you access the web server for different directories and pages?
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>
|||I just remember.
If you are using IIS6, you should enable some options on iis configuration
for security reasons:
http://support.microsoft.com/default...&Product=sql2k
If this doesn't work, follow the steps given in this article:
http://sqlxml.org/faqs.aspx?79
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>
|||Fantastic
I followed the first link and added the SQLXML web service extension, which
cured the problem.
I have now unchecked the 'Allow URL queries'
Thanks for your help
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:uQxZ5AFtFHA.2792@.tk2msftngp13.phx.gbl...
>I just remember.
> If you are using IIS6, you should enable some options on iis configuration
> for security reasons:
> http://support.microsoft.com/default...&Product=sql2k
> If this doesn't work, follow the steps given in this article:
> http://sqlxml.org/faqs.aspx?79
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
> news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
>

accessing sql server 2000 with http

Hi there,

I want to access to sql server 2000 on localhost with http

.Following instructions on "Sql Server books online", If I perform on Window Server 2003 R2 operating System, the result was not unsuccessful. However, on Window XP, the result was successful.

Go to Enterprise Manager right click at the top and go to server properties click on network configuration make sure both TCP/IP and Named Pipes is enabled. Then go to VS at the top you will see data link property choose integrated and connect. Hope this helps.|||Following your instruction, the result is not expected. I think that most problem is Window Server 2003 R2 which sql is installed on. Because with Window XP, The result is right.
If you are using the Window Server 2003 or Window Server 2003 R2 OS. You attemp test this problem ( accessing sql server with http- Creating the nwind Virtual Directory).
Thank you so much.

Accessing Oracle data from Reporting Services 2000

I am receiving this error -

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'IFSDB'. (rsErrorOpeningConnection) Get Online Help ORA-12638: Credential retrieval failed

When I attempt to run a report that accesses an Oracle database. If I sign on to the report server and run the report, it is successful. When I attempt to run it from any other workstation, I get the above error.

We are running both Oracle and SQL Server on the same server.

Particulars -

SQL Server 2000,

Oracle 9.2.0.6

Windows Server 2003

Thanks for any and all help

First, I suggest to check your Oracle client configuration file (ORA_HOME\network\admin\sqlnet.ora) and consult the Oracle documentation. Most likely you can resolve the error by changing the configuration file line

SQLNET.AUTHENTICATION_SERVICES= (NTS)
into:
SQLNET.AUTHENTICATION_SERVICES=(NONE)

If you then run into other Oracle error messages, it may be causes by insufficient file system permissions to read certain files of the Oracle client installation. See this KB article for details: http://support.microsoft.com/?kbid=870668

-- Robert