I have 2 instances of SQL Server installed on the same machine but i dont have access to the second instance?

Question

I have Windows Server 2003 and I have 2 instances of SQL server 2000 installed on the same machine.
I can see and access the default instance but I cant see or access the second instance
I tried all kinds of authentication but I couldn't do anything

Answer 1

Take a look here to see if it helps - http://msdn2.microsoft.com/en-us/library/aa174516(SQL.80).aspx

Answer 2

You need to configure the second instance to use a different port. This is not a good way to work, better ids to use one instance, and 2 separate databases. You can isolate their security. 2 instances is a very heavy load on the machine, and means you need your applications set to access the second port.

Answer 3

try "scott" as username and "tiger" as password

and also "system" as name and "manager" as password

these come default

then create a user name and assign all database permissions to this user