I have a windows 7, 64 bit client computer connected via a work type network to a windows 7, 64 bit server running sql server 2008 R2. I am trying to connect from a .net c# program on the client to the server using the sqlconnection object. The connection
string is: "Data Source=ROOM-3\\SQLEXPRESS;Initial Catalog=AtsmDatabase;Integrated Security=True". The open method generates a 18452 error. logon failed for user ''. The user is not associated with a trusted sql server connection.
Sql server 2005 was running on the server. I did an upgrade to 2008 R2. Under Start \ Programs there are now 2 folders one for 2005 and one for 2008. Under 2005 is Configuration Tools with sql server configuration manager, sql server error and usage reporting
and sql server suface area reporting. Under 2008 R2 is also Configuration manager with sql server installation center 64 bit.
questions:
1. why is sql server 2005 still present on the server even after the upgrade ...
Go to the complete details ...