RE: Connection Issue : SQL Server 2005 install on XPpro when connecting from a XPpro machine

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Daryl,

I think you are trying to mix the use of windows authentication and SQL authentication. With Windows authentication you don't specify a username it uses the user you are logged in as. For this to work you need to in a domain where the user on your machine is a domain user and then assign that user access on the server.


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


I have installed SQL Server 2005 (Developer Edition) as a default
instance onto a Windows XPpro (SP2) machine and I am trying to connect
to it from another Windows XPpro (SP2) machine using Microsoft's
DataLink connection tool. I have installed using Windows
Authentication only for the default instance of Server 2005.

The machine that has Server 2005 installed on is called JOSHUA and I
can
obtain the Server Name over the network but I am having difficulty
when I
attempt to get the Database name. The error message I get is "Login
failed
for user 'JOSHUA\Guest'." I have a login in the Security section of
the SQL
Server's instance JOSHUA\MyLoginName and I have added this to the
"Manage my
network passwords" area on the XP machine I am trying to connect from.
i.e.
Server: JOSHUA
User Name: JOSHUA\MyLoginName
Password: Password used on the machine with Server 2005 installed.
I have (I think) made the correct changes to the Surface Area
Connections and have added the correct services / ports to the
Exemptions list. But I am happy for someone to comment on these as
well, can anyone please help me?

thanks
daryl


.

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.windowsservices)