Re: SQL Server 2005 Express Fail to connect with Vista PCs

What error are you getting?
Vista doesn't automatically let you use Administrator credentials. Are you relying on the membership of your domain login in the Local Administrators group to provide your SQL Server permissions? Try adding domain credentials 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.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Josh" <Josh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4563AA02-B1B3-4D4B-B471-6DEDAF131D99@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:857A02EF-C1CC-493B-99CD-9813E123363A@xxxxxxxxxxxxxxxx
>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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:4F867A7D-2EDC-4C52-9394-ED56CD1339B1@xxxxxxxxxxxxxxxx
>> > 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.
>>
>>
>>


.

Relevant Pages

  • RE: Reality of remote connection
    ... but either your username 'Administrator' or password are ... I am attempting to login using the administrator account that ... figuring it will at least do the connection string correctly. ... > connect to on the SQL server machine that connects to SQL Server on my behalf? ...
    (microsoft.public.sqlserver.connect)
  • Re: Connect to SQL Server over the internet
    ... connection dialog window that you will find on the main menu: ... which is the port used by SQL-Server in its basic configuration. ... I can remove the firewall. ... Computer A is where is installed SQL server 2000 and the BE. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: connecting to SQL Server 2000 from a VB.net app using ADO.net
    ... In terms of connectivity issues over the Internet, firewall ... TCP Ports Needed for Communication to SQL Server ... I can't create a remote connection in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)
  • Re: Named pipe error 53
    ... Did you try disabling the firewall on the Windows XP machine to see if it is dedicted to the settings of the firewall? ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... (provider: Named Pipes Provider, error: 40 - Could not open a connection to ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot Generate SSPI Context - help
    ... Windows authenticated user that connects to an SQL Server DB successfully. ... Administrator and the relevant password to get in. ... connection string I received the exact same error message as below. ... with the remote SQL server as a windows authentication user. ...
    (microsoft.public.inetserver.asp.db)