Re: SQL Server 2005 Login Problem

Ensure you have approprate logins for those users who can't connect in your SQL Server Logins, if not, create logins for those users.

Also, it's a default instance I believe, because you use only server name in Data Source?

--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCDBA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT



"Andy Baker" <abaker@xxxxxxxxxxxxxxxxxx> wrote in message news:13j6eo61mk6he1e@xxxxxxxxxxxxxxxxxxxxx
We have recently purchased Small Business Server Premium, with SQL Server 2005 workgroup edition included. I has 3 XP PCs that I want to access the SQL Server database, and have set it up with windows integrated security. When I try to connect (from a VB.NET application) I am getting an error 'Login failed for User' followed by the domain name and user name. The connection string that I am using is 'Data Source=MAIN; Database=Vanputer; integrated security=SSPI; persist security info=False;" (where MAIN is the server name and Vanputer is the database name) The application connects fine to a server running SBS 2000 and SQL Server 2000, but 2005 is rejecting the login. What am I doing wrong. Thanks in advance for any suggestions.

Andy Baker



.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • Re: Windows permissions to run Jet OLEDB 4.0
    ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
    (microsoft.public.data.oledb)
  • Re: Logins & Permissions
    ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
    (microsoft.public.sqlserver.security)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)
Loading