This forum is closed. Thank you for your contributions.

Remove From My Forums

App-v 4.6 SP1 management server with SQL authentication issue

Question
0

Sign in to vote

I am installing App-v 4.6 SP1 management server with a remote SQL database that I do not have access to. However, I have a SQL user who is DBO over the needed database. When I attempt the installation, at the Configuration Database screen, I am getting the error:

The installation program could not connect to the configuration data store. Please see the installation log for details.

I check the log and it's indicates that the installer is using my id for login. Next step was to create a system dsn that would accurately point to the sql server, database and SQL user id. Still no joy?

Is there a way to do this installation with SQL authentication, not windows/AD authentication? Thanks in advance..Team

Wednesday, October 12, 2011 5:27 PM

Answers

0

Sign in to vote
Hello,

See this documentation;

http://technet.microsoft.com/sv-se/library/cc843742.aspx

See this whitepaper;

http://download.microsoft.com/download/1/6/1/161042F3-9CDE-45F7-BC20-4FBDA8888890/Creating_new_db_using_sql_scripting.docx
/Znack
- Proposed as answer by znack Tuesday, November 22, 2011 8:02 AM
- Unproposed as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:21 AM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:21 AM
Wednesday, October 12, 2011 5:36 PM

All replies

0

Sign in to vote
Hello,

See this documentation;

http://technet.microsoft.com/sv-se/library/cc843742.aspx

See this whitepaper;

http://download.microsoft.com/download/1/6/1/161042F3-9CDE-45F7-BC20-4FBDA8888890/Creating_new_db_using_sql_scripting.docx
/Znack
- Proposed as answer by znack Tuesday, November 22, 2011 8:02 AM
- Unproposed as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:21 AM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:21 AM
Wednesday, October 12, 2011 5:36 PM
0

Sign in to vote

Znack,

I have zero rights to the SQL box that has been assigned. There is no windows/ad authentication allowed. How can I get the installer to understand that I want to have a sql user, not the system id, attempt this connect to the SQL box?

Wednesday, October 12, 2011 5:43 PM
0

Sign in to vote

Hello,

Supported methods are explained above - the whitepaper explains the scenario where you have no permissions on the SQL-box.

I suggest you read them to understand whats possible.
/Znack

Wednesday, October 12, 2011 5:45 PM
0

Sign in to vote

I read them. thanks znack. this will not work for the environment that this must be built in. Ill figure it out..

Wednesday, October 12, 2011 6:01 PM