Vista doesn't automatically let you use Administrator credentials. Are you
to SQL Server as a login with membership in the sysadmin group. One way to
do this, is from the SQL Server Surface Area Configuration tool. On the
opening page, click Add New Administrator.
"Josh" <Josh@discussions.microsoft.com> wrote in message
news:4563AA02-B1B3-4D4B-B471-6DEDAF131D99@microsoft.com...
> yes, I've tried all of these sugestions.
>
> "Rick Byham, (MSFT)" wrote:
>
>> Have you enabled remote connection using the SQL Server Surface Area
>> Configuration tool?
>> Are you connecting to a named instance as <computer_name>\sqlexpress ?
>> Is the SQL Server Browser service running to resolve the name to the
>> port?
>> The Books Online connectivity tutorial provides details on all these at
>>
http://msdn2.microsoft.com/en-us/library/ms345318(sql.90).aspx
>> --
>> Rick Byham (MSFT)
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Josh" <Josh@discussions.microsoft.com> wrote in message
>> news:857A02EF-C1CC-493B-99CD-9813E123363A@microsoft.com...
>> >I diabled the firewalls on both pc to see if that would make a
>> >diffenence
>> >and
>> > it still doesn't allow the SQL to connect. Not really sure what could
>> > be
>> > causing this if it isn't the firewall. Also tried switching between
>> > NAmed
>> > Pipes and TCP/IP, still doesn't connect.
>> >
>> > "William (Bill) Vaughn" wrote:
>> >
>> >> I was having a similar problem but was able to get it to work when I
>> >> disabled the firewall. This tells me that I needed to do some custom
>> >> tuning
>> >> thereof.
>> >>
>> >> hth
>> >>
>> >> --
>> >> ____________________________________
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant
>> >> Microsoft MVP
>> >> INETA Speaker
>> >>
www.betav.com/blog/billva >> >>
www.betav.com >> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit
www.hitchhikerguides.net to get more information on my latest
>> >> book:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >>
>> >> "Josh" <Josh@discussions.microsoft.com> wrote in message
>> >> news:4F867A7D-2EDC-4C52-9394-ED56CD1339B1@microsoft.com...
>> >> > Trying to get a Vista PC to connect to the SQL Server 2005 Express
>> >> > on
>> >> > another
>> >> > Vista PC. The PCs do have access to each other. The PCs can access
>> >> > the
>> >> > shared folders from each other. Both PCs can ping one another. The
>> >> > SQL
>> >> > is
>> >> > the only item that does not allow access to.
>> >> >
>> >> > We have looked at and done all the steps in the knowlage database on
>> >> > the
>> >> > microsoft site. We have added the sqlservr.exe and the
>> >> > sqlbrowser.exe
>> >> > to
>> >> > the
>> >> > firewall exceptions. We have tried the SQL connection with both PC
>> >> > firewalls
>> >> > off to elimate a firewall issues. We have turned off all third
>> >> > party
>> >> > software that may be interfering with the connection. The SP2 for
>> >> > SQL
>> >> > 2005
>> >> > has been applied. We have uninstalled the SQL and reinstalled the
>> >> > SQL
>> >> > .
>> >> > If
>> >> > someone could help us, have any suggestions, or have any comments
>> >> > about
>> >> > this
>> >> > connection issue we would be happy to here from you.
>> >>
>> >>
>> >>
>>