Created On: 15 June 2011
Problem:
HCOSS & SQL Server CNN using SQL User authentication causes MS Visual Studio 2008 HCOSS build error > Error 2 Connection name not found. Builds ok when Windows authentication is used.
Resolution:
Setting the SQL PASS directive solves the issue.
Sa.sa is the user you would create in the SQL server using the SQL management studio tool.
Make sure you have PASS=sa.sa in your SQL directives.
sa.sa = defined SQL Server user & should be created as a SQL Server user.
UID: sa password: sa , sa.sa is used as an example.
Sa.sa is the user you would create in the SQL server using the SQL management studio tool.
Make sure you have PASS=sa.sa in your SQL directives.
sa.sa = defined SQL Server user & should be created as a SQL Server user.
UID: sa password: sa , sa.sa is used as an example.
Incident #2485463
Old KB# 34166
#EnterpriseDeveloper
#MFDS
