October 6, 2006 at 7:29 am
Hi,
I have SQL Server 2000 and 2005 on the same server wherein 2000 got installed after 2005. Now the problem is , since the "sa" password has been set already for SQL Server 2005 , I am not able to connect to SQL Server 2000 as it is saying "login failed for user sa".
Can you please help me out and let me know how to create two instances of the SQL Servers on the same machine.....
Regards
Daniel
October 6, 2006 at 9:19 am
You should have been asked to set a password for SA when you installed SQL 2000. The password set for it in SQL 2005 is irrelevant since SQL Server logins, which SA is, only exist in a given instance of SQL Server. Thus, the SA logins in SQL 2000 and SQL 2005 are independent of each other.
If you don't know the password for the SQL 2000 SA login, perhaps you can login as a local administrator or some other account with sysadmin privileges.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply