Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

CPS 12 Test Server Deployment

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

10 Posts

7 Users

0 Reactions

126 Views

RSS

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

Topic starter

I've never done a deployment before, but I'm wanting to learn so we don't have to pay our vendor $1,500 every time we need to upgrade. The included instructions I've found to be more than adequate; however I'm to the part of installing Jboss and it's asking for the "Application Logon and Password". I'm not sure what this is. I tried my normal CPS login but didn't work, tried the admin login for SQL but it says it's reserved. What else is there to try? Thanks in advance.

And for the record, I'm breaking things on our test server, after all, that's what it's there for, right? 😉

Posted : January 30, 2015 6:16 am

ekappes

(@ekappes)

Posts: 87

Estimable Member

Try superuser...superuser and see if that works.

Posted : January 30, 2015 6:51 am

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

Topic starter

Good thought, but it didn't work 🙁 "Superuser cannot be logged into the test database on the server"

Posted : January 30, 2015 6:53 am

SLHV

(@slhv)

Posts: 478

Honorable Member

You can do installs and upgrades yourself. There are a few gotchas to watch out for during an upgrade. Have a rollback plan. Have a known good backup of your database prior to the upgrade. Disable the SQL agent. I was 4 hours into a major version upgrade when at the very end I had a database conflict with my SQL agent backup job. Ouch. Others are the install guide can be vague in areas.

I glanced at the installation guide. It doesn't say that the sa account is prohibited, but it's probably best practice.

I don't see anything in the server name field in your screenshot. If it is on the local machine, try adding "localhost" or "centricitytest" as the SQL server name.

Posted : January 30, 2015 7:08 am

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

Topic starter

Could you clarify the disable sql agent?

I removed the server name so no one tries to hack me lol

Posted : January 30, 2015 7:10 am

acantu

(@acantu)

Posts: 722

Prominent Member

Application Login is a SQL user you will have to create that has access to your CPS Database, you use this for running CPS and JBOSS communicating with the DB.

Posted : January 30, 2015 7:29 am

SLHV

(@slhv)

Posts: 478

Honorable Member

Right click on SQL Server Agent in SSMS and select stop before you start your upgrade. It runs scheduled jobs that interact with the database.

[caption id="attachment_168395" align="alignnone" width="265"] sql server agent[/caption]

Posted : January 30, 2015 9:29 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

Chris,

As ACANTU stated, you will have to go into SQL Server, create a SQL Server user account with full rights. Once that account is created, you can use that account as the Application Logon. Keep that info handy.

Posted : January 31, 2015 8:10 pm

aaltotsky

(@aaltotsky)

Posts: 129

Estimable Member

The SA is the system admin account in SQL. Try to use something else (adminuser for example)

Posted : February 5, 2015 8:20 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

as acantu say, you need to create an account in your sql that will server as the database read/write account between the Jboss and the database.

Go to your SQL management studio.

On the left side

you will have

-Database

-Security

-Server Objects

-Replication

-management

-SQL Server agent.

expand security-> right click on logins-> new Login->Click on the SQL server authentication ->

fill "Login name" with the desire user name-> uncheck enforce password policy, enforce password expiration and user must change password at next login. --> type your desire password and confirm it--> on your left side menu click user mapping--> check mark your cps database--> on the bottom windows on the same tab, check db_datawriter and db_datareader.--> click the ok button.

no, go back to where you were and use this account for that authentication.

Posted : February 13, 2015 5:45 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.1