| Author |
Message |
Jan Hruz
Guest
|
 Posted:
Wed Dec 01, 2004 3:46 pm Post subject:
CS and SQL Server separated |
|
|
Hi all,
we are trying to install CS and SQL Server on different machines. There were
the whole list of problems. Finally we succeed and CS creates its databases
on sql server but still one problem persists.
When we browse CS Application it looks that it tries to connect to localhost
instead of remote SQL Server.
Any ideas ? Do someone successfully run CS and SQL Server on different
machines ?
Jan |
|
| Back to top |
|
 |
Robert Bogue [MVP]
Guest
|
| Posted:
Wed Dec 01, 2004 6:37 pm Post subject:
Re: CS and SQL Server separated |
|
|
Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start walking
through all of the resources and checking their properties to see if they
have connection strings. The one placce that gives a lot of people trouble
is the profile connection string. It can be found under Global Resources,
Profiles, Profile Data Sources, and there should be a SQL data source under
there which has a connection string that you may have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot to
bring my Commerce Server VPC image with me. If you can't find it let me
know, I'll have access to get the exact steps sometime tomorrow.
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:OWuemq41EHA.4028@TK2MSFTNGP15.phx.gbl...
| Quote: | Hi all,
we are trying to install CS and SQL Server on different machines. There
were the whole list of problems. Finally we succeed and CS creates its
databases on sql server but still one problem persists.
When we browse CS Application it looks that it tries to connect to
localhost instead of remote SQL Server.
Any ideas ? Do someone successfully run CS and SQL Server on different
machines ?
Jan
|
|
|
| Back to top |
|
|
Jan Hruz
Guest
|
| Posted:
Thu Dec 02, 2004 3:14 am Post subject:
Re: CS and SQL Server separated |
|
|
Rob,
thanks for answer. I feel much better if i know that solution exists :-).
We analyze current situation and it looks that problem is only with OLAP
database.
It gave error :
Database XXX does not exist", Source: MS OLEDB Provider for Analysis
Services
Then we tried to change OLEDB Provider (recommended by MS expert) and we
moved forward, but it still doesn't work :-P More information tomorrow.
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
| Quote: | Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to see
if they have connection strings. The one placce that gives a lot of
people trouble is the profile connection string. It can be found under
Global Resources, Profiles, Profile Data Sources, and there should be a
SQL data source under there which has a connection string that you may
have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot to
bring my Commerce Server VPC image with me. If you can't find it let me
know, I'll have access to get the exact steps sometime tomorrow.
Rob |
|
|
| Back to top |
|
|
Jan Hruz
Guest
|
| Posted:
Thu Dec 02, 2004 10:55 pm Post subject:
Re: CS and SQL Server separated |
|
|
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on the
server A.
We have installed commerce server 2002 on the server B. This time they are
running as domain administrator.(just in order to avoid problems with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
| Quote: | Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to see
if they have connection strings. The one placce that gives a lot of
people trouble is the profile connection string. It can be found under
Global Resources, Profiles, Profile Data Sources, and there should be a
SQL data source under there which has a connection string that you may
have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot to
bring my Commerce Server VPC image with me. If you can't find it let me
know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Robert Bogue [MVP]
Guest
|
| Posted:
Fri Dec 03, 2004 7:38 am Post subject:
Re: CS and SQL Server separated |
|
|
Did you change the default security in Analysis Services to not include the
everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
| Quote: | Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on the
server A.
We have installed commerce server 2002 on the server B. This time they are
running as domain administrator.(just in order to avoid problems with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to see
if they have connection strings. The one placce that gives a lot of
people trouble is the profile connection string. It can be found under
Global Resources, Profiles, Profile Data Sources, and there should be a
SQL data source under there which has a connection string that you may
have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot
to bring my Commerce Server VPC image with me. If you can't find it let
me know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Jan Hruz
Guest
|
| Posted:
Fri Dec 03, 2004 9:45 pm Post subject:
Re: CS and SQL Server separated |
|
|
We've found what was wrong. Connecting directly from vbscript works f.e.:
set oGetADOConnection = nothing
sConnectionString = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=olapserver;Initial Catalog=cnet6_dw"
Set oConn = CreateObject("ADODB.Connection")
if Err.number <> 0 then
setError "", sGetErrorByID("Cant_create_object"), sGetScriptError(Err),
ERROR_ICON_ALERT
end if
oConn.ConnectionTimeout = AD_CONNECTION_TIMEOUT
oConn.CommandTimeout = AD_COMMAND_TIMEOUT
oConn.Open sConnectionString
set oGetADOConnection = oConn
but when the application tries to connect from ASP script it failed. :-P
Security problem ?
OLAP server and CSS-IIS server are in the same domain. IIS is running under
standard local user account "Network Service". In the OLAP server's event
log appears "anonymous connection" when unsuccesfully trying from ASP page,
and regular user name when successfully trying from vbs. Is the ASP page
from IIS trynig to connect the OLAP server anonymously? Is ther any way to
force it to connect as a regular user?
Regards,
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:e179NjN2EHA.936@TK2MSFTNGP12.phx.gbl...
| Quote: | Did you change the default security in Analysis Services to not include
the everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on the
server A.
We have installed commerce server 2002 on the server B. This time they
are running as domain administrator.(just in order to avoid problems with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote
in message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to
see if they have connection strings. The one placce that gives a lot of
people trouble is the profile connection string. It can be found under
Global Resources, Profiles, Profile Data Sources, and there should be a
SQL data source under there which has a connection string that you may
have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot
to bring my Commerce Server VPC image with me. If you can't find it let
me know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Tea C
Guest
|
| Posted:
Sat Dec 04, 2004 1:59 am Post subject:
Re: CS and SQL Server separated |
|
|
From IIS Manager, navigate to ASP page that tries to connect to DB as
anonymous user per your posting below:
1. Right click on the ASP page and select Properties.
2. Go to Directory Security tab.
3. Click the Edit button.
4. What security settings do you have for the page? Is anonymous checked?
Depending on the IIS security settings for the page, different UID will be
passed to SQL Server for authentication.
Tea C.
"Jan Hruz" wrote:
| Quote: | We've found what was wrong. Connecting directly from vbscript works f.e.:
set oGetADOConnection = nothing
sConnectionString = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=olapserver;Initial Catalog=cnet6_dw"
Set oConn = CreateObject("ADODB.Connection")
if Err.number <> 0 then
setError "", sGetErrorByID("Cant_create_object"), sGetScriptError(Err),
ERROR_ICON_ALERT
end if
oConn.ConnectionTimeout = AD_CONNECTION_TIMEOUT
oConn.CommandTimeout = AD_COMMAND_TIMEOUT
oConn.Open sConnectionString
set oGetADOConnection = oConn
but when the application tries to connect from ASP script it failed. :-P
Security problem ?
OLAP server and CSS-IIS server are in the same domain. IIS is running under
standard local user account "Network Service". In the OLAP server's event
log appears "anonymous connection" when unsuccesfully trying from ASP page,
and regular user name when successfully trying from vbs. Is the ASP page
from IIS trynig to connect the OLAP server anonymously? Is ther any way to
force it to connect as a regular user?
Regards,
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:e179NjN2EHA.936@TK2MSFTNGP12.phx.gbl...
Did you change the default security in Analysis Services to not include
the everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on the
server A.
We have installed commerce server 2002 on the server B. This time they
are running as domain administrator.(just in order to avoid problems with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote
in message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe half a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to
see if they have connection strings. The one placce that gives a lot of
people trouble is the profile connection string. It can be found under
Global Resources, Profiles, Profile Data Sources, and there should be a
SQL data source under there which has a connection string that you may
have to change.
My directions may be a bit off, I'm just ending a vacation and I forgot
to bring my Commerce Server VPC image with me. If you can't find it let
me know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Viktor Kollarik
Guest
|
| Posted:
Tue Dec 07, 2004 11:16 pm Post subject:
Re: CS and SQL Server separated |
|
|
Hi,
I am cooperating with Jan Hruz on the problem.
We have Anonymous access denied on for the directory. Only windows
auhentication is allowed.
But despite the fact in the targer server with sql in system event log there
is an event about connection anonymous from the commerce server side.
Viktor Kollarik
"Tea C" <smece1972@yahoo.com.nospam> wrote in message
news:B7D15BE6-71BD-4488-BB23-6DEF12C34813@microsoft.com...
| Quote: | From IIS Manager, navigate to ASP page that tries to connect to DB as
anonymous user per your posting below:
1. Right click on the ASP page and select Properties.
2. Go to Directory Security tab.
3. Click the Edit button.
4. What security settings do you have for the page? Is anonymous checked?
Depending on the IIS security settings for the page, different UID will be
passed to SQL Server for authentication.
Tea C.
"Jan Hruz" wrote:
We've found what was wrong. Connecting directly from vbscript works f.e.:
set oGetADOConnection = nothing
sConnectionString = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=olapserver;Initial Catalog=cnet6_dw"
Set oConn = CreateObject("ADODB.Connection")
if Err.number <> 0 then
setError "", sGetErrorByID("Cant_create_object"), sGetScriptError(Err),
ERROR_ICON_ALERT
end if
oConn.ConnectionTimeout = AD_CONNECTION_TIMEOUT
oConn.CommandTimeout = AD_COMMAND_TIMEOUT
oConn.Open sConnectionString
set oGetADOConnection = oConn
but when the application tries to connect from ASP script it failed. :-P
Security problem ?
OLAP server and CSS-IIS server are in the same domain. IIS is running
under
standard local user account "Network Service". In the OLAP server's event
log appears "anonymous connection" when unsuccesfully trying from ASP
page,
and regular user name when successfully trying from vbs. Is the ASP page
from IIS trynig to connect the OLAP server anonymously? Is ther any way
to
force it to connect as a regular user?
Regards,
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote
in
message news:e179NjN2EHA.936@TK2MSFTNGP12.phx.gbl...
Did you change the default security in Analysis Services to not include
the everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot
Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same
windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on
the
server A.
We have installed commerce server 2002 on the server B. This time they
are running as domain administrator.(just in order to avoid problems
with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he
database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com
wrote
in message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe half
a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to
see if they have connection strings. The one placce that gives a lot
of
people trouble is the profile connection string. It can be found
under
Global Resources, Profiles, Profile Data Sources, and there should
be a
SQL data source under there which has a connection string that you
may
have to change.
My directions may be a bit off, I'm just ending a vacation and I
forgot
to bring my Commerce Server VPC image with me. If you can't find it
let
me know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Tea C
Guest
|
| Posted:
Wed Dec 08, 2004 7:09 am Post subject:
Re: CS and SQL Server separated |
|
|
Viktor,
Please see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csvr2002/htm/cs_se_securityconcepts_rvxn.asp
I believe it confirms you scenario.
Tea C.
"Viktor Kollarik" wrote:
| Quote: | Hi,
I am cooperating with Jan Hruz on the problem.
We have Anonymous access denied on for the directory. Only windows
auhentication is allowed.
But despite the fact in the targer server with sql in system event log there
is an event about connection anonymous from the commerce server side.
Viktor Kollarik
"Tea C" <smece1972@yahoo.com.nospam> wrote in message
news:B7D15BE6-71BD-4488-BB23-6DEF12C34813@microsoft.com...
From IIS Manager, navigate to ASP page that tries to connect to DB as
anonymous user per your posting below:
1. Right click on the ASP page and select Properties.
2. Go to Directory Security tab.
3. Click the Edit button.
4. What security settings do you have for the page? Is anonymous checked?
Depending on the IIS security settings for the page, different UID will be
passed to SQL Server for authentication.
Tea C.
"Jan Hruz" wrote:
We've found what was wrong. Connecting directly from vbscript works f.e.:
set oGetADOConnection = nothing
sConnectionString = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=olapserver;Initial Catalog=cnet6_dw"
Set oConn = CreateObject("ADODB.Connection")
if Err.number <> 0 then
setError "", sGetErrorByID("Cant_create_object"), sGetScriptError(Err),
ERROR_ICON_ALERT
end if
oConn.ConnectionTimeout = AD_CONNECTION_TIMEOUT
oConn.CommandTimeout = AD_COMMAND_TIMEOUT
oConn.Open sConnectionString
set oGetADOConnection = oConn
but when the application tries to connect from ASP script it failed. :-P
Security problem ?
OLAP server and CSS-IIS server are in the same domain. IIS is running
under
standard local user account "Network Service". In the OLAP server's event
log appears "anonymous connection" when unsuccesfully trying from ASP
page,
and regular user name when successfully trying from vbs. Is the ASP page
from IIS trynig to connect the OLAP server anonymously? Is ther any way
to
force it to connect as a regular user?
Regards,
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote
in
message news:e179NjN2EHA.936@TK2MSFTNGP12.phx.gbl...
Did you change the default security in Analysis Services to not include
the everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot
Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same
windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server on
the
server A.
We have installed commerce server 2002 on the server B. This time they
are running as domain administrator.(just in order to avoid problems
with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005) Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he
database
exists and is also accessible form the server B via analysis manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com
wrote
in message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe half
a
dozen) that the connection string is stored. My suggestion is start
walking through all of the resources and checking their properties to
see if they have connection strings. The one placce that gives a lot
of
people trouble is the profile connection string. It can be found
under
Global Resources, Profiles, Profile Data Sources, and there should
be a
SQL data source under there which has a connection string that you
may
have to change.
My directions may be a bit off, I'm just ending a vacation and I
forgot
to bring my Commerce Server VPC image with me. If you can't find it
let
me know, I'll have access to get the exact steps sometime tomorrow.
Rob
|
|
|
| Back to top |
|
|
Viktor Kollarik
Guest
|
| Posted:
Fri Dec 10, 2004 11:57 pm Post subject:
Re: CS and SQL Server separated |
|
|
Hi,
thank you for the advice. We have completely regenerated the envirnoment
(full reinstall of both servers). The commerce server is now installed
following the guidelines you sent. Ther result is, taht everythiong works
(and does not work) the same way as before. Bizdesk works with normal SQL
database, but is unable to connect the MSOLAP database when trying to show
any report. The database exists and is available using the same connect
string that fails within the webpage. Do you reports work good?
Koldo
"Tea C" <smece1972@yahoo.com.nospam> wrote in message
news:9ECD5FE0-F700-4B45-879D-B169D68B51FF@microsoft.com...
| Quote: | Viktor,
Please see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csvr2002/htm/cs_se_securityconcepts_rvxn.asp
I believe it confirms you scenario.
Tea C.
"Viktor Kollarik" wrote:
Hi,
I am cooperating with Jan Hruz on the problem.
We have Anonymous access denied on for the directory. Only windows
auhentication is allowed.
But despite the fact in the targer server with sql in system event log
there
is an event about connection anonymous from the commerce server side.
Viktor Kollarik
"Tea C" <smece1972@yahoo.com.nospam> wrote in message
news:B7D15BE6-71BD-4488-BB23-6DEF12C34813@microsoft.com...
From IIS Manager, navigate to ASP page that tries to connect to DB as
anonymous user per your posting below:
1. Right click on the ASP page and select Properties.
2. Go to Directory Security tab.
3. Click the Edit button.
4. What security settings do you have for the page? Is anonymous
checked?
Depending on the IIS security settings for the page, different UID will
be
passed to SQL Server for authentication.
Tea C.
"Jan Hruz" wrote:
We've found what was wrong. Connecting directly from vbscript works
f.e.:
set oGetADOConnection = nothing
sConnectionString = "Provider=MSOLAP.2;Integrated
Security=SSPI;Persist
Security Info=False;Data Source=olapserver;Initial Catalog=cnet6_dw"
Set oConn = CreateObject("ADODB.Connection")
if Err.number <> 0 then
setError "", sGetErrorByID("Cant_create_object"),
sGetScriptError(Err),
ERROR_ICON_ALERT
end if
oConn.ConnectionTimeout = AD_CONNECTION_TIMEOUT
oConn.CommandTimeout = AD_COMMAND_TIMEOUT
oConn.Open sConnectionString
set oGetADOConnection = oConn
but when the application tries to connect from ASP script it failed.
:-P
Security problem ?
OLAP server and CSS-IIS server are in the same domain. IIS is running
under
standard local user account "Network Service". In the OLAP server's
event
log appears "anonymous connection" when unsuccesfully trying from ASP
page,
and regular user name when successfully trying from vbs. Is the ASP
page
from IIS trynig to connect the OLAP server anonymously? Is ther any
way
to
force it to connect as a regular user?
Regards,
Jan
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com
wrote
in
message news:e179NjN2EHA.936@TK2MSFTNGP12.phx.gbl...
Did you change the default security in Analysis Services to not
include
the everyone permission?
Have you tried accessing the cube from Excel? (Data-Pivot
Report-External
Data-Get Data-OLAP-New Datasource ...)
Have you tried processing the database from Analysis Manager?
Rob
"Jan Hruz" <jan.hruz@anasoft.sk> wrote in message
news:u1m76%23I2EHA.2644@TK2MSFTNGP11.phx.gbl...
Oki here's the description of situation :
server A: mssql and ms olap
server B: commerce server
Status:
Both Servers are runing win2k3 server and are members of the same
windows
domain.
We have installed mssql sp3 + msolap sp3 to the server A. They run
as
"localsystem" and work fine.
We have installed mssql client sp3 + msolap sp3 to the server B.
We can connect form server B to both DB server and analysis server
on
the
server A.
We have installed commerce server 2002 on the server B. This time
they
are running as domain administrator.(just in order to avoid
problems
with
insufficient privileges.) Installation completed succesfully.
Unpacking site also completed succesfully.
SQL Database and DWdatabase and also DW database at OLAP server
were
created succesfully.
problem description:
When we try to open any report via Bizdek, we get this error:
MicrosoftR OLE DB Provider for Analysis Services (0x80004005)
Database
'cnet6_dw' does not exist.
where cnet6_dw is the name of the relevant OLAP database. But he
database
exists and is also accessible form the server B via analysis
manager.
Any idea what we may have forgotten to set up ?
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com
wrote
in message news:uooEPK61EHA.3236@TK2MSFTNGP15.phx.gbl...
Jan:
We do it all the time. There are a few dozen places (ok, maybe
half
a
dozen) that the connection string is stored. My suggestion is
start
walking through all of the resources and checking their properties
to
see if they have connection strings. The one placce that gives a
lot
of
people trouble is the profile connection string. It can be found
under
Global Resources, Profiles, Profile Data Sources, and there
should
be a
SQL data source under there which has a connection string that you
may
have to change.
My directions may be a bit off, I'm just ending a vacation and I
forgot
to bring my Commerce Server VPC image with me. If you can't find
it
let
me know, I'll have access to get the exact steps sometime
tomorrow.
Rob
|
|
|
| Back to top |
|
|
Viktor Kollarik
Guest
|
| Posted:
Tue Dec 14, 2004 10:45 pm Post subject:
Re: CS and SQL Server separated |
|
|
Hi,
could you please send us maybe just a sample of your CS deployment
architecture?
In addionion to the problems with running reports etc, we met some other
problems, e.g. scheduling imports from CS to the SQL Server - import wizard
claims it is unable to save the import package beacuse it cannot find the
server - is it possible, to run the import package in cscheduler fom the
remote SQL Server?
Thank you
Viktor Kollarik |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in