Link to home
Create AccountLog in
Avatar of Declan Basile
Declan BasileFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Kent Dyer
Kent Dyer
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Declan Basile

ASKER

Thanks for all the info.  Eventually the routines to create the linked tables in Access worked without changing anything.  I'm not sure why.