Cannot connect to SQL databank from a different account

[govindsankar]

Hi,

I have a labview program that connects to a SQL datenbank. The program works perfectly in one microsoft account which is of another person. But when I go log out of that persons account and then log in to my account and then try to run the program it is showing an error that it cannot connect to the datenbank. Does anyone know what is the problem and if yes what can I do to fix the problem. I have attached two pics of the program. The first pic is the block diagram of the main program and the second pic is the block diagram of the SQL open from the first pic. Kindly do help me. Thank You. 

[wiebe@CARYA]

Are you connecting to an ODBC database? That should be a system ODBC database, or it won't exist for the other user.

(S)he might not have rights to the database, if this is setup to use Windows credentials...

[govindsankar]

Yes it is an ODBC database. What should I do to have rights to the database. Thank You.

[wiebe@CARYA]

---

@govindsankar wrote:

Yes it is an ODBC database. What should I do to have rights to the database. Thank You.

---

In the program you use to manage the database.

If you mean SQLServer with "SQL datenbank", then SQLServer.

[govindsankar]

No I dont manage the database. The database and the LabVIEW program was created by someone before me. I am new to the company and right now learning the whole system. The database is used to store the details of testing of their product which is done by a software written in LabVIEW. The software after testing stores the details of the test in the database. But when I log into my Microsoft account and try to run the program it immediately shows cannot connect to the database. Should I make changes in LabVIEW program or the SQL database program. Thanking you. 

[cbutcher · Accepted solution]

The SQL database server will maintain a series of access restrictions. Apparently you are not an authorised user.

You'll need to change the SQL server's list of users, or ask someone with access to do it for you if you cannot.

[govindsankar]

Thank you very much. I will do that but i have to learn sql first. Anyway thank you.

[wiebe@CARYA · Accepted solution]

---

@govindsankar wrote:

Thank you very much. I will do that but i have to learn sql first. Anyway thank you.

---

You'll need to learn SQLServer.

SQL is not SQLServer. SQL is the language you talk to an SQL enabled database. SQLServer is an SQL enabled database. SQL is pretty standard; used by Access, MySQL, SQLite, SQLServer. You can even make a .txt file ODBC database, and talk SQL to it.

If you mix SQL and SQLServer, you will confuse people, and get confusing answers on your questions..

[govindsankar]

Thank You very much for the clarification. My programming skills are limited to LabVIEW and MATLAB. My interest and experience is in LabVIEW, so I got a job in that. I guess LabVIEW is not just enough. Thank you again.