SQL Server - Connection String Problem after changing name of Server
I'm running SQL Server Express 2008 on a Windows Server 2008 Server. I changed the name of the server computer from "BackupServer" to "AltekNT". I can connect to the instance of SQLServer running on the server from a Windows XP computer using Management Studio and using the name "AltekNT\SQLEXPRESS" (former name was "BackupServer\SQLEXPRESS"). However, the connection string in my Access Database Program will not connect any tables using the name "AltekNT\SQLEXPRESS" (Note: Using "BackupServer\SQLEXPRESS" in the connection string before I changed the name of the server worked to create linked tables). How can I fix this?
Microsoft SQL Server 2008Microsoft AccessMicrosoft SQL Server