Mander77
Jul 15, 2009, 12:49:21 PM7/15/09
to RISE
I must be doing something incredibly simply wrong, but I canNOT get
RISE to accept my connection string (or any variation of it).
In the "Create new system" dialog box it asks for a database
connection string.
I have entered the information in the following format with no luck. I
have confirmed that I can connect to the database from both my local
machine and the RISE server with using either ODBC connection or
directly connecting using the SQL management studio client. It works
both with my window authentication credentials as well as with a
specific SQL username and password.
DSN=myDataSourceName;
DSN=myDataSourceName;DATABASE=myDatabase;
Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
ID=myUserID; Password=myPassword;
I assume I must be formatting this connection string incorrectly..
What am I doing wrong? All it tells me is "Please check the
connection string you have supplied."
RISE to accept my connection string (or any variation of it).
In the "Create new system" dialog box it asks for a database
connection string.
I have entered the information in the following format with no luck. I
have confirmed that I can connect to the database from both my local
machine and the RISE server with using either ODBC connection or
directly connecting using the SQL management studio client. It works
both with my window authentication credentials as well as with a
specific SQL username and password.
DSN=myDataSourceName;
DSN=myDataSourceName;DATABASE=myDatabase;
Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
ID=myUserID; Password=myPassword;
I assume I must be formatting this connection string incorrectly..
What am I doing wrong? All it tells me is "Please check the
connection string you have supplied."
Ola Hellgren
Jul 15, 2009, 5:00:05 PM7/15/09
to RISE
Hi Mander77, sorry for the inconvenience.
To my understanding there's nothing wrong with your connection
strings. Let's follow the schema below. I think it'll give us the
details needed to solve this issue.
1. Uninstall your current RISE Server and download and install
http://www.risetobloome.com/File.aspx?item=792 instead.
2. On the RISE Server computer, try accessing the RISE Server from a
web browser. Typically, the URL would be http://localhost/rise/maintenance.asmx.
If the server is at all available you'll get a list of its methods.
3. Select the method GetSystemList and click Invoke to run it. This
method isn't depending on the database so if the server is working at
all you'll get a response.
4. Select the method TestConnection, fill in your connection string
and click Invoke to run it. If the server is able to connect to the
database you'll get an xml response saying "true" otherwise you'll get
a more detailed printout of what goes wrong.
Also, you might find the page http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
useful.
Best regards,
Ola
To my understanding there's nothing wrong with your connection
strings. Let's follow the schema below. I think it'll give us the
details needed to solve this issue.
1. Uninstall your current RISE Server and download and install
http://www.risetobloome.com/File.aspx?item=792 instead.
2. On the RISE Server computer, try accessing the RISE Server from a
web browser. Typically, the URL would be http://localhost/rise/maintenance.asmx.
If the server is at all available you'll get a list of its methods.
3. Select the method GetSystemList and click Invoke to run it. This
method isn't depending on the database so if the server is working at
all you'll get a response.
4. Select the method TestConnection, fill in your connection string
and click Invoke to run it. If the server is able to connect to the
database you'll get an xml response saying "true" otherwise you'll get
a more detailed printout of what goes wrong.
Also, you might find the page http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
useful.
Best regards,
Ola
Amanda Myer
Jul 16, 2009, 9:45:58 AM7/16/09
to RISE
Well... I am able to complete steps 2, 3, and 4 without issue. When
I put my connection string in, the RISE server accesses the database
without a problem (it returns "true") when I am logged into the actual
server itself. Not sure why I can't do it from the RISE Editor.... I
still just get "Please check your connection string" from the editor
when trying to "Create new system". The editor doesn't actually need
to be running on the RISE machine, does it?
On Jul 15, 5:00 pm, Ola Hellgren <hellgren....@gmail.com> wrote:
> Hi Mander77, sorry for the inconvenience.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> web browser. Typically, the URL would behttp://localhost/rise/maintenance.asmx.
>
> - Show quoted text -
I put my connection string in, the RISE server accesses the database
without a problem (it returns "true") when I am logged into the actual
server itself. Not sure why I can't do it from the RISE Editor.... I
still just get "Please check your connection string" from the editor
when trying to "Create new system". The editor doesn't actually need
to be running on the RISE machine, does it?
On Jul 15, 5:00 pm, Ola Hellgren <hellgren....@gmail.com> wrote:
> Hi Mander77, sorry for the inconvenience.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> If the server is at all available you'll get a list of its methods.
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> Also, you might find the pagehttp://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> useful.
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
> > connection string you have supplied."- Hide quoted text -
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
>
> - Show quoted text -
Amanda Myer
Jul 16, 2009, 9:51:12 AM7/16/09
to RISE
Also, the connection string works fine when using the "Generate code
to database" tool in the RISE editor. It's only on the "Generate code
to server" and then "Create new system" that it is having a problem.
to database" tool in the RISE editor. It's only on the "Generate code
to server" and then "Create new system" that it is having a problem.
> Hi Mander77, sorry for the inconvenience.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> web browser. Typically, the URL would behttp://localhost/rise/maintenance.asmx.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> If the server is at all available you'll get a list of its methods.
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> Also, you might find the pagehttp://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> useful.
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
Amanda Myer
Jul 16, 2009, 10:06:16 AM7/16/09
to RISE
Also, I tried using the "CreateSystem" method directly from the
http://localhost/rise/maintenance.asmx page from the RISE server. It
accepted the input but gave no output after completion.
When I go into the "Generate code to server" dialog now, it shows the
system I created in the "Select system" dropdown, but the dropdowns
for "Select database code generator" and "Select application code
generator" are blank and have no options for selection.
http://localhost/rise/maintenance.asmx page from the RISE server. It
accepted the input but gave no output after completion.
When I go into the "Generate code to server" dialog now, it shows the
system I created in the "Select system" dropdown, but the dropdowns
for "Select database code generator" and "Select application code
generator" are blank and have no options for selection.
> Hi Mander77, sorry for the inconvenience.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> web browser. Typically, the URL would behttp://localhost/rise/maintenance.asmx.
>
> To my understanding there's nothing wrong with your connection
> strings. Let's follow the schema below. I think it'll give us the
> details needed to solve this issue.
>
> 1. Uninstall your current RISE Server and download and installhttp://www.risetobloome.com/File.aspx?item=792instead.
>
> 2. On the RISE Server computer, try accessing the RISE Server from a
> If the server is at all available you'll get a list of its methods.
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> Also, you might find the pagehttp://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> 3. Select the method GetSystemList and click Invoke to run it. This
> method isn't depending on the database so if the server is working at
> all you'll get a response.
>
> 4. Select the method TestConnection, fill in your connection string
> and click Invoke to run it. If the server is able to connect to the
> database you'll get an xml response saying "true" otherwise you'll get
> a more detailed printout of what goes wrong.
>
> useful.
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
>
> Best regards,
> Ola
>
> On Jul 15, 6:49 pm, Mander77 <mande...@gmail.com> wrote:
>
>
>
> > I must be doing something incredibly simply wrong, but I canNOT get
> > RISE to accept my connection string (or any variation of it).
>
> > In the "Create new system" dialog box it asks for a database
> > connection string.
> > I have entered the information in the following format with no luck. I
> > have confirmed that I can connect to the database from both my local
> > machine and the RISE server with using either ODBC connection or
> > directly connecting using the SQL management studio client. It works
> > both with my window authentication credentials as well as with a
> > specific SQL username and password.
>
> > DSN=myDataSourceName;
> > DSN=myDataSourceName;DATABASE=myDatabase;
> > Driver={SQL Server}; SERVER=myServerAddress; DATABASE=myDatabase;
> > Driver={SQL Server}; Server=myServerAddress; Database=myDatabase; User
> > ID=myUserID; Password=myPassword;
>
> > I assume I must be formatting this connection string incorrectly..
> > What am I doing wrong? All it tells me is "Please check the
Ola Hellgren
Jul 17, 2009, 5:30:00 AM7/17/09
to RISE
Hi Amanda,
Did you update the server software as well? That should populate the
code generator lists.
//Ola
On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
> Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpage from the RISE server. It
> > - Show quoted text -- Hide quoted text -
Did you update the server software as well? That should populate the
code generator lists.
//Ola
On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
> Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpage from the RISE server. It
Amanda Myer
Jul 17, 2009, 8:18:04 AM7/17/09
to RISE
I just reinstalled it again, but it still doesn't work. Now it's back
where it started (with no system name) and it still is arguing about
the connection string. =( ARGH...
On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
> Hi Amanda,
>
> Did you update the server software as well? That should populate the
> code generator lists.
>
> //Ola
>
> On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
> > Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpagefrom the RISE server. It
where it started (with no system name) and it still is arguing about
the connection string. =( ARGH...
On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
> Hi Amanda,
>
> Did you update the server software as well? That should populate the
> code generator lists.
>
> //Ola
>
> On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
Joar
Jul 17, 2009, 11:59:21 AM7/17/09
to RISE
Hi Amanda,
This sounds to me like a permissions issue.
Have you checked that you have a set up according to the "RISE web
application permissions" section on the "Installing the RISE Server"
page?
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
Hope this helps,
Joar
On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
> I just reinstalled it again, but it still doesn't work. Now it's back
> where it started (with no system name) and it still is arguing about
> the connection string. =( ARGH...
>
> On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
>
>
> > Hi Amanda,
>
> > Did you update the server software as well? That should populate the
> > code generator lists.
>
> > //Ola
>
> > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
> > > Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpagefromthe RISE server. It
> > - Show quoted text -- Dölj citerad text -
>
> - Visa citerad text -
This sounds to me like a permissions issue.
Have you checked that you have a set up according to the "RISE web
application permissions" section on the "Installing the RISE Server"
page?
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
Hope this helps,
Joar
On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
> I just reinstalled it again, but it still doesn't work. Now it's back
> where it started (with no system name) and it still is arguing about
> the connection string. =( ARGH...
>
> On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
>
>
> > Hi Amanda,
>
> > Did you update the server software as well? That should populate the
> > code generator lists.
>
> > //Ola
>
> > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
>
> - Visa citerad text -
Amanda Myer
Jul 17, 2009, 12:21:06 PM7/17/09
to RISE
Well.. the only reference to "ASP.net Impersonation" settings that I
can find is in the web.config. I tried manually setting the
impersonate settings in the web.config to use my explicit username and
password, but then the RISE Editor gives me an error about expecting
xml and not getting it. It's a generic ASP.net error. I then tried
to set "customErrors="Off" so I could see more detail about the error,
but the RISE Editor still only sees the generic error.
In addition, the server this is running on is Windows 2003. If I read
the instructions on the "Installing the RISE Server" page correctly,
it stated that the RISE Server would use the inherited permissions of
the user accessing the RISE server (me), and that nothing special
needed to be done in order to allow this behavior on Windows 2003. My
username has full administrative priviledges on this server, and the
website appears to be setup for Windows authentication so it should be
functioning normally.
.. I just setup the webservices to be testable from remote, and ran
the method "TestConnection" using the connection string that I can use
without error in the "Generate code to Database" tool in the RISE
Editor. When I try it, it throws this error:
System.Data.Odbc.OdbcException: ERROR [28000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user 'NT AUTHORITY
\ANONYMOUS LOGON'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection
(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at RISE.Database.CDBCommand.Connect(String connectionString)
at RISE.WebService.Maintenance.TestConnection(String
odbcConnectionString)
... I'm not sure why it's trying to logon to the database with "NT
AUTHORITY\ANONYMOUS LOGIN" if I am passing a username and password in
the connection string?
On Jul 17, 11:59 am, Joar <joar.swenn...@gmail.com> wrote:
> Hi Amanda,
> This sounds to me like a permissions issue.
> Have you checked that you have a set up according to the "RISE web
> application permissions" section on the "Installing the RISE Server"
> page?
>
> http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> Hope this helps,
> Joar
>
> On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
> > I just reinstalled it again, but it still doesn't work. Now it's back
> > where it started (with no system name) and it still is arguing about
> > the connection string. =( ARGH...
>
> > On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
> > > Hi Amanda,
>
> > > Did you update the server software as well? That should populate the
> > > code generator lists.
>
> > > //Ola
>
> > > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
> > > > Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpagefromtheRISE server. It
> > - Visa citerad text -- Hide quoted text -
can find is in the web.config. I tried manually setting the
impersonate settings in the web.config to use my explicit username and
password, but then the RISE Editor gives me an error about expecting
xml and not getting it. It's a generic ASP.net error. I then tried
to set "customErrors="Off" so I could see more detail about the error,
but the RISE Editor still only sees the generic error.
In addition, the server this is running on is Windows 2003. If I read
the instructions on the "Installing the RISE Server" page correctly,
it stated that the RISE Server would use the inherited permissions of
the user accessing the RISE server (me), and that nothing special
needed to be done in order to allow this behavior on Windows 2003. My
username has full administrative priviledges on this server, and the
website appears to be setup for Windows authentication so it should be
functioning normally.
.. I just setup the webservices to be testable from remote, and ran
the method "TestConnection" using the connection string that I can use
without error in the "Generate code to Database" tool in the RISE
Editor. When I try it, it throws this error:
System.Data.Odbc.OdbcException: ERROR [28000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user 'NT AUTHORITY
\ANONYMOUS LOGON'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection
(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at RISE.Database.CDBCommand.Connect(String connectionString)
at RISE.WebService.Maintenance.TestConnection(String
odbcConnectionString)
... I'm not sure why it's trying to logon to the database with "NT
AUTHORITY\ANONYMOUS LOGIN" if I am passing a username and password in
the connection string?
On Jul 17, 11:59 am, Joar <joar.swenn...@gmail.com> wrote:
> Hi Amanda,
> This sounds to me like a permissions issue.
> Have you checked that you have a set up according to the "RISE web
> application permissions" section on the "Installing the RISE Server"
> page?
>
> http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> Hope this helps,
> Joar
>
> On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
> > I just reinstalled it again, but it still doesn't work. Now it's back
> > where it started (with no system name) and it still is arguing about
> > the connection string. =( ARGH...
>
> > On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
> > > Hi Amanda,
>
> > > Did you update the server software as well? That should populate the
> > > code generator lists.
>
> > > //Ola
>
> > > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
Amanda Myer
Jul 17, 2009, 12:25:14 PM7/17/09
to RISE
Also, when I try connecting using the System datasource I had set up
for testing on the RISE server, I get this error (even thought testing
the data source connection works fine from within the Windows Data
Source connections dialog box):
associated with a trusted SQL Server connection.
Server connection.
> > - Visa citerad text -- Hide quoted text -
for testing on the RISE server, I get this error (even thought testing
the data source connection works fine from within the Windows Data
Source connections dialog box):
System.Data.Odbc.OdbcException: ERROR [28000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user ''. The user is not
associated with a trusted SQL Server connection.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user ''. The user is not associated with a trusted SQL
string attribute
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login
Server connection.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection
string attribute
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection
(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at RISE.Database.CDBCommand.Connect(String connectionString)
at RISE.WebService.Maintenance.TestConnection(String
odbcConnectionString)
string attribute
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, OdbcConnectionString constr, OdbcEnvironmentHandle
environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection
(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at RISE.Database.CDBCommand.Connect(String connectionString)
at RISE.WebService.Maintenance.TestConnection(String
odbcConnectionString)
On Jul 17, 11:59 am, Joar <joar.swenn...@gmail.com> wrote:
> Hi Amanda,
> This sounds to me like a permissions issue.
> Have you checked that you have a set up according to the "RISE web
> application permissions" section on the "Installing the RISE Server"
> page?
>
> http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> Hope this helps,
> Joar
>
> On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
> > I just reinstalled it again, but it still doesn't work. Now it's back
> > where it started (with no system name) and it still is arguing about
> > the connection string. =( ARGH...
>
> > On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
> > > Hi Amanda,
>
> > > Did you update the server software as well? That should populate the
> > > code generator lists.
>
> > > //Ola
>
> > > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
> > > > Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpagefromtheRISE server. It
> This sounds to me like a permissions issue.
> Have you checked that you have a set up according to the "RISE web
> application permissions" section on the "Installing the RISE Server"
> page?
>
> http://www.risetobloome.com/Page_1_S.aspx?ITEM=1544
>
> Hope this helps,
> Joar
>
> On 17 Juli, 14:18, Amanda Myer <mande...@gmail.com> wrote:
>
>
>
> > I just reinstalled it again, but it still doesn't work. Now it's back
> > where it started (with no system name) and it still is arguing about
> > the connection string. =( ARGH...
>
> > On Jul 17, 5:30 am, Ola Hellgren <hellgren....@gmail.com> wrote:
>
> > > Hi Amanda,
>
> > > Did you update the server software as well? That should populate the
> > > code generator lists.
>
> > > //Ola
>
> > > On Jul 16, 4:06 pm, Amanda Myer <mande...@gmail.com> wrote:
>
Joar
Jul 17, 2009, 12:51:36 PM7/17/09
to RISE
Hi again,
I thought it was a UAC issue but just as you noted if you are running
a Windows 2003 that's not it.
What IIS version are you running on it?
Are the code generator selection lists still empty after you
downloaded and reinstalled the server?
Joar
> > > > > Also, I tried using the "CreateSystem" method directly from thehttp://localhost/rise/maintenance.asmxpagefromtheRISEserver. It
I thought it was a UAC issue but just as you noted if you are running
a Windows 2003 that's not it.
What IIS version are you running on it?
Are the code generator selection lists still empty after you
downloaded and reinstalled the server?
Joar
Amanda Myer
Jul 17, 2009, 1:45:13 PM7/17/09
to RISE
Well, it is IIS 6.0 running in IIS 5.0 isolation mode. I just changed
it to IIS 6.0 normal mode, and tested again, but there is no
difference in the behavior.
And yes, the code generator lists are still empty.
Some more info:
1) The RISE Editor "Generate Code to Database" works from my local
machine with the connection string.
2) The TestConnection method on the RISE Server returns an SQL
authentication error when invoking the method remotely. It appears to
be trying to send the user "NT AUTHORITY\ANONYMOUS LOGON" as the login
user instead of the username and password I have specified in the
connection string.
3) The TestConnection method on the RISE Server passes when invoking
the method locally on the RISE server.
....
> > - Visa citerad text -- Hide quoted text -
it to IIS 6.0 normal mode, and tested again, but there is no
difference in the behavior.
And yes, the code generator lists are still empty.
Some more info:
1) The RISE Editor "Generate Code to Database" works from my local
machine with the connection string.
2) The TestConnection method on the RISE Server returns an SQL
authentication error when invoking the method remotely. It appears to
be trying to send the user "NT AUTHORITY\ANONYMOUS LOGON" as the login
user instead of the username and password I have specified in the
connection string.
3) The TestConnection method on the RISE Server passes when invoking
the method locally on the RISE server.
....
Amanda Myer
Jul 17, 2009, 2:20:19 PM7/17/09
to RISE
I found some information here: http://forums.devx.com/showthread.php?t=20206
I think this is my problem...
so... since I don't have access to mess around with our AD settings, I
unchecked "Use Windows Integrated Authentication" in the IIS
properties for the RISE folder and changed it to just "basic
authentication." Now, when I remotely browse to http://myRiseServer/rise/maintenance.asmx
from my local machine I get a dialog box asking me for a username and
password. I put in my AD domain\username and password and I can get
to the Methods list. I can run all the methods, including
"TestConnection" successfully.. Yay...
However, when I try to connect to the server using the RISE Editor, it
tells me that authentication has failed. I have tried connecting with
the "Use Windows Authentication" box checked, and unchecked, and tried
putting my username in several different ways (domain\username,
username@domain) with no effect.
.. so now, the question is, how do I get "basic authentication" to
work with RISE server, or is this not possible?
> > - Show quoted text -- Hide quoted text -
I think this is my problem...
so... since I don't have access to mess around with our AD settings, I
unchecked "Use Windows Integrated Authentication" in the IIS
properties for the RISE folder and changed it to just "basic
authentication." Now, when I remotely browse to http://myRiseServer/rise/maintenance.asmx
from my local machine I get a dialog box asking me for a username and
password. I put in my AD domain\username and password and I can get
to the Methods list. I can run all the methods, including
"TestConnection" successfully.. Yay...
However, when I try to connect to the server using the RISE Editor, it
tells me that authentication has failed. I have tried connecting with
the "Use Windows Authentication" box checked, and unchecked, and tried
putting my username in several different ways (domain\username,
username@domain) with no effect.
.. so now, the question is, how do I get "basic authentication" to
work with RISE server, or is this not possible?
Reply all
Reply to author
Forward
0 new messages