The version of sqlservr.exe was 20.0 after the upgrade. I used the upgrade option from 2005 to 2008 R2 which did nothing. I have two computers running windows 7 64 bit connected by a private work network configured to be client server with sql server 2008 R2 running on the server. I re-read the 1st paragraph and you are actually connecting, but being denied.Ĭheck the sql server errorlog for the state of the 18452 error which will tell you why, but my guess is that the login doesn't exist, or the instance is having issues communicating with a DC - but the errorlog will tell you, I'm just guessing. I don't believe (I'm not positive though) that configuration settings are pulled over with an in-place version upgrade (as opposed to an edition upgrade which doesn't affect this). Check the dates and version of the actual binaries. Probably because it was an in-place upgrade of a 32-bit 2005 install. If you did a side-by-side upgrade once again the older insatnce is not uninstalled. If you did an in-place upgrade (which is probably what happened) 2008R2 was installed over top of the older instance, but it doesn't uninstall it. why can't I connect to sql server on the server?
Why do the service for sqlserver and sqlbrowser point to program files x86 even after I installed the 64 bit upgrade?ģ. why is sql server 2005 still present on the server even after the upgrade to 2008 R2?Ģ. Under 2008 R2 is also Configuration manager with sql server installation center 64 bit.ġ. Under 2005 is Configuration Tools with sql server configuration manager, sql server error and usage reportingĪnd sql server suface area reporting.
Under Start \ Programs there are now 2 folders one for 2005 and one for 2008. Sql server 2005 was running on the server. The user is not associated with a trusted sql server connection. String is: "Data Source=ROOM-3\\SQLEXPRESS Initial Catalog=AtsmDatabase Integrated Security=True". net c# program on the client to the server using the sqlconnection object. 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.
0 kommentar(er)
