Help on ANSI

Hi all!!!!!!
My requirement is to write DDL and DML scripts which are ANSI complient, so that it can run on MS SQL server 7.0 & 2000, Oracle 8i & 9i, DB@. and Sybase.
So could U plz tell me where can I find ANSI Standards for this.Originally posted by sameer_mehta198
Hi all!!!!!!

My requirement is to write DDL and DML scripts which are ANSI complient, so that it can run on MS SQL server 7.0 & 2000, Oracle 8i & 9i, DB@. and Sybase.

So could U plz tell me where can I find ANSI Standards for this.

How about:

http://webstore.ansi.org/ansidocstore/default.asp

a little google will do ya...

help needed on configure reporting service

report server: sql2005
remote database server: clustered server, sql2005
while configure on report server failed on the step:
create a grant scripts
with the error message:
System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts (Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
set to 1 on the database srever. Also no firewall on the database server.
Any one have some hint on this one, any help is welcome.
ThanksWhat user are you using to run the services?
daw
"green hand" wrote:
> report server: sql2005
> remote database server: clustered server, sql2005
> while configure on report server failed on the step:
> create a grant scripts
> with the error message:
> System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> unavailable. (Exception from HRESULT: 0x800706BA)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementScope.InitializeGuts (Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> set to 1 on the database srever. Also no firewall on the database server.
> Any one have some hint on this one, any help is welcome.
> Thanks|||the user to run the RPC and to configure the report ingservice has the System
admin for the systme and database.
"daw" wrote:
> What user are you using to run the services?
> daw
> "green hand" wrote:
> > report server: sql2005
> > remote database server: clustered server, sql2005
> >
> > while configure on report server failed on the step:
> > create a grant scripts
> >
> > with the error message:
> > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > unavailable. (Exception from HRESULT: 0x800706BA)
> > at
> > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > errorCode, IntPtr errorInfo)
> > at System.Management.ManagementScope.InitializeGuts (Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > set to 1 on the database srever. Also no firewall on the database server.
> >
> > Any one have some hint on this one, any help is welcome.
> >
> > Thanks|||I'm not familiar with the problem, but hopefully one of these links will help:
http://support.microsoft.com/kb/224370
http://msdn2.microsoft.com/en-us/library/ms365170.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/09/22/473012.aspx
daw
"green hand" wrote:
> the user to run the RPC and to configure the report ingservice has the System
> admin for the systme and database.
> "daw" wrote:
> > What user are you using to run the services?
> >
> > daw
> >
> > "green hand" wrote:
> >
> > > report server: sql2005
> > > remote database server: clustered server, sql2005
> > >
> > > while configure on report server failed on the step:
> > > create a grant scripts
> > >
> > > with the error message:
> > > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > > unavailable. (Exception from HRESULT: 0x800706BA)
> > > at
> > > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > > errorCode, IntPtr errorInfo)
> > > at System.Management.ManagementScope.InitializeGuts (Object o)
> > > at System.Management.ManagementScope.Initialize()
> > > at System.Management.ManagementObjectSearcher.Initialize()
> > > at System.Management.ManagementObjectSearcher.Get()
> > > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > > machine)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > > dbServer)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > > connectionString, String server, String database,
> > > ConfigurationCredentialsType credsType, String account, String password,
> > > Boolean upgrade, String dbVersion)
> > >
> > > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > > set to 1 on the database srever. Also no firewall on the database server.
> > >
> > > Any one have some hint on this one, any help is welcome.
> > >
> > > Thanks