Hi all,

we had an application that connection to a db fine and update some tables. the server moved to the cloud and it stopped working. Some settings were changes on the server, names etc. and I have allowed for these but the connection string won't work, any ideas?
Old connection string

Driver=SQL Server;Server=SERVER01\scanning;Database=Scanning;uSER iD=user1;Password=Password1;Trusted_connection=yes

New connection string

Driver=SQLOLEDB; Data source=SERVER99\scanning; Initial Catalog=Scanning; User id=user99; Password=Password99; Integrated Security=SSPI

If i use the SQL manager setup I can log into the new server using the username and password and SQL authentication.
~M