MS SQL Server - Can't access an instance installed on same server

Author

Can't access an instance installed on same server

Multitasker

2006-02-05, 8:23 pm

About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
been working with the database in that instance. However, now I try to
access the other instance on the server and I get connection failed check
server registration properties. When I check them I get "login failed." I
switch the registration back to SQL and windows - same issue. All services
are running on server and users are able to get to database.

I checked whitepapers and KB but can't find what to do. Any assistance is
greatly appreciated.

John Bell

2006-02-06, 3:23 am

Hi

If you login is failing how can your "users are able to get to database"?

If you can access the server using the given login though query analyser
(from the failing client), then check the connection string and check the
network libraries/protocols.

John

"Multitasker" wrote:

> About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
> been working with the database in that instance. However, now I try to
> access the other instance on the server and I get connection failed check
> server registration properties. When I check them I get "login failed." I
> switch the registration back to SQL and windows - same issue. All services
> are running on server and users are able to get to database.
>
> I checked whitepapers and KB but can't find what to do. Any assistance is
> greatly appreciated.

Sponsored Links