This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi All,
I need some help with setting this connection for BIRT 371. In my data source properties file, my sql connection string looks like this but it does not work.
maximoDataSource.url=jdbc:sqlserver://localhost:1433;databasename=MAX75
I have a local SQL Server installed on Windows 7. I tried IP address or else but no luck. Can anyone have any suggestion on how can I address this issue.
let me know.
Thanks in advance,
Kumar
maximoDataSource.url=jdbc:sqlserver://MAXIMO75:1433;databasename=MAX75
maximoDataSource.username=sa
maximoDataSource.password=1*&FaZ2u
maximoDataSource.schemaowner=dbo
________________________________
From: Kumar <mahato01@yahoo.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, May 13, 2013 10:19 AM
Subject: [MAXIMO List] Need help with sql connection string on SQL Server 2008
Hi All,
I need some help with setting this connection for BIRT 371. In my data source properties file, my sql connection string looks like this but it does not work.
maximoDataSource.url=jdbc:sqlserver://localhost:1433;databasename=MAX75
I have a local SQL Server installed on Windows 7. I tried IP address or else but no luck. Can anyone have any suggestion on how can I address this issue.
let me know.
Thanks in advance,
Kumar
I have our first line as
maximoDataSource.url=jdbc:sqlserver://SQLSERVER:PORT;databaseName=DATABASENAME;integratedSecurity=false;
Also confirm that SQL is allowing connections on the specified port. I know we run on non-standard ports as part of our defense in depth.
Maybe this will help?
Andy
--- In MAXIMO@yahoogroups.com, siva ravuri <srpravuri@...> wrote:
>
> maximoDataSource.url=jdbc:sqlserver://MAXIMO75:1433;databasename=MAX75
> maximoDataSource.username=sa
> maximoDataSource.password=1*&FaZ2u
> maximoDataSource.schemaowner=dbo
>
>
>
>
>
> ________________________________
> From: Kumar <mahato01@...>
> To: MAXIMO@yahoogroups.com
> Sent: Monday, May 13, 2013 10:19 AM
> Subject: [MAXIMO List] Need help with sql connection string on SQL Server 2008
>
>
>
> Â
> Hi All,
>
> I need some help with setting this connection for BIRT 371. In my data source properties file, my sql connection string looks like this but it does not work.
>
> maximoDataSource.url=jdbc:sqlserver://localhost:1433;databasename=MAX75
>
> I have a local SQL Server installed on Windows 7. I tried IP address or else but no luck. Can anyone have any suggestion on how can I address this issue.
>
> let me know.
>
> Thanks in advance,
>
> Kumar
>
>
>
>
>
>
Can you log into the SQL Server Studio and connect to the Maximo database using the username/password you listed below using 'SQL Server Authentication' in the connection dialog box?
--- In MAXIMO@yahoogroups.com, "andrew.tess" <atess@...> wrote:
>
> I have our first line as
> maximoDataSource.url=jdbc:sqlserver://SQLSERVER:PORT;databaseName=DATABASENAME;integratedSecurity=false;
>
> Also confirm that SQL is allowing connections on the specified port. I know we run on non-standard ports as part of our defense in depth.
> Maybe this will help?
>
> Andy
>
> --- In MAXIMO@yahoogroups.com, siva ravuri <srpravuri@> wrote:
> >
> > maximoDataSource.url=jdbc:sqlserver://MAXIMO75:1433;databasename=MAX75
> > maximoDataSource.username=sa
> > maximoDataSource.password=1*&FaZ2u
> > maximoDataSource.schemaowner=dbo
> >
> >
> >
> >
> >
> > ________________________________
> > From: Kumar <mahato01@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Monday, May 13, 2013 10:19 AM
> > Subject: [MAXIMO List] Need help with sql connection string on SQL Server 2008
> >
> >
> >
> > Â
> > Hi All,
> >
> > I need some help with setting this connection for BIRT 371. In my data source properties file, my sql connection string looks like this but it does not work.
> >
> > maximoDataSource.url=jdbc:sqlserver://localhost:1433;databasename=MAX75
> >
> > I have a local SQL Server installed on Windows 7. I tried IP address or else but no luck. Can anyone have any suggestion on how can I address this issue.
> >
> > let me know.
> >
> > Thanks in advance,
> >
> > Kumar
> >
> >
> >
> >
> >
> >
>
Try using the ip address instead of the MAXIMO75 alias.
There could be something wrong in the ODBC connection.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: Jason Verly <jason.verly@yahoo.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, May 15, 2013 3:24 PM
Subject: [MAXIMO List] Re: Need help with sql connection string on SQL Server 2008
Can you log into the SQL Server Studio and connect to the Maximo database using the username/password you listed below using 'SQL Server Authentication' in the connection dialog box?
--- In mailto:MAXIMO%40yahoogroups.com, "andrew.tess" <atess@...> wrote:
>
> I have our first line as
> maximoDataSource.url=jdbc:sqlserver://SQLSERVER:PORT;databaseName=DATABASENAME;integratedSecurity=false;
>
> Also confirm that SQL is allowing connections on the specified port. I know we run on non-standard ports as part of our defense in depth.
> Maybe this will help?
>
> Andy
>
> --- In mailto:MAXIMO%40yahoogroups.com, siva ravuri <srpravuri@> wrote:
> >
> > maximoDataSource.url=jdbc:sqlserver://MAXIMO75:1433;databasename=MAX75
> > maximoDataSource.username=sa
> > maximoDataSource.password=1*&FaZ2u
> > maximoDataSource.schemaowner=dbo
> >
> >
> >
> >
> >
> > ________________________________
> > From: Kumar <mahato01@>
> > To: mailto:MAXIMO%40yahoogroups.com
> > Sent: Monday, May 13, 2013 10:19 AM
> > Subject: [MAXIMO List] Need help with sql connection string on SQL Server 2008
> >
> >
> >
> > Â
> > Hi All,
> >
> > I need some help with setting this connection for BIRT 371. In my data source properties file, my sql connection string looks like this but it does not work.
> >
> > maximoDataSource.url=jdbc:sqlserver://localhost:1433;databasename=MAX75
> >
> > I have a local SQL Server installed on Windows 7. I tried IP address or else but no luck. Can anyone have any suggestion on how can I address this issue.
> >
> > let me know.
> >
> > Thanks in advance,
> >
> > Kumar
> >
> >
> >
> >
> >
> >
>