Subject:connect with sql server Author:ivich georg Date:24 Feb 2009 05:53 AM
Hi
I installed sql server developer edition 2005 on the same computer as stylus studio enterprise edition and i want to connect with sql server database via stylus studio but appears - [XQuery][SQLServer JDBC Driver][SQLServer]Login failed for user 'ivich/zola'. The user is not associated with a trusted SQL Server connection.Can you tell me how to configure sql ? I use server name localhost, windows authentication
Subject:connect with sql server Author:Ivan Pedruzzi Date:24 Feb 2009 11:00 PM
H Ivich,
Your SQL Server is configured to allows only Windows Authentication Mode. Please try to connect without specifying user/password doing so Stylus Studio will use your Windows user security token.
Subject:connect with sql server Author:ivich georg Date:25 Feb 2009 05:37 AM
i tried , but the stylus studio always asks me about the user name , so i can not skip it.I want to know if I can configure the studio in that manner so it does not ask me about the user name .Defining the database type , in this case sql server, and server url - //localhost:1433, thnings will meet their end