Hi.. First post nerves.. ;)

I'm trying to connect to a networked Dev server here, and despite it working for other Dev sites we have, I can't connect today.. I have the following errors with the following connection strings..

String:
Provider=sqloledb; Network Library=DBMSSOCN; Data Source=HUEY; Initial Catalog=vs000_1; User ID=devUser; Password=devUser;
Error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database requested in login 'vs000_1'. Login fails.

String:
Provider=sqloledb; Data Source=HUEY; Initial Catalog=vs000_1; Integrated Security=SSPI
Error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.


Any ideas as to what I am doing wrong or if there is anything I can check elsewhere??

Thanks for any help..


Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.

http://www.dogfightclothing.com

__________________
Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.
http://www.dogfightclothing.com

Sorted the issue..

Had to allow Public on vs000_1 to devUser.. Simple as that..

If I had set up Windows NT Integrated Security on vs000_1 then I could use SSPI I suppose?

Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.

http://www.dogfightclothing.com