SQL Server 2005 Login Problem

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: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
  • Exactly How to Use Disconnected Recordsets in VB / SQL Server Application
    ... Front-end is VB 6.0, back-end is SQL Server 2000 (actually, MSDE since ... underlying SQL Server database w/the assumption that the user *might* ... the local disconnected recordset on the user's machine would seem to ... time to update each and every record as each user scrolls through the ...
    (microsoft.public.vb.database)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... if the way synchronization needs to be handled changes in the ... > data stored in an SQL Server database. ... > GetChanges() call, but I feel that this workaround is not my best choice. ...
    (microsoft.public.dotnet.framework.adonet)
  • VBA Microsoft Access and SQL Server
    ... I am currently working on a project with Power Point. ... into a Microsoft SQL Server database. ... information from the Microsoft SQL Server database and re-populate a Power ...
    (microsoft.public.office.developer.vba)
  • Re: curious problem in production
    ... thank for the lesson on unique keys, but I suggest you read the question ... I am getting an exception from sql server ... >> trying to insert into the same sql server database. ...
    (microsoft.public.sqlserver.server)
Loading