I have two instances I'm trying to connect to on my server. One is the default (nameless) instance, which I have connected fine. But, when I try to connect to the named instace, I seem unable to do so.

I've tried connecting in enterprise manager and query analyzer with things like 127.0.0.1\name, 127.0.0.1\\name, \\127.0.0.1\name but none of them have worked. I'm sure it's easy enough, as most baffling things are, but I'm really stumped on this one.

Would someone please point me in the right direction?

Thanks.

I think I found what's wrong. The instance I'm trying to connect to uses windows authentication but I'm trying to connect with SQL authentication. Now my question is how do I switch from one to the other?

>> Now my question is how do I switch from one to the other? <<

If you are referring to switching from Windows Authentication and SQL Authentication, you have that option when connecting using Query Analyzer. It asks you whether you want to connect using Windows Authenticaiton or SQL Authentication.

If you are asking how to switch the SQL Server from Windows Authentication to SQL Authentication, simply right-click on the SQL Server instance in Enterprise Manager and go to Properties. There's a tab there where you can change this.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Hahahahahaha....... wow. I finally got it working. The port my second instance was using was being blocked by windows firewall. Wow.... I feel like an id10t.... oh well.

Thanks!