After i started running all my software on Vista , SQL Server 2005 is the only thing thats giving me a bit of trouble. Tried connecting to my database server using Windows Authentication but i keep getting an invalid login error. For some strange reason analysis server is connecting perfectly but not my database server.
When i disabled UAC and tried connecting again, the connection to my database server works. Not sure if i am missing out something but for the moment whenever i have to connect to my database server i have to disable UAC :( If anyone comes across any solution do post a comment.