View Single Post
  #2 (permalink)  
Old June 11th, 2003, 06:42 AM
pgtips pgtips is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

It would help if we could see your connection string, but I guess you've tried quite a few variations. For SQL Server connections using a windows authentication, my connection string usually looks like this:
Code:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbname;Data Source=servername
Another problem may be that the windows user IUSR_HP864N may not be a valid database user. Have you set-up permissions for this user in the db? If not try running something like this script to grant log-in to your db:
Code:
-- Create Server logins
USE Master
go
EXEC sp_grantlogin 'domain\user'
go

-- Grant access to database
USE dbname
GO
EXEC sp_grantdbaccess 'domain\user', 'user'
GO